[JSP] JSP 中spring事务配置详解

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="https://www.springframework.org/schema/beans"
  xmlns:context="https://www.springframework.org/schema/context"
  xmlns:xsi="https://www.w3.org/2001/XMLSchema-instance" xmlns:aop="https://www.springframework.org/schema/aop"
  xmlns:tx="https://www.springframework.org/schema/tx"
  xsi:schemaLocation="
  https://www.springframework.org/schema/beans 
  https://www.springframework.org/schema/beans/spring-beans.xsd
  https://www.springframework.org/schema/tx
  https://www.springframework.org/schema/tx/spring-tx.xsd
  https://www.springframework.org/schema/context
  https://www.springframework.org/schema/context/spring-context.xsd
  https://www.springframework.org/schema/aop
  https://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=true&characterEncoding=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>