Spring boot分页
分页QueryPageParam
点击查看代码
package com.example.demo.common;
import lombok.Data;
import java.util.HashMap;
@Data
public class QueryPageParam {
//默认
private static int PAGE_SIZE = 20;
private static int PAGE_NUM = 1;
private int pageSize=PAGE_SIZE;
private int pageNum=PAGE_NUM;
private HashMap param=new HashMap();
public int getPageSize() {
return pageSize;
}
public void setPageSize(int pageSize) {
this.pageSize = pageSize;
}
public int getPageNum() {
return pageNum;
}
public void setPageNum(int pageNum) {
this.pageNum = pageNum;
}
@Override
public String toString() {
return "QueryPageParam{" +
"pageSize=" + pageSize +
", pageNum=" + pageNum +
", param=" + param +
'}';
}
public HashMap getParam() {
return param;
}
public void setParam(HashMap param) {
this.param = param;
}
}
分页controler1
点击查看代码
//分页
@PostMapping("/listPage")
//public List<User> listPage(@RequestBody HashMap map){ //自动提取
public List<User> listPage(@RequestBody QueryPageParam queryPageParam){
System.out.println(queryPageParam);
System.out.println("num=="+queryPageParam.getPageNum());
System.out.println("size=="+queryPageParam.getPageSize());
HashMap param = queryPageParam.getParam();
String name = param.get("name").toString();
System.out.println("name==="+(String)param.get("name"));
// System.out.println("no==="+(String)param.get("no"));
Page<User> page = new Page<>(queryPageParam.getPageNum(),queryPageParam.getPageSize());
LambdaQueryWrapper<User> queryWrapper = new LambdaQueryWrapper<>();
queryWrapper.like(User::getName,name);
IPage result=userService.page(page,queryWrapper);
System.out.println("total=="+result.getTotal());//总数
//System.out.println("num=="+(String) map.get("pageSize"));
return result.getRecords();
}
分页controler2
点击查看代码
@PostMapping("/listPageC")
//public List<User> listPage(@RequestBody HashMap map){
public List<User> listPageC(@RequestBody QueryPageParam queryPageParam){
System.out.println(queryPageParam);
System.out.println("num=="+queryPageParam.getPageNum());
System.out.println("size=="+queryPageParam.getPageSize());
HashMap param = queryPageParam.getParam();
System.out.println("name==="+(String)param.get("name"));
String name = param.get("name").toString();
Page<User> page = new Page<>(queryPageParam.getPageNum(),queryPageParam.getPageSize());
LambdaQueryWrapper<User> queryWrapper = new LambdaQueryWrapper<>();
queryWrapper.like(User::getName,name);
//IPage result=userService.pageC(page);
IPage result=userService.pageCC(page,queryWrapper);
System.out.println("total=="+result.getTotal());//总数
//System.out.println("num=="+(String) map.get("pageSize"));
return result.getRecords();
}
浙公网安备 33010602011771号