SpringBoot使用Mybatis-plus给Oracle进行分页

短命女 2023-09-29 18:05 5阅读 0赞

#### Mybatis-plus给Oracle进行分页 ####

*  导入Mybatis-plus依赖
 *  添加Mybatis-plus配置类
 *  在Mapper层添加入参IPage<T>
 *  在业务层传入页码和每页的数量

## 导入Mybatis-plus依赖 ##

[Mybatis-plus文档][Mybatis-plus]

<dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>最新版本</version>
        </dependency>
        <dependency>
            <groupId>com.h2database</groupId>
            <artifactId>h2</artifactId>
            <scope>runtime</scope>
        </dependency>

## 添加Mybatis-plus配置类 ##

这里是版本较低的SpringBoot

@Configuration
    public class MybatisConfig {
        
    
        @Bean
        public PaginationInterceptor paginationInterceptor() {
        
            PaginationInterceptor interceptor = new PaginationInterceptor();
            interceptor.setDialectType(DbType.ORACLE.getDb());
            return interceptor;
        }
    
    }

SpringBoot版本比较高的

@Configuration
    public class MybatisConfig {
        
    
        @Bean
        public MybatisPlusInterceptor mybatisPlusInterceptor() {
        
            MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
            //分页查 设置数据类型
            interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.ORACLE));
            // 乐观锁
            interceptor.addInnerInterceptor(new OptimisticLockerInnerInterceptor());
            return interceptor;
        }
    }

## 在Mapper层添加入参IPage ##

![在这里插入图片描述][27a08641b2db4fa0b0cc5b970c4141fe.png]

## 在业务层传入页码和每页的数量 ##

![在这里插入图片描述][aca0d2022de84c5ba754704fda70c3c7.png]

[Mybatis-plus]: https://baomidou.com/
[27a08641b2db4fa0b0cc5b970c4141fe.png]: https://img-blog.csdnimg.cn/27a08641b2db4fa0b0cc5b970c4141fe.png
[aca0d2022de84c5ba754704fda70c3c7.png]: https://img-blog.csdnimg.cn/aca0d2022de84c5ba754704fda70c3c7.png