springboot集成mybatis实现分页查询

springboot集成mybatis实现分页查询

1、引入依赖

          <dependencies>
           <dependency>
                <groupId>com.github.pagehelper</groupId>
                <artifactId>pagehelper-spring-boot-starter</artifactId>
                <version>1.2.5</version>
            </dependency>
         <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.1.1</version>
        </dependency>
          </dependencies>

2、添加配置文件

#数据库连接配置
spring.datasource.username=root
spring.datasource.password=root
spring.datasource.url=jdbc:mysql://localhost:3306/jpa?useUnicode=true&characterEncoding=utf-8&useSSL=true&serverTimezone=UTC
spring.datasource.driver-class-name=com.mysql.jdbc.Driver

#分页查询配置
pagehelper.helperDialect=mysql
pagehelper.reasonable:=true
pagehelper.supportMethodsArguments=true
pagehelper.params=count=countSql

3、持久层接口（dao）

    @Select("select * from user")
    public List<User> findAll();

4、service层代码

  public PageInfo  findPage(){
        PageHelper.startPage(1,10);
        List<User>list= userDao.findAll();//依然调用查所用的接口
        PageInfo<User> pageInfo = new PageInfo(list);
        return pageInfo;
    }

5、PageInfo的属性

    private int pageNum;//当前页
    private int pageSize;//每页的数量
    private long total;    //总记录数
    private int pages;    //总页数
    private List<T> list;   //结果集
    private int navigatePages;    //导航页码数
    private int[] navigatepageNums;    //所有导航页号