1.在spring的配置文件中application.xml中加入
<!-- 配置ibatis应用 -->
<bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
<property name="configLocation" value="WEB-INF/sqlmap-config.xml" />
<property name="dataSource" ref="dataSource" />
</bean>
2.在sqlmap-config.xml中加入
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMapConfig
PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN"
"http://www.ibatis.com/dtd/sql-map-config-2.dtd">
<sqlMapConfig> //settings 必须加入
<settings cacheModelsEnabled="false" enhancementEnabled="false"
maxSessions="64" maxTransactions="8" maxRequests="128" useStatementNamespaces="true" />
//CJDB1_CAUSER_SqlMap.xml 由abator自动生成
<sqlMap resource="com/jce/ca/sqlmap/CJDB1_CAUSER_SqlMap.xml" />
</sqlMapConfig>
3.自动生成的 *rDAOImpl中必须添加空的构造方法
4.abator.xml ibatis插件生成dao
<?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 >
<jdbcConnection driverClass="oracle.jdbc.driver.OracleDriver" connectionURL="jdbc:oracle:thin:@localhost:1521:ORCL" userId="cjdb1" password="cjdb1_admin" >
<classPathEntry location="E:\workspace\Test004\lib\classes12.jar" />
</jdbcConnection>
<javaModelGenerator targetPackage="com.jce.ca.data" targetProject="houseencrypt" />
<sqlMapGenerator targetPackage="com.jce.ca.sqlmap" targetProject="houseencrypt" />
<daoGenerator targetPackage="com.jce.ca.dao" targetProject="houseencrypt" type="SPRING" />
<table schema="cjdb1" tableName="causer" >
</table>
</abatorContext>
</abatorConfiguration>