
引入依赖:
com.baomidou mybatis-plus-boot-starter3.2.0 mysql mysql-connector-java5.1.27 com.alibaba druid1.0.29
在application.yml配置
spring: datasource: type: com.alibaba.druid.pool.DruidDataSource driver-class-name: com.mysql.jdbc.Driver url: jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=UTF-8 username: root password: 123456
新建一个配置类
@Configuration
public class MybatisPlusConfig {
@Bean//加入Spring容器中
public MybatisPlusInterceptor mybatisPlusInterceptor() {
MybatisPlusInterceptor mybatisPlusInterceptor = new MybatisPlusInterceptor();
mybatisPlusInterceptor.addInnerInterceptor(new PaginationInnerInterceptor());
return mybatisPlusInterceptor;
}
}
public Rpage(int page,int pageSize){ Page page1=new Page(page,pageSize); LambdaQueryWrapper queryWrapper=new LambdaQueryWrapper<>(); queryWrapper.orderByAsc(Category::getCreateTime); categoryService.page(page1,queryWrapper); return R.success(page1);