下面列出了怎么用com.github.pagehelper.PageInfo的API类实例代码及写法，或者点击链接到github查看源代码。
@GetMapping("/_useSqlhelper_over_pageHelper")
public Page list_sqlhelper_over_pageHelper(
@RequestParam(name = "pageNo") Integer pageNo,
@RequestParam(name = "pageSize") Integer pageSize,
@RequestParam(name = "sort", required = false) String sort,
@RequestParam(value = "countColumn", required = false) String countColumn) {
Page page = PageHelper.offsetPage(pageNo, pageSize);
// Page page = PageHelper.startPage(pageNo, pageSize, sort);
page.setCountColumn(countColumn);
User queryCondition = new User();
queryCondition.setAge(10);
List<User> users = userDao.selectByLimit(queryCondition);
String json = JSONBuilderProvider.simplest().toJson(users);
System.out.println(json);
json = JSONBuilderProvider.simplest().toJson(users);
System.out.println(json);
PageInfo pageInfo1 = new PageInfo(page);
json = JSONBuilderProvider.simplest().toJson(pageInfo1);
System.out.println(json);
PageInfo pageInfo2 = new PageInfo(users);
json = JSONBuilderProvider.simplest().toJson(pageInfo2);
System.out.println(json);
return page;
}
@Permission(type = ResourceType.ORGANIZATION)
@ApiOperation(value = "查询状态机方案列表")
@CustomPageRequest
@GetMapping
public ResponseEntity<PageInfo<StateMachineSchemeVO>> pagingQuery(@ApiIgnore
@SortDefault(value = "id", direction = Sort.Direction.DESC) PageRequest pageRequest,
@PathVariable("organization_id") Long organizationId,
@RequestParam(required = false) String name,
@RequestParam(required = false) String description,
@RequestParam(required = false) String[] param) {
StateMachineSchemeVO schemeDTO = new StateMachineSchemeVO();
schemeDTO.setOrganizationId(organizationId);
schemeDTO.setName(name);
schemeDTO.setDescription(description);
return new ResponseEntity<>(schemeService.pageQuery(organizationId, pageRequest, schemeDTO, ParamUtils.arrToStr(param)), HttpStatus.OK);
}
/**
* 分页查询
*
* @param pageNum
* @param pageSize
* @param tbSysUserJson
* @return
*/
@RequestMapping(value = "page/{pageNum}/{pageSize}", method = RequestMethod.GET)
public BaseResult page(
@PathVariable(required = true) int pageNum,
@PathVariable(required = true) int pageSize,
@RequestParam(required = false) String tbSysUserJson
) throws Exception {
TbSysUser tbSysUser = null;
if (tbSysUserJson != null) {
tbSysUser = MapperUtils.json2pojo(tbSysUserJson, TbSysUser.class);
}
PageInfo pageInfo = adminService.page(pageNum, pageSize, tbSysUser);
// 分页后的结果集
List<TbSysUser> list = pageInfo.getList();
// 封装 Cursor 对象
BaseResult.Cursor cursor = new BaseResult.Cursor();
cursor.setTotal(new Long(pageInfo.getTotal()).intValue());
cursor.setOffset(pageInfo.getPageNum());
cursor.setLimit(pageInfo.getPageSize());
return BaseResult.ok(list, cursor);
}
@RequiresPermissions("admin:ad:list")
@RequiresPermissionsDesc(menu={"推广管理" , "广告管理"}, button="查询")
@GetMapping("/list")
public Object list(String name, String content,
@RequestParam(defaultValue = "1") Integer page,
@RequestParam(defaultValue = "10") Integer limit,
@Sort @RequestParam(defaultValue = "add_time") String sort,
@Order @RequestParam(defaultValue = "desc") String order) {
List<LitemallAd> adList = adService.querySelective(name, content, page, limit, sort, order);
long total = PageInfo.of(adList).getTotal();
Map<String, Object> data = new HashMap<>();
data.put("total", total);
data.put("items", adList);
return ResponseUtil.ok(data);
}
@PostMapping(value = "/request/audit_query")
public PageInfo<RequestAudit> requestAuditQuery(HttpServletRequest request) {
Map<String, Object> dataMap = new HashMap<>();
dataMap.put(CommonParameter.ID, request.getParameter(CommonParameter.ID));
dataMap.put("prId", request.getParameter("prId"));
dataMap.put(CommonParameter.PRODUCT_ID, request.getParameter(CommonParameter.PRODUCT_ID));
dataMap.put(CommonParameter.SUBMITTER, request.getParameter(CommonParameter.SUBMITTER));
dataMap.put("auditStatus", request.getParameter("auditStatus"));
if (!StringUtils.isEmpty(request.getParameter("submitTimeStart"))) {
dataMap.put("submitTimeStart", request.getParameter("submitTimeStart") + " 00:00:00");
}
if (!StringUtils.isEmpty(request.getParameter("submitTimeEnd"))) {
dataMap.put("submitTimeEnd", request.getParameter("submitTimeEnd") + " 23:59:59");
}
int pageNum = ParameterThreadLocal.getPageNum();
int pageSize = ParameterThreadLocal.getPageSize();
PageHelper.startPage(pageNum, pageSize);
List<RequestAudit> requestAudits = requestAuditService.requestAuditQuery(dataMap);
PageInfo<RequestAudit> pageInfo = new PageInfo<>(requestAudits);
return pageInfo;
}
/**
* 查询订阅者列表.
*
* @param tpcMqConsumer the tpc mq consumer
*
* @return the wrapper
*/
@PostMapping(value = "/querySubscribeListWithPage")
@ApiOperation(httpMethod = "POST", value = "查询订阅者列表")
public Wrapper<PageInfo<TpcMqSubscribeVo>> querySubscribeListWithPage(@ApiParam(name = "consumer", value = "Mq消费者") @RequestBody TpcMqConsumer tpcMqConsumer) {
logger.info("查询Mq订阅列表tpcMqConsumerQuery={}", tpcMqConsumer);
PageHelper.startPage(tpcMqConsumer.getPageNum(), tpcMqConsumer.getPageSize());
tpcMqConsumer.setOrderBy("update_time desc");
List<TpcMqSubscribeVo> list = tpcMqConsumerService.listSubscribeVoWithPage(tpcMqConsumer);
PageInfo<TpcMqSubscribeVo> pageInfo = new PageInfo<>(list);
if (PublicUtil.isNotEmpty(list)) {
Map<Long, TpcMqSubscribeVo> tpcMqSubscribeVoMap = this.trans2Map(list);
List<Long> subscribeIdList = new ArrayList<>(tpcMqSubscribeVoMap.keySet());
List<TpcMqSubscribeVo> tagVoList = tpcMqConsumerService.listSubscribeVo(subscribeIdList);
for (TpcMqSubscribeVo vo : tagVoList) {
Long subscribeId = vo.getId();
if (!tpcMqSubscribeVoMap.containsKey(subscribeId)) {
continue;
}
TpcMqSubscribeVo tpcMqSubscribeVo = tpcMqSubscribeVoMap.get(subscribeId);
tpcMqSubscribeVo.setTagVoList(vo.getTagVoList());
}
pageInfo.setList(new ArrayList<>(tpcMqSubscribeVoMap.values()));
}
return WrapMapper.ok(pageInfo);
}
@RequiresPermissions("admin:user:list")
@RequiresPermissionsDesc(menu={"用户管理" , "会员管理"}, button="查询")
@GetMapping("/list")
public Object list(String username, String mobile,
@RequestParam(defaultValue = "1") Integer page,
@RequestParam(defaultValue = "10") Integer limit,
@Sort @RequestParam(defaultValue = "add_time") String sort,
@Order @RequestParam(defaultValue = "desc") String order) {
List<LitemallUser> userList = userService.querySelective(username, mobile, page, limit, sort, order);
long total = PageInfo.of(userList).getTotal();
Map<String, Object> data = new HashMap<>();
data.put("total", total);
data.put("items", userList);
return ResponseUtil.ok(data);
}
@RequiresPermissions("admin:history:list")
@RequiresPermissionsDesc(menu={"用户管理" , "搜索历史"}, button="查询")
@GetMapping("/list")
public Object list(String userId, String keyword,
@RequestParam(defaultValue = "1") Integer page,
@RequestParam(defaultValue = "10") Integer limit,
@Sort @RequestParam(defaultValue = "add_time") String sort,
@Order @RequestParam(defaultValue = "desc") String order) {
List<LitemallSearchHistory> footprintList = searchHistoryService.querySelective(userId, keyword, page, limit, sort, order);
long total = PageInfo.of(footprintList).getTotal();
Map<String, Object> data = new HashMap<>();
data.put("total", total);
data.put("items", footprintList);
return ResponseUtil.ok(data);
}
/**
* datasource test
* @return
*/
// @Transactional
@GetMapping("test")
public String test() {
PageHelper.startPage(1, 1);
List<UserRequestData> userRequestData = userRequestDataMapper.selectAll();
PageInfo<UserRequestData> userRequestDataPageInfo = new PageInfo<>(userRequestData);
System.out.println(userRequestDataPageInfo);
PageHelper.startPage(1, 2);
List<Test> tests = testMapper.selectAll();
PageInfo<Test> testPageInfo = new PageInfo<>(tests);
System.out.println(testPageInfo);
return JSONObject.toJSONString(testPageInfo);
// UserRequestData userRequestData1 = new UserRequestData();
// userRequestData1.setUserId(11L);
// userRequestDataMapper.insert(userRequestData1);
// int i = 1 / 0;
// testMapper.insert();
}
@RequestMapping(value = "/pageList", method = RequestMethod.POST)
public RestResponse<PageInfo<ExamPaperAnswerPageResponseVM>> pageList(@Valid ExamPaperAnswerPageVM model) {
model.setCreateUser(getCurrentUser().getId());
PageInfo<ExamPaperAnswer> pageInfo = examPaperAnswerService.studentPage(model);
PageInfo<ExamPaperAnswerPageResponseVM> page = PageInfoHelper.copyMap(pageInfo, e -> {
ExamPaperAnswerPageResponseVM vm = modelMapper.map(e, ExamPaperAnswerPageResponseVM.class);
Subject subject = subjectService.selectById(vm.getSubjectId());
vm.setDoTime(ExamUtil.secondToVM(e.getDoTime()));
vm.setSystemScore(ExamUtil.scoreToVM(e.getSystemScore()));
vm.setUserScore(ExamUtil.scoreToVM(e.getUserScore()));
vm.setPaperScore(ExamUtil.scoreToVM(e.getPaperScore()));
vm.setSubjectName(subject.getName());
vm.setCreateTime(DateTimeUtil.dateFormat(e.getCreateTime()));
return vm;
});
return RestResponse.ok(page);
}
/**
* 查询公告列表
*
* @param goodsSn
* @param name
* @param page
* @param limit
* @param sort
* @param order
* @return
*/
@RequiresPermissions("admin:article:list")
@RequiresPermissionsDesc(menu = { "推广管理", "公告管理" }, button = "查询")
@GetMapping("/list")
public Object list(String title, @RequestParam(defaultValue = "1") Integer page,
@RequestParam(defaultValue = "10") Integer limit,
@Sort @RequestParam(defaultValue = "add_time") String sort,
@Order @RequestParam(defaultValue = "desc") String order) {
logger.info("【请求开始】推广管理->公告管理->查询,请求参数:title:{},page:{}", title, page);
List<DtsArticle> articleList = articleService.querySelective(title, page, limit, sort, order);
long total = PageInfo.of(articleList).getTotal();
Map<String, Object> data = new HashMap<>();
data.put("total", total);
data.put("items", articleList);
logger.info("【请求结束】推广管理->公告管理->查询,响应结果:{}", JSONObject.toJSONString(data));
return ResponseUtil.ok(data);
}
@RequiresPermissions("admin:feedback:list")
@RequiresPermissionsDesc(menu = { "用户管理", "意见反馈" }, button = "查询")
@GetMapping("/list")
public Object list(Integer userId, String username, @RequestParam(defaultValue = "1") Integer page,
@RequestParam(defaultValue = "10") Integer limit,
@Sort @RequestParam(defaultValue = "add_time") String sort,
@Order @RequestParam(defaultValue = "desc") String order) {
logger.info("【请求开始】用户管理->意见反馈->查询,请求参数:userId:{},username:{},page:{}", userId, username, page);
List<DtsFeedback> feedbackList = feedbackService.querySelective(userId, username, page, limit, sort, order);
long total = PageInfo.of(feedbackList).getTotal();
Map<String, Object> data = new HashMap<>();
data.put("total", total);
data.put("items", feedbackList);
logger.info("【请求结束】用户管理->意见反馈->查询,响应结果:{}", JSONObject.toJSONString(data));
return ResponseUtil.ok(data);
}
@RequiresPermissions("admin:user:list")
@RequiresPermissionsDesc(menu = { "用户管理", "会员管理" }, button = "查询")
@GetMapping("/list")
public Object list(String username, String mobile, @RequestParam(defaultValue = "1") Integer page,
@RequestParam(defaultValue = "10") Integer limit,
@Sort @RequestParam(defaultValue = "add_time") String sort,
@Order @RequestParam(defaultValue = "desc") String order) {
logger.info("【请求开始】用户管理->会员管理->查询,请求参数,username:{},code:{},page:{}", username, mobile, page);
List<DtsUser> userList = userService.querySelective(username, mobile, page, limit, sort, order);
long total = PageInfo.of(userList).getTotal();
Map<String, Object> data = new HashMap<>();
data.put("total", total);
data.put("items", userList);
logger.info("【请求结束】用户管理->会员管理->查询:响应结果:{}", JSONObject.toJSONString(data));
return ResponseUtil.ok(data);
}
@ApiOperation(value = "查询用户", notes = "分页查询用户所有")
@ApiImplicitParams({
@ApiImplicitParam(name = "page", value = "当前页码",
dataType = "Integer", paramType = "query"),
@ApiImplicitParam(name = "size", value = "每页显示条数",
dataType = "Integer", paramType = "query")
})
@PostMapping("/selectAll")
public RetResult<PageInfo<UserInfo>> selectAll(@RequestParam(defaultValue = "0") Integer page,
@RequestParam(defaultValue = "0") Integer size) {
PageHelper.startPage(page, size);
List<UserInfo> userInfoList = userInfoService.selectAll();
PageInfo<UserInfo> pageInfo = new PageInfo<>(userInfoList);
return RetResponse.makeOKRsp(pageInfo);
}
@RequestMapping(value = "/mybatisPageNO", method = RequestMethod.GET)
public PageInfo mybatisPageNO(int pageNo, int pageSize) throws SQLException {
PageHelper.startPage(pageNo, pageSize);
List<DemoInfo> demoInfoList = demoInfoRead.getAllDemoInfo();
log.info("demo info list are {}", demoInfoList.stream().map(DemoInfo::toString)
.collect(Collectors.joining(",")));
PageInfo<DemoInfo> pageValue = new PageInfo<>(demoInfoList);
log.info("page value is {}", pageValue);
return pageValue;
}
@Permission(type = ResourceType.ORGANIZATION)
@ApiOperation(value = "分页查询状态机列表")
@CustomPageRequest
@GetMapping
public ResponseEntity<PageInfo<StateMachineListVO>> pagingQuery(@PathVariable("organization_id") Long organizationId,
@ApiIgnore
@SortDefault(value = "id", direction = Sort.Direction.DESC) PageRequest pageRequest,
@RequestParam(required = false) String name,
@RequestParam(required = false) String description,
@RequestParam(required = false) String[] param) {
return new ResponseEntity<>(stateMachineService.pageQuery(organizationId, pageRequest, name, description, ParamUtils.arrToStr(param)), HttpStatus.OK);
}
/**
* 查询文章的评论信息，并补充到里面，返回前端
*
* @param request
* @param contents
*/
private void completeArticle(HttpServletRequest request, ContentVo contents) {
if (contents.getAllowComment()) {
String cp = request.getParameter("cp");
if (StringUtils.isBlank(cp)) {
cp = "1";
}
request.setAttribute("cp", cp);
PageInfo<CommentBo> commentsPaginator = commentService.getComments(contents.getCid(), Integer.parseInt(cp), 6);
request.setAttribute("comments", commentsPaginator);
}
}
@Override
public DataGridResult listPageKeyword(BaseQuery query) {
PageHelper.startPage(query.getPage(), query.getLimit());
List<KeywordDO> list = keywordMapper.listKeyword();
//取记录总条数
PageInfo<KeywordDO> pageInfo = new PageInfo<KeywordDO>(list);
long total = pageInfo.getTotal();
//创建一个返回值对象
DataGridResult result = new DataGridResult();
result.setData(list);
result.setCount(total);
return result;
}
@PostMapping("queryOrderListWithPage")
@ApiOperation(httpMethod = "POST", value = "查询用户订单列表")
public Wrapper queryOrderListWithPage(@RequestBody OrderPageQuery orderPageQuery) {
logger.info("queryOrderListWithPage - 查询订单集合. orderPageQuery={}", orderPageQuery);
PageInfo pageInfo = omcOrderService.queryOrderListWithPage(orderPageQuery);
return WrapMapper.ok(pageInfo);
}
@Override
public PageInfo<ArtDTO> queryArtList(Long programId, PageRequest pageRequest) {
PageInfo<ArtDTO> artDTOPage = PageHelper.startPage(pageRequest.getPage(),
pageRequest.getSize()).doSelectPageInfo(() -> artMapper.selectArtList(programId));
if (artDTOPage.getList() != null && !artDTOPage.getList().isEmpty()) {
return artDTOPage;
} else {
return new PageInfo<>(new ArrayList<>());
}
}
@RequestMapping(value = "alljudge.do")
public String AllJudge(Model model, @RequestParam(defaultValue = "1") int pn){
PageHelper.startPage(pn,6);
List<Judge>judges = tkService.AllJudge();
PageInfo pageInfo = new PageInfo(judges,5);
model.addAttribute("pageInfo",pageInfo);
return "page/teacher/tea_judge";
}
/**
* 显示所有知识点
* @param model
* @param pn
* @return
*/
@RequestMapping(value = "findallchoice.do")
public String findChoiceAll(Model model,@RequestParam(defaultValue = "1") int pn){
PageHelper.startPage(pn,6);
List<Choice>choice = userService.findChoiceAll();
PageInfo pageInfo = new PageInfo(choice,5);
model.addAttribute("pageInfo",pageInfo);
return "page/admin/tk_choice";
}
/**
* 将PageHelper分页后的list转为分页信息
*/
public static <T> CommonPage<T> restPage(List<T> list) {
CommonPage<T> result = new CommonPage<T>();
PageInfo<T> pageInfo = new PageInfo<T>(list);
result.setTotalPage(pageInfo.getPages());
result.setPageNum(pageInfo.getPageNum());
result.setPageSize(pageInfo.getPageSize());
result.setTotal(pageInfo.getTotal());
result.setList(pageInfo.getList());
return result;
}
@RequestMapping(value = "/taskExamPage", method = RequestMethod.POST)
public RestResponse<PageInfo<ExamResponseVM>> taskExamPageList(@RequestBody ExamPaperPageRequestVM model) {
PageInfo<ExamPaper> pageInfo = examPaperService.taskExamPage(model);
PageInfo<ExamResponseVM> page = PageInfoHelper.copyMap(pageInfo, e -> {
ExamResponseVM vm = modelMapper.map(e, ExamResponseVM.class);
vm.setCreateTime(DateTimeUtil.dateFormat(e.getCreateTime()));
return vm;
});
return RestResponse.ok(page);
}
@Override
//@Cacheable
public Map<String, Object> queryAll(DeptQueryCriteria criteria, Pageable pageable) {
getPage(pageable);
PageInfo<Dept> page = new PageInfo<>(queryAll(criteria));
Map<String, Object> map = new LinkedHashMap<>(2);
map.put("content", generator.convert(page.getList(), DeptDto.class));
map.put("totalElements", page.getTotal());
return map;
}
public PageResult<FileInfo> findList(Map<String, Object> params){
//设置分页信息，分别是当前页数和每页显示的总记录数【记住：必须在mapper接口中的方法执行之前设置该分页信息】
PageHelper.startPage(MapUtils.getInteger(params, "page"),MapUtils.getInteger(params, "limit"),true);
List<FileInfo> list = getFileDao().findList(params);
PageInfo<FileInfo> pageInfo = new PageInfo<>(list);
return PageResult.<FileInfo>builder().data(pageInfo.getList()).code(0).count(pageInfo.getTotal()).build();
}
/**
* 首页分页
*
* @return 模板路径/themes/{theme}/index
*/
@GetMapping(value = "page/{page}")
public String index(Model model, @PathVariable(value = "page") Integer page) {
page = page < 0 || page > MaydayConst.MAX_PAGE ? 1 : page;
// 默认显示条数
Integer limit = StrUtil.isEmpty(MaydayConst.OPTIONS.get("index_article")) ? PageNumber.POST_INDEX_lIMIT.getLimit()
: Integer.parseInt(MaydayConst.OPTIONS.get("index_article"));
ArticleCustom articleCustom = new ArticleCustom();
articleCustom.setArticleStatus(ArticleStatus.PUBLISH.getStatus());
articleCustom.setArticlePost(PostType.POST_TYPE_POST.getValue());
PageInfo<ArticleCustom> pageInfo = articleService.findPageArticle(page, limit, articleCustom);
model.addAttribute("articles", pageInfo);
return this.render("index");
}
@Override
public PageInfo getYs(String lx, int page, int size) {
List<Ysb> relist = new ArrayList<>();
Example example = new Example(Ysb.class);
switch (lx) {
case "电影":
example.createCriteria().orLike("lx", "%动作片%").orLike("lx", "%喜剧片%").orLike("lx", "%爱情片%").orLike("lx"
, "%科幻片%");
break;
case "电视剧":
example.createCriteria().orLike("lx", "%国产剧%").orLike("lx", "%韩国剧%").orLike("lx", "%欧美剧%").orLike("lx"
, "%海外剧%");
break;
case "综艺":
example.createCriteria().andLike("lx", "%综艺%");
break;
case "动漫":
example.createCriteria().andLike("lx", "%动漫%");
break;
case "全部":
break;
default:
}
example.orderBy("gxtime").desc();
PageHelper.startPage(page, size).getPages();
List<Ysb> ysbs = ysbMapper.selectByExample(example);
PageInfo pages = new PageInfo(ysbs);
relist.addAll(ysbs);
return pages;
}
@Override
//@Cacheable
public Map<String, Object> queryAll(YxWechatMenuQueryCriteria criteria, Pageable pageable) {
getPage(pageable);
PageInfo<YxWechatMenu> page = new PageInfo<>(queryAll(criteria));
Map<String, Object> map = new LinkedHashMap<>(2);
map.put("content", generator.convert(page.getList(), YxWechatMenuDto.class));
map.put("totalElements", page.getTotal());
return map;
}
@RequestMapping(value = "/module/query", method = RequestMethod.POST)
public PageInfo<Module> moduleQuery(HttpServletRequest request) {
Map<String, Object> dataMap = new HashMap<>();
dataMap.put(CommonParameter.MODULE_ID, request.getParameter(CommonParameter.MODULE_ID));
dataMap.put(CommonParameter.PRODUCT_ID, request.getParameter(CommonParameter.PRODUCT_ID));
dataMap.put("moduleName", request.getParameter("moduleName"));
dataMap.put("isValid", request.getParameter("isValid"));
PageHelper.startPage(ParameterThreadLocal.getPageNum(), ParameterThreadLocal.getPageSize());
List<Module> list = moduleService.moduleQuery(dataMap);
PageInfo<Module> pageInfo = new PageInfo<>(list);
return pageInfo;
}