mybatis探险之声明式事务管理

浅浅的花香味﹌ 2022-06-17 07:37 139阅读 0赞

mybatis的声明式事务管理主要是由spring的org.springframework.jdbc.datasource.DataSourceTransactionManager来完成的。

<?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:p="http://www.springframework.org/schema/p" xmlns:context="http://www.springframework.org/schema/context" xmlns:tx="http://www.springframework.org/schema/tx" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:mvc="http://www.springframework.org/schema/mvc" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.1.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.1.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.0.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd">
             
             <context:component-scan base-package="com.cn.winter"/>
             
             <bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
                <property name="location" value="classpath:jdbc.properties"/>
             </bean>            
    
             <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
                <property name="driverClassName" value="${jdbc.driver}"/>
                <property name="url" value="${jdbc.url}"/>
                <property name="username" value="${jdbc.username}"/>
                <property name="password" value="${jdbc.password}"/>
                <property name="initialSize" value="${initialSize}"/>
                <property name="maxActive" value="${maxActive}"/>
                <property name="maxIdle" value="${maxIdle}"/>
                <property name="minIdle" value="${maxIdle}"/>
                <property name="maxWait" value="${maxWait}"/>
             </bean>
    
             
             <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
                <property name="dataSource" ref="dataSource"/>
                
                <property name="mapperLocations" value="classpath:com/cn/winter/mapping/*.xml"/>
             </bean>   
    
             
             <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
                <property name="basePackage" value="com.cn.winter.dao"/>
                <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
             </bean>
    
             
             <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
                <property name="dataSource" ref="dataSource"></property>
             </bean>
    
             <tx:advice id="userTxAdvice" transaction-manager="transactionManager">
                <tx:attributes>
                    <tx:method name="delete*" propagation="REQUIRED" read-only="false" rollback-for="java.lang.Exception" no-rollback-for="java.lang.RuntimeException"/>
                    <tx:method name="batchDelete*" propagation="REQUIRED" read-only="false" rollback-for="java.lang.Exception" no-rollback-for="java.lang.RumtimeException"/>
                    <tx:method name="save*" propagation="REQUIRED" read-only="false" rollback-for="java.lang.RuntimeException"/>
                    <tx:method name="add*" propagation="REQUIRED" read-only="false" rollback-for="java.lang.RuntimeException"/>
                    <tx:method name="batchSave*" propagation="REQUIRED" read-only="false" rollback-for="java.lang.RuntimeException"/>
                    <tx:method name="update*" propagation="REQUIRED" read-only="false" rollback-for="java.lang.Exception"/>
                    <tx:method name="batchAdd*" propagation="REQUIRED" read-only="false" rollback-for="java.lang.RuntimeException"/>
                    <tx:method name="get*" propagation="SUPPORTS"/>
                    <tx:method name="find*" propagation="SUPPORTS"/>
                </tx:attributes>
             </tx:advice>
    
             <aop:config>
                <aop:pointcut expression="execution(public * com.cn.winter.service.*.*(..))" id="pc"/>
                <aop:advisor advice-ref="userTxAdvice" pointcut-ref="pc"/>
             </aop:config>
    </beans>