根据数据库表逆向工程生成mapper和实体类-（简单工具）

蔚落 2024-03-23 12:21 125阅读 0赞

**需要准备好：**  
1、连接的数据库驱动  
2、逆向工程jar包mybatis-generator-core-1.3.2.jar  
3、generatorConfig.xml  
4、start.bat  
![在这里插入图片描述][b48682120927467ba0f9e65917adf467.png]  
**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>
        
        
         <classPathEntry location="gsjdbc4.jar" />
        <context id="DB2Tables" targetRuntime="MyBatis3">
            
            <property name="javaFileEncoding" value="UTF-8" />
            
            <commentGenerator>
                
    
                
                <property name="suppressAllComments" value="true"/>
            </commentGenerator>
            
            <jdbcConnection
                    driverClass="org.postgresql.Driver"
                    connectionURL="jdbc:postgresql://192.134.107.80:8000/ccdb"
                    password="cctest"
                    userId="Cctest_123">
            </jdbcConnection>
    
            <javaTypeResolver>
                <property name="forceBigDecimals" value="false"/>
            </javaTypeResolver>
            
            <javaModelGenerator targetPackage="po" targetProject="P:\文档\逆向工程工具\mybatis-generator_for_cgb\" >
                
                <property name="enableSubPackages" value="true" />
                
                <property name="trimStrings" value="true" />
            </javaModelGenerator>
            
            <sqlMapGenerator targetPackage="dao" targetProject="P:\文档\逆向工程工具\mybatis-generator_for_cgb\" >
                
                <property name="enableSubPackages" value="false" />
            </sqlMapGenerator>
            
            <javaClientGenerator targetPackage="dao" targetProject="P:\文档\逆向工程工具\mybatis-generator_for_cgb\" type="XMLMAPPER">
                
                <property name="enableSubPackages" value="true" />
            </javaClientGenerator>
    
            
            
            
            <table tableName="csp_ta_account_ext"
                   domainObjectName="CspTaAccountExt"
                   enableCountByExample="false"
                   enableUpdateByExample="false"
                   enableDeleteByExample="false"
                   enableSelectByExample="false"
                   selectByExampleQueryId="false">
                
    
            </table>
        </context>
    </generatorConfiguration>

**2、start.bat 内容**

cd "P:\文档\逆向工程工具\mybatis-generator_for_cgb"
    java -jar mybatis-generator-core-1.3.2.jar -configfile generatorConfig.xml -overwrite

3、准备好之后、**直接点击start.bat**，即可生成代码到po、dao里

[b48682120927467ba0f9e65917adf467.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/cce47d5e21514e2aa66bf48b3dadc3bf.png