分页查询建议全部添加排序规则,即使不需要也要添加按主键排序,原因:
Integer pageNum = 0;
Integer pageSize = 100;
while(true) {
pageNum++;
PageHelper.startPage(pageNum, pageSize);
ThreePlaceInfoExample placeExample = new ThreePlaceInfoExample();
placeExample.createCriteria().andProjectGuidEqualTo(projectId);
// placeExample.setOrderByClause("guid");
List<ThreePlaceInfo> placeList = threePlaceInfoMapper.selectByExample(placeExample);
PageInfo<ThreePlaceInfo> pageInfo = new PageInfo<>(placeList);
for (ThreePlaceInfo placeInfo : placeList) {
//获取该场所相关的片区信息
if (placeInfo == null) {
log.info("场所为空,跳过创建该场所:");
continue;
}
//判断当前场所是否添加过,如果没有添加过,则进行添加
if (placeBaseMapper.selectByPrimaryKey(placeInfo.getGuid()) == null) {
PlaceBase currentAddPlaceInfo = addPlaceOnly(placeInfo, networkInfo, projectAdminId);
}
}
}
这段代码执行3次,发现每次数量都不对,后来添加了按guid排序后正确。
分页查找排序的作用
最新推荐文章于 2025-01-22 03:20:39 发布