mybatis-使用generator反向数据库表并生成dao和mapping映射

 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 <!--生成命令:java -jar mybatis-generator-core-1.3.1.jar -configfile mybatis-generator.xml  -overwrite -->
 6 <generatorConfiguration>
 7 
 8         <classPathEntry location="D:/generator/ojdbc14.jar" />
 9         <context id="WS_Tables" targetRuntime="MyBatis3">
10              <commentGenerator>
11                 <property name="suppressAllComments" value="true"/>
12              </commentGenerator>
13              
14 
15              <jdbcConnection driverClass="oracle.jdbc.OracleDriver" connectionURL="jdbc:oracle:thin:@192.168.1.110:1521:duwenlei" userId="system" password="du"></jdbcConnection>
16              <javaTypeResolver>
17                  <property name="forceBigDecimais" value="false"/>
18              </javaTypeResolver>
19              
20 
21              <javaModelGenerator targetPackage="sy.model" targetProject="D:/generator/src">
22                  <property name="enableSubPackages" value="true"/>
23                  <property name="trimStrings" value="true"/>
24              </javaModelGenerator>
25              
26 
27              <sqlMapGenerator targetPackage="sy.mapping" targetProject="D:/generator/src">
28                  <property name="enableSubPackages" value="true"/>
29              </sqlMapGenerator>
30              
31 
32              <javaClientGenerator targetPackage="sy.dao" type="XMLMAPPER" targetProject="D:/generator/src">
33                  <property name="enableSubPackages" value="true"/>
34              </javaClientGenerator>
35              
36 
37              <table tableName="user_" domainObjectName="User" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false"></table>
38         </context>
39 </generatorConfiguration>

注意:所有的targetProject="D:/generator/src",不要包含中文名称,要不然会一堆乱码
  需要用到数据库驱动

             mybatis-generator-core-1.3.2.jar两个jar文件。

如果有使用请标明来源:http://www.cnblogs.com/duwenlei/
原文地址:https://www.cnblogs.com/duwenlei/p/3519392.html