DbUtils之更新（广义）和批处理操作

public class App_update {private Connection conn;// 1. 更新@Testpublic void testUpdate() throws Exception {String sql = "delete from admin where id=?";// 连接对象conn = JdbcUtil.getConnection();// 创建DbUtils核心工具类对象QueryRunner qr = new QueryRunner();qr.update(conn, sql, 26);// 关闭DbUtils.close(conn);}// 2. 批处理@Testpublic void testBatch() throws Exception {String sql = "insert into admin (userName, pwd) values(?,?)";conn = JdbcUtil.getConnection();QueryRunner qr = new QueryRunner();// 批量删除qr.batch(conn, sql, new Object[][]{ {"jackyy1","888"},{"jackyy2","999"}  });// 关闭conn.close();}}