通过命令行方式利用mybatis-generator连接Oracle快速生成代码

• 环境说明：Oracle 11g 、Mybatis 3.4.6
•  
• 任意位置新建autoMybatis文件夹，文件夹中新建generator.xml文件，代码如下：

 1 <?xml version="1.0" encoding="UTF-8"?>    
 2 <!DOCTYPE generatorConfiguration    
 3         PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"    
 4         "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">    
 5     
 6 <generatorConfiguration>
 7     <!-- classPathEntry:数据库的JDBC驱动-->   
 8     <classPathEntry location="电脑上ojdbc6.jar文件的绝对路径" />  
 9     <context id="deDault" targetRuntime="MyBatis3">   
10  
11     <!-- 去掉自动生成的注释-->
12         <commentGenerator>    
13             <property name="suppressAllComments" value="true" />    
14         </commentGenerator>    
15     
16         <!-- 连接Oracle数据库的各项参数 -->    
17        <jdbcConnection driverClass="oracle.jdbc.driver.OracleDriver"  
18        connectionURL="jdbc:oracle:thin:@localhost:1521:数据库名称"  
19        userId="用户名"  
20        password="密码">  
21</jdbcConnection> 
22    
23         <javaTypeResolver>    
24             <property name="forceBigDecimals" value="false" />    
25         </javaTypeResolver>    
26      
27         <!--生成entity文件的路径-->    
28         <javaModelGenerator targetPackage="entity" 
29             targetProject="文件保存的位置">    
30             <property name="enableSubPackages" value="true"/>    
31             <property name="trimStrings" value="true" />    
32         </javaModelGenerator>    
33     
34         <!--生成mapper文件的路径-->     
35         <sqlMapGenerator targetPackage="mapper" 
36             targetProject="文件保存的位置">    
37             <property name="enableSubPackages" value="true"/>    
38         </sqlMapGenerator>    
39     
40         <!--生成mapper.xml文件的路径-->      
41         <javaClientGenerator type="XMLMAPPER" 
42             targetPackage="mapper" 
43             targetProject="文件保存的位置">   
44             <property name="enableSubPackages" value="true"/>    
45         </javaClientGenerator>    
46     
47     
48         <!--数据库中相关表的名称 -->    
49         <table tableName="表名" domainObjectName="生成的实体类的名称"    
50                enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false"    
51                enableSelectByExample="false" selectByExampleQueryId="false" >
52         </table>    
53     </context>    
54 </generatorConfiguration>

• 下载mybatis-generator-core-1.3.2.jar，下载地址：https://mvnrepository.com/artifact/org.mybatis.generator/mybatis-generator-core/1.3.2
•  
• 在本地Oracle的安装路径下找到ojdbc6.jar，将两个jar包都放置于autoMybatis文件夹中
•  
• 打开CMD命令行，切换到autoMybatis路径下，执行以下命令：

  java -jar mybatis-generator-core-1.3.2.jar -configfile generator.xml -overwrite

  

 

　　

• 出现以上结果便说明已成功生成entity和mapper文件

 

转载于:https://www.cnblogs.com/Czar1996/p/10291933.html

 

 

==================eg======================================

<?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="D:\up\src\up-branch\branch-server\src\main\resources\automybatis\ojdbc6-11.2.0.4.jar" />

    <context id="Mybatis3Context" targetRuntime="MyBatis3">
        <property name="javaFileEncoding" value="UTF-8"/>
        <!-- 去掉自动生成的注释-->
        <commentGenerator>
            <property name="suppressAllComments" value="true" />
        </commentGenerator>
        <jdbcConnection driverClass="oracle.jdbc.OracleDriver"
                        connectionURL="jdbc:oracle:thin:@10.2.x.x:1521:dbname"
                        userId="UP"
                        password="123456">
        </jdbcConnection>
        <javaTypeResolver>
            <property name="forceBigDecimals" value="false"/>
        </javaTypeResolver>

        <!--生成entity文件的路径-->
        <javaModelGenerator targetPackage="com.hu.cloud.up.branch.api.entity" targetProject="D:\up\src\up-branch\branch-api\src\main\java\">
            <property name="enableSubPackages" value="true"/>
            <property name="trimStrings" value="true"/>
        </javaModelGenerator>

        <!--生成mapper xml文件的路径-->
        <sqlMapGenerator targetPackage="mapper" targetProject="D:\upay\src\up-branch\branch-server\src\main\resources">
            <property name="enableSubPackages" value="true"/>
        </sqlMapGenerator>

        <!--生成mapper dao文件的路径-->
        <javaClientGenerator type="XMLMAPPER" targetPackage="com.hu.cloud.up.branch.dao" targetProject="D:\upay\src\up-branch\branch-server\src\main\java\" >
            <property name="enableSubPackages" value="true"/>
        </javaClientGenerator>

        <!--数据库中相关表的名称，生成的实体类的名称 -->
        <table tableName="ADVERT_INFO" domainObjectName="AdvertEntity" enableCountByExample="true"
               enableDeleteByExample="true" enableUpdateByExample="true" enableSelectByExample="true">
        </table>

    </context>
</generatorConfiguration>