delete more than 1 records using single prepared statement

Question

I am executing two prepared statement for deleting two records of different id. i want to delete both records in a single prepared statement execution my code is like this

String sqlDelete,sqlSelect2; sqlDelete = "delete from vul_detail where scanno=? and id=?";// PreparedStatement ps2=conn.prepareStatement(sqlDelete); // System.out.println("PS Created Successfully"); ps2.setString(1, "scan_2"); ps2.setInt(2, 2); // ps2.setInt(3, 5); ps2.executeUpdate(); System.out.println("first record deleted"); ps2.setString(1, "scan_2"); ps2.setInt(2, 5); ps2.executeUpdate(); System.out.println("second record deleted"); sqlSelect2="select * from vul_detail;"; stmt=conn.createStatement(); System.out.println("select query created"); ResultSet rs2 = stmt.executeQuery(sqlSelect2);

I tried query as

sqlDelete = "delete from vul_detail where scanno=? and id=?,?"; PreparedStatement ps2=conn.prepareStatement(sqlDelete); System.out.println("PS Created Successfully"); ps2.setString(1, "scan_2"); ps2.setInt(2, 2); ps2.setInt(3, 5); ps2.executeUpdate();

I am getting exception in this please help

You already got an answer that should fix this issue (since it's quite obvious). But please remember to include the exception in future questions instead of just saying "I am getting exception". — user2298374
– user2298374, Commented Sep 25, 2013 at 7:42

M Abbas · Accepted Answer · 2013-09-25 07:26:13Z

The syntax for the "IN" condition is:

expression in (value1, value2, .... value_n);

In your example:

sqlDelete = "delete from vul_detail where scanno = ? and id in (?, ?)";

Collectives™ on Stack Overflow

delete more than 1 records using single prepared statement

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related