[Spring]事务管理--实例1-手动配置

水深无声 2022-05-08 03:16 203阅读 0赞

\[TOC\]

> 注意 MyISAM不支持Spring的事务管理，需要使用InnoDB

1. spring配置文件

<?xml version="1.0" encoding="UTF-8"?>
    <beans xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xmlns="http://www.springframework.org/schema/beans" xmlns:context="http://www.springframework.org/schema/context"
        xmlns:p="http://www.springframework.org/schema/p" xmlns:tx="http://www.springframework.org/schema/tx"
        xmlns:aop="http://www.springframework.org/schema/aop"
        xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
            http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.3.xsd
            http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.3.xsd
            http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.3.xsd">
    
        <context:property-placeholder location="classpath:database.properties" />
        <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
    
            <property name="driverClass" value="${jdbc.driverClass}" />
            <property name="jdbcUrl" value="${jdbc.jdbcUrl}" />
            <property name="user" value="${jdbc.user}" />
            <property name="password" value="${jdbc.password}" />
        </bean>
    
        
        
        <bean name="transactionManager"
            class="org.springframework.jdbc.datasource.DataSourceTransactionManager"
            p:dataSource-ref="dataSource" />
    
        
        <tx:advice id="txAdivce" transaction-manager="transactionManager">
            <tx:attributes>
                
                <tx:method name="" isolation="REPEATABLE_READ" propagation="REQUIRED"
                    read-only="false" />
            </tx:attributes>
        </tx:advice>
        
        <aop:config>
            <aop:pointcut id="aopPointCut"
                expression="execution(* top.belmode.service.*ServiceImpl.*(..))" />
            <aop:advisor advice-ref="txAdivce" pointcut-ref="aopPointCut" />
        </aop:config>
    
        <bean name="moneyDao" class="top.belmode.dao.MoneyDaoImpl"
            p:dataSource-ref="dataSource" />
    
        <bean name="moneyService" class="top.belmode.service.MoneyServiceImpl"
            p:moneyDao-ref="moneyDao" />
    </beans>

2. Service层代码

public class MoneyServiceImpl implements MoneyService {
    
        private MoneyDao moneyDao;
    
        public MoneyDao getMoneyDao() {
            return moneyDao;
        }
    
        public void setMoneyDao(MoneyDao moneyDao) {
            this.moneyDao = moneyDao;
        }
    
        @Override
        public void transfer(Integer from, Integer to, Double money) {
            moneyDao.subMoney(from, money);
            moneyDao.addMoney(to, money);
        }
    
    }

3. Junit测试类

public class SpringTransactionTest {
    
        @SuppressWarnings("resource")
        @Test
        public void fun1() {
            ApplicationContext context = new 
              ClassPathXmlApplicationContext("applicationContext.xml");
    
            MoneyService moneyService = (MoneyService) context.getBean("moneyService");
            moneyService.transfer(2, 1, 1000d);
        }
    }