1.引入依赖
<dependency> <groupId>com.github.pagehelper</groupId> <artifactId>pagehelper-spring-boot-starter</artifactId> <version>${pageHelper.version}</version> </dependency> |
2.在controller中实现分页:
@PostMapping("/paperList")
public Result paperList(Integer current,Integer size){
HashMap<String,Object> hs=new HashMap<>();
try {
List<Map<String,Object>> data=new ArrayList<>();
Map<String,Object> colmnMap = new HashMap<>();
PageHelper.startPage(current!=null?current:1,size!=null?size:10);
List<TPaper> paperList = paperService.list(new QueryWrapper<TPaper>().eq("data_state", "Normal"));
for (TPaper p:paperList) {
Map<String,Object> map = new HashMap<>();
colmnMap.put("data_state","Normal");
colmnMap.put("id",p.getKnowledgeTestId());
map.put("id",p.getId());
map.put("paperNum",p.getPaperNum());
map.put("paperPwd",p.getPaperPwd());
data.add(map);
}
PageInfo<Map<String, Object>> page = new PageInfo<Map<String, Object>>(data);
hs.put("page",page);
return Result.ok(hs);
}catch (Exception e){
return Result.error(901,e.getMessage());
}
}
|
注意代码中的红色字体,如果红色字体放在查询数据后,很可能分页不生效