SpringBoot使用Mybatis插件pagehelper

1. 导入依赖

   <dependency>
       <groupId>com.github.pagehelper</groupId>
       <artifactId>pagehelper-spring-boot-starter</artifactId>
       <version>1.3.0</version>
   </dependency>
   <dependency>
       <groupId>org.mybatis.spring.boot</groupId>
       <artifactId>mybatis-spring-boot-starter</artifactId>
       <version>2.2.0</version>
   </dependency>
   <dependency>
       <groupId>mysql</groupId>
       <artifactId>mysql-connector-java</artifactId>
       <scope>runtime</scope>
   </dependency>
   

2. 配置文件

   spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
   spring.datasource.url=jdbc:mysql://127.0.0.1:3306/mytest?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC&useSSL=false
   spring.datasource.username=root
   spring.datasource.password=root1234
   
   pagehelper.helper-dialect=mysql
   pagehelper.reasonable=true
   pagehelper.support-methods-arguments=true
   

3. dao层

   @Mapper
   public interface TestDao {
   
       @Select("select * from myuser")
       List<Map<String,Object>> selects();
   
   }
   

4. 使用

   @RestController
   public class TestController {
   
       @Autowired
       private TestDao testDao;
   
       @GetMapping(path = "/test")
       public Object test(){
           //第一个参数是页数，第二个为显示数
           PageHelper.startPage(1, 1);
           return testDao.selects();
       }
       
   }