mybatis in查询条件过长的解决方法

方法1：分次查询，将参数且分割成多个短的查询后合并
代码：

int splitNum =(int) Math.ceil( (float) ids.length/999); //切片数量
List itemIdList = new ArrayList<>(Arrays.asList(ids));
List<List> splitList = averageAssign(itemIdList, splitNum);
for (List list : splitList) {
param.put(“itemIds”,list);
List<Map<Object, Object>> itemStatisticsList = iProcessExtMapper.getItemStatisticsList(param);
result.addAll(itemStatisticsList);
}

将list分成N等分方法方法：

public static <T> List<List<T>> averageAssign(List<T> source,int n){
List<List<T>> result=new ArrayList<List<T>>();
int remaider=source.size()%n;  //(先计算出余数)
int number=source.size()/n;  //然后是商
int offset=0;//偏移量
for(int i=0;i<n;i++){
 List<T> value=null;
 if(remaider>0){
  value=source.subList(i*number+offset, (i+1)*numbe