MybatisPlus新版中的自带分页插件

阳光穿透心脏的1/2处 2022-12-30 10:38 224阅读 0赞

##### MybatisPlus中自带分页插件： #####

**1、依赖版本：**

<dependency>
        <groupId>com.baomidou</groupId>
        <artifactId>mybatis-plus-boot-starter</artifactId>
        <version>3.4.1</version>
    </dependency>

--------------------

**2、编写一个配置类：**

package com.pipi.mybatisplus02.config;
    
    import com.baomidou.mybatisplus.annotation.DbType;
    import com.baomidou.mybatisplus.core.injector.DefaultSqlInjector;
    import com.baomidou.mybatisplus.core.injector.ISqlInjector;
    import com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor;
    import com.baomidou.mybatisplus.extension.plugins.OptimisticLockerInterceptor;
    import com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor;
    import org.springframework.context.annotation.Bean;
    import org.springframework.context.annotation.Configuration;
    import org.springframework.transaction.annotation.EnableTransactionManagement;
    
    @EnableTransactionManagement
    @Configuration
    public class MybatisPlusConfig { 
    
        /** * 注册插件 */
        @Bean
        public MybatisPlusInterceptor mybatisPlusInterceptor() { 
            MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
    
            // 添加分页插件
            PaginationInnerInterceptor pageInterceptor = new PaginationInnerInterceptor();
            // 设置请求的页面大于最大页后操作，true调回到首页，false继续请求。默认false
            pageInterceptor.setOverflow(false);
            // 单页分页条数限制，默认无限制
            pageInterceptor.setMaxLimit(500L);
            // 设置数据库类型
            pageInterceptor.setDbType(DbType.MYSQL);
            
            interceptor.addInnerInterceptor(pageInterceptor);
            return interceptor;
        }
    
    }

--------------------

**3、测试代码：**

@Test
        void test02() { 
            // 两个参数：current的值默认是1，从1开始，不是0。size是每一页的条数。
            Page<UserEntity> page = new Page<>(2, 4);
            Page<UserEntity> userPage = userMapper.selectPage(page, null);
            userPage.getRecords().forEach(System.out::println);
    
            System.out.println("当前页：" + userPage.getCurrent());
            System.out.println("总页数：" + userPage.getPages());
            System.out.println("记录数：" + userPage.getTotal());
            System.out.println("是否有上一页：" + userPage.hasPrevious());
            System.out.println("是否有下一页：" + userPage.hasNext());
        }

--------------------