Mybatis在IDEA中使用generator逆向工程生成pojo,mapper

短命女 2022-04-06 11:20 317阅读 0赞

**1.创建maven 工程，修改pom.xml**

** **

<build> <plugins>  <plugin> <groupId>org.mybatis.generator</groupId> <artifactId>mybatis-generator-maven-plugin</artifactId> <version>1.3.2</version> <configuration>  <configurationFile>src/main/resources/generatorConfig.xml</configurationFile> <verbose>true</verbose> <overwrite>true</overwrite> </configuration> </plugin> </plugins> </build>

** **

**2.****在resources下新建   **Personal-DB.propertie(数据库连接文件) （也可以写死）

jdbc.driverLocation=D:\\maven\\com\\oracle\\ojdbc14\\10.2.0.4.0\\ojdbc14-10.2.0.4.0.jar  
    jdbc.driverClass=oracle.jdbc.driver.OracleDriver  
    jdbc.connectionURL=jdbc:oracle:thin:@//localhost:1521/XE  
    jdbc.userId=LOUIS  
    jdbc.password=123456

**3.在resources下新建   **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="Personal-DB.properties"></properties>
        <classPathEntry location="${jdbc.driverLocation}" />
        
        <context id="context1" targetRuntime="MyBatis3">
    
            <commentGenerator>
                
                <property name="suppressAllComments" value="true" />
            </commentGenerator>
            
            
            <jdbcConnection driverClass="${jdbc.driverClass}"
                connectionURL="${jdbc.connectionURL}"
                userId="${jdbc.userId}"
                password="${jdbc.password}" />
            
    
     
            <javaTypeResolver>
                <property name="forceBigDecimals" value="false"/>
            </javaTypeResolver>
    
            
            <javaModelGenerator targetPackage="com.unisits.zngkpt.common.userprivrman.pojo"
                targetProject="src/main/java" />
                
            
            <sqlMapGenerator targetPackage="com.unisits.zngkpt.common.userprivrman.mapper" targetProject="src/main/java" />
    
             
            <javaClientGenerator type="XMLMAPPER" targetPackage="com.bldz.train.mapper" targetProject="src/main/java">
                    <property name="enableSubPackages" value="true"/>
            </javaClientGenerator>
            
            <table schema="" tableName="sys_role" enableCountByExample="false" enableSelectByExample="false"
                enableDeleteByExample="false" enableUpdateByExample="false" selectByExampleQueryId="false" >
            </table>
            <table schema="" tableName="sys_permission" enableCountByExample="false" enableSelectByExample="false"
                   enableDeleteByExample="false" enableUpdateByExample="false" selectByExampleQueryId="false" >
            </table>
            <table schema="" tableName="sys_role_permission" enableCountByExample="false" enableSelectByExample="false"
                   enableDeleteByExample="false" enableUpdateByExample="false" selectByExampleQueryId="false" >
            </table>
            <table schema="" tableName="sys_user" enableCountByExample="false" enableSelectByExample="false"
                   enableDeleteByExample="false" enableUpdateByExample="false" selectByExampleQueryId="false" >
            </table>
            <table schema="" tableName="sys_user_role" enableCountByExample="false" enableSelectByExample="false"
            enableDeleteByExample="false" enableUpdateByExample="false" selectByExampleQueryId="false" >
            </table>
            <table schema="" tableName="unit_info" enableCountByExample="false" enableSelectByExample="false"
                   enableDeleteByExample="false" enableUpdateByExample="false" selectByExampleQueryId="false" >
            </table>
            <table schema="" tableName="unit_type" enableCountByExample="false" enableSelectByExample="false"
                   enableDeleteByExample="false" enableUpdateByExample="false" selectByExampleQueryId="false" >
            </table>
        </context>
    </generatorConfiguration>

3，到现在为止，所有的mybatis配置工作已经结束了，开始配置idea来运行生成pojo吧

点击菜单Run->Edit Configuration,然后在弹出窗体的左上角，如下，输入 mybatis-generator:generate -e

然后点击确定  
![543ec6bc-9f58-3492-8620-5acbf6067c7b.png][]

** 4.运行刚才编辑的maven，不出意外就会生成成功**

**    
![94b671a7-7c27-3d02-842b-36e1e936aeea.png][]**

补充：最终 红色部分会生成 xml  对应method 的 mapper.java 文件

转载：

[ http://www.cnblogs.com/ningheshutong/p/6376970.html][http_www.cnblogs.com_ningheshutong_p_6376970.html]

** **

[543ec6bc-9f58-3492-8620-5acbf6067c7b.png]: /images/20220406/4edbe4f911254e86b23d22edee5f9fa1.png
[94b671a7-7c27-3d02-842b-36e1e936aeea.png]: /images/20220406/03fcf953ab12416394c087087a47bc14.png
[http_www.cnblogs.com_ningheshutong_p_6376970.html]: http://www.cnblogs.com/ningheshutong/p/6376970.html