springboot分页查询

mapper层

首先使用getInfo获取用户信息：

PageInfo<Pioneer> getInfo(Pioneer pioneer);

mapper.xml文件

getInfo .xml文件

<select id="getPioneerById"  resultType="com.xxxx.domain.Pioneer">
        SELECT * FROM aff_pioneer WHERE pioneer_id = #{pioneerId}
    </select>

iservice层

PageInfo<Pioneer> getInfo(Pioneer pioneer);

serviceImpl

代码中使用了条件查询，如果不需要可以去掉

public PageInfo<Pioneer> getInfo(Pioneer pioneer){
        String name=pioneer.getName();
        String status=pioneer.getStatus();
        long pioneerId=pioneer.getPioneerId();
        if(!StringUtils.isNotEmpty(name)){
            name=null;
        }
        if(!StringUtils.isNotEmpty(status)){
            status="0";
        }
        List<Pioneer> result = pioneerMapper.selectPioneer(name,status,pioneerId);
        return new PageInfo<>(result);
    }

controller层

默认为查询第一页，每页十条信息。

通过getInfo 获得一个list ,将list放入pageInfo中分页

public ResponseEntity<Object> getInfo(@RequestParam(required = false, defaultValue = "1", value = "pageNum") Integer pageNum,
                                          @RequestParam(required = false, defaultValue = "10", value = "pageSize") Integer pageSize, Pioneer pioneer) {
        if (pageNum <= 0 || pageNum.equals("") || pageNum == null) {
            pageNum = 1;
        }
        if (pageSize <= 0 || pageSize.equals("") || pageSize == null) {
            pageSize = 10;
        }
        PageHelper.startPage(pageNum, pageSize);
        PageInfo<Pioneer> list = IPioneerService.getInfo(pioneer);
        return ResponseEntity.ok().body(list);
    }

技术小白，如有错误，敬请指正。