Java mybatis 插入10w 条数据

Java mybatis 插入10w 条数据

• Java + mybatis + MySQL
• 分批次,list 循环插入

java service 代码

public void batchInsert() {
        // 每次插入记录数
        int size = 2000;
        // 总共执行插入操作次数
        int i = 0;
        // 待处理元数据
        List<Demo> list = Lists.newArrayList();
        if (!CollectionUtils.isEmpty(list)) {
            while (list.size() > size) {
                List<Demo> subList = list.subList(0,size);
                list = list.subList(size, list.size());
                // 批量入库
                batchInsert2(subList);
                i++;
            }
            if (!CollectionUtils.isEmpty(list)) {
                batchInsert2(list);
            }
        }
    }

    /**
     * @Author CaiXiaowei
     * @Description 具体插入操作
     * @Date 2020/3/21 11:19 
     * @param 
     * @return 
     **/
    private void batchInsert2(List<Demo> list) {
        demoMapper.batchInsert(list);
    }

mybatis xml文件

<insert id="batchInsert" >
    INSERT INTO company_balance
    (id, name)
    VALUES
    <foreach collection ="list" item="item" separator =",">
        (#{item.id}, #{item.name})
    </foreach >
</insert>