Implementation of inserting millions of data into MySQL database in 10 seconds

public class BaseDao {  //   Static tool class , Used to create database connection objects and release resources , Convenient to call 
    //     Import driver jar Package or add Maven rely on （ What we use here is Maven,Maven The dependent code is attached at the end of the text ）
    static {
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
    }
//  Get database connection object  public static Connection getConn() { Connection conn = null; try { // rewriteBatchedStatements=true, Insert multiple data at a time , Just insert it once  conn = 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 amazing   The single throughput is very large   Very efficient execution 
    addBatch() Put a number of sql Statements are loaded together , Then it is sent to the database for execution at one time , Execution takes a short time 
     and preparedStatement.executeUpdate()  It is sent to the database one by one for execution   Time is spent on the transmission of database connection */
public static void main(String[] args) {
    long start = System.currentTimeMillis();    //   Get the current time of the system , Record before method execution 
    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())";  //   Executes sql sentence 
    PreparedStatement ps = null;
    try {
        ps = conn.prepareStatement(sql);    //   obtain PreparedStatement object 
        //   Continuous production 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());  //  UUID This class is used to randomly generate a string that will not be repeated 
            ps.addBatch();  //   Adds a set of parameters to this  PreparedStatement  Object in the batch command .
        }
        int[] ints = ps.executeBatch();//    Submit a batch of commands to the database for execution , If all commands are executed successfully , Returns an array of update counts .
        //   If the array length is not 0, shows sql Statement executed successfully , That is, one million pieces of data are added successfully ！
        if (ints.length > 0) {
            System.out.println(" One million pieces of data have been successfully added ！！");
        }
    } 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 used :" + (end - start) / 1000 + " second ");  //   Subtracting the two times is the time taken for the method to execute 
}

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