Implementation of inserting millions of records into MySQL database within 10 seconds

public class BaseDao { // Static tool class, used to create database connection objects and release resources for easy calling // Import the driver jar package or add Maven dependencies (Maven is used here, and the Maven dependency code is attached at the end of the article)
    static {
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
    }
 
    // Get the database connection object public static Connection getConn() {
        Connection conn = null;
        try {
            // rewriteBatchedStatements=true, insert multiple data at a time, insert only onceconn = DriverManager.getConnection("jdbc:mysql://localhost:3306/million-test?rewriteBatchedStatements=true", "root", "qwerdf");
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }
        return conn;
    }
 
    // Release resources public static void closeAll(AutoCloseable... autoCloseables) {
        for (AutoCloseable autoCloseable : autoCloseables) {
            if (autoCloseable != null) {
                try {
                    autoCloseable.close();
                } catch (Exception e) {
                    // TODO Auto-generated catch block
                    e.printStackTrace();
                }
            }
        }
    }
}

/* Because the processing speed of the database is very fast, the single throughput is very large and the execution efficiency is very high. addBatch() loads several SQL statements together and sends them to the database for execution at once. The execution takes a very short time. preparedStatement.executeUpdate() sends them to the database one by one for execution, and the time is consumed in the transmission of the database connection.*/
public static void main(String[] args) {
    long start = System.currentTimeMillis(); // Get the current time of the system and record it before the method starts executing Connection conn = BaseDao.getConn(); // Call the static tool class just written to get the connection database object String sql = "insert into mymilliontest values(null,?,?,?,NOW())"; // SQL statement to be executed PreparedStatement ps = null;
    try {
        ps = conn.prepareStatement(sql); // Get PreparedStatement object // Continuously generate sql
        for (int i = 0; i < 1000000; i++) {
            ps.setString(1, Math.ceil(Math.random() * 1000000) + "");
            ps.setString(2, Math.ceil(Math.random() * 1000000) + "");
            ps.setString(3, UUID.randomUUID().toString()); // The UUID class is used to randomly generate a string that will not be repeated ps.addBatch(); // Add a set of parameters to the batch command of this PreparedStatement object.
        }
        int[] ints = ps.executeBatch(); // Submit a batch of commands to the database for execution. If all commands are executed successfully, an array of update counts is returned.
        // If the array length is not 0, it means that the SQL statement is executed successfully, that is, one million data are added successfully!
        if (ints.length > 0) {
            System.out.println("One million records have been added successfully!!");
        }
    } catch (SQLException throwables) {
        throwables.printStackTrace();
    finally
        BaseDao.closeAll(conn, ps); // Call the static tool class just written to release resources}
    long end = System.currentTimeMillis(); // Get the system time again System.out.println("Time taken: " + (end - start) / 1000 + "seconds"); // Subtracting the two times is the time taken to execute the method}

<!--mysql-connector-java dependency used to connect to the database-->
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.27</version>
</dependency>