How to delete a MySQL database in java selected record (row)

Question

How to delete a MySQL database selected record (row) I use this code

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();

but it get an error like this -

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

So how can I fix this probleam....(Examples please) Thanks

Remove your String sql. You've already had stmt. Use it to execute query instead of pstmt — Roman Danilov
– Roman Danilov, Commented Sep 26, 2017 at 6:28
I tried this code [ string sql = "Delete FROM user WHERE No= '" + txt_search_code.getText()+ "'"; ] but it still get an error like this - "java.sql.SQLException:Parameter index out of range(1>number of parameters,which is 0)" So how can I fix this probleam....(Examples please) Thanks — sumith
– sumith, Commented Sep 27, 2017 at 7:18

Roman Danilov · Accepted Answer · 2017-09-26 06:39:45Z

2

Try this:

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();

answered Sep 26, 2017 at 6:39

Roman Danilov

3713 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Yarince · Accepted Answer · 2017-09-26 06:40:10Z

1

The problem is you are not using quotation marks around the string you want to delete.

It should be the following:

string sql = "Delete FROM user WHERE No= '" + txt_search_code.getText()+ "'";

Sql is now tring to convert to numerics.

answered Sep 26, 2017 at 6:40

Yarince

631 silver badge9 bronze badges

1 Comment

Yarince Over a year ago

Excuse me, that is definitely better!

Collectives™ on Stack Overflow

How to delete a MySQL database in java selected record (row)

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related