spring + ibatis2 整合

来源：互联网发布：c数组删除指定元素编辑：程序博客网时间：2024/05/21 14:43

1.在spring的配置文件中application.xml中加入
   
<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>