一个proxool连接池的applicationContext.xml配置文件

applicationContext.xml
<?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"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd
http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.0.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.0.xsd"
default-autowire="byName" default-lazy-init="true">

<bean id="dataSource"
class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName">
<value>org.logicalcobwebs.proxool.ProxoolDriver</value>
</property>
<property name="url">
<value>proxool.db</value>
</property>
</bean>
<!--
<bean id="dataSource"
class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName"
value="com.mysql.jdbc.Driver">
</property>
<property name="url"
value="jdbc:mysql://xxxxxxxxxx:3306/imrms">
</property>
<property name="username" value="user"></property>
<property name="password" value="User"></property>
</bean>
-->
<bean id="sessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource">
<ref bean="dataSource" />
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">
org.hibernate.dialect.MySQLDialect
</prop>
<prop key="hibernate.show_sql">true</prop>
</props>
</property>

<property name="mappingResources">
<list>
<value>
com/midland/eagents/vo/ImrmsSalesResume.hbm.xml
</value>
<value>com/midland/eagents/vo/ImrmsData.hbm.xml</value>
<value>
com/midland/eagents/vo/ImrmsNetPersonDateHitStat.hbm.xml
</value>
<value>
com/midland/eagents/vo/ImrmsCommiData.hbm.xml
</value>
<value>
com/midland/eagents/vo/ImrmsBusinessData.hbm.xml
</value>
<value>
com/midland/eagents/vo/ImrmsNetFloorDateHitsStat.hbm.xml
</value>
<value>
com/midland/eagents/vo/ImrmsDiaryHit.hbm.xml
</value>
<value>
com/midland/eagents/vo/ImrmsPic2estid.hbm.xml
</value>
<value>
com/midland/eagents/vo/TbBrmRegion.hbm.xml
</value>

<value>
com/midland/eagents/vo/ImrmsBusinessDataImgs.hbm.xml
</value></list>
</property></bean>

<!-- 配置事务 -->
<bean id="transactionManager"
class="org.springframework.orm.hibernate3.HibernateTransactionManager">
<property name="sessionFactory">
<ref local="sessionFactory" />
</property>
</bean>

<!-- 此处设置spring 管理session 如果不设会出现session没关的问题 -->
<!--
<bean id="transactionInterceptor" class="org.springframework.transaction.interceptor.TransactionInterceptor">
<property name="transactionManager" ref="transactionManager"/>
<property name="transactionAttributes">
<props>
<prop key="save*">PROPAGATION_REQUIRED</prop>
<prop key="add*">PROPAGATION_REQUIRED</prop>
<prop key="set*">PROPAGATION_REQUIRED</prop>
<prop key="update*">PROPAGATION_REQUIRED</prop>
<prop key="delete*">PROPAGATION_REQUIRED</prop>
<prop key="remove">PROPAGATION_REQUIRED</prop>
<prop key="find*">PROPAGATION_REQUIRED,readOnly</prop>
<prop key="get*">PROPAGATION_REQUIRED,readOnly</prop>

</props>
</property>
</bean>

<bean class="org.springframework.aop.framework.autoproxy.BeanNameAutoProxyCreator">

<property name="beanNames">
<list>
<value>imrmsCommiDataDaoImp</value>
<value>imrmsSalesResumeDaoImp</value>
<value>imrmsBusinessDataDaoImp</value>
<value>imrmsNetFloorDateHitsStatDaoImp</value>
<value>imrmsDiaryHitDaoImp</value>
<value>imrmsDataDaoImp</value>
<value>imrmsTbBrmRegionDaoImp</value>
<value>eagentManagerImpl</value>
<value>officeManager</value>
<value>shopManager</value>
<value>homeManager</value>
</list>

</property>
<property name="interceptorNames">
<list>
<value>transactionInterceptor</value>
</list>
</property>
</bean>
<bean class="org.springframework.transaction.interceptor.TransactionAttributeSourceAdvisor">
<property name="transactionInterceptor" ref="transactionInterceptor"/>
</bean>

-->
<!--

其中带问号的modifiers-pattern?(public/protected) 和 declaring-type-pattern? throws-pattern? 可以不填

可见execution(* *..BookManager.save(..))

第一颗* 代表ret-type-pattern 返回值可任意，
*..BookManager 代表任意Pacakge里的BookManager类。
如果写成com.xyz.service.* 则代表com.xyz.service下的任意类
com.xyz.service..* com.xyz.service则代表com.xyz.service及其子package下的任意类
save代表save方法，也可以写save* 代表saveBook()等方法
(..) 匹配0个参数或者多个参数的，任意类型
(x,..) 第一个参数的类型必须是X
(x,,,s,..) 匹配至少4个参数，第一个参数必须是x类型，第二个和第三个参数可以任意，第四个必须是s类型。
-->
<!-- 支持 @Transactional 标记 -->
<tx:annotation-driven/>

<!-- 支持 @AspectJ 标记-->
<aop:aspectj-autoproxy/>

<!-- 以AspectJ方式 定义 AOP -->
<aop:config proxy-target-class="true">
<aop:advisor pointcut="execution(* com.midland.eagents.service.*Manager*.*(..))"
advice-ref="txAdvice"/>
<aop:advisor pointcut="execution(* com.midland.eagents.dao.imp.*Dao*.*(..))"
advice-ref="txAdvice"/>
</aop:config>

<!-- 基本事务定义,使用transactionManager作事务管理,默认get*方法的事务为readonly,其余方法按默认设置.
默认的设置请参考Spring文档事务一章. -->
<tx:advice id="txAdvice">
<tx:attributes>
<tx:method name="get*" read-only="true"/>
<tx:method name="find*" read-only="true"/>
<tx:method name="*"/>
</tx:attributes>
</tx:advice>

<bean id="imrmsSalesResumeDaoImp" class="com.midland.eagents.dao.imp.ImrmsSalesResumeDaoImp" >
<property name="sessionFactory">
<ref local="sessionFactory"/>
</property>
</bean>
<bean id="imrmsDataDaoImp" class="com.midland.eagents.dao.imp.ImrmsDataDaoImp" >
<property name="sessionFactory">
<ref local="sessionFactory"/>
</property>
</bean>
<bean id="imrmsCommiDataDaoImp" class="com.midland.eagents.dao.imp.ImrmsCommiDataDaoImp" >
<property name="sessionFactory">
<ref local="sessionFactory"/>
</property>
</bean>

<bean id="imrmsBusinessDataDaoImp" class="com.midland.eagents.dao.imp.ImrmsBusinessDataDaoImp" >
<property name="sessionFactory">
<ref local="sessionFactory"/>
</property>
</bean>
<bean id="imrmsNetFloorDateHitsStatDaoImp" class="com.midland.eagents.dao.imp.ImrmsNetFloorDateHitsStatDaoImp" >
<property name="sessionFactory">
<ref local="sessionFactory"/>
</property>
</bean>
<bean id="imrmsDiaryHitDaoImp" class="com.midland.eagents.dao.imp.ImrmsDiaryHitDaoImp" >
<property name="sessionFactory">
<ref local="sessionFactory"/>
</property>
</bean>
<bean id="imrmsTbBrmRegionDaoImp" class="com.midland.eagents.dao.imp.ImrmsTbBrmRegionDaoImp" >
<property name="sessionFactory">
<ref local="sessionFactory"/>
</property>
</bean>
<!-- 首页参数配置开始 -->
<bean name="/index" class="com.midland.eagents.struts.action.IndexAction" >
<property name="imrmsSalesResumeDao">
<ref local="imrmsSalesResumeDaoImp"/>
</property>
<property name="imrmsDataDao">
<ref local="imrmsDataDaoImp"/>
</property>
<property name="imrmsCommiDataDao">
<ref local="imrmsCommiDataDaoImp"/>
</property>
<property name="imrmsBusinessDataDao">
<ref local="imrmsBusinessDataDaoImp"/>
</property>
<property name="imrmsNetFloorDateHitsStatDao">
<ref local="imrmsNetFloorDateHitsStatDaoImp"/>
</property>
<property name="imrmsDiaryHitDao">
<ref local="imrmsDiaryHitDaoImp"/>
</property>
<property name="imrmsTbBrmRegionDao">
<ref local="imrmsTbBrmRegionDaoImp"/>
</property>
</bean>
<!-- 首页配置结束 -->
<!-- profile页面参数配置开始 -->
<bean name="/profile" class="com.midland.eagents.struts.action.ProfileAction" >
<property name="imrmsSalesResumeDao">
<ref local="imrmsSalesResumeDaoImp"/>
</property>
<property name="imrmsDataDao">
<ref local="imrmsDataDaoImp"/>
</property>
<property name="imrmsCommiDataDao">
<ref local="imrmsCommiDataDaoImp"/>
</property>
<property name="imrmsBusinessDataDao">
<ref local="imrmsBusinessDataDaoImp"/>
</property>
<property name="imrmsNetFloorDateHitsStatDao">
<ref local="imrmsNetFloorDateHitsStatDaoImp"/>
</property>
<property name="imrmsDiaryHitDao">
<ref local="imrmsDiaryHitDaoImp"/>
</property>
<property name="imrmsTbBrmRegionDao">
<ref local="imrmsTbBrmRegionDaoImp"/>
</property>
</bean>

<!-- profile页面配置结束 -->
<bean name="/eagent" class="com.midland.eagents.struts.action.EagentAction" >
<property name="imrmsSalesResumeDao">
<ref local="imrmsSalesResumeDaoImp"/>
</property>
<property name="imrmsTbBrmRegionDao">
<ref local="imrmsTbBrmRegionDaoImp"/>
</property>
</bean>




</beans>