springboot使用Mybatis-Generator自动生成Dao、Model、Mapping相关文件

以你之姓@ 2022-05-14 08:22 165阅读 0赞

第一步：在pom.xml配置如下

<build>
            <plugins>
                <plugin>
                    <groupId>org.springframework.boot</groupId>
                    <artifactId>spring-boot-maven-plugin</artifactId>
                    <configuration>
                        <jvmArguments>-Dfile.encoding=UTF-8</jvmArguments>
                    </configuration>
                </plugin>
    
                <plugin>
                    <groupId>org.mybatis.generator</groupId>
                    <artifactId>mybatis-generator-maven-plugin</artifactId>
                    <version>1.3.2</version>
                    <configuration>
                        <configurationFile>${basedir}/src/main/resources/generator/generatorConfig.xml</configurationFile>
                        <overwrite>true</overwrite>
                        <verbose>true</verbose>
                    </configuration>
                    <dependencies>
                        <dependency>
                            <groupId>com.oracle</groupId>
                            <artifactId>ojdbc8</artifactId>
                            <version>12.1.0.2</version>
                        </dependency>
                        <dependency>
                            <groupId>tk.mybatis</groupId>
                            <artifactId>mapper</artifactId>
                            <version>3.3.9</version>
                        </dependency>
                    </dependencies>
                </plugin>
    
            </plugins>
        </build>

第二步：配置generatorConfig.xml文件

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE generatorConfiguration
            PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
            "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
    
    
    <generatorConfiguration>
        <properties resource="application-dev.properties"/>
        
        <context id="oracle" targetRuntime="MyBatis3Simple" defaultModelType="flat">
            <property name="beginningDelimiter" value="`"/>
            <property name="endingDelimiter" value="`"/>
    
            <plugin type="tk.mybatis.mapper.generator.MapperPlugin">
                <property name="mappers" value="com.mmm.util.mapper.MyMapper"/>
            </plugin>
    
            <jdbcConnection driverClass="${spring.datasource.driver-class-name}"
                            connectionURL="${spring.datasource.url}"
                            userId="${spring.datasource.username}"
                            password="${spring.datasource.password}">
            </jdbcConnection>
    
            <javaModelGenerator targetPackage="com.mmm.model.base" targetProject="src/main/java"/>
    
            <sqlMapGenerator targetPackage="mapper.main" targetProject="src/main/resources"/>
    
            <javaClientGenerator targetPackage="com.mmm.dao.main.base" targetProject="src/main/java" type="XMLMAPPER"/>
    
            
            <table tableName="ERP_%">
                <generatedKey column="id" sqlStatement="select uuid()" identity="false" type="pre"/>
            </table>
        </context>
    </generatorConfiguration>

第三步：根据下图跑程序

![70][]

[70]: /images/20220514/c21c1b2994d54f57881bc2b7f6acfc71.png