我在youtube上尝试了教程,我在jframe java中创建了删除按钮,然后当我运行错误时会发生错误。
private void btnDeleteActionPerformed(java.awt.event.ActionEvent evt) {
if (!jtextId.getText().equals(""))
{
try {
Connection con = getConnection();
PreparedStatement ps = con.prepareStatement("DELETE FROM product WHRRE id = ?");
int id=Integer.parseInt(jtextId.getText());
ps.setInt(1, id);
ps.executeUpdate();
JOptionPane.showMessageDialog(null, "Data Delete");
} catch (SQLException ex) {
Logger.getLogger(Main_Window.class.getName()).log(Level.SEVERE, null, ex);
JOptionPane.showMessageDialog(null, "Produt Not Deleted");
}
}
else{
JOptionPane.showMessageDialog(null, "Enter Product");
}
}
关于输出错误在ps.executeUpdate();
中
我该做什么??
发布于 2017-08-14 01:27:38
如果您粘贴的代码是实际代码,则错误来自以下一行:
PreparedStatement ps = con.prepareStatement("DELETE FROM product WHRRE id = ?");
您的SQL中有错误,替换为:
PreparedStatement ps = con.prepareStatement("DELETE FROM product WHERE id = ?");
https://stackoverflow.com/questions/45666321
复制相似问题