Spring 拦截式事务管理

最新推荐文章于 2024-07-18 15:27:29 发布

jxdwuao

最新推荐文章于 2024-07-18 15:27:29 发布

阅读量88

点赞数

分类专栏： Spring 文章标签： Spring Bean AOP JDBC iBATIS

本文链接：https://blog.csdn.net/jxdwuao/article/details/83676743

版权

Spring 专栏收录该内容

13 篇文章 0 订阅

订阅专栏

友系统中的配置：　

<?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:jee="http://www.springframework.org/schema/jee"
 xmlns:tx="http://www.springframework.org/schema/tx"
 xmlns:context="http://www.springframework.org/schema/context"
 xmlns:aop="http://www.springframework.org/schema/aop"
 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/jee
 http://www.springframework.org/schema/jee/spring-jee-2.5.xsd
 http://www.springframework.org/schema/context
 http://www.springframework.org/schema/context/spring-context-2.5.xsd"
 default-lazy-init="false">
    <bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
        <property name="locations">
            <list>
                <value>classpath:conf/db/jdbc.properties</value>
            </list>
        </property>
    </bean>

 <!-- 第一个数据库 -->
    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
  <!-- Connection Info -->
        <property name="driverClassName">
            <value>${jdbc.driverClassName}</value>
        </property>
        <property name="url">
            <value>${jdbc.url}</value>
        </property>
        <property name="username">
            <value>${jdbc.username}</value>
        </property>
        <property name="password">
            <value>${jdbc.password}</value>
        </property>

  <!-- Connection Pooling DBCP -->
  <!-- 初始化时创建的连接数  -->
        <property name="initialSize" value="5" />
  <!-- 最大连接数据库连接数，设置为0时，表示没有限制；  -->
        <property name="maxActive" value="100" />
  <!-- 最大等待连接中的数量，设置为0时，表示没有限制；  -->
        <property name="maxIdle" value="30" />
  <!-- 最大等待秒数，单位为毫秒， 超过时间会报出错误信息； -->
        <property name="maxWait" value="100000" />
  <!-- 是否可用预执行 -->
        <property name="poolPreparedStatements" value="true" />
  <!-- 设置从数据源中返回的连接是否采用自动提交机制，默认值为 true；false支持事务 -->
        <property name="defaultAutoCommit" value="false" />
    </bean>
 <!--根据dataSource和sql-map-config.xml创建一个SqlMapClient-->
    <bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
        <property name="dataSource">
            <ref local="dataSource"/>
        </property>
        <property name="configLocation">
            <value>classpath:/conf/sqlmap/sqlmap-config.xml</value>
        </property>

    </bean>
    <context:annotation-config />
    <context:component-scan base-package="com.woyo.business" />
    <context:component-scan base-package="com.woyo.biz.lab.tools" />
    <tx:annotation-driven transaction-manager="transactionManager" proxy-target-class="false"/>
    <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
        <property name="dataSource" ref="dataSource"/>
    </bean>

    <!-- Transaction manager for a single JDBC DataSource -->
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource"/>
    </bean>

       <bean id="txInterceptor" class="org.springframework.transaction.interceptor.TransactionInterceptor">
        <property name="transactionManager">
            <ref bean="transactionManager"/>
        </property>
        <property name="transactionAttributes">
            <props>
                <prop key="*">PROPAGATION_REQUIRED,-Exception</prop>
            </props>
        </property>
    </bean>

    <bean id="txBeanNameProxyCreator" class="org.springframework.aop.framework.autoproxy.BeanNameAutoProxyCreator">
        <property name="interceptorNames">
            <list>
                <value>txInterceptor</value>
            </list>
        </property>
        <property name="beanNames">
            <value>*Service</value>
        </property>
    </bean>
    </beans>

代码中，需要写：　

@Transactional(rollbackFor=Exception.class)  
public MessItemSaveVO saveMessItem(MessItemSaveVO messItemSaveVO) throws Exception {

旅游系统中的配置：　

	<!-- 事务管理 -->
	<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
	    <property name="dataSource" ref="writeDataSource"/>
    </bean>
    
	<aop:config>
		<aop:pointcut id="servicesPointcut" expression="execution(* com.woyoframework.travel.*.service.impl..*ServiceImpl.*(..))" />
		<aop:advisor advice-ref="txAdvice" pointcut-ref="servicesPointcut" />
	</aop:config>
	
	<tx:advice id="txAdvice" transaction-manager="transactionManager">
		<tx:attributes>
			<tx:method name="add*" propagation="REQUIRED" />
			<tx:method name="save*" propagation="REQUIRED" />
			<tx:method name="update*" propagation="REQUIRED" />
			<tx:method name="delete*" propagation="REQUIRED" />
			<tx:method name="recommend*" propagation="REQUIRED" />
			<tx:method name="cancel*" propagation="REQUIRED" />
			<tx:method name="init*" propagation="REQUIRED" />
			<tx:method name="get*" propagation="REQUIRED" read-only="true" />
			<tx:method name="query*" propagation="REQUIRED" read-only="true" />
		</tx:attributes>
	</tx:advice>