spring 事务管理

1.导入相应的jar包

2. 编写配置文件：jdbc.properties

driverClass=com.mysql.jdbc.Driver
jdbcUrl=jdbc:mysql://localhost:3306/test
user=root
password=123456

3.编写业务类接口：AccountService  

public interface AccountService {
    public void transfer(String out,String in,Double money);
}

4.编写实现类：AccountServiceImpl

public class AccountServiceImpl implements AccountService{
    
    public AccountDao accountDao;
    
    public void setAccountDao(AccountDao accountDao) {
        this.accountDao = accountDao;
    }

    @Override
    public void transfer(String out, String in, Double money) {
        accountDao.outMoney(out, money);
        int i = 10/0;
        accountDao.inMoney(in, money);
    }
}

5.编写dao层接口：AccountDao

public interface AccountDao {
    public void outMoney(String out,Double money);
    public void inMoney(String in,Double money);
}

6.编写dao层实现类：AccountDaoImpl

public class AccountDaoImpl implements AccountDao{
    private JdbcTemplate jdbcTemplate;
    
    public void setDataSource(DataSource dataSource) {
        this.jdbcTemplate = new JdbcTemplate(dataSource);
    }

    @Override
    public void outMoney(String out, Double money) {
        String sql = "update db01 set money = money - ? where name=?";
        jdbcTemplate.update(sql, money,out);
    }

    @Override
    public void inMoney(String in, Double money) {
        String sql = "update db01 set money = money + ? where name=?";
        jdbcTemplate.update(sql, money,in);
    }

}

7.配置spring配置文件：bean.xml

<?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:aop="http://www.springframework.org/schema/aop"
    xmlns:tx="http://www.springframework.org/schema/tx"
    xmlns:context="http://www.springframework.org/schema/context"
    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.xsd
        http://www.springframework.org/schema/aop
        http://www.springframework.org/schema/aop/spring-aop-4.3.xsd">
        
         <!-- 引入外部属性文件 -->
        <context:property-placeholder location="classpath:jdbc.properties"/>
    
        <!-- 配置c3p0连接池 -->
        <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
            <property name="driverClass" value="${driverClass}"/>
            <property name="jdbcUrl" value="${jdbcUrl}"/>
            <property name="user" value="${user}"/>
            <property name="password" value="${password}"/>
        </bean>
        
        <!-- 配置DAO层,注入连接池就可以得到jdbc模板-->
        <bean id="accountDao" class="com.xuzhiwen.service.AccountDaoImpl">
            <property name="dataSource" ref="dataSource"/>
        </bean>
        
        <!-- 配置业务层 -->
        <bean id="accountService" class="com.xuzhiwen.service.AccountServiceImpl">
            <property name="accountDao" ref="accountDao"/>
        </bean>
        
        
        <!-- 配置SpringJdbc的事务管理器 -->
            <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource"/>
        </bean>
        
        <!-- 配置事务的增强 -->
            <tx:advice id="txAdvice" transaction-manager="transactionManager">
        <tx:attributes>
            <tx:method name="transfer" propagation="REQUIRED"/>
        </tx:attributes>
        </tx:advice>
        
        <!-- 配置切面 -->
        <aop:config>
        <!-- 配置切点 -->
        <aop:pointcut expression="execution(* com.xuzhiwen.service.AccountServiceImpl.*(..))" id="pointcut1"/>
        <!-- 配置切面 -->
        <aop:advisor advice-ref="txAdvice" pointcut-ref="pointcut1"/>
        </aop:config>
        
</beans>

8.建库建表：

 9.编写测试类：Test

public class Test {

    @org.junit.Test
    public void test() {
        ApplicationContext app = new ClassPathXmlApplicationContext("bean.xml");
        AccountService test = (AccountService) app.getBean("accountService");
        test.transfer("xuzhiwen", "weibin", 200d);
    }
}

10.运行结果为：

要么都成功，要么都失败！