Myeclipse添加mybatis generator插件

Myeclipse添加mybatis generator插件

地址：http://mybatis.googlecode.com/svn/sub-projects/generator/trunk/eclipse/UpdateSite/

Myeclipse-help-Myeclipse ConfigurationCenter

在mybatis下右击：Add to profile — pending  Changes

 

MyBatis Generator Generated Java ClientObjects官网：

http://mybatis.org/generator/generatedobjects/javaclient.html

 

 

1、  数据库表：

CREATE TABLE IT_USER

   (ROW_ID VARCHAR2(15) NOT NULL,

    USERNAME VARCHAR2(16),

    PWD VARCHAR2(32),

    TELEPHONE VARCHAR2(30),

    constraint PK_T_SCORE primarykey(ROW_ID)

);

 

createsequence a_seq       --创建序列名字为   a_seq

minvalue1               -- 最小值为      1

maxvalue99999   ---  最大值为     99999  

startwith1            ---  开始值       1

incrementby1           ---每次增长值    1

cache100;              

 

INSERTINTOIT_USER(ROW_ID,USERNAME,PWD,TELEPHONE)

VALUES(a_seq.NEXTVAL,'王五','123456','123456789');

 

select * from IT_USER;

 

 

添加generatorConfig.xml，文件内容：

 

<?xml version="1.0"encoding="UTF-8" ?>
<!DOCTYPE generatorConfiguration PUBLIC "-//mybatis.org//DTDMyBatis Generator Configuration 1.0//EN" "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
<generatorConfiguration >
  <context id="context1">
    <jdbcConnection driverClass="oracle.jdbc.driver.OracleDriver" connectionURL="jdbc:oracle:thin:@192.168.6.40:1521:SIEBELDB"userId="SIEBEL" password="SIEBEL"/>
    <javaModelGenerator targetPackage="com.hand.siebel.pojo" targetProject="Generate\src">
       <property name="enableSubPackages" value="true" />
    </javaModelGenerator>
    <sqlMapGenerator targetPackage="com.hand.siebel.xml" targetProject="Generate\src">
       <property name="enableSubPackages" value="true" />
    </sqlMapGenerator>
    <javaClientGenerator type="XMLMAPPER" targetPackage="com.hand.siebel.dao"  targetProject="Generate\src">
      <property name="enableSubPackages"value="true" />
    </javaClientGenerator>
    <table schema="SIEBEL"tableName="IT_USER" domainObjectName="User"
       enableSelectByExample="true"
       enableDeleteByExample="true"
       enableCountByExample="true"
       enableUpdateByExample="true">
   
    </table>
  </context>
</generatorConfiguration>

 

右击generatorConfig.xml，选择生成mybatis，