dao层
Page<Config> selectListByPage(Map map);
xml
<select id="selectListByPage" resultMap="com.briup.user.dao.ConfigMapper.BaseResultMap">
select <include refid="com.briup.user.dao.ConfigMapper.Base_Column_List"/>
from base_config
</select>
service
PageInfo selectListByPage(int currentPage,int pageSize);
PageUtil selectListByPage(PageUtil pageUtil);
service实现类
@Override
public PageInfo selectListByPage(int pageNumber, int pageSize) {
PageHelper.startPage(pageNumber,pageSize);
List<Config> configList = configExtendMapper.selectListByPage();
System.out.println("configList = " + configList);
return new PageInfo(configList);
}
@Override
public PageUtil selectListByPage(PageUtil pageUtil) {
PageHelper.startPage(pageUtil.getPageNumber(),pageUtil.getPageSize());
Page page = configExtendMapper.selectListByPage(null);
pageUtil.setList(page.getResult());
pageUtil.setTotal(page.getTotal());
return pageUtil;
}
controller
@ApiOperation(value = "分页查询所有配置", notes = "提供分页参数")
@ApiImplicitParams({
@ApiImplicitParam(name = "pageNumber", value = "当前页", dataType = "int", paramType = "path", defaultValue = "0"),
@ApiImplicitParam(name = "pageSize", value = "每页条数", dataType = "int", paramType = "path", defaultValue = "5")
})
@GetMapping("/{pageNumber}/{pageSize}")
public Result selectByPage(@PathVariable Integer pageNumber, @PathVariable Integer pageSize) {
PageInfo pageInfo = configService.selectListByPage(pageNumber, pageSize);
return Result.success(pageInfo);
}
@ApiOperation("带条件的简洁分页")
@PostMapping("/selectByPageWithMe")
public Result selectByPageWithMe(@RequestBody PageUtil pageUtil) {
pageUtil = configService.selectListByPage(pageUtil);
return Result.success(pageUtil);
}