JZTXT

jdbc批量插入

发布时间 2023-11-14 18:54:24作者: chenzechao

1. 开启JDBC

rewriteBatchedStatements=true

2. 准备数据

PreparedStatement preparedStatement = connection.prepareStatement(InsertSql);

3. 插入数据并添加到批次

preparedStatement.setObject(columnIndex, resultSet.getObject(columnIndex));
preparedStatement.addBatch();

4. 批量提交并清空批次

if (resultSet.getRow() % 500 == 0) {
    log.info("当前行数：" + resultSet.getRow());
    preparedStatement.executeBatch();
    preparedStatement.clearBatch();
}

if (resultSet.isLast()) {
    log.info("最后一行：" + resultSet.getRow());
    preparedStatement.executeBatch();
    preparedStatement.clearBatch();
}