獲得
????? http://ibatis.apache.org/abator.html
???? Eclipse可以自動(dòng)的進(jìn)行Update獲取此Plugin,官方的安裝步驟
Automatic Eclipse Install
If you've already installed a prior version of Abator, simply run the Eclipse Install/Update tool and the 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:
- Take the "Help>Software Updates>Find and Install" Menu Option
- Select the "Search for new features to install" radio button, press "Next"
- Press the "New Remote Site" button
- Enter the following information:
- Name:
- Abator for Eclipse Update Site
- URL:
- http://ibatis.apache.org/tools/abator
- Press OK
- Check the box next to "Abator for Eclipse Update Site"
- Follow the remainder of the install wizard
2、安裝好后將在New菜單中看到一個(gè)新的文件類型Abator for iBATIS Configuration File,此是Abator的配置文件,配置文件的詳細(xì)說明見http://ibatis.apache.org/docs/tools/abator/
3、新建一個(gè)配置文件,進(jìn)行修改,根據(jù)自己的實(shí)際需求進(jìn)行修改
關(guān)鍵點(diǎn):
1)jdbcconnection,按照一般的配置即可,需要說明的是它需要指定訪問JdbcDriver的classPathEntry,對(duì)于MsSqlServer而言,要將這三個(gè)jar文件均包含在內(nèi),否則會(huì)出現(xiàn)jdbc訪問錯(cuò)誤。
2)配置三個(gè)Pakage
3)配置表,此處需說明的是對(duì)于MsSqlServer不能寫TableSchema,我初次指定TableSchema,結(jié)果未找到對(duì)應(yīng)的表
簡(jiǎn)單的配置如下,復(fù)雜的見配置文件的詳細(xì)說明。示例配置文件如下
<abatorConfiguration>
? <abatorContext>??? <!-- TODO: Add Database Connection Information -->
??? <jdbcConnection driverClass="com.microsoft.jdbc.sqlserver.SQLServerDriver"
??????? connectionURL="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=whm;SelectMethod=cursor"
??????? userId="sa"
??????? password="sa">
????? <classPathEntry location="C:/Program Files/Apache Software Foundation/Tomcat 5.0/common/lib/mssqlserver.jar" />
????? <classPathEntry location="C:/Program Files/Apache Software Foundation/Tomcat 5.0/common/lib/msutil.jar" />
????? <classPathEntry location="C:/Program Files/Apache Software Foundation/Tomcat 5.0/common/lib/msbase.jar" />
??? </jdbcConnection>
??? <javaModelGenerator targetPackage="com.dwerp.itatis.domain" targetProject="BhbManage" />
??? <sqlMapGenerator targetPackage="com.dwerp.itatis.persistence.xml" targetProject="BhbManage" />
??? <daoGenerator type="IBATIS" targetPackage="com.dwerp.itatis.persistence.sqlmapdao" targetProject="BhbManage" />
??? <table tableName="BHBGL">
????
??? </table>
? </abatorContext>
</abatorConfiguration>
4、右鍵單擊配置文件,點(diǎn)擊Generate iBatis Artifacts,生成文件。
?