How to insert 10 million records into a MySQL database table in 88 seconds

set global max_allowed_packet = 100*1024*1024*

show VARIABLES like '%max_allowed_packet%'

package insert;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Date;
import com.mysql.jdbc.PreparedStatement;
public class InsertTest {
   public static void main(String[] args) throws ClassNotFoundException, SQLException {
     final String url = "jdbc:mysql://127.0.0.1/teacher" ; 
     final String name = "com.mysql.jdbc.Driver"; 
     final String user = "root" ; 
     final String password = "123456" ; 
     Connection conn = null; 
     Class.forName(name); //Specify the connection type conn = DriverManager.getConnection(url, user, password); //Get the connection if (conn!= null ) {
       System.out.println("Connection obtained successfully");
       insert(conn);
     } else {
       System.out.println("Failed to obtain connection");
     }
   }
   public static void insert(Connection conn) {
     // Start time Long begin = new Date().getTime();
     // sql prefix String prefix = "INSERT INTO t_teacher (id,t_name,t_password,sex,description,pic_url,school_name,regist_date,remark) VALUES ";
     try {
       // Save sql suffix StringBuffer suffix = new StringBuffer();
       // Set the transaction to non-auto commit conn.setAutoCommit( false );
       // PST is better than ST PreparedStatement pst = (PreparedStatement) conn.prepareStatement( "" ); //Prepare to execute statement// Outer loop, total number of committed transactions for ( int i = 1 ; i <= 100 ; i++) {
         suffix = new StringBuffer();
         // j-th submission step for ( int j = 1 ; j <= 100000 ; j++) {
           // Build SQL suffix suffix.append( "('" + uutil.UUIDUtil.getUUID()+ "','" +i*j+ "','123456'" + ",'Male'" + ",'Teacher'" + ",'www.bbk.com'" + ",'XX University'" + ",'" + "2016-08-12 14:43:26" + "','Note'" + ")," );
         }
         // Build complete SQL
         String sql = prefix + suffix.substring( 0 , suffix.length() - 1 );
         // Add execution SQL
         pst.addBatch(sql);
         // Execute operations pst.executeBatch();
         // Commit transaction conn.commit();
         // Clear the last added data suffix = new StringBuffer();
       }
       //First-class connection pst.close();
       conn.close();
     } catch (SQLException e) {
       e.printStackTrace();
     }
     // End time Long end = new Date().getTime();
     // Time consuming System.out.println( "Time taken to insert 10 million records: " + (end - begin) / 1000 + " s" );
     System.out.println("Insert completed");
   }
}