Mybatis -代码自动生成（generatorConfig.xml）

古城微笑少年丶 2022-05-08 08:12 227阅读 0赞

> 对于一个字段太多的表，如果一个一个的去写 mapper和pojo太累还容易出错，可用mybatis的工具处理这些事情

## 1. 环境： ##

Maven 3.39  
Oracle 11g  
Mybatis 3.4.1  
Maven project

## 2. 目录结构 ##

![这里写图片描述][SouthEast]

## 3. pom添加插件 ##

<dependencies>
            <dependency>
                <groupId>org.mybatis</groupId>
                <artifactId>mybatis</artifactId>
                <version>3.4.1</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>
                </plugin>
            </plugins>
        </build>

## 4. 新建generatorConfig.xml 文件(放在src/main/resources目录下) ##

<?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.properties"/>
    
            
            <classPathEntry
                location="${generator.location}" />
    
             
            <context id="sqlserverTables">
                
                <plugin type="org.mybatis.generator.plugins.SerializablePlugin"></plugin>
    
                
                <commentGenerator>
                    <property name="suppressAllComments" value="true" />
                    
                </commentGenerator>  
    
                
                <jdbcConnection driverClass="${db.example.driver}"
                    connectionURL="${db.example.url}" userId="${db.example.username}" 
                    password="${db.example.password}">
                </jdbcConnection>
    
                
                <javaTypeResolver>
                
                    <property name="forceBigDecimals" value="false" />
                </javaTypeResolver>
    
                
                <javaModelGenerator targetPackage="${generator.targetPackage}"
                    targetProject="./src/main/java">
                     
                    <property name="enableSubPackages" value="false" />
                    
                    <property name="trimStrings" value="true" />
                </javaModelGenerator>
    
                
                <sqlMapGenerator targetPackage="${generator.targetPackage}"
                    targetProject="./src/main/java">
                    <property name="enableSubPackages" value="false" />
                </sqlMapGenerator>
    
                
                <javaClientGenerator type="XMLMAPPER"
                    targetPackage="${generator.targetPackage}" targetProject="./src/main/java">
                    <property name="enableSubPackages" value="false" />
                </javaClientGenerator>
    
    
                
                  
                <table tableName="${gererator.tableName}" domainObjectName="${gererator.objectName}"
                    schema="${gererator.schema}"
                    enableCountByExample="false" enableUpdateByExample="false"
                    enableDeleteByExample="false" enableSelectByExample="false"
                    selectByExampleQueryId="false">
                       
                    
                    
                    <property name="useActualColumnNames" value="false" />
                </table>
            </context>
        </generatorConfiguration>

## 5. 设置需要生成的表及创建目录参数（application.properties放在src/main/resources目录下） ##

db.example.type=oracle
    db.example.driver=oracle.jdbc.driver.OracleDriver
    db.example.url=jdbc:oracle:thin:@ip:port:sid
    db.example.username=username
    db.example.password=password
    
    #MBGInfo
    generator.location=D:/project/eas_std/BaseApp/lib/ojdbc14-10.2.0.5.jar
    generator.targetPackage=com.zteict.example.menu
    gererator.schema=fbp
    gererator.tableName=fbp_menu
    gererator.objectName=FbpMenu

## 6. 项目右键-RUN AS-MAVEN BUILD.. ##

输入 mybatis-generator:generate  
![这里写图片描述][SouthEast 1]

## 7. 生成的文件 ##

FbpMenu：  
![这里写图片描述][SouthEast 2]  
FbpMenuMapper:  
![这里写图片描述][SouthEast 3]  
Xml：  
![这里写图片描述][SouthEast 4]

参考：[http://blog.csdn.net/jinshiyill/article/details/51546676][http_blog.csdn.net_jinshiyill_article_details_51546676]  
官方网址: [http://www.mybatis.org/generator/configreference/xmlconfig.html][http_www.mybatis.org_generator_configreference_xmlconfig.html]  
原码:[http://download.csdn.net/detail/wangxy799/9773975][http_download.csdn.net_detail_wangxy799_9773975]

[SouthEast]: /images/20220508/605303762b1b421cac9f430c16c3c92d.png
[SouthEast 1]: /images/20220508/f615d322119042b4b9755672f68970c6.png
[SouthEast 2]: /images/20220508/80bcdbc527af4c48a7e9641bf0e44b4e.png
[SouthEast 3]: /images/20220508/bfbe9975b8d04f1793ee9e2b1cd1d3b2.png
[SouthEast 4]: /images/20220508/7cb5a550125f48d5b89518158fca58ea.png
[http_blog.csdn.net_jinshiyill_article_details_51546676]: http://blog.csdn.net/jinshiyill/article/details/51546676
[http_www.mybatis.org_generator_configreference_xmlconfig.html]: http://www.mybatis.org/generator/configreference/xmlconfig.html
[http_download.csdn.net_detail_wangxy799_9773975]: http://download.csdn.net/detail/wangxy799/9773975