iBATOR是一个代码生成器,用于iBATIS。 iBATOR内部检查的一个或多个数据库表和将生成iBATIS的工件,可用于访问表。
稍后,您可以编写自定义的SQL代码或存储过程来满足您的要求。 iBATOR产生以下项目:
-
SqlMap XML文件
-
Java类相匹配的表的主键和字段
-
使用上述对象DAO类(可选)
iBATOR可以运行作为一个独立的JAR文件,或作为一个Ant任务,或者作为一个Eclipse插件。本教程将教你生成iBATIS的配置文件格式命令行的简单的方法。
下载iBATOR:
如果您使用的IDE是Eclipse,比其他下载独立的JAR。独立的JAR包括一个Ant任务来运行iBATOR,或者您也可以从Java代码中的命令行运行iBATOR。
-
You can download zip file from Download iBATOR.
-
You can check online documentation: iBATOR Documentation.
Generating Configuration File:
To get up and running quickly with Abator, follow these steps:
Step 1:
Create and fill out a configuration file ibatorConfig.xml appropriately. At a minimum, you must specify:
-
A <jdbcConnection> element to specify how to connect to the target database.
-
A <javaModelGenerator> element to specify target package and target project for generated Java model objects
-
A <sqlMapGenerator> element to specify target package and target project for generated SQL map files.
-
A <daoGenerator> element to specify target package and target project for generated DAO interfaces and classes (you may omit the <daoGenerator> element if you don't wish to generate DAOs).
-
At least one database <table> element
NOTE: See the XML Configuration File Reference page for an example of an Abator configuration file.
Step 2:
Save the file in some convenient location for example at: empibatorConfig.xml).
Step 3:
Now run Abator from the command line with a command line as follows:
java -jar abator.jar -configfile empabatorConfig.xml -overwrite
This will tell Abator to run using your configuration file. It will also tell Abator to overwrite any existing Java files with the same name. If you want to save any existing Java files, then omit the -overwriteparameter.
If there is a conflict, Abator will save the newly generated file with a unique name.
After running Abator, you will need to create or modify the standard iBATIS configuration files to make use of your newly generated code. This is explained in next section.
Tasks After Running Abator:
After you run Abator, you will need to create or modify other iBATIS configuration artifacts. The main tasks are as follows:
-
Create or Modify the SqlMapConfig.xml file.
-
Create or modify the dao.xml file (only if using the iBATIS DAO Framework).
Each task is described in detail below:
Updating the SqlMapConfig.xml File:
iBATIS uses an XML file, commonly named SqlMapConfig.xml, to specify information for a database connection, a transaction management scheme, and SQL map XML files that will be used in an iBATIS session.
Abator cannot create this file for you because Abator knows nothing about your execution environment. However, some of the items in this file relate directly to Abator generated items.
Abator specific needs in the configuration file are as follows:
-
Statement namespaces must be enabled.
-
Abator generated SQL Map XML files must be listed .
For example, suppose that Abator has generated an SQL Map XML file called MyTable_SqlMap.xml, and that the file has been placed in the test.xml package of your project. The SqlMapConfig.xml file should have these entries:
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE sqlMapConfig PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-config-2.dtd"> <sqlMapConfig> <!-- Statement namespaces are required for Abator --> <settings useStatementNamespaces="true" /> <!-- Setup the transaction manager and data source that are appropriate for your environment --> <transactionManager type="..."> <dataSource type="..."> </dataSource> </transactionManager> <!-- SQL Map XML files should be listed here --> <sqlMap resource="test/xml/MyTable_SqlMap.xml" /> </sqlMapConfig>
If there is more than one SQL Map XML file (as is quite common), then the files can be listed in any order with repeated <sqlMap> elements after the <transactionManager> element.
Updating the dao.xml File:
The iBATIS DAO framework is configured by an xml file commonly called dao.xml.
The iBATIS DAO framework uses this file to control the database connection information for DAOs, and also to list the DAO implementation classes and DAO interfaces.
In this file you should specify the path to your SqlMapConfig.xml file, and all the Abator generated DAO interfaces and implementation classes.
For example, suppose that Abator has generated a DAO interface called MyTableDAO and a implementation class called MyTableDAOImpl, and that the files have been placed in the test.dao package of your project.
dao.xml文件应该有这些项:
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE daoConfig PUBLIC "-//ibatis.apache.org//DTD DAO Configuration 2.0//EN" "http://ibatis.apache.org/dtd/dao-2.dtd"> <daoConfig> <context> <transactionManager type="SQLMAP"> <property name="SqlMapConfigResource" value="test/SqlMapConfig.xml"/> </transactionManager> <!-- DAO interfaces and implementations should be listed here --> <dao interface="test.dao.MyTableDAO" implementation="test.dao.MyTableDAOImpl" /> </context> </daoConfig>
NOTE: This step is only required if you generated DAOs for the iBATIS DAO framework.