mybatisplus分页插件(mybatisplus分页原理)

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

Controller层代码

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

service层代码

@Service("categoryService")
public class CategoryServiceImpl extends ServiceImpl implements CategoryService {
    @Override
    public PageUtils queryPage(Map params) {
        IPage page = this.page(
                new Query().getPage(params),
                new QueryWrapper()
        );
        return new PageUtils(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")
public class Mybatisplusconfig {
    @Bean
    public PaginationInterceptor paginationInterceptor(){
        PaginationInterceptor paginationInterceptor = new PaginationInterceptor();
        return paginationInterceptor;
    }
}

附上pom的内容：

        
            org.springframework.boot
            spring-boot-starter-test
        
        
            org.springframework.boot
            spring-boot-starter-web
        
        
            com.baomidou
            mybatis-plus-boot-starter
            ${mybatisplus.version}
            
                
                    com.baomidou
                    mybatis-plus-generator
                
            
        
        
            com.alibaba
            druid
            ${druid.version}
        
        
            commons-lang
            commons-lang
            ${commons.lang.version}
        
        
            commons-io
            commons-io
            ${commons.io.version}
        
        
            commons-configuration
            commons-configuration
            ${commons.configuration.version}
        
        
            com.alibaba
            fastjson
            ${fastjson.version}
        
        
            velocity
            org.apache.velocity
            ${velocity.version}
        
        
            com.github.pagehelper
            pagehelper-spring-boot-starter
            ${pagehelper.spring.boot.version}
            
                
                    org.mybatis
                    mybatis
                
                
                    org.mybatis
                    mybatis-spring
                
            
        
        
        
            mysql
            mysql-connector-java
            ${mysql.version}
        

        
        
            com.baidu.aip
            java-sdk
            4.4.1
        

        
        
            org.projectlombok
            lombok
            1.18.8
        

        
            org.apache.shiro
            shiro-spring
            1.3.2
        


        
            org.springframework.boot
            spring-boot-starter-test
            test
            
                
                    org.junit.vintage
                    junit-vintage-engine
                
            
        
    

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