How to add multiple rows from JTable to MySQL database

Question

I have been trying to add multiple rows from JTable to my MySQL Database, but only the first row is registered and not the rest.

Here's my code:

 DefaultTableModel tblmodel= (DefaultTableModel) jTable1.getModel();
  
 
  if (tblmodel.getRowCount()==0)
  {
      JOptionPane.showMessageDialog(this, "Table is Empty");
      }
  else {
            
      try
      {
          Class.forName("com.mysql.jdbc.Driver");

          Connection con =DriverManager.getConnection("jdbc:mysql://localhost:3306/project","root","123456");
          
      
      for (int i=0; i<tblmodel.getRowCount(); i++)
      {
          String pid = (String)jTable1.getValueAt(i, 0);
    String pname = (String)jTable1.getValueAt(i, 1);
    int price = (int)jTable1.getValueAt(i, 2);
    int qty = (int)jTable1.getValueAt(i, 3);
    int tprice = (int)jTable1.getValueAt(i, 4);
    
    String query = "Insert into invoice(product_id, product_name, price,quantity, total_price) values (?,?,?,?,?)";
 PreparedStatement ps;
    ps = con.prepareStatement(query);
   
    
    
     ps.setString(1, pid);
    ps.setString(2, pname);
    ps.setInt(3, price);
    ps.setInt(4, qty);
    ps.setInt(5, tprice);
          ps.execute();
          JOptionPane.showMessageDialog(this , "Data added Successfully");
          tblmodel.setRowCount(0);
          
      }
      } catch (Exception e) {
          
          }

@halfer Apologies. I'm new to stack and I'm not quite familiar with the rules. I'll ensure that this would not happen in he foreseeable future. — Joshua Mathew
– Joshua Mathew, Commented Nov 7, 2021 at 17:28
Thanks Joshua! The idea with Stack Overflow is that questions (and their answers) become almost like documentation, and so succinct technical writing is preferred - ideally tailored to broad/general cases as much as possible. — halfer
– halfer, Commented Nov 7, 2021 at 17:31

isaace · Accepted Answer · 2021-11-05 17:10:08Z

1

This line of code

tblmodel.setRowCount(0)

is causing it to break out of the loop after the first iteration.

answered Nov 5, 2021 at 17:10

isaace

3,4291 gold badge11 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Joshua Mathew Over a year ago

I used it to reset the JTable after it was done saving.

isaace Over a year ago

reset a table means to clear it. is that what you want?

Joshua Mathew Over a year ago

Yes, I removed tblmodel.setRowCount (0) and it worked perfectly fine, but I am now unable to clear the jTable as this function used to clear it.

isaace Over a year ago

I'm not sure exactly when you want to clear it but how about clearing it after you are out of the for loop?

Collectives™ on Stack Overflow

How to add multiple rows from JTable to MySQL database

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related