<备忘>
安装:eclipse自动安装url: http://ibatis.apache.org/tools/abator
配置:安装好后将在New菜单中看到一个新的文件类型Abator for iBATIS Configuration File,这个是Abator的配置文件,new一个并修改配置文件,配置样式如下所示:
<abatorConfiguration>
<abatorContext> <!-- TODO: Add Database Connection Information -->
<jdbcConnection driverClass="oracle.jdbc.driver.OracleDriver"
connectionURL="jdbc:oracle:thin:@192.168.73.5:1521:dev"
userId="acct"
password="acct12">
<classPathEntry location="E:\lib\ojdbc14.jar" />
</jdbcConnection>
<javaModelGenerator targetPackage="com.greentrip.db.data" targetProject="mis.db" />
<sqlMapGenerator targetPackage="sqlmap" targetProject="mis.db" />
<table tableName="txn_log">
</table>
</abatorContext>
</abatorConfiguration>
运行:右键单击配置文件,点击Generate iBatis Artifacts,生成文件。
网上找的完整的属性:
<abatorConfiguration>
<abatorContext generatorSet="Java5"> <!-- TODO: Add Database Connection Information -->
<jdbcConnection driverClass="oracle.jdbc.driver.OracleDriver"
connectionURL="jdbc:oracle:thin:@127.0.0.1:1521:orcl"
userId="user"
password="password">
<!-- 注意:以下的classPathEntry一定要设置,否则会出现Exception JDBC Driver的错误 -->
<classPathEntry location="D:/workspace/lib/ojdbc14_g.jar" />
</jdbcConnection>
<javaModelGenerator targetPackage="com.iamyy.test.ibatis.vo" targetProject="AbatorTest" />
<sqlMapGenerator targetPackage="com.iamyy.test.ibatis.dao" targetProject="AbatorTest" />
<daoGenerator type="IBATIS" targetPackage="com.iamyy.test.ibatis.dao" targetProject="AbatorTest" />
<table tableName="T_Role" domainObjectName="Role">
<generatedKey column="role_id" identity="true" sqlStatement="select s_role.nextval from dual"/>
<columnOverride column="role_id" property="id" javaType="java.lang.String" jdbcType="VARCHAR"/>
<columnOverride column="role_name" property="name" javaType="java.lang.String" jdbcType="VARCHAR" />
</table>
</abatorContext>
</abatorConfiguration>
安装:eclipse自动安装url: http://ibatis.apache.org/tools/abator
配置:安装好后将在New菜单中看到一个新的文件类型Abator for iBATIS Configuration File,这个是Abator的配置文件,new一个并修改配置文件,配置样式如下所示:
<abatorConfiguration>
<abatorContext> <!-- TODO: Add Database Connection Information -->
<jdbcConnection driverClass="oracle.jdbc.driver.OracleDriver"
connectionURL="jdbc:oracle:thin:@192.168.73.5:1521:dev"
userId="acct"
password="acct12">
<classPathEntry location="E:\lib\ojdbc14.jar" />
</jdbcConnection>
<javaModelGenerator targetPackage="com.greentrip.db.data" targetProject="mis.db" />
<sqlMapGenerator targetPackage="sqlmap" targetProject="mis.db" />
<table tableName="txn_log">
</table>
</abatorContext>
</abatorConfiguration>
运行:右键单击配置文件,点击Generate iBatis Artifacts,生成文件。
网上找的完整的属性:
<abatorConfiguration>
<abatorContext generatorSet="Java5"> <!-- TODO: Add Database Connection Information -->
<jdbcConnection driverClass="oracle.jdbc.driver.OracleDriver"
connectionURL="jdbc:oracle:thin:@127.0.0.1:1521:orcl"
userId="user"
password="password">
<!-- 注意:以下的classPathEntry一定要设置,否则会出现Exception JDBC Driver的错误 -->
<classPathEntry location="D:/workspace/lib/ojdbc14_g.jar" />
</jdbcConnection>
<javaModelGenerator targetPackage="com.iamyy.test.ibatis.vo" targetProject="AbatorTest" />
<sqlMapGenerator targetPackage="com.iamyy.test.ibatis.dao" targetProject="AbatorTest" />
<daoGenerator type="IBATIS" targetPackage="com.iamyy.test.ibatis.dao" targetProject="AbatorTest" />
<table tableName="T_Role" domainObjectName="Role">
<generatedKey column="role_id" identity="true" sqlStatement="select s_role.nextval from dual"/>
<columnOverride column="role_id" property="id" javaType="java.lang.String" jdbcType="VARCHAR"/>
<columnOverride column="role_name" property="name" javaType="java.lang.String" jdbcType="VARCHAR" />
</table>
</abatorContext>
</abatorConfiguration>