Java多线程百万数据快速入库
说明:实体类是自己项目中用到的,注释的部分为多线程提供。
package cn.boraydata.epc.web.controller.tool;
import cn.boraydata.epc.system.domain.CalResult;
import com.mysql.cj.jdbc.MysqlDataSource;
import lombok.Data;
import lombok.SneakyThrows;
import org.springframework.jdbc.datasource.DataSourceUtils;
import java.math.BigDecimal;
import java.sql.*;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.Random;
import java.util.concurrent.ExecutorService;
import java.util.concurrent.Executors;
import java.util.concurrent.atomic.AtomicInteger;
public class Producer {
public static void main(String[] args) throws SQLException {
Producer.createData();
}
public static void createData() throws SQLException {
ExecutorService pool = Executors.newFixedThreadPool(100);
final int totalPageNo = 10;
final int pageSize =</