81,122
社区成员




/**
* 批量执行多条SQL
*
* @param connection 数据库连接
* @param sqls 多条更新语句
*/
public static void moreSql(Connection connection, JSONArray sqls) {
Statement statement = null;
try {
connection.setAutoCommit(false);
statement = connection.createStatement();
for (Object sql : sqls) {
if (null != sql && !ToolUtil.isBlank(sql.toString())) {
SqlUtil.show(sql.toString(), null, null);
statement.addBatch(sql.toString());
}
}
statement.executeBatch();// 执行更新
connection.commit();// 统一提交事务
statement.clearBatch();// 清除批量
} catch (Exception e) {
try {
connection.rollback();// 事务回滚
} catch (Exception e2) {
}
throw new RuntimeException(e);
} finally {
ReflectUtil.close(connection, statement);
}
}