//分批查询:
public List<Task> batchSelectTaskList(Long id){
  List<Task> taskList = new ArrayList<>();
  int count = mapper.selectTaskCount(id);
  int limit = 500;
  int batchSelectCount = count%limit == 0 ? count/limit : count/limit+1;
  int start = 0;
  int end = 0;
  for(int i=1;i<=batchSelectCount;i++){
    //end = i==batchSelectCount ? end+count%limit : end+limit;
    end = end+limit;
    List<Task> subTaskList = mapper.batchSelect(id,start,limit);
    start = end;
    taskList.addAll(subTaskList);
  }
  return taskList;
}

Logo

为开发者提供学习成长、分享交流、生态实践、资源工具等服务,帮助开发者快速成长。

更多推荐