Spring基于 XML 的声明式事务控制（配置方式）

àì夳堔傛蜴生んèń 2022-01-26 10:47 361阅读 0赞

# 一、引入依赖 #

<?xml version="1.0" encoding="UTF-8"?>
    <project xmlns="http://maven.apache.org/POM/4.0.0"
             xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
             xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
        <modelVersion>4.0.0</modelVersion>
    
        <groupId>com.william</groupId>
        <artifactId>spring_day04_05_tx_aop_xml</artifactId>
        <version>1.0-SNAPSHOT</version>
    
        <properties>
            <maven.compiler.source>1.8</maven.compiler.source>
            <maven.compiler.target>1.8</maven.compiler.target>
        </properties>
        <dependencies>
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>5.1.47</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-context-support</artifactId>
                <version>5.0.2.RELEASE</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-test</artifactId>
                <version>5.0.2.RELEASE</version>
            </dependency>
            <dependency>
                <groupId>com.mchange</groupId>
                <artifactId>c3p0</artifactId>
                <version>0.9.5.2</version>
            </dependency>
            <dependency>
                <groupId>junit</groupId>
                <artifactId>junit</artifactId>
                <version>4.12</version>
            </dependency>
            <dependency>
                <groupId>commons-dbutils</groupId>
                <artifactId>commons-dbutils</artifactId>
                <version>1.4</version>
            </dependency>
            <dependency>
                <groupId>cglib</groupId>
                <artifactId>cglib</artifactId>
                <version>2.2.2</version>
            </dependency>
            <dependency>
                <groupId>org.aspectj</groupId>
                <artifactId>aspectjweaver</artifactId>
                <version>1.8.9</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-jdbc</artifactId>
                <version>5.0.2.RELEASE</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-tx</artifactId>
                <version>5.0.2.RELEASE</version>
            </dependency>
        </dependencies>
    </project>

# 二、配置xml文件 #

### 1.开启注解扫描 ###

![开启注解扫描][20190528202744699.png]

### 2 创建数据源SpringdataSource ###

![创建SpringdataSource][SpringdataSource]

### 3 引入属性文件 ###

![引入属性文件db.properties][db.properties]  
![db.properties][db.properties 1]

### 4、 创建JdbcTemplate对象 ###

![创建JdbcTemplate对象][JdbcTemplate]

### 5、创建事务管理器对象： 增强（通知） ###

![创建事务管理器对象： 增强（通知）][20190528204029773.png]

### 6 事务增强：对方法的过滤 ###

![事务增强：对方法的过滤][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM5MTc5OTkz_size_16_color_FFFFFF_t_70]  
name: 方法名，可以使用通配符的方式配置  
propagation： 传播的行为，查询方法SUPPORTS， 增删改方法：REQUIRED  
（REQUIRED:如果当前没有事务，就新建一个事务，如果已经存在一个事务中，加入到这个事务中。一般的选 择（默认值）  
SUPPORTS:支持当前事务，如果当前没有事务，就以非事务方式执行（没有事务） ）  
isolation： 隔离级别：一般选择数据库默认的隔离级别（一般不用配置）  
read-only： 只读，查询使用只读操作，增删改使用非只读操作  
time-out: 超时的时间定义，默认-1 ，永不超时（一般不用配置）

### 7配置aop ###

![配置aop][aop]

<?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:context="http://www.springframework.org/schema/context"
           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/context http://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd">
        
        <context:component-scan base-package="com.william"></context:component-scan>
        
        <bean id="SpringdataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
            <property name="driverClassName" value="${jdbc.driverClass}"></property>
            <property name="url" value="${jdbc.jdbcUrl}"></property>
            <property name="username" value="${jdbc.user}"></property>
            <property name="password" value="${jdbc.password}"></property>
        </bean>
        
      <context:property-placeholder location="classpath:db.properties"></context:property-placeholder>
        
       <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
           <constructor-arg name="dataSource" ref="SpringdataSource"></constructor-arg>
       </bean>
        
        <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
            
           <property name="dataSource" ref="SpringdataSource"></property>
        </bean>
    
        
        <tx:advice id="txAdvice"  transaction-manager="transactionManager">
            <tx:attributes>
                <tx:method name="*"/>
            </tx:attributes>
            
            
            
            
            
            
            
            
            
        </tx:advice>
        
        <aop:config>
            
            <aop:pointcut id="pc" expression="execution(* com.itheima.service.impl.*.*(..))"></aop:pointcut>
            
            <aop:advisor advice-ref="txAdvice" pointcut-ref="pc" ></aop:advisor>
        </aop:config>
    
        
    
        
    </beans>

# 二、Class文件 #

### 1.目录结构 ###

![目录结构][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM5MTc5OTkz_size_16_color_FFFFFF_t_70 1]

### 2.AccountDaoImpl 代码 ###

![AccountDaoImpl][]

package com.william.Dao.Impl;
    
    import com.william.Dao.AccountDao;
    import com.william.domain.Account;
    
    import org.apache.commons.dbutils.QueryRunner;
    import org.apache.commons.dbutils.handlers.BeanHandler;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.jdbc.core.BeanPropertyRowMapper;
    import org.springframework.jdbc.core.JdbcTemplate;
    import org.springframework.stereotype.Repository;
    
    import java.sql.SQLException;
    import java.util.List;
    
    /**
     * @author ：lijunxuan
     * @date ：Created in 2019/5/27  16:00
     * @description ：
     * @version: 1.0
     */
    @Repository
    public class AccountDaoImpl implements AccountDao {
        @Autowired
        JdbcTemplate jdbcTemplate;
        @Override
        public Account findByUserName(String username ) {
            String sql="select * from account where name = ?";
    
            Account account = jdbcTemplate.queryForObject(sql, new BeanPropertyRowMapper<>(Account.class), username);
    
    
            return account;
        }
    
        @Override
        public void Update(Account account) {
         String sql =" update account set money = ? where id =?";
         Object [] params= {account.getMoney(),account.getId()};
    
                jdbcTemplate.update(sql,params);
    
        }
    }

### 3.AccountServiceImpl ###

![AccountServiceImpl][]  
AccountServiceImpl代码：

package com.william.service.Impl;
    
    import com.william.Dao.AccountDao;
    import com.william.domain.Account;
    import com.william.service.AccountService;
    
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    
    /**
     * @author ：lijunxuan
     * @date ：Created in 2019/5/27  16:14
     * @description ：
     * @version: 1.0
     */
    @Service
    public class AccountServiceImpl implements AccountService {
    
        @Autowired
        AccountDao accountDao;
        @Override
        public void transfer(String FromMoney, String ToMoney, Float money) {
                //开启事务：transactionManager
                //查询账户名称 两个账户名称
                Account FromuserName = accountDao.findByUserName(FromMoney);
                Account ToUserName = accountDao.findByUserName(ToMoney);
                //修改金额
                FromuserName.setMoney(FromuserName.getMoney()-money);
                ToUserName.setMoney(ToUserName.getMoney()+money);
                int i=1/0;
                //修改账户表
                accountDao.Update(FromuserName);
                accountDao.Update(ToUserName);
    
        }
    }

### 3.TestTrasfer ###

![TestTrasfer][]  
代码TestTrasfer  
package com.william;

import com.william.service.AccountService;  
import org.junit.Test;  
import org.junit.runner.RunWith;  
import org.springframework.beans.factory.annotation.Autowired;  
import org.springframework.stereotype.Component;  
import org.springframework.stereotype.Repository;  
import org.springframework.test.context.ContextConfiguration;  
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;

/\*\*

*  @author ：lijunxuan
 *  @date ：Created in 2019/5/27 16:22
 *  @description ：
 *  @version: 1.0  
    \*/  
    @Component  
    @RunWith(SpringJUnit4ClassRunner.class)  
    @ContextConfiguration(“classpath:applicationContext.xml”)  
    public class TestTrasfer \{  
    @Autowired  
    AccountService accountService;  
    @Test  
    public void testTrasferMoney()\{  
    accountService.transfer(“william”,“william-Li”,500f);  
    \}  
    \}

[20190528202744699.png]: /images/20220126/398cb30390ca4360b5823e2f5fd030e8.png
[SpringdataSource]: /images/20220126/3f35deb47abb4500819b159be6dfdf67.png
[db.properties]: /images/20220126/15571b832a4e4c1cb44e74aeddd5b01a.png
[db.properties 1]: /images/20220126/21e8187258134cfba52eb2a7c98de7c8.png
[JdbcTemplate]: /images/20220126/7323f3fcde0640a2b22f8190a1d8d3c5.png
[20190528204029773.png]: /images/20220126/bc2facbbdc17414d857613af2c64458b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM5MTc5OTkz_size_16_color_FFFFFF_t_70]: /images/20220126/1e8ad4d23bd146a48c096449a8f12231.png
[aop]: /images/20220126/865845299b314c239a7e5c0e606f766b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM5MTc5OTkz_size_16_color_FFFFFF_t_70 1]: /images/20220126/40695dc4bd1544129a9fdc3eae975348.png
[AccountDaoImpl]: /images/20220126/46354ecdc6c647d5af56c2788790ac73.png
[AccountServiceImpl]: /images/20220126/20af99d1adae42bcb3691d55c3e15199.png
[TestTrasfer]: /images/20220126/29f61746d1f14eaa8cf2be30d524f679.png