title: How to delete a record (string) JAVA and MYSQL
body: <p>I successfully can delete an integer but when I tried to make it a STRING it says
  "unknown column itemtodelete in where clause but my ITEMTODELETE is a STRING declared in the database not an integer how much It doesn't delete a STRING?</p>
  
  <p>below is my code:</p>
  
  <pre><code> 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,""+e.getMessage(),"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,""+e.getMessage(),"Communication Error",JOptionPane.WARNING_MESSAGE);
          }
      }
  </code></pre>