java多线程插入数据_Java基础知识（四）使用多线程插入数据

importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.SQLException;importjava.sql.Statement;importjava.util.UUID;importjava.util.concurrent.CountDownLatch;importjava.util.concurrent.ExecutorService;importjava.util.concurrent.Executors;public classtest_20191010 {public static voidmain(String... arg) {

BatchInsert bi= newBatchInsert();//bi.exec();//自动分配需要线程 耗时80s//bi.exec(1);//使用单线程 耗时288s

bi.exec(10);//手动分配需要线程 耗时81s

}

}classBatchInsert {private final String url = "jdbc:mysql://localhost:3306/test";private final String user = "root";private final String pwd = "root";private final int dataSize = 1000000;//插入数据数量

private final int dataUnit = 10000;//1个线程处理数据数量

privateConnection getConn() {

Connection conn= null;try{

Class.forName("com.mysql.jdbc.Driver");

conn=DriverManage