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 的配置文件里管理数据库的连接和