Mybatis-Plus如何使用分页

小鱼儿 2023-09-29 11:22 15阅读 0赞

### 文章目录 ###

*  Mybatis-plus如何使用分页
 *   *  1.写个Mybatis-plus配置类：
     *  2.写接口测试
     *  3.注意
     *  4.如果你还有查询条件
     *   *  1.Lambda表达式
         *  2.普通查询

# Mybatis-plus如何使用分页 #

## 1.写个Mybatis-plus配置类： ##

是通过拦截器实现分页

@Configuration
    public class MybatisConfig {
        @Bean
        public MybatisPlusInterceptor mybatisPlusInterceptor() {
            MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
            interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL));
            return interceptor;
        }
    }

官网复制即可，只是你需要把数据库改为你使用的，这里我是使用mysql

![image-20211127103508187][]

## 2.写接口测试 ##

很简单

@GetMapping("/test")
        public Response test(){
            Page<Produce> producePage = new Page<>(1,1);
            Page<Produce> page = produceService.page(producePage);
            System.out.println(producePage == page);
            List<Produce> records = page.getRecords();
            for (Produce record : records) {
                System.out.println(record);
            }
            return new Response<>(records, ResultEnum.SUCCESS);
        }

![image-20211127104035078][]

默认是会查询总条数，都有get、set方法，可以根据自己的需求设置（点开Page类看看）

![image-20211127113428364][]

## 3.注意 ##

我们传入的page对象和查询返回的page对象是同一个

![image-20211127105657392][]

![image-20211127105710551][]

## 4.如果你还有查询条件 ##

比如我们只查询id和price，id小于5的分页查询

![image-20211127112433085][]

### 1.Lambda表达式 ###

@GetMapping("/test")
    public Response test(){
        Page<Produce> producePage = new Page<>(1,2);
        Page<Produce> page = new LambdaQueryChainWrapper<>(produceService.getBaseMapper())
                .select(Produce::getPid,Produce::getPrice)
                .lt(Produce::getPid,5)
                .page(producePage);
    
        return new Response<>(page.getRecords(), ResultEnum.SUCCESS);
    }

![image-20211127112546762][]

### 2.普通查询 ###

@GetMapping("/test")
    public Response test(){
        Page<Produce> producePage = new Page<>(1,2);
        QueryWrapper<Produce> queryWrapper = new QueryWrapper<>();
        queryWrapper.select("pid","price");
        queryWrapper.lt("pid",5);
        Page<Produce> page = produceService.page(producePage, queryWrapper);
        return new Response<>(page.getRecords(), ResultEnum.SUCCESS);
    }

![image-20211127113153795][]

![image-20211127113105586][]

[image-20211127103508187]: https://img-blog.csdnimg.cn/img_convert/6e6912c160e328ea33afc9154336e45b.png
[image-20211127104035078]: https://img-blog.csdnimg.cn/img_convert/656c18aaaf9ed11fee9b9f1576cc840f.png
[image-20211127113428364]: https://img-blog.csdnimg.cn/img_convert/d0e0280ca8a9d46a4a41c4a1de89ab3c.png
[image-20211127105657392]: https://img-blog.csdnimg.cn/img_convert/69a4e84411644e79a07fb97fcdd53b1f.png
[image-20211127105710551]: https://img-blog.csdnimg.cn/img_convert/468b9172dbd975e977e42f45cf7057ab.png
[image-20211127112433085]: https://img-blog.csdnimg.cn/img_convert/63028bb320cc2482562df0cff5a14155.png
[image-20211127112546762]: https://img-blog.csdnimg.cn/img_convert/4bc325c61a7e2e4aefb3db33040973f5.png
[image-20211127113153795]: https://img-blog.csdnimg.cn/img_convert/881c5e0cdcaff7dbf955f5b8b4292d82.png
[image-20211127113105586]: https://img-blog.csdnimg.cn/img_convert/d7d864d2e6d5abee5e79d4b6d6d07fa4.png