java mysql快速导入大数据

try (Connection conn = DriverManager.getConnection(url, username, password);
     PreparedStatement pstmt = conn.prepareStatement("INSERT INTO table_name (column1, column2) VALUES (?, ?)")) {
    for (Data data : dataList) {
        pstmt.setString(1, data.getColumn1());
        pstmt.setString(2, data.getColumn2());
        pstmt.addBatch();
    }
    pstmt.executeBatch();
} catch (SQLException e) {
    e.printStackTrace();
}

try (BufferedReader br = new BufferedReader(new FileReader("data.csv"));
     Connection conn = DriverManager.getConnection(url, username, password);
     PreparedStatement pstmt = conn.prepareStatement("INSERT INTO table_name (column1, column2) VALUES (?, ?)")) {
    String line;
    while ((line = br.readLine()) != null) {
        String[] values = line.split(",");
        pstmt.setString(1, values[0]);
        pstmt.setString(2, values[1]);
        pstmt.addBatch();
        if (batchSize % 1000 == 0) {
            pstmt.executeBatch();
        }
    }
    pstmt.executeBatch();
} catch (IOException | SQLException e) {
    e.printStackTrace();
}

# 数据库连接池配置示例
spring.datasource.hikari.connection-timeout=60000
spring.datasource.hikari.validation-timeout=30000
spring.datasource.hikari.idle-timeout=600000
spring.datasource.hikari.max-lifetime=1800000