java mysql分页封装_使用Java封装的分页工具类

1 package com.bie.controller;2

3 import com.bie.po.RxxxPxxxxx;4 import com.bie.service.RxxxPxxxxxService;5 import com.bie.service.RxxxPxxxxxThemeService;6 import com.bie.utils.PageBean;7 import org.springframework.beans.factory.annotation.Autowired;8 import org.springframework.stereotype.Controller;9 import org.springframework.web.bind.annotation.RequestMapping;10 import org.springframework.web.bind.annotation.RequestMethod;11 import org.springframework.web.bind.annotation.RequestParam;12 import org.springframework.web.bind.annotation.ResponseBody;13

14 import java.util.List;15

16 /**17 * @ProjectName: nxxxxxpxxxxxx18 * @Package: com.bie.controller19 * @ClassName: RxxxPxxxxxController20 * @Author: biehl21 * @Description: ${description}22 * @Date: 2020/2/28 19:4223 * @Version: 1.024 */

25 @Controller26 @RequestMapping(value = "/xxxxxx")27 public classRxxxPxxxxxController {28

29 @Autowired30 privateRxxxPxxxxxService rxxxPxxxxxService;31

32 @Autowired33 privateRxxxPxxxxxThemeService rxxxPxxxxxThemeService;34

35

36 /**37 * @param aaa38 * @param bbb39 * @param ccc40 * @param ddd41 * @param current 当前页，默认是第一页，从1开始42 * @param size 每页多少，默认是每页20条数据43 * @return44 */

45 @RequestMapping(value = "/xxxxxxxxx/xxxxx", method =RequestMethod.GET)46 @ResponseBody47 public List selectRxxxPxxxxxPageBean(@RequestParam(value = "aaa", required = false) String aaa, @RequestParam(value = "bbb", required = false) String bbb, @RequestParam(value = "ccc", required = false) String ccc, @RequestParam(value = "ddd", required = false) String ddd, @RequestParam(value = "current", defaultValue = "1") int current, @RequestParam(value = "size", defaultValue = "20") intsize) {48 //得到数据表中的行数

49 int count =rxxxPxxxxxService.selectRxxxPxxxxxPageBeanCount();50 //创建工具类对象

51 PageBean pager = new PageBean<>();52 //每页显示的行数

53 pager.setPageSize(size);54 //设置总行数

55 pager.setRows(count);56 //设置当前页数

57 pager.setPageNo(current);58 //计算出总页数

59 int totalPage = count % size == 0 ? count / size : (count / size + 1);60 //mysql获取分页第一个参数 (pager.getPageNo() - 1) * pager.getPageSize();61 //获取分页第一个参数62 //Limit接受一个或两个数字参数。参数必须是一个整数常量。如果给定两个参数，63 //第一个参数指定第一个返回记录行的偏移量，第二个参数指定返回记录行的最大数目。64 //初始记录行的偏移量是 0(而不是 1)。

65 int first = (pager.getPageNo() - 1) *pager.getPageSize();66 //调用service层将分页的两个参数传递过去

67 List rxxxPxxxxxs =rxxxPxxxxxService.selectRxxxPxxxxxPageBean(aaa, bbb, ccc, ddd, first, pager.getPageSize());68

69

70 //将得到的集合对象放到PagerBean类里，这里面主要看你需要返回什么格式的数据，可以根据需要返回的格式进行封装即可

71 pager.setLists(rxxxPxxxxxs);72 List lists =pager.getLists();73 returnlists;74

75 //如果是需要其他格式的返回类型，在下面可以封装返回的逻辑或者在业务层封装返回的逻辑76 //封装返回结果，如果返回的是下面格式的数据，返回类型换成NxxxxxxxPxxxxxxxResult即可。77 //List resultLists = new ArrayList<>();78 //if (rxxxPxxxxxs != null && rxxxPxxxxxs.size() > 0 && !rxxxPxxxxxs.isEmpty()) {79 //for (RxxxPxxxxx rxxxPxxxxx : rxxxPxxxxxs) {80 //RxxxPxxxxx rxxxPxxxxx1 = new RxxxPxxxxx();81 // //获取到policyId82 //int policyId = rxxxPxxxxx.getId();83 // //封装主题信息84 //List rxxxPxxxxxThemes = rxxxPxxxxxThemeService.selectRxxxPxxxxxThemeByPolicyId(policyId);85 //if (rxxxPxxxxxThemes != null && rxxxPxxxxxThemes.size() > 0 && !rxxxPxxxxxThemes.isEmpty()) {86 //int[] themeIds = new int[rxxxPxxxxxThemes.size()];87 //for (int i = 0; i < rxxxPxxxxxThemes.size(); i++) {88 //int themeId = rxxxPxxxxxThemes.get(i).getThemeId();89 //themeIds[i] = themeId;90 //}91 //rxxxPxxxxx1.setThemeIds(themeIds);92 //}93 //

94 // //封装themeIds95 //rxxxPxxxxx1.setId(rxxxPxxxxx.getId());96 //rxxxPxxxxx1.setAaa(rxxxPxxxxx.getAaa());97 //rxxxPxxxxx1.setBbb(rxxxPxxxxx.getBbb());98 //rxxxPxxxxx1.setCcc(rxxxPxxxxx.getCcc());99 //rxxxPxxxxx1.setDdd(rxxxPxxxxx.getDdd());100 //rxxxPxxxxx1.setEee(rxxxPxxxxx.getEee());101 //rxxxPxxxxx1.setFff(rxxxPxxxxx.getFff());102 //rxxxPxxxxx1.setGgg(rxxxPxxxxx.getGgg());103 //rxxxPxxxxx1.setIii(rxxxPxxxxx.getIii());104 //

105 //resultLists.add(rxxxPxxxxx1);106 //}107 //}108 //

109 //RxxxPxxxxxResult rxxxPxxxxxResult = new RxxxPxxxxxResult();110 //rxxxPxxxxxResult.setRecords(resultLists);111 //rxxxPxxxxxResult.setTotal(count);112 //rxxxPxxxxxResult.setSize(size);113 //rxxxPxxxxxResult.setCurrent(current);114 //rxxxPxxxxxResult.setOrders(new int[0]);115 //rxxxPxxxxxResult.setSearchCount(true);116 //rxxxPxxxxxResult.setPages(totalPage);117 //

118 //NxxxxxxxPxxxxxxxResult nationalPolicyResult = new NxxxxxxxPxxxxxxxResult();119 //NxxxxxxxPxxxxxxxResult result = new NxxxxxxxPxxxxxxxResult();120 //if (resultLists != null && resultLists.size() > 0 && !resultLists.isEmpty()) {121 //result = nationalPolicyResult.success(rxxxPxxxxxResult);122 //} else {123 //result = nationalPolicyResult.build(1, "fail");124 //}125 //return result;

126 }127 }