java mysql大量insert

try (Connection conn = DriverManager.getConnection(url, username, password);
     PreparedStatement pstmt = conn.prepareStatement("INSERT INTO table_name (column1, column2) VALUES (?, ?)")) {
    conn.setAutoCommit(false); // 关闭自动提交
    for (int i = 0; i < dataList.size(); i++) {
        pstmt.setString(1, dataList.get(i).getColumn1());
        pstmt.setString(2, dataList.get(i).getColumn2());
        pstmt.addBatch(); // 添加到批处理
        if (i % 1000 == 0) { // 每1000条提交一次
            pstmt.executeBatch(); // 执行批处理
            conn.commit(); // 提交事务
            pstmt.clearBatch(); // 清空批处理
        }
    }
    pstmt.executeBatch(); // 执行剩余的批处理
    conn.commit(); // 提交事务
} catch (SQLException e) {
    e.printStackTrace();
}