使用jdbc在mysql数据库中快速批量插入数据

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class BatchInsertExample {
    public static void main(String[] args) {
        String jdbcUrl = "jdbc:mysql://localhost:3306/mydatabase";
        String username = "root";
        String password = "password";
        
        String sql = "INSERT INTO mytable (column1, column2) VALUES (?, ?)";
        
        try (Connection connection = DriverManager.getConnection(jdbcUrl, username, password);
             PreparedStatement statement = connection.prepareStatement(sql)) {
            
            connection.setAutoCommit(false); // 开启事务批处理模式
            
            for (int i = 0; i < 1000; i++) {
                statement.setString(1, "value1");
                statement.setString(2, "value2");
                statement.addBatch(); // 添加到批处理中
            }
            
            statement.executeBatch(); // 执行批处理
            
            connection.commit(); // 提交事务
            
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}