taotao--mybits逆向工程

generatorConfig.xml

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58

<?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>     <context id="testTables" targetRuntime="MyBatis3">         <commentGenerator>             <!-- 是否去除自动生成的注释 true：是 ： false:否 -->             <property name="suppressAllComments" value="true" />         </commentGenerator>         <!--数据库连接的信息：驱动类、连接地址、用户名、密码 -->         <jdbcConnection driverClass="com.mysql.jdbc.Driver"             connectionURL="jdbc:mysql://localhost:3306/taotao" userId="root"             password="1">         </jdbcConnection>         <!-- 默认false，把JDBC DECIMAL 和 NUMERIC 类型解析为 Integer，为 true时把JDBC DECIMAL 和             NUMERIC 类型解析为java.math.BigDecimal -->         <javaTypeResolver>             <property name="forceBigDecimals" value="false" />         </javaTypeResolver>           <!-- targetProject:生成PO类的位置 -->         <javaModelGenerator targetPackage="com.taotao.pojo"             targetProject=".\src">             <!-- enableSubPackages:是否让schema作为包的后缀 -->             <property name="enableSubPackages" value="false" />             <!-- 从数据库返回的值被清理前后的空格 -->             <property name="trimStrings" value="true" />         </javaModelGenerator>         <!-- targetProject:mapper映射文件生成的位置 -->         <sqlMapGenerator targetPackage="com.taotao.mapper"             targetProject=".\src">             <!-- enableSubPackages:是否让schema作为包的后缀 -->             <property name="enableSubPackages" value="false" />         </sqlMapGenerator>         <!-- targetPackage：mapper接口生成的位置 -->         <javaClientGenerator type="XMLMAPPER"             targetPackage="com.taotao.mapper"             targetProject=".\src">             <!-- enableSubPackages:是否让schema作为包的后缀 -->             <property name="enableSubPackages" value="false" />         </javaClientGenerator>         <!-- 指定数据库表 -->         <table schema="" tableName="tb_content"></table>         <table schema="" tableName="tb_content_category"></table>         <table schema="" tableName="tb_item"></table>         <table schema="" tableName="tb_item_cat"></table>         <table schema="" tableName="tb_item_desc"></table>         <table schema="" tableName="tb_item_param"></table>         <table schema="" tableName="tb_item_param_item"></table>         <table schema="" tableName="tb_order"></table>         <table schema="" tableName="tb_order_item"></table>         <table schema="" tableName="tb_order_shipping"></table>         <table schema="" tableName="tb_user"></table>       </context> </generatorConfiguration>

 GeneratorSqlmap.java

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38

import java.io.File; import java.io.IOException; import java.util.ArrayList; import java.util.List;   import org.mybatis.generator.api.MyBatisGenerator; import org.mybatis.generator.config.Configuration; import org.mybatis.generator.config.xml.ConfigurationParser; import org.mybatis.generator.exception.XMLParserException; import org.mybatis.generator.internal.DefaultShellCallback;   public class GeneratorSqlmap {       public void generator() throws Exception{           List<String> warnings = new ArrayList<String>();         boolean overwrite = true;         //指定 逆向工程配置文件         File configFile = new File("generatorConfig.xml");         ConfigurationParser cp = new ConfigurationParser(warnings);         Configuration config = cp.parseConfiguration(configFile);         DefaultShellCallback callback = new DefaultShellCallback(overwrite);         MyBatisGenerator myBatisGenerator = new MyBatisGenerator(config,                 callback, warnings);         myBatisGenerator.generate(null);       }     public static void main(String[] args) throws Exception {         try {             GeneratorSqlmap generatorSqlmap = new GeneratorSqlmap();             generatorSqlmap.generator();         } catch (Exception e) {             e.printStackTrace();         }               }   }

逆向工程目录结构：

log4j-1.2.16.jar ：显示程序运行日志

mybatis-3.2.3 jar:常用jar包

mybatis-generator-core-1.3.2.jar:这个的一个用途就是要据DB生成mapping

mybatis-connector-java.5.1.28 .jar:mybits驱动包

ojdbc14.jar:oracle连接数据库驱动包,oracle jdbc 开发驱动

 

逆向生成mapper和pojo.

mapper:java web中mapper是对象持久化映射层，一般会继承ibatis或者mybatis.

pojo:简单的Java对象，实际就是普通JavaBeans，是为了避免和EJB混淆所创造的简称.