mybatis中大数据量foreach插入效率对比_insert放到<foreach 效率-CSDN博客

本文链接：https://blog.csdn.net/weixin_45810161/article/details/130343044

1.controller代码

    @RequestMapping("/testInsert")
    public String testInsert(Integer sum){
        testService.testInsert(sum);
        return "发送成功";
    }

2.service代码

 @Override
    public void testInsert(Integer sum) {
        long start = System.currentTimeMillis();
        List<TestDTO> list = new ArrayList<>();

        for (int i = 0; i < sum; i++) {
            TestDTO testDTO = new TestDTO();
            testDTO.setId(i);
            testDTO.setAgentId(2L*i);
            list.add(testDTO);
            if (i % 300 == 0){
                testMapper.testInsert(list);
                list.clear();
            }
        }
        if (ToolUtil.isNotEmpty(list)){
            testMapper.testInsert(list);
        }
        long end = System.currentTimeMillis();
        System.out.println("时间:"+(end - start)/1000);
    }

3.mapper代码

void testInsert(@Param("list") List<TestDTO> list);

4.xml代码

<insert id="testInsert">
    INSERT INTO tb_agent_test
        (id, agent_id)
    VALUES
    <foreach collection="list" item="testDTO" separator=",">
        (#{testDTO.id},#{testDTO.agentId})
    </foreach>
    </insert>