分页:
- 直接处理
public Response findReportList(Long schoolCode, Long subjectCode, Long classCode,int index,int max) {
Map<String,Object> map = Maps.newHashMap();
Long reportNum = resultStatisticalMapper.getReportNum(schoolCode,subjectCode,classCode);
List<ClassOutline> list= new ArrayList<>();
if (reportNum > 0){
list= resultStatisticalMapper.findReportList(schoolCode,subjectCode,classCode,(index * max),max);
int num = (index * max) + max;
if (num >= reportNum) {
map.put("hasNext", false);
} else {
map.put("hasNext", true);
}
}else{
map.put("hasNext", false);
}
map.put("total", (reportNum == null) ? 0 : reportNum);
map.put("list", list);
return Response.success(map);
}
上面這个方法就是对报告列表分页查找, index(查询页码,默认从0开始),max(每页最多显示得条数),从前端传过来的。
报告列表得查询sqly语句;
LIMIT #{start}, #{max}
#{start}:查询结果得索引值(