SpringBoot---整合分页PageHelper

1.说明:

Spring Boot整合PageHelper不需要做任何配置文件的配置，添加依赖后就可以直接使用。

2.步骤:

1.添加依赖

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

2.在serviceImpl中编写代码

@Service
public class PeopleServiceImpl implements PeopleService {
    @Autowired
    private PeopleMapper peopleMapper;

    
    /**1.调用startPage方法 :PageHelper.startPage
     * 2.调用mapper层的方法查询所有,得到一个peopleList集合
     * 3.创建PageInfo方法,并把peopleList传进去
     * 4.利用pageinfo对象的getList方法返回
     * @param current 当前页
     * @param pazesize 每页的大小
     * @return
     */
    @Override
    public List<People> selectPeopleByPage(int current, int pazesize) {
        PageHelper.startPage(current,pazesize);
        List<People> peopleList = peopleMapper.selectAll(current, pazesize);
        PageInfo<People> pageInfo=new PageInfo<>(peopleList);
        List<People> list = pageInfo.getList();
        return list;
    }
}

3.机制原理:

在sql运行之前,拦截sql,并给sql添加分页sql的代码