MyBatisPlus整合Spring-Boot

原创已于 2023-09-10 20:33:13 修改 · 83 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#java #mybatis #spring boot

于 2023-09-03 18:03:09 首次发布

MyBatis-Plus 专栏收录该内容

3 篇文章

订阅专栏

本文详细介绍了如何在SpringBoot项目中整合Mybatis-Plus，包括添加依赖、配置mapper位置、自定义MybatisPlusInterceptor以及设置分页和防止全表操作限制。

整合spring-boot

配置依赖

       <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>${mp-version}</version>
        </dependency>

        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-extension</artifactId>
            <version>${mp-version}</version>
        </dependency>

配置文件

mybatis-plus:
  mapper-locations: /mapper/**/*.xml # 默认

配置类

package com.strap.mydemo.config;

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

/**
 * <p></p>
 *
 * @author strap
 * @since 2023/3/21 16:14
 */
@Configuration
@MapperScan("com.strap.mydemo.mapper")
public class MyBatisPlusConfig {

    public MyBatisPlusConfig() {
    }

    @Bean
    public MybatisPlusInterceptor paginationInterceptor() {
        MybatisPlusInterceptor paginationInterceptor = new MybatisPlusInterceptor();
        PaginationInnerInterceptor pageInterceptor = new PaginationInnerInterceptor(DbType.POSTGRE_SQL);
        pageInterceptor.setOverflow(true);
        pageInterceptor.setMaxLimit(500L);
        // 分页插件
        paginationInterceptor.addInnerInterceptor(pageInterceptor);
        // 防止全表更新与删除插件
        paginationInterceptor.addInnerInterceptor(new BlockAttackInnerInterceptor());
        return paginationInterceptor;
    }

}