java - 为什么删除 jframe java 中的按钮错误

Question

我尝试了 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();

我应该解决什么问题？

Answer 1

如果您粘贴的代码是您的实际代码，则错误来自此行:

PreparedStatement ps = con.prepareStatement("DELETE FROM product WHRRE id = ?");

您的 SQL 中有拼写错误，请替换为:

PreparedStatement ps = con.prepareStatement("DELETE FROM product WHERE id = ?");