DGenerationX 2014-03-17
一.安装插件AbatorAbator for Eclipse Update Site
This is the Abator for Eclipse update site. If you're not sure what Abator is, then see this pagehttp://ibatis.apache.org/abator.html
If you've already installed a prior version of Abator for Eclipse, then simply run the Eclipse Install/Update tool and any new version will be found automatically.
If you've not already installed Abator, then you can use the built in Eclipse install support by following these steps:
3、插件完成后,建立一个项目ibatisTest,然后选择文件>新建>ABator for iBatis configuration File,默认文件名,点击“完成”。修改刚才的文件abatorConfig.xml,把里面的相关“?”根据自己的实际情况替换如下,我的是这样的。
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE abatorConfiguration PUBLIC "-//Apache Software Foundation//DTD Abator for iBATIS Configuration 1.0//EN"
"http://ibatis.apache.org/dtd/abator-config_1_0.dtd">
<abatorConfiguration>
<abatorContext> <!-- TODO: Add Database Connection Information -->
<jdbcConnection driverclass="oracle.jdbc.driver.OracleDriver"
connectionURL="jdbc:oracle:thin:@localhost:1521:orcl"
userid="spell"
password="spell">
<classPathEntry location="G:/techinfo/javaLib/DB_Jar/oracle/classes12.jar" />
</jdbcConnection>
<javaModelGenerator targetPackage="com.spell.model" targetProject="ibatisTest/src" />
<sqlMapGenerator targetPackage="com.spell.map" targetProject="ibatisTest/src" />
<daoGenerator type="IBATIS" targetPackage="com.spell.dao" targetProject="ibatisTest/src" />
<table tablename="members">
</table>
</abatorContext>
</abatorConfiguration>
5、 在abatorConfig.xml上点击鼠标右键,选择Generate iBATIS Artifact,在src目录下会生成com.spell.model、com.spell.map、com.spell.dao三个目录,文件也建立好了。 其他有什么要修改的就自己动手吧~~
6
来至:http://hi.baidu.com/ecspell/item/7293b4456d94d1d2c0a592a8
如:对于sql语句order by #user_id#,如果传入的值是111,那么解析成sql时的值为order by "111", 如果传入的值是id,则解析成的sql为order by "id"。