PageHelper 分页失败

查询出的 SQL 一定要写到 PageInfo 之前才行，否则会分页失败。

1public Result find() {
2    PageHelper.startPage(PageNum, PageSize);
3    List<JSONObject> list = commonService.find();
4    PageInfo<JSONObject> pageInfo = new PageInfo(list);
5    JSONObject jo = new JSONObject();
6    jo.put("data", pageInfo.getList());
7    jo.put("size", pageInfo.getSize());
8    jo.put("total", pageInfo.getTotal());
9    return new SuccessResult(jo);
10}

---

PageHelper 分页 3 个核心数据

1PageHelper.startPage(pageNum, pageSize);
2List<PassMemberVO> list = userService.listPassMember(name, companyName);
3PageInfo<PassMemberVO> pageInfo = new PageInfo<>(list);
4JSONObject result = new JSONObject();
5result.put("pages", pageInfo.getPages());
6result.put("total", pageInfo.getTotal());
7result.put("list", pageInfo.getList());