MyBaits和IBatis反向生成

一、建立目录，层级关系和包如下：

二、写入xml文件

config.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="ojdbc14.jar"/>

    <context id="sim">
        <jdbcConnection driverClass="oracle.jdbc.OracleDriver"
                        connectionURL="XXX"
                        userId="XXX" password="XXX"/>

        <javaModelGenerator targetPackage="entity" targetProject="src"/>
        <sqlMapGenerator targetPackage="dao" targetProject="src"/>
        <javaClientGenerator targetPackage="dao" targetProject="src"
                             type="XMLMAPPER"/>

  		
  		<table  tableName="XXX"
               domainObjectName="XXX">
            <generatedKey column="id" sqlStatement="Mysql" identity="true"/>
        </table>

    </context>
</generatorConfiguration>

 

 

confg.xml：

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE ibatorConfiguration
  PUBLIC "-//Apache Software Foundation//DTD Apache iBATIS Ibator Configuration 1.0//EN"
  "http://ibatis.apache.org/dtd/ibator-config_1_0.dtd">

<ibatorConfiguration>
	<classPathEntry location="ojdbc14.jar" />
	<ibatorContext id="DB2Tables" targetRuntime="Ibatis2Java5">
	<jdbcConnection driverClass="oracle.jdbc.driver.OracleDriver"
		connectionURL="XXX" 
	        userId="XXX" password="XXX" >
	</jdbcConnection>
    <javaTypeResolver>  
         <property name="forceBigDecimals" value="true" />  
    </javaTypeResolver>  

	<javaModelGenerator targetPackage="model"
	    targetProject="src">
	    <property name="enableSubPackages" value="true" />
	    <property name="trimStrings" value="true" />
	</javaModelGenerator>
	
	<sqlMapGenerator targetPackage="mapper"
	    targetProject="src">
	    <property name="enableSubPackages" value="true" />
	</sqlMapGenerator>
	
    <daoGenerator type="IBATIS"
	    targetPackage="dao" 
	    implementationPackage="dao"
	    targetProject="src">
	    <property name="enableSubPackages" value="true" /> 
	    <property name="exampleMethodVisibility" value="public" />
	</daoGenerator> 
	
	<table tableName="XXX">
		<generatedKey column="ID" sqlStatement="select XXX_SEQ.nextval from dual" />
     </table>
	 
	</ibatorContext>
</ibatorConfiguration>

 

三、进入当前目录cmd  指令  java -jar mybatis-generator-core-1.3.2.jar -configfile confg.xml -overwrite 

四、功成验收

 

mysql：

<?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="mysql-connector-java-5.1.6.jar"/>

    <context id="erp">
        <jdbcConnection driverClass="com.mysql.jdbc.Driver"
                        connectionURL="jdbc:mysql://118.25.108.204:3306/mysql"
                        userId="root" password="456123"/>

        <javaModelGenerator targetPackage="com.hp.daily.entity" targetProject="src"/>
        <sqlMapGenerator targetPackage="com.hp.daily.mapper" targetProject="src"/>
        <javaClientGenerator targetPackage="com.hp.daily.dao" targetProject="src"
                             type="XMLMAPPER"/>

  		
  		<table  tableName="hp_user"
               domainObjectName="HpUser" enableCountByExample="true" enableUpdateByExample="true"    
           enableDeleteByExample="true" enableSelectByExample="true" selectByExampleQueryId="true">
            <generatedKey column="id" sqlStatement="Mysql" identity="true"/>
        </table>

    </context>
</generatorConfiguration>

jar包下载链接