我试图从Java swing数据中插入数据到mysql数据库中,其中我有两个textfield值和一个table列值。在那里,我的插入过程遇到了问题。我试图将jtable列的行插入数据库,但是我发现在数据库中插入了最后一行的值。
我做了下面的代码。String customer_name = nametf.getText();
String phone = phonetf.getText();
PreparedStatement ps;
ResultSet rs = null;
String salesQuery = "INSERT INTO `sales`(`Customer_Name`, `Phone`,`Items`) VALUES (?,?,?)";
try {
ps = my_con.getConnection().prepareStatement(salesQuery);
ps.setString(1, customer_name);
ps.setString(2, phone);
for(int i=0; i
ps.setString(3, table1.getValueAt(i, 0).toString());
}
if(ps.executeUpdate() != 0){
JOptionPane.showMessageDialog(null,"\nSave Succesfully\n\n","Saved",1);
}
else {
JOptionPane.showMessageDialog(null,"\nCheck Error\n\n","Error",1);
}
}
catch (SQLException ex) {
Logger.getLogger(registration.class.getName()).log(Level.SEVERE, null, ex);
}