?xml version="1.0" encoding="UTF-8"?>
beans xmlns="http://www.springframework.org/schema/beans"
  xmlns:context="http://www.springframework.org/schema/context"
  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.xsd
  http://www.springframework.org/schema/tx
  http://www.springframework.org/schema/tx/spring-tx.xsd
  http://www.springframework.org/schema/context
  http://www.springframework.org/schema/context/spring-context.xsd
  http://www.springframework.org/schema/aop
  http://www.springframework.org/schema/aop/spring-aop-2.0.xsd">
  
  !-- 使用annotation @Repository,@Service自動注冊bean, 并保證@Required、@Autowired的屬性被注入的包范圍 -->
  context:component-scan base-package="com.rd,com.rongdu"/>
  context:annotation-config/>
  

  bean id="dataSource" class="com.jolbox.bonecp.BoneCPDataSource" destroy-method="close">
    !-- Connection Info -->
    property name="driverClass" value="com.mysql.jdbc.Driver"/>
    property name="jdbcUrl" value="jdbc:mysql://localhost:3306/sfd?useUnicode=truecharacterEncoding=utf8"/>
    property name="username" value="root"/>
    property name="password" value="123456"/>

    !-- 檢查數據庫連接池中空閑連接的間隔時間 -->
    property name="idleConnectionTestPeriod" value="4" />
    !-- 連接池中未使用的鏈接最大存活時間 -->
    property name="idleMaxAge" value="240" />
    !-- 設置每個分區含有connection最大個數 -->
    property name="maxConnectionsPerPartition" value="20" />
    !-- 設置每個分區含有connection最小個數 -->
    property name="minConnectionsPerPartition" value="10" />
    !-- 設置每個分區數 -->
    property name="partitionCount" value="3" />
    !-- 設置分區中的connection增長數量 -->
    property name="acquireIncrement" value="5" />
    property name="statementsCacheSize" value="50"/>
     property name="releaseHelperThreads" value="3"/>
  /bean>

  bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
    property name="dataSource">
      ref bean="dataSource" />
    /property>
  /bean>
  bean id="namedParameterJdbcTemplate" class="org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate">
    constructor-arg index="0" ref="dataSource"/> 
  /bean>

  bean id="txManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
     property name="dataSource" ref="dataSource"/>
  /bean>
  
  
  tx:advice id="txAdvice" transaction-manager="txManager">
    tx:attributes>
      tx:method name="add*" propagation="REQUIRED" />
      tx:method name="delete*" propagation="REQUIRED" />
      tx:method name="update*" propagation="REQUIRED" />
      tx:method name="*" propagation="REQUIRED" />

    /tx:attributes>
  /tx:advice>
  
  aop:config>
    aop:pointcut id="allManagerMethod"
      expression="execution(* com.test.service.*.*(..))" />
    aop:advisor advice-ref="txAdvice" pointcut-ref="allManagerMethod" />
  /aop:config>
/beans>