使用MyBatis逆向工具MyBatis GeneratorDao生成Model、Mapper、Mapping

Dear 丶 2022-04-15 01:50 206阅读 0赞

**[源码点这里][Link 1]； [官方介绍点这里][Link 2]**

## 一、使用Maven插件的方式 ##

## 1. 新建一个项目，导入pom。 ##

<?xml version="1.0" encoding="UTF-8"?>
    <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
        <modelVersion>4.0.0</modelVersion>
    
        <groupId>com.freech</groupId>
        <artifactId>mybatis-generator</artifactId>
        <version>1.0-SNAPSHOT</version>
        <dependencies>
            <dependency>
                <groupId>org.mybatis</groupId>
                <artifactId>mybatis</artifactId>
                <version>3.4.4</version>
            </dependency>
            <dependency>
                <groupId>org.mybatis.generator</groupId>
                <artifactId>mybatis-generator-core</artifactId>
                <version>1.3.2</version>
            </dependency>
            <dependency>
                <groupId>junit</groupId>
                <artifactId>junit</artifactId>
                <version>4.12</version>
            </dependency>
        </dependencies>
        <build>
            <plugins>
                <plugin>
                    
                    <groupId>org.mybatis.generator</groupId>
                    <artifactId>mybatis-generator-maven-plugin</artifactId>
                    <version>1.3.5</version>
                    <configuration>
                        <verbose>true</verbose>
                        <overwrite>true</overwrite>
                    </configuration>
                </plugin>
            </plugins>
        </build>
    
    </project>

## 2. 编写数据源配置文件datasource.properties。 ##

jdbc.driverLocation=D:/maven/repository/mysql/mysql-connector-java/5.1.44/mysql-connector-java-5.1.44.jar
    jdbc.driverClassName=com.mysql.jdbc.Driver
    jdbc.url=jdbc:mysql://localhost:3306/mybatis-generator-test?characterEncoding=utf8
    jdbc.username=root
    jdbc.password=

## 3. 编写MBG配置文件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="datasource.properties"></properties>
    
        
        <classPathEntry location="${jdbc.driverLocation}"/>
    
        
        
        
        <context id="mysql" targetRuntime="MyBatis3">
            
            <property name="javaFileEncoding" value="UTF-8"/>
    
            
            <commentGenerator>
                <property name="suppressDate" value="true"/>
                
                <property name="suppressAllComments" value="true"/>
            </commentGenerator>
    
            
            <jdbcConnection driverClass="${jdbc.driverClassName}" connectionURL="${jdbc.url}" userId="${jdbc.username}" password="${jdbc.password}">
            </jdbcConnection>
    
            
            <javaTypeResolver>
                
                <property name="forceBigDecimals" value="false"/>
            </javaTypeResolver>
    
            
            
            
            <javaModelGenerator targetPackage="com.freech.model" targetProject=".\src\main\java">
                
                <property name="constructorBased" value="false"/>
                
                <property name="enableSubPackages" value="true"/>
    
                
                <property name="immutable" value="false"/>
                
                <property name="rootClass" value="com.freech.base.BaseModel"/>
                
                <property name="trimStrings" value="true"/>
            </javaModelGenerator>
    
            
            <sqlMapGenerator targetPackage="mappers" targetProject=".\src\main\resources">
                
                <property name="enableSubPackages" value="true"/>
            </sqlMapGenerator>
    
            
            
            
            <javaClientGenerator type="XMLMAPPER" targetPackage="com.freech.mapper" targetProject=".\src\main\java">
                
                <property name="enableSubPackages" value="false"/>
            </javaClientGenerator>
            
            <table tableName="u_user" domainObjectName="User" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false">
            </table>
            <table tableName="u_role" domainObjectName="Role" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false">
            </table>
        </context>
    </generatorConfiguration>

1.  使用插件一键生成代码。  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3F3cXczMzMzMzMz_size_16_color_FFFFFF_t_70]

# 二、使用代码的方式生成 #

## 编写测试类，右键运行即可 ##

public class GeneratorTest { 
        @Test
        public void generator() throws Exception{ 
    
            List<String> warnings = new ArrayList<String>();
            boolean overwrite = true;
            //指定 逆向工程配置文件
            File configFile = new File("src\\main\\resources\\generatorConfig.xml");
            ConfigurationParser cp = new ConfigurationParser(warnings);
            Configuration config = cp.parseConfiguration(configFile);
            DefaultShellCallback callback = new DefaultShellCallback(overwrite);
            MyBatisGenerator myBatisGenerator = new MyBatisGenerator(config,callback, warnings);
            myBatisGenerator.generate(null);
    
        }
    }

[Link 1]: https://gitee.com/luckycyl/mybatis-generator.git
[Link 2]: http://www.mybatis.org/generator/index.html
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3F3cXczMzMzMzMz_size_16_color_FFFFFF_t_70]: /images/20220415/a5a88685e164484d981221f0c1d3354c.png