Intellij IDEA使用Mybatis-generator自动生成数据库表对应的实体类，mapper类以及XML文件

Myth丶恋晨 2022-05-09 09:28 261阅读 0赞

项目结构

![70][]

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="F:\jdbc\mysql-connector-java-5.0.8-bin.jar"/> 
        <context id="DB2Tables"    targetRuntime="MyBatis3">
            <commentGenerator>
                <property name="suppressDate" value="true"/>
                <property name="suppressAllComments" value="true"/>
            </commentGenerator>
            
            <jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://localhost:3306/pblog" userId="root" password="Root">
            </jdbcConnection>
            <javaTypeResolver>
                <property name="forceBigDecimals" value="false"/>
            </javaTypeResolver>
            
            <javaModelGenerator targetPackage="com.njxz.demo.domain" targetProject="E:/IDEAProjects/springbootTest/src/main/java">
                <property name="enableSubPackages" value="true"/>
                <property name="trimStrings" value="true"/>
            </javaModelGenerator>
            
            <sqlMapGenerator targetPackage="mapper" targetProject="E:/IDEAProjects/springbootTest/src/main/resources">
                <property name="enableSubPackages" value="true"/>
            </sqlMapGenerator>
            
            <javaClientGenerator type="XMLMAPPER" targetPackage="com.njxz.demo..mapper" targetProject="E:/IDEAProjects/springbootTest/src/main/java">
                <property name="enableSubPackages" value="true"/>
            </javaClientGenerator>
            
     
            <table tableName="p_user" domainObjectName="User" enableCountByExample="true" enableUpdateByExample="true" enableDeleteByExample="true" enableSelectByExample="true" selectByExampleQueryId="true"></table>
    
    
    
        </context>
    </generatorConfiguration>

双击mybatis-generator运行

![70 1][]

运行结果

![70 2][]

[70]: /images/20220509/b307c6edbb564743b833b96f51067543.png
[70 1]: /images/20220509/669c45ccb08741839dc1f027e96a03f9.png
[70 2]: /images/20220509/c02b7fba1ac9433f811cb6f2ff5bbcd3.png