MySQL批量查询

public List<Long> batchSelectImageIds(Long templateId){List<Long> imageIdList = new ArrayList<>();int count = templateBlackImageRelMapper.selectImageCount(templateId);int limit = 500

黑蛋先生

4595人浏览 · 2022-02-07 10:30:30

黑蛋先生 · 2022-02-07 10:30:30 发布

//分批查询：
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;
}