批处理更新是同时执行多个语句的机制。
要执行批处理,需要:
– 按照正常的方式创建一个语句对象
– 向语句对象中添加多个要执行的SQL语句
– 执行批处理
示例1:
Statement stmt = connection.createStatement();
stmt.addBatch("insert into test values(’. . .’)");
stmt.addBatch("insert into test values(’. . .’)");
. . .
stmt.executeBatch();// 返回 结果 影响行数
示例2:
String sql = "insert into dept values(?,?,?);";
PreparedStatement pStatement = connection.prepareStatement(sql);
pStatement.setString(1, dept.getDeptno());
pStatement.setString(3, dept.getLoc());
pStatement.addBatch();
String sql1 = "insert into dept values('90','市场部','杭州');";
pStatement.addBatch(sql1);
. . .
pStatement.executeBatch();