SpringBoot 整合 mybatis-plus

最新推荐文章于 2025-09-14 17:16:06 发布

原创最新推荐文章于 2025-09-14 17:16:06 发布 · 270 阅读

0 ·

CC 4.0 BY-SA版权

SpringBoot 同时被 2 个专栏收录

13 篇文章

订阅专栏

Mybatis

10 篇文章

订阅专栏

本文详细介绍了如何在Spring Boot项目中配置和使用MyBatis Plus，包括依赖配置、数据源配置、逆向代码生成等关键步骤。通过示例展示了pom.xml依赖、配置文件设置、配置类编写及逆向生成工具的使用，帮助开发者快速上手。

依赖配置

pom.xml

<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>mybatis-plus-boot-starter</artifactId>
    <version>3.1.0</version>
</dependency>
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.13</version>
</dependency>
<!-- 代码生成器依赖 -->
<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>mybatis-plus-generator</artifactId>
    <version>3.1.0</version>
</dependency>
<dependency>
    <groupId>com.ibeetl</groupId>
    <artifactId>beetl</artifactId>
    <version>2.9.8</version>
</dependency>
<!--如果把xml文件放在java包下-->
<build>
	<resources>
	    <resource>
	        <directory>src/main/java</directory>
	        <includes>
	            <include>**/*.properties</include>
	            <!--java包下xml文件为资源文件-->
	            <include>**/*.xml</include>
	        </includes>
	        <filtering>false</filtering>
	    </resource>
	    <resource>
	        <directory>src/main/resources</directory>
	        <includes>
	            <include>**/*.properties</include>
	            <include>**/*.xml</include>
	            <include>**/*.txt</include>
	        </includes>
	        <filtering>false</filtering>
	    </resource>
	</resources>
</build>

配置文件配置

application.properties

mybatis-plus.mapper-locations: classpath*:com/demo/example/**/xml/*Mapper.xml
mybatis-plus.global-config.id-type: 0
mybatis-plus.global-config.db-column-underline: false
mybatis-plus.global-config.refresh-mapper: true

配置类配置

@Configuration
@EnableTransactionManagement
@MapperScan(basePackages = "com.example.demo.dao")
public class MybatisPlusConfig {

    /**
     * mybatis-plus分页插件
     */
    @Bean
    public PaginationInterceptor paginationInterceptor() {
        return new PaginationInterceptor();
    }

    /**
     * 乐观锁mybatis插件
     */
    @Bean
    public OptimisticLockerInterceptor optimisticLockerInterceptor() {
        return new OptimisticLockerInterceptor();
    }
}

数据源配置

见 SpringBoot 整合 druid

逆向生成

在 SpringBoot 项目的 test.java 文件夹下创建此类，import org.junit.Test;

public class EntityGenerator {

    // 生成输出目录，定位到工程的java目录下
    private String outputDir = "F:\\demo\\src\\main\\java";
    // 生成类的作者
    private String author = "";
    // 数据源相关配置
    private String url = "jdbc:mysql://127.0.0.1:3306/demo?autoReconnect=true&useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=CONVERT_TO_NULL&useSSL=false&serverTimezone=UTC";
    private String driverName = "com.mysql.cj.jdbc.Driver";
    private String userName = "root";
    private String userPwd = "root";
    // DAO的包路径
    private String daoPackage = "com.demo.example.dao";
    // 待生成的表名，注意是覆盖更新
    private static String[] tableNames;

    static{
        tableNames = new String[]{
                "user"
        };
    }

    @Test
    public void entityGenerator() {
        AutoGenerator mpg = new AutoGenerator();
        mpg.setTemplateEngine(new BeetlTemplateEngine());
        // 全局配置
        GlobalConfig gc = new GlobalConfig();
        gc.setOutputDir(outputDir);
        gc.setFileOverride(true);
        gc.setActiveRecord(true);
        gc.setEnableCache(false);
        gc.setBaseResultMap(true);
        gc.setBaseColumnList(false);
        gc.setAuthor(author);
        mpg.setGlobalConfig(gc);

        // 数据源配置
        DataSourceConfig dsc = new DataSourceConfig();
        dsc.setUrl(url);
        // dsc.setSchemaName("public");
        dsc.setDriverName(driverName);
        dsc.setUsername(userName);
        dsc.setPassword(userPwd);
        mpg.setDataSource(dsc);

        // 策略配置
        StrategyConfig strategy = new StrategyConfig();
        //strategy.setTablePrefix(new String[]{"_"});// 此处可以修改为您的表前缀
        strategy.setNaming(NamingStrategy.underline_to_camel);// 表名生成策略
        strategy.setInclude(tableNames);
        mpg.setStrategy(strategy);

        // 包配置
        PackageConfig pc = new PackageConfig();
        pc.setParent(null);
        pc.setEntity(daoPackage+".entity");
        pc.setMapper(daoPackage+".mapper");
        pc.setXml(daoPackage+".mapper.xml");
        mpg.setPackageInfo(pc);

        // 注入自定义配置，可以在 VM 中使用 cfg.abc 设置的值
        InjectionConfig cfg = new InjectionConfig() {
            @Override
            public void initMap() {
                Map<String, Object> map = new HashMap<>();
                map.put("abc", this.getConfig().getGlobalConfig().getAuthor() + "-mp");
                this.setMap(map);
            }
        };

        mpg.setCfg(cfg);

        // 执行生成
        mpg.execute();

        // 打印注入设置
        System.err.println(mpg.getCfg().getMap().get("abc"));

    }
}