Question

JAVA用批处理怎么执行多条SQL语句

public int deleteGoodsOne(String goodid,int status) {
int i = 0;
String sql = "";
if(status == 1 || status == 2)
{
sql = "update goods set status = 0 where goodid = ?";
//这里想增加update record set status = 0 where goodid = ?
}else{
sql = "update goods set status = 1 where goodid = ?";
//这里想增加update record set status = 1 where goodid = ?
}
conn = db.getConn();
try {
ps = conn.prepareStatement(sql);
ps.setString(1,goodid);
i=ps.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
} finally {
db.closeDB(conn);
}
return i;
}
请问怎么实现？

Answer 1

使用PreparedStatement的addBatch()方法添加批量sql执行，然后用executeBatch()来批量执行add进去的sql

追问

能在我的基础上改一下吗？我自己改完后不能用，也没有报错信息~