如何删除记录(字符串)JAVA和MYSQL

发布时间：2020-12-14 05:17:45 所属栏目：Java 来源：网络整理

导读：我成功地删除了一个整数,但是当我试图将它变为STRING时它会说 “where子句中的未知列itemtodelete但是我的ITEMTODELETE是在数据库中声明的STRING不是一个整数它不删除一个STRING多少？下面是我的代码： private void DeleteButtonActionPerformed(java.awt.

我成功地删除了一个整数,但是当我试图将它变为STRING时它会说
“where子句中的未知列itemtodelete但是我的ITEMTODELETE是在数据库中声明的STRING不是一个整数它不删除一个STRING多少？

下面是我的代码：

private void DeleteButtonActionPerformed(java.awt.event.ActionEvent evt) {                                            
        int del = (prompt):
        if (del == JOptionPane.YES_OPTION){
        DelCurRec();
        }

    }     


   public void DelCurRec() {

        String id = field.getText();
        String SQL = "DELETE FROM inventory WHERE ItemCode = "+id+" ";

        try {
           Class.forName(connectio);
       }  catch (Exception e) {
           JOptionPane.showMessageDialog(null,""+e.getMessage(),"JDBC Driver Error",JOptionPane.WARNING_MESSAGE);
       }

        Statement stmt = null;
        Connection con = null;

        //Creates connection to database
        try {
            con = DriverManager.getConnection("Connection");
            stmt = con.createStatement();
        } catch (Exception e) {
            JOptionPane.showMessageDialog(null,"Connection Error",JOptionPane.WARNING_MESSAGE);
        }

        //Execute the SQL statment for deleting records
        try {
            stmt.executeUpdate(SQL);
            //This closes the connection to the database
            con.close();
            //This closes the dialog
            JOptionPane.showMessageDialog(null,"Deleted Succesfully","Delete Successful",JOptionPane.WARNING_MESSAGE);
        } catch (Exception e) {
            JOptionPane.showMessageDialog(null,"Communication Error",JOptionPane.WARNING_MESSAGE);
        }
    }

解决方法

尝试更改线路：

String SQL = "DELETE FROM inventory WHERE ItemCode = "+id+" ";

至

String SQL = "DELETE FROM inventory WHERE ItemCode = '"+id+"' ";

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!