spring boot集成mybatis分页插件

mybatis的分页插件能省事，本章记录的是 spring boot整合mybatis分页插件。

1、引入依赖

<!-- 分页插件pagehelper -->
        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper</artifactId>
            <version>5.0.0</version>
        </dependency>
        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper-spring-boot-autoconfigure</artifactId>
            <version>1.2.3</version>
        </dependency>
        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper-spring-boot-starter</artifactId>
            <version>1.2.3</version>
        </dependency>
        <!-- 分页插件pagehelper -->

2、配置application.yml文件

注意 pagehelper 是一级根目录和 spring 同级

spring:
  mvc:
    view:
      prefix: /
      suffix: .jsp
  datasource:
    url: jdbc:mysql://localhost:3306/myrec?characterEncoding=utf8&useSSL=true
    username: root
    password: m123456
    driver-class-name: com.mysql.jdbc.Driver
       
#配置分页插件pagehelper
pagehelper:
    helperDialect: mysql
    reasonable: true
    supportMethodsArguments: true
    params: count=countSql

3、业务层使用

/**
     * 按分页查询
     */
    @Override
    public PageResult findPage(int pageNum, int pageSize) {
        PageHelper.startPage(pageNum, pageSize);
        Page<Loginuser> page=   (Page<Loginuser>) loginuserMapper.selectByExample(null);
        return new PageResult(page.getTotal(), page.getResult());
    }

包别导错了

import com.github.pagehelper.Page;
import com.github.pagehelper.PageHelper;

 

转载于:https://www.cnblogs.com/zeussbook/p/11244174.html