在mybatis中
1)写查询所有的满足条件的sql
2)在分页的sql中添加
limit #{limitStart},#{limitLength}
3)在controller中
if (StringUtils.isBlank(currPage)) {
currPage = “1”;
}
if (StringUtils.isBlank(onePageNum)) {
onePageNum = “5”;
}
//查询所有的满足条件的sql,查询的总数量
Integer count = informationService.getInformationCount();
Integer pageTotal = count % Integer.valueOf(onePageNum) == 0 ? count / Integer.valueOf(onePageNum) : (count / Integer.valueOf(onePageNum) + 1);
Integer limitStart = (Integer.valueOf(currPage) - 1) * Integer.valueOf(onePageNum);
Integer limitLength = (Integer.valueOf(onePageNum));
List informationVOList = informationService.getInformationDetail(limitStart,limitLength);
springboot分页
最新推荐文章于 2022-11-25 23:25:27 发布