java集合处理数据量过大导致超过Mysql in的最大值

一、解决方案

(1) 将List转换为String

String Str = list.stream().map(t -> t.toString()).collect(Collectors.joining(","));
1

   <if test="Str!=null and Str!=''">
            and Id in (${Str})
    </if>
1
2
3

(2) 将List分批查询

List<List<Long>> devListAll = Lists.partition(List, 10000);
1