08.新版MybatisPlus插件配置案例实战之分页插件

简介： 案例实战 Mybatis plus 分页插件配置

• 项目配置分页【笔记】

@Configuration
public class MybatisPlusPageConfig {

    /*  旧版本配置
  @Bean
  public PaginationInterceptor paginationInterceptor(){
    return new PaginationInterceptor();
  }*/

    /**
     * 新的分页插件
     */
    @Bean
    public MybatisPlusInterceptor mybatisPlusInterceptor() {
        MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
        interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL));
        return interceptor;
    }
    
}

• 测试分页

   /***
     * 测试分页
     */
    @Test
    public void testPage() {
        QueryWrapper<BannerDO> wrapper = new QueryWrapper<>();
        wrapper.eq("weight",4);
        //第1页，每页2条
        Page<BannerDO> page = new Page<>(1, 2);
        IPage<BannerDO> bannerDOIPage = bannerMapper.selectPage(page, wrapper);
        System.out.println("总条数"+bannerDOIPage.getTotal());
        System.out.println("总页数"+bannerDOIPage.getPages());
        //获取当前数据
        System.out.println(bannerDOIPage.getRecords().toString());
    }

实战MybatisPlus实现分页

package com.lzh.xd_shop.config;

import com.baomidou.mybatisplus.annotation.DbType;
import com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor;
import com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

/**
 * @Author：kaiyang.cui
 * @Package：com.lzh.xd_shop.config
 * @Project：xd_shop
 * @name：MybatisPlusPageConfig
 * @Date：2023/4/1 下午9:31
 * @Filename：MybatisPlusPageConfig
 * @Description：填写功能描述
 * @Version：1.0
 */
@Configuration
public class MybatisPlusPageConfig {
    /**
     * 新的分页插件
     */
    @Bean
    public MybatisPlusInterceptor mybatisPlusInterceptor() {
        MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
        interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL));
        return interceptor;
    }

}

@Test
@DisplayName("banner-MyBatisPlus分页")
public void test19() throws Exception {
    QueryWrapper<BannerDO> wrapper = new QueryWrapper();
    wrapper.eq("weight", 4);
    //第1页，每页2条
    Page<BannerDO> page = new Page<>(2, 2);
    IPage<BannerDO> bannerDOIPage = bannerMapper.selectPage(page, wrapper);
    System.out.println("总条数" + bannerDOIPage.getTotal());
    System.out.println("总页数" + bannerDOIPage.getPages());
    //获取当前数据
    System.out.println(bannerDOIPage.getRecords().toString());

}