软件工程日报26

pagehelper实现分页查询
导入依赖

<dependency>
    <groupId>com.github.pagehelper</groupId>
    <artifactId>pagehelper-spring-boot-starter</artifactId>
</dependency>

public PageBean<T> list(Integer pageNum, Integer pageSize, Integer Id, String state) {
        //创建pageBean对象
        PageBean<T> pb = new PageBean<>();

        //开启分页查询 pageHelper
        PageHelper.startPage(pageNum, pageSize);

        //调用mapper
        List<Article> as = articleMapper.list(userId,categoryId,state);

        //Page中提供了方法,可以获取PageHelper分页查询后得到的总记录条数和当前页数据
        Page<T> p = (Page<T>) as;

        //把数据填充到pageBean
        pb.setItems(p.getResult());
        pb.setTotal(p.getTotal());
        return pb;
    }