SpringBoot整合MybatisPlus分页拦截器

由于使用逆向工程，生成出来的代码，已经带有分页功能，但是明明查询第一页，却查出了整张表的所有数据。

Controller层代码

@IgnoreAuth@RequestMapping("/list")public Rlist(@RequestParam Map<String, Object> params){
        PageUtils page= categoryService.queryPage(params);return R.ok().put("page", page);}

service层代码

@Service("categoryService")publicclassCategoryServiceImplextendsServiceImpl<CategoryDao, Category>implementsCategoryService{@Overridepublic PageUtilsqueryPage(Map<String, Object> params){
        IPage<Category> page=this.page(newQuery<Category>().getPage(params),newQueryWrapper<Category>());returnnewPageUtils(page);}}

解决办法： 添加一个分页配置类

package com.ithuang.school.learnschema.config;import com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor;import org.mybatis.spring.annotation.MapperScan;import org.springframework.boot.autoconfigure.condition.ConditionalOnClass;import org.springframework.context.annotation.Bean;import org.springframework.context.annotation.Configuration;@Configuration@ConditionalOnClass(value={PaginationInterceptor.class})@MapperScan("com.ithuang.school.learnschema.dao")publicclassMybatisplusconfig{@Beanpublic PaginationInterceptorpaginationInterceptor(){
        PaginationInterceptor paginationInterceptor=newPaginationInterceptor();return paginationInterceptor;}}

附上pom的内容：

<dependencies><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-test</artifactId></dependency><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-web</artifactId></dependency><dependency><groupId>com.baomidou</groupId><artifactId>mybatis-plus-boot-starter</artifactId><version>${mybatisplus.version}</version><exclusions><exclusion><groupId>com.baomidou</groupId><artifactId>mybatis-plus-generator</artifactId></exclusion></exclusions></dependency><dependency><groupId>com.alibaba</groupId><artifactId>druid</artifactId><version>${druid.version}</version></dependency><dependency><groupId>commons-lang</groupId><artifactId>commons-lang</artifactId><version>${commons.lang.version}</version></dependency><dependency><groupId>commons-io</groupId><artifactId>commons-io</artifactId><version>${commons.io.version}</version></dependency><dependency><groupId>commons-configuration</groupId><artifactId>commons-configuration</artifactId><version>${commons.configuration.version}</version></dependency><dependency><groupId>com.alibaba</groupId><artifactId>fastjson</artifactId><version>${fastjson.version}</version></dependency><dependency><artifactId>velocity</artifactId><groupId>org.apache.velocity</groupId><version>${velocity.version}</version></dependency><dependency><groupId>com.github.pagehelper</groupId><artifactId>pagehelper-spring-boot-starter</artifactId><version>${pagehelper.spring.boot.version}</version><exclusions><exclusion><groupId>org.mybatis</groupId><artifactId>mybatis</artifactId></exclusion><exclusion><groupId>org.mybatis</groupId><artifactId>mybatis-spring</artifactId></exclusion></exclusions></dependency><!-- mysql驱动--><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>${mysql.version}</version></dependency><!-- 百度人工智能--><dependency><groupId>com.baidu.aip</groupId><artifactId>java-sdk</artifactId><version>4.4.1</version></dependency><!--        lombok--><dependency><groupId>org.projectlombok</groupId><artifactId>lombok</artifactId><version>1.18.8</version></dependency><dependency><groupId>org.apache.shiro</groupId><artifactId>shiro-spring</artifactId><version>1.3.2</version></dependency><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-test</artifactId><scope>test</scope><exclusions><exclusion><groupId>org.junit.vintage</groupId><artifactId>junit-vintage-engine</artifactId></exclusion></exclusions></dependency></dependencies>

上面项目使用别人的逆向工程生成的自己的项目。