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); //指定連接類型      conn = DriverManager.getConnection(url, user, password); //獲取連接      if (conn!= null ) {       System.out.println( "獲取連接成功" );       insert(conn);     } else {       System.out.println( "獲取連接失敗" );     }   }   public static void insert(Connection conn) {     // 開始時間     Long begin = new Date().getTime();     // sql前綴     String prefix = "INSERT INTO t_teacher (id,t_name,t_password,sex,description,pic_url,school_name,regist_date,remark) VALUES " ;     try {       // 保存sql后綴       StringBuffer suffix = new StringBuffer();       // 設(shè)置事務(wù)為非自動提交       conn.setAutoCommit( false );       // 比起st，pst會更好些       PreparedStatement pst = (PreparedStatement) conn.prepareStatement( "" ); //準(zhǔn)備執(zhí)行語句       // 外層循環(huán)，總提交事務(wù)次數(shù)       for ( int i = 1 ; i <= 100 ; i++) {         suffix = new StringBuffer();         // 第j次提交步長         for ( int j = 1 ; j <= 100000 ; j++) {           // 構(gòu)建SQL后綴           suffix.append( "('" + uutil.UUIDUtil.getUUID()+ "','" +i*j+ "','123456'" + ",'男'" + ",'教師'" + ",'www.bbk.com'" + ",'XX大學(xué)'" + ",'" + "2016-08-12 14:43:26" + "','備注'" + ")," );         }         // 構(gòu)建完整SQL         String sql = prefix + suffix.substring( 0 , suffix.length() - 1 );         // 添加執(zhí)行SQL         pst.addBatch(sql);         // 執(zhí)行操作         pst.executeBatch();         // 提交事務(wù)         conn.commit();         // 清空上一次添加的數(shù)據(jù)         suffix = new StringBuffer();       }       // 頭等連接       pst.close();       conn.close();     } catch (SQLException e) {       e.printStackTrace();     }     // 結(jié)束時間     Long end = new Date().getTime();     // 耗時     System.out.println( "1000萬條數(shù)據(jù)插入花費時間 : " + (end - begin) / 1000 + " s" );     System.out.println( "插入完成" );   }}