Spring事务管理（基于xml实现）

红太狼 2022-05-21 06:35 195阅读 0赞

##### 【例】模拟银行转账 #####

数据表结构

accountNo:表示账号

balance:表示余额

初始余额都为1000

![70][]

![70 1][]

##### 一、创建相关类 #####

AccountBiz类

package com.tx;
    public class AccountBiz {
    	private AccountDao accountDao;
    	public void setAccountDao(AccountDao accountDao) {
    		this.accountDao = accountDao;
    	}
    	//银行转账
    	public void transfer(){
    		accountDao.transfer();
    	}
    }

AccountDao类

package com.tx;
    import org.springframework.jdbc.core.JdbcTemplate;
    public class AccountDao {
    	private JdbcTemplate jdbcTemplate;
    	public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
    		this.jdbcTemplate = jdbcTemplate;
    	}
    	//银行转账
    	public void transfer(){
    		add();
    		reduce();		
    	}
    	//增加余额
    	public void add(){
    		String sql="update account set balance=balance+? where accountNo=?";
    		jdbcTemplate.update(sql, 500,655925);
    	}
    	//减少余额
    	public void reduce(){
    		String sql="update account set balance=balance-? where accountNo=?";
    		jdbcTemplate.update(sql, 500,358788);
    	}
    }

Test类

package com.tx;
    import java.util.List;
    import java.util.Map;
    import org.springframework.context.ApplicationContext;
    import org.springframework.context.support.ClassPathXmlApplicationContext;
    import org.springframework.jdbc.core.JdbcTemplate;
    public class Test {
    	public static void main(String[] args) {
    		//加载配置spring-jdbcTemplate.xml
    		ApplicationContext context=new ClassPathXmlApplicationContext("Spring-tx.xml");
    		//获取jdbcTemplate实例
    		JdbcTemplate jdbcTemplate=context.getBean(JdbcTemplate.class);
    		//获取accountBiz实例
    		AccountBiz accountBiz=(AccountBiz) context.getBean("accountBiz");
    		//银行转账
    		accountBiz.transfer();
    	}
    }

##### 二、配置Spring-tx.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:aop="http://www.springframework.org/schema/aop"
            xmlns:tx="http://www.springframework.org/schema/tx" xsi:schemaLocation="
            http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.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.xsd"> 
    
    <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
      <property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
      <property name="url" value="jdbc:mysql:///spring_demo"/>
      <property name="username" value="root"/>
      <property name="password" value="root"/>  
    </bean>  
    
    <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
    		<property name="dataSource" ref="dataSource" />
    </bean>
    
    <bean id="accountBiz" class="com.tx.AccountBiz">
    	<property name="accountDao" ref="accountDao"></property>
    </bean>
    <bean id="accountDao" class="com.tx.AccountDao">
    	<property name="jdbcTemplate" ref="jdbcTemplate"></property>
    </bean>
    
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    	<property name="dataSource" ref="dataSource"></property>
    </bean>
    <tx:advice id="advice" transaction-manager="transactionManager">
    	<tx:attributes>
    		<tx:method name="*" propagation="REQUIRED"/>
    	</tx:attributes>
    </tx:advice>
    
    <aop:config>
    	<aop:pointcut expression="execution(* com.tx.AccountBiz.transfer(..))" id="pointcut"/>
    	<aop:advisor advice-ref="advice" pointcut-ref="pointcut"/>
    </aop:config>
    </beans>

测试正常转账

![70 2][]

测试转账失败

注意：在AccountDao类的transfer方法抛出异常

//银行转账
    	public void transfer(){
    		add();
    		int i=10/0;
    		reduce();		
    	}

运行结果：

![70 3][]

![70 4][]

[70]: /images/20220521/e5cdb8c3e4744c398f4d00f245d20ae5.png
[70 1]: /images/20220521/7111c1bbde844cf9b0c1bb3aed6220f0.png
[70 2]: /images/20220521/80548ee7271c412a873040365c4d0d3d.png
[70 3]: /images/20220521/1bd031d31fff4e1a8bd366f91d736dbc.png
[70 4]: /images/20220521/ea241e14ecc3413aa7aaba3358253524.png