mybatis plus作分页查询

先导入mybatis plus 相关依赖   

https://mp.baomidou.com/guide/annotation.html#tableid

下图为拦截器代码，用mybatis plus 必须使用拦截器

//Spring boot方式
@Configuration
@MapperScan("com.baomidou.cloud.service.*.mapper*")
public class MybatisPlusConfig {
    @Bean
    public MybatisPlusInterceptor mybatisPlusInterceptor() {
        MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
                    //PaginationInnerInterceptor方法里有多种类型数据库，DbType 代表方言  
        interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.mysql));
        return interceptor;
    }
    
}