MyBatisplus 使用IPage和Page分页

1@RequestMapping(value = "/cityList",method = RequestMethod.POST)
2    public ResponseVo<IPage<GovernanceRegulationClosePo>> querySearchCityDataList(@RequestBody Map<String,Object>map){
3
4        IPage<GovernanceRegulationClosePo> page=governanceRegulationCloseService.getCityDataList(map);
5
6        return new ResponseVo<>(true,page,UnicomResponseEnums.SUCCESS_OPTION);
7    }
8
9IPage<GovernanceRegulationClosePo> getCityDataList(Map<String, Object> map);
10
11@Override
12    public IPage<GovernanceRegulationClosePo> getCityDataList(Map<String, Object> map) {
13        String countyName = (String) map.get("countyName");
14        String regionCode = (String) map.get("regionCode");
15        Integer pageNum = (Integer) map.get("pageNum");
16        Integer pageSize = (Integer) map.get("pageSize");
17        String subRegionCode=regionCode.substring(0,4);
18
19        Page<GovernanceRegulationClosePo> page=new Page<>(pageNum,pageSize);
20
21        IPage<GovernanceRegulationClosePo> iPage=governanceRegulationCloseMapper.getCityDataList(page,countyName,subRegionCode);
22
23        return iPage;
24    }
25
26IPage<GovernanceRegulationClosePo> getCityDataList(Page<GovernanceRegulationClosePo> page, @Param("countyName") String countyName,@Param("subRegionCode") String subRegionCode);
27
28<select id="getCityDataList" resultType="com.huitian.mine.domain.vo.GovernanceRegulationCloseVo">
29        SELECT
30        b.COUNTY_NAME,b.REGION_CODE,COUNT(MINE_NUMBER) AS count ,SUM(DAMAGED_AREA) AS sumDamagedArea ,SUM(PLAN_REPAIR_AREA) AS sumPlanRepairedArea ,SUM(REPAIRED_AREA) AS sumRepairedArea ,SUM(CAPITAL_USAGE) AS sumCapitalUsage
31        FROM B_MINEREPAIRPROGRESSCLOSE b
32        <if test="countyName!=''and countyName!=null">
33            WHERE b.COUNTY_NAME=#{countyName}
34        </if>
35        GROUP BY b.COUNTY_NAME,b.REGION_CODE
36        HAVING b.REGION_CODE LIKE CONCAT(#{subRegionCode},'%')
37    </select>
38
39public class GovernanceRegulationCloseVo {
40     /**
41      * 区县名称
42      */
43     private String countyName;
44     /**
45      * 所属行政区编码
46      */
47     private String regionCode;
48     /**
49      * 矿山总数
50      */
51     private Integer count;
52     /**
53      * 总损毁面积
54      */
55     private Long sumDamagedArea;
56     /**
57      * 总拟修复面积
58      */
59     private Long sumPlanRepairedArea;
60     /**
61      * 总已修复面积
62      */
63     private Long sumRepairedArea;
64     /**
65      * 总使用资金
66      */
67     private Double sumCapitalUsage;
68
69
70
71}

测试