这是我的代码,我调试并检查了很多,但我不明白为什么这不起作用。请帮我一个。
if (msg.equals("succes"))
{
Connection c = null;
Statement stmt = null;
Class.forName("org.sqlite.JDBC");
c = DriverManager.getConnection("jdbc:sqlite:C:''Users''pk''Documents''NetBeansProjects''HRMS''employee.sqlite");
c.setAutoCommit(false);
stmt = c.createStatement();
String sql = "DELETE FROM attendance";
stmt.executeUpdate(sql);
stmt.execute(sql);
System.out.println(sql);
JOptionPane.showMessageDialog(null, "data are sent to server and deleted from local sqlite");
rs.close();
stmt.close();
c.close();
}
else
{
JOptionPane.showMessageDialog(null, msg);
}
您在代码中放入c.setAutoCommit(false);
,这意味着delete语句不会提交到数据库。将其更改为"true"或添加提交语句来解决此问题。