Java批量向数据库插入10W数据

一、准备工作：

1、依赖：这里面的mysql版本要和插入数据库版本保持一致

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.20</version>
</dependency>
    <dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis</artifactId>
        <version>3.5.8</version></dependency>

二、代码段：

import java.sql.*;

public class BatchUpdate {
    static final String JDBC_DRIVER = "com.mysql.cj.jdbc.Driver";
    static final String DB_URL = "jdbc:mysql://localhost";

    static final String USER = "USER";
    static final String PASS = "PASS";
    static final String INSERT_SQL = "INSERT INTO ddd.ddd_stubjt (num,name,age,sex,phonenumber,email) VALUES (?,?,25,'男','12312343234','123456@163.com')";

public static void main(String[] args) {
    long startTime = System.currentTimeMillis();
    try (Connection conn = DriverManager.getConnection(DB_URL, USER, PASS)){
        PreparedStatement pstmt = conn.prepareStatement(INSERT_SQL);
        int batchSize = 1000;
        int count = 0;
        for (int i = 1; i <= 5; i++) {
            pstmt.setInt(1, i % 100);
            pstmt.setString(2, "张北北" + i);
            pstmt.addBatch();
            count++;
            if (count % batchSize == 0) {
                pstmt.executeBatch();
                count = 0;
            }
        }
        if (count > 0) {
            pstmt.executeBatch();
        }
        long endTime = System.currentTimeMillis();
        System.out.println("Total execution time: " + (endTime - startTime) + "ms");
    } catch (SQLException e) {
        e.printStackTrace();
    }
}
}