SpringBoot Mybatis 逆向工程

港控/mmm° 2021-09-16 14:32 390阅读 0赞

**一、在 pom.xml 文件中，增加generator插件**

<plugin>
         <groupId>org.mybatis.generator</groupId>
         <artifactId>mybatis-generator-maven-plugin</artifactId>
         <version>1.3.2</version>
         <configuration>
             <verbose>true</verbose>
             <overwrite>true</overwrite>
             
             <configurationFile>src\main\resources\mybatis-generator\generatorConfig.xml</configurationFile>
         </configuration>
         <executions>
             <execution>
                 <id>Generate MyBatis Artifacts</id>
                 <goals>
                     <goal>generate</goal>
                 </goals>
                 <phase>generate-sources</phase>
             </execution>
         </executions>
    
         
         
         <dependencies>
             <dependency>
                 <groupId>mysql</groupId>
                 <artifactId>mysql-connector-java</artifactId>
                 <version>5.1.38</version>
             </dependency>
         </dependencies>
     </plugin>

**二、在 resources 目录下，建立 mapper 文件夹，自定义 generatorConfig.xml 文件 和 mybatisGeneratorinit.properties 文件**

**1、在 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="mybatis-generator/mybatisGeneratorinit.properties"/>
    
        
        
    
        
        
        <context id="DB2Tables" targetRuntime="MyBatis3">
    
            
            <property name="autoDelimitKeywords" value="true" />
    
            
            <property name="javaFileEncoding" value="utf-8" />
    
            
            <property name="beginningDelimiter" value="`" />
            <property name="endingDelimiter" value="`" />
    
            
            <property name="javaFormatter" value="org.mybatis.generator.api.dom.DefaultJavaFormatter"/>
    
            
            <property name="xmlFormatter" value="org.mybatis.generator.api.dom.DefaultXmlFormatter"/>
            <plugin type="org.mybatis.generator.plugins.SerializablePlugin" />
            <plugin type="org.mybatis.generator.plugins.ToStringPlugin" />
    
            
            <commentGenerator >
                <property name="suppressAllComments" value="true"/>
                <property name="suppressDate" value="true" /> 
            </commentGenerator>
    
            
            <jdbcConnection driverClass="${jdbc_driver}" connectionURL="${jdbc_url}" userId="${jdbc_user}" password="${jdbc_password}" />
    
            
            <javaTypeResolver>
                
                <property name="forceBigDecimals" value="false"/>
            </javaTypeResolver>
    
            
            <javaModelGenerator targetPackage="${domainPackage}" targetProject="${domain}">
                
                <property name="enableSubPackages" value="false"/>
                
                <property name="trimStrings" value="false"/>
            </javaModelGenerator>
    
            
            <sqlMapGenerator targetPackage="mapper" targetProject="${resources}">
                <property name="enableSubPackages" value="true"/>
            </sqlMapGenerator>
    
            
    
            
            <javaClientGenerator type="XMLMAPPER" targetPackage="${mapperPackage}" targetProject="${mapper}">
                <property name="enableSubPackages" value="true"/>
            </javaClientGenerator>
    
            
            
            
            <table tableName="%"
                   enableCountByExample="false"
                   enableUpdateByExample="false"
                   enableDeleteByExample="false"
                   enableSelectByExample="false"
                   selectByExampleQueryId="false">
                <property name="useActualColumnNames" value="false" />
                
                <generatedKey column="id" sqlStatement="Mysql" identity="true" />
            </table>
        </context>
    </generatorConfiguration>

**2、在 mybatisGeneratorinit.properties 文件添加如下内容**

jdbc_driver = com.mysql.jdbc.Driver
    jdbc_url = jdbc:mysql://localhost:3306/xdclass?useUnicode=true&characterEncoding=utf-8&useSSL=true
    jdbc_user = root
    jdbc_password = 123456
    
    # 按照 maven 工程生成的项目结构代码，如下的 domain、mapper、resources 的地址按如下进行配置
    domain = src/main/java
    domainPackage = net.xdclass.xdvideoxml.domain
    
    mapper = src/main/java
    mapperPackage = net.xdclass.xdvideoxml.mapper
    
    resources = src/main/resources

**三、在 idea 最右侧，按如下图操作，开始运行**  
![在这里插入图片描述][70]  
**四、最终的效果，如下图**  
![在这里插入图片描述][70 1]

[70]: /images/20210913/a19a9cf0794a4938974c5ff86ba5ec51.png
[70 1]: /images/20210913/17c8f39f6e1e46dd9e75e0504343196a.png