java用PrepareStatement实现多sql语句执行

最新推荐文章于 2025-06-01 00:14:52 发布

原创最新推荐文章于 2025-06-01 00:14:52 发布 · 6.5k 阅读

11 ·

CC 4.0 BY-SA版权

文章标签：

#Java #PrepareStatement #sql #多条sql执行

try{

//连接数据库

conn = ConnMysqlUtil.getConnection();
//禁止自动提交(默认为自动提交，所以需要修改)
conn.setAutoCommit(false);
prst = conn.prepareStatement("update tb_admin set username = '123' where id = 11 ");
prst.executeUpdate();//加载到缓冲区而不执行
prst = conn.prepareStatement("update tb_admin set userpass = '456' where id = 12 ");
prst.executeUpdate();//同上
prst = conn.prepareStatement("update tb_admin set userage = '789' where id = 13 ");
prst.executeUpdate();//同上
conn.commit();//提交处于缓冲区的sql
conn.setAutoCommit(true);

}catch (Exception e) {

e.printStackTrace();

}finally{

//关闭数据库连接

ConnMysqlUtil.release(rest, prst, conn);

}

try{

//连接数据库
conn = ConnMysqlUtil.getConnection();
prst = conn.prepareStatement("update tb_admin set adminpass = ? where id = ? ");
prst.setString(1, "123");
prst.setString(2, "11");
prst.addBatch();
prst.setString(1, "123");
prst.setString(2, "12");
prst.addBatch();
prst.setString(1, "123");
prst.setString(2, "13333");
prst.addBatch();
prst.executeBatch();