整合spring2.5与ibatis2

spring配置文件：

<?xml version="1.0" encoding="UTF-8"?>
<beans
    xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:aop="http://www.springframework.org/schema/aop"
    xmlns:tx="http://www.springframework.org/schema/tx"
    xmlns:context="http://www.springframework.org/schema/context"
    xsi:schemaLocation="http://www.springframework.org/schema/beans
                        http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
                        http://www.springframework.org/schema/aop
                        http://www.springframework.org/schema/aop/spring-aop-2.5.xsd
                        http://www.springframework.org/schema/tx
                        http://www.springframework.org/schema/tx/spring-tx-2.5.xsd
                        http://www.springframework.org/schema/context
           http://www.springframework.org/schema/context/spring-context-2.5.xsd">
  
  
<!--    配置事务特性 -->
    <tx:advice id="txAdvice" transaction-manager="txManager">
        <tx:attributes>
           <tx:method name="add*" propagation="REQUIRED"/>
           <tx:method name="del*" propagation="REQUIRED"/>
           <tx:method name="update*" propagation="REQUIRED"/>
           <tx:method name="*" read-only="true"/>
       </tx:attributes>
    </tx:advice>

<!--     配置哪些类的方法需要进行事务管理 -->
    <aop:config>
       <aop:pointcut id="allManagerMethod" expression="execution(* com.ibatis.manager.*.*(..))"/>
       <aop:advisor advice-ref="txAdvice" pointcut-ref="allManagerMethod"/>
    </aop:config>
  
   <bean id="txManager"
    class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    <property name="dataSource" ref="proxoolDataSource" />
   </bean>
<!--   <context:annotation-config />-->
   <!-- proxoolDataSource配置 -->
   <bean id="proxoolDataSource"
        class="org.logicalcobwebs.proxool.ProxoolDataSource" destroy-method="close">
        <property name="alias" value="dataSource" />
        <property name="driver" value="oracle.jdbc.driver.OracleDriver" />
        <property name="driverUrl" value="jdbc:oracle:thin:databaseuser/8888@localhost1521:orcl" />
        <property name="user" value="databaseuser" />
        <property name="password" value="8888" />   
        <property name="minimumConnectionCount" value="2" />
        <property name="maximumConnectionCount" value="5" />
        <property name="trace" value="true" />
        <property name="delegateProperties" value=" foo=5" />
    </bean>
   
    <!-- ibatis跟spring配置 -->
    <bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
        <property name="dataSource">
            <ref local="proxoolDataSource"/>
        </property>
        <property name="configLocation">
            <value>classpath:ibatis/persistenceModel/sql-config.xml</value><!-- classpath:sql-config.xml -->
        </property>
    </bean>
   
    <bean id="accountDAO" class="ibatis.persistence.AccountSqlMapDao">
     <property name="sqlMapClient" ref="sqlMapClient"/>
    </bean>
   
    <bean id="testStruts2Tag" class="testStruts2Tag.TestStruts2Tag">
      <property name="dao" ref="accountDAO"/>
    </bean>
</beans>

 

 

ibatis的sqlmapconfig.xml

<?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>
<!--    <settings-->
<!--           lazyLoadingEnabled="true"-->
<!--            useStatementNamespaces="true" />-->
       
<!--  <properties resource="ibatis/properties/database.properties"/>-->

<!--  <transactionManager type="JDBC">-->
<!--    <dataSource type="SIMPLE">-->
<!--      <property value="${driver}" name="JDBC.Driver"/>-->
<!--      <property value="${url}" name="JDBC.ConnectionURL"/>-->
<!--      <property value="${username}" name="JDBC.Username"/>-->
<!--      <property value="${password}" name="JDBC.Password"/>-->
<!--    </dataSource>-->
<!--  </transactionManager>-->

  <sqlMap resource="ibatis/persistenceModel/Account.xml"/>

</sqlMapConfig>

 

主要是spring 的配置文件里管理数据库的连接和