/**
* 批处理
*
* @throws Exception
*/
@Test
public void testBatch() throws Exception {
String sql = "insert into admin (userName,pwd) values(?,?)";
conn = DbUtil.getConnection();
QueryRunner qr = new QueryRunner();
// 批量插入
qr.batch(conn, sql, new Object[][] {{"jack1", "888"}, {"jack2", "999"}});
// 关闭
DbUtils.close(conn);
}
/**
* 更新
*
* @throws Exception
*/
@Test
public void testUpdate() throws Exception {
String sql = "delete from admin where id=?";
// 连接对象
conn = DbUtil.getConnection();
// 创建DbUtils核心工具类对象
QueryRunner qr = new QueryRunner();
qr.update(conn, sql, 26);
// 关闭
DbUtils.close(conn);
}