java - 如何在java中删除MySQL数据库中选中的记录(行)

Question

如何删除MySQL数据库选中的记录(行)我用这个代码

connectDB();
try{
    java.sql.PreparedStatement stmt = con.prepareStatement("DELETE FROM tbl_codes WHERE No=? ");
    String sql = "Delete FROM user WHERE No= "+txt_search_code.getText(); 
    pstmt = con.prepareStatement(sql);
    pstmt.setString(1,txt_search_code.getText());
    pstmt.execute();
    JOptionPane.showMessageDialog(null, " Your new records Deleted Succsessfully!!");   
} catch(Exception e){
    JOptionPane.showMessageDialog(null,e);
}
closeDB();

但是它得到这样的错误-

java.sql.SQLException:Parameter index out of range(1>number of parameters,which is 0)

那么我该如何解决这个问题....(请举例)谢谢

Answer 1

试试这个:

connectDB();
try{
    java.sql.PreparedStatement stmt = con.prepareStatement("DELETE FROM tbl_codes WHERE No=? ");
    stmt.setString(1,txt_search_code.getText());
    stmt.execute();
    JOptionPane.showMessageDialog(null, " Your new records Deleted Succsessfully!!");   
} catch(Exception e){
    JOptionPane.showMessageDialog(null,e);
}
closeDB();