Hello Professionals out there, i am making a point-of-sales systems in java. And i have a jTable named "tbitempurchase" wherein I add the ordered items using an add button.I also have a table in mysql database named "itemSold". Now my problem goes like this, I want to insert the data added from the "tbitempurchase" to mySQL table "itemSold" all at once using a save button with a batch insert query. And i just don't know how to do it. Please, i need help with this. It would be an honor to receive generous and wise comments from you guys.
Zdneth_1
0
Newbie Poster
Recommended Answers
Jump to PostCan you please be more precise about the help you need? Eg Do you need to know how to get the data froma JTable? Do you need to know know how to execute an SQL insert statement? Etc?
Jump to Postyeah... you already made that clear.
All 6 Replies
JamesCherrill
4,733
Most Valuable Poster
Team Colleague
Featured Poster
Zdneth_1
0
Newbie Poster
JamesCherrill
4,733
Most Valuable Poster
Team Colleague
Featured Poster
Zdneth_1
0
Newbie Poster
Zdneth_1
0
Newbie Poster
JamesCherrill
4,733
Most Valuable Poster
Team Colleague
Featured Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.