iBATIS的自动代码生成工具Abator在Eclipse的应用

iBATIS的自动代码生成工具Abator在Eclipse的应用呢首先就是iBATIS的准备：

1、获得 iBATIS

http://ibatis.apache.org/abator.html  

Eclipse可以自动的进行Update获取此Plugin，官方的安装步骤.   

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 "HelpSoftware UpdatesFind 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菜单中看到一个新的文件类型Abator for iBATIS Configuration File，此是Abator的配置文件，配置文件的详细说明见http://ibatis.apache.org/docs/tools/abator/   

3、新建一个配置文件，进行修改，根据自己的实际需求进行修改  

关键点：  

1）jdbcconnection，按照一般的配置即可，需要说明的是它需要指定访问JdbcDriver的classPathEntry，对于MsSqlServer而言，要将这三个jar文件均包含在内，否则会出现jdbc访问错误。  

2）配置三个Pakage  

3）配置表，此处需说明的是对于MsSqlServer不能写TableSchema，我初次指定TableSchema，结果未找到对应的表  

简单的配置如下，复杂的见配置文件的详细说明。示例配置文件如下 

abatorConfiguration     


  abatorContext         



    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