参考

(525条消息) mybatis解决＜foreach＞标签不能超过1000的问题_mybatis每次提交1000条数据_小海海不怕困难的博客-CSDN博客

本人自测

   @Override
    public List<Dict> a20000() {
        ArrayList<String> list1 = new ArrayList<>();
        for (int i = 0; i < 6000; i++) {
            list1.add(String.valueOf(i));
        }
        List<Dict> list=  dictMapper.select2000(list1);
        return list;
    }

   <select id="select2000" resultType="com.atguigu.yygh.model.cmn.Dict">
        select * from t_test
        WHERE
        t_test.id IN
        <foreach collection="list1" index="index" open="(" close=")" item="id" separator=",">
        <if test="(index % 999) == 998"> NULL) OR t_test.id IN(</if>

         #{id}
        </foreach>

    </select>

最终的sql