Spring（c）

1.transaction_template

1.1 PlatformTransactionManager

保证使用的是同一个connection → DataSource
平台事务管理器依赖于数据源

DataSourceTransactionManager（mybatis）

1.2 TransactionStatus（记录事务的状态）

1.3 TransactionDefinition

事务的名称、事务的隔离级别、事务的传播行为、事务的只读状态、事务的超时时间

1.4 搭建一个转账业务

spring中基本配置

pom.xml

<?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.cskaoyan</groupId>
    <artifactId>demo1-transaction-template</artifactId>
    <version>1.0-SNAPSHOT</version>
    <build>
        <plugins>
            <plugin>
                <groupId>org.apache.maven.plugins</groupId>
                <artifactId>maven-compiler-plugin</artifactId>
                <configuration>
                    <source>6</source>
                    <target>6</target>
                </configuration>
            </plugin>
        </plugins>
    </build>
    <dependencies>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>5.2.10.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.47</version>
        </dependency>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.6</version>
        </dependency>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis-spring</artifactId>
            <version>2.0.6</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>5.2.10.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-test</artifactId>
            <version>5.2.10.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.2.4</version>
        </dependency>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.13.1</version>
            <scope>test</scope>
        </dependency>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.6</version>
            <scope>compile</scope>
        </dependency>
    </dependencies>


</project>

AccountMapper

public interface AccountMapper {

    Integer selectMoneyById(@Param("id") Integer id);

    int updateMoneyById(@Param("money") Integer money, @Param("id") Integer id);
}

AccountService

public interface AccountService {

    void transfer(Integer fromId, Integer destId, Integer money);
}

AccountServiceImpl

• 哪一部分需要增加事务，哪部分代码就放入到doInTransaction方法中
• doInTransaction方法的返回值 → 给到TransactionTemplate的execute方法

@Service
public class AccountServiceImpl implements AccountService{

    @Autowired
    AccountMapper accountMapper;

    @Autowired
    TransactionTemplate transactionTemplate;

    @Override
    public void transfer(final Integer fromId, final Integer destId, Integer money) {
        final Integer fromMoney = accountMapper.selectMoneyById(fromId) - money;
        final Integer destMoney = accountMapper.selectMoneyById(destId) + money;
        
        transactionTemplate.execute(new TransactionCallbackWithoutResult() {
            @Override
            protected void doInTransactionWithoutResult(TransactionStatus transactionStatus) {
                accountMapper.updateMoneyById(fromMoney, fromId);
               // int i = 1/0;
                accountMapper.updateMoneyById(destMoney, destId);
            }
        });
    }
}

application.xml
事务模板 → 每次都要去调用一个方法
TransactionTemplate需要注册到容器中 → TransactionManager（DataSourceTransactionManager）

下图spring事务通用配置：

<?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"
       xsi:schemaLocation="
        http://www.springframework.org/schema/beans https://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd
        http://www.springframework.org/schema/aop https://www.springframework.org/schema/aop/spring-aop.xsd">

    <!-- bean definitions here -->
    <context:component-scan base-package="com.cskaoyan"/>
    <bean id="datasource" class="com.alibaba.druid.pool.DruidDataSource">
        <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
        <property name="url" value="jdbc:mysql://localhost:3306/testdb4?useUnicode=true&amp;characterEncoding=utf8"/>
        <property name="username" value="root"/>
        <property name="password" value="123456"/>
    </bean>
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="datasource"/>
    </bean>
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="com.cskaoyan.mapper"/>
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
    </bean>

    <!--TransactionManager-->
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="datasource"/>
    </bean>
    <!--TransactionTemplate-->
    <bean class="org.springframework.transaction.support.TransactionTemplate">
        <property name="transactionManager" ref="transactionManager"/>
    </bean>
</beans>

AccountMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
  PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
  "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.cskaoyan.mapper.AccountMapper">

    <select id="selectMoneyById" resultType="integer">
        select money from account where id = #{id}
    </select>

    <update id="updateMoneyById" >
        update account set money = #{money} where id = #{id}
    </update>
</mapper>

数据库：

MyTest测试类：

@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration("classpath:application.xml")
public class MyTest {


    @Autowired
    AccountService accountService;

    @Test
    public void mytest1(){
        accountService.transfer(1,2,1000);
    }
}

2.transaction_proxy（保留转账业务）

SpringAOP类似
通过委托类组件生成一个事务代理组件

pom.xml(与transaction_template中一样)

AccountMapper(与transaction_template中一样)

AccountServiceImpl

@Service
public class AccountServiceImpl implements AccountService{

    @Autowired
    AccountMapper accountMapper;
    
    @Override
    public void transfer(Integer fromId, Integer destId, Integer money) {
        Integer fromMoney = accountMapper.selectMoneyById(fromId) - money;
        Integer destMoney = accountMapper.selectMoneyById(destId) + money;

        //fromMoney -= money;
        //destMoney += money;

        accountMapper.updateMoneyById(fromMoney, fromId);
        //int i = 1/0;
        accountMapper.updateMoneyById(destMoney, destId);

    }
}

application.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:context="http://www.springframework.org/schema/context"
       xmlns:aop="http://www.springframework.org/schema/aop"
       xsi:schemaLocation="
        http://www.springframework.org/schema/beans https://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd
        http://www.springframework.org/schema/aop https://www.springframework.org/schema/aop/spring-aop.xsd">

    <!-- bean definitions here -->
    <context:component-scan base-package="com.cskaoyan"/>
    <bean id="datasource" class="com.alibaba.druid.pool.DruidDataSource">
        <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
        <property name="url" value="jdbc:mysql://localhost:3306/cskaoyan_db?useUnicode=true&amp;characterEncoding=utf8"/>
        <property name="username" value="root"/>
        <property name="password" value="123456"/>
    </bean>
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="datasource"/>
    </bean>
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="com.cskaoyan.mapper"/>
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
    </bean>

    <!--TransactionManager-->
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="datasource"/>
    </bean>
    <!--委托类组件accountServiceImpl-->
    <!--代理组件-->
    <bean id="accountServiceProxy" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">
        <property name="target" ref="accountServiceImpl"/>
        <property name="transactionManager" ref="transactionManager"/>
        <!--TransactionAttributes → TransactionDefinition-->
        <property name="transactionAttributes">
            <!--properties类型：既要表达key，又要表达value-->
            <props>
                <!--
                    key的含义：方法名
                    value的含义：TransactionDefinition
                    PROPAGATION_XXX:传播行为
                    ISOLATION_XXX：隔离级别
                    readOnly:只读
                    timeout_数字：超时时间，单位是秒
                    -Exception：当发生XXX异常的时候回滚
                    +Exception：当发生xxx异常是不回滚
                -->
                <prop key="transfer">PROPAGATION_REQUIRED,ISOLATION_DEFAULT,timeout_5</prop>
            </props>
        </property>
    </bean>

</beans>

AccountMapper.xml(与transaction_template中一样)

MyTest

@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration("classpath:application.xml")
public class MyTest {


    @Autowired
    @Qualifier("accountServiceProxy")
    AccountService accountService;

    @Test
    public void mytest1(){
        accountService.transfer(1,2,1000);
    }
}

报错及解决：
https://blog.youkuaiyun.com/gy99csdn/article/details/114735840

3.transaction_advisor

<aop:advisor advice-ref=“transactionAdvice” pointcut-ref=“txPointcut”/>

以上可批量指定需要增加事务的方法

AccountService（前面一样）
AccountServiceImpl（和transaction_proxy一样）

pom.xml在前面配置的基础上，增加以下配置

  <!--aspectjweaver-->
        <dependency>
            <groupId>org.aspectj</groupId>
            <artifactId>aspectjweaver</artifactId>
            <version>1.9.6</version>
        </dependency>

application.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: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 https://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd
        http://www.springframework.org/schema/tx https://www.springframework.org/schema/tx/spring-tx.xsd
        http://www.springframework.org/schema/aop https://www.springframework.org/schema/aop/spring-aop.xsd">

    <!-- bean definitions here -->
    <context:component-scan base-package="com.cskaoyan"/>
    <bean id="datasource" class="com.alibaba.druid.pool.DruidDataSource">
        <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
        <property name="url" value="jdbc:mysql://localhost:3306/cskaoyan_db?useUnicode=true&amp;characterEncoding=utf8"/>
        <property name="username" value="root"/>
        <property name="password" value="123456"/>
    </bean>
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="datasource"/>
    </bean>
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="com.cskaoyan.mapper"/>
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
    </bean>

    <!--TransactionManager-->
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="datasource"/>
    </bean>


    <aop:config>
        <aop:pointcut id="txPointcut" expression="execution(* com..service..*(..))"/>
        <!--事务通知组件-->
        <aop:advisor advice-ref="transactionAdvice" pointcut-ref="txPointcut"/>
    </aop:config>


    <!--tx:advice-->
    <tx:advice id="transactionAdvice" transaction-manager="transactionManager">
        <!--method definition-->
        <tx:attributes>
            <tx:method name="transfer*" propagation="REQUIRED" isolation="REPEATABLE_READ" read-only="false" timeout="5"/>
        </tx:attributes>
    </tx:advice>


</beans>

AccountMapper.xml和前面一样
Mytest和前面一样

4. transactional（精确到某个方法增加事务,指哪打哪）

声明式事务@Transactional

pom.xml（不变）

AccountMapper（不变）

AccountService

AccountServiceImpl

@Transactional//ElementType.Type意味着当前组件里的全部方法都增加上事务
@Service
public class AccountServiceImpl implements AccountService{

    @Autowired
    AccountMapper accountMapper;

    @Transactional(isolation = Isolation.REPEATABLE_READ,propagation = Propagation.REQUIRED,
            readOnly = true,timeout = 5)//ElementType.Method 当前方法增加上事务
    @Override
    public void transfer(Integer fromId, Integer destId, Integer money) {
        Integer fromMoney = accountMapper.selectMoneyById(fromId) - money;
        Integer destMoney = accountMapper.selectMoneyById(destId) + money;

        //fromMoney -= money;
        //destMoney += money;

        accountMapper.updateMoneyById(fromMoney, fromId);
        int i = 1/0;
        accountMapper.updateMoneyById(destMoney, destId);

    }
}

application.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: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 https://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd
        http://www.springframework.org/schema/tx https://www.springframework.org/schema/tx/spring-tx.xsd
        http://www.springframework.org/schema/aop https://www.springframework.org/schema/aop/spring-aop.xsd">

    <!-- bean definitions here -->
    <context:component-scan base-package="com.cskaoyan"/>
    <bean id="datasource" class="com.alibaba.druid.pool.DruidDataSource">
        <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
        <property name="url" value="jdbc:mysql://localhost:3306/cskaoyan_db?useUnicode=true&amp;characterEncoding=utf8"/>
        <property name="username" value="root"/>
        <property name="password" value="123456"/>
    </bean>
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="datasource"/>
    </bean>
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="com.cskaoyan.mapper"/>
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
    </bean>

    <!--TransactionManager-->
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="datasource"/>
    </bean>
    <tx:annotation-driven transaction-manager="transactionManager"/>

</beans>

AccountMapper.xml（不变）

Mytest（不变）

5. transactional_javaconfig（可以消灭application配置文件）

pom.xml（和前面一样）

ApplicationConfig（全新增加）
@Configuration：把一个类标记为配置类，把配置也作为容器中的组件（可以使用注入功能的注解）
@ComponentScan：扫描包

@Bean：对应的是方法，将该方法的返回值注册为容器中的组件
返回值：对应bean标签中的class属性值或其接口 👉 组件的类或接口
方法体：按照se的代码风格去写即可
组件id：可以使用@Bean的value属性指定;默认组件id为方法名

可以通过形参按照类型从容器中取出组件
如果容器中该类型组件不止一个，需要使用@Qualifier指定组件id

@EnableTransactionManagement

@EnableAspectjAutoproxy

@Configuration
@ComponentScan("com.cskaoyan")
@EnableTransactionManagement
@EnableAspectJAutoProxy //aop:aspectj-autoproxy
public class ApplicationConfig {

    @Autowired
    AccountService accountService;

    /**
     * 返回值：对应bean标签中的class属性值或其接口 👉 组件的类或接口
     * 方法体：按照se的代码风格去写即可
     * 组件id：可以使用@Bean的value属性指定;默认组件id为方法名
     */
    //@Bean("datasource") //组件id为datasource
    @Bean                 //组件id为dataSource
    public DruidDataSource dataSource(){
        DruidDataSource druidDataSource = new DruidDataSource();
        druidDataSource.setDriverClassName("com.mysql.jdbc.Driver");
        druidDataSource.setUrl("jdbc:mysql://localhost:3306/cskaoyan_db");
        druidDataSource.setUsername("root");
        druidDataSource.setPassword("123456");
        return druidDataSource;
    }
    @Bean                 //组件id为dataSource2
    public DruidDataSource dataSource2(){
        DruidDataSource druidDataSource = new DruidDataSource();
        druidDataSource.setDriverClassName("com.mysql.jdbc.Driver");
        druidDataSource.setUrl("jdbc:mysql://localhost:3306/shenguancheng_db");
        druidDataSource.setUsername("root");
        druidDataSource.setPassword("123456");
        return druidDataSource;
    }
    //public DataSource

    /**
     * 可以通过形参按照类型从容器中取出组件
     *     如果容器中该类型组件不止一个，需要使用@Qualifier指定组件id
     */
    @Bean
    public SqlSessionFactoryBean sqlSessionFactory(@Qualifier("dataSource") DataSource dataSource){
        SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();
        sqlSessionFactoryBean.setDataSource(dataSource);
        return sqlSessionFactoryBean;
    }

    @Bean
    public MapperScannerConfigurer mapperScannerConfigurer(){
        MapperScannerConfigurer mapperScannerConfigurer = new MapperScannerConfigurer();
        mapperScannerConfigurer.setBasePackage("com.cskaoyan.mapper");
        mapperScannerConfigurer.setSqlSessionFactoryBeanName("sqlSessionFactory");
        return mapperScannerConfigurer;
    }
    @Bean
    public DataSourceTransactionManager dataSourceTransactionManager(@Qualifier("dataSource") DataSource dataSource){
        DataSourceTransactionManager dataSourceTransactionManager = new DataSourceTransactionManager();
        dataSourceTransactionManager.setDataSource(dataSource);
        return dataSourceTransactionManager;
    }
}

AccountMapper（不变）

AccountService（不变）

AccountServiceImpl（不变）

AccountMapper.xml（不变）

Mytest
在单元测试中使用配置类

@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(classes = ApplicationConfig.class)
public class MyTest {

    @Autowired
    AccountService accountService;

    @Test
    public void mytest1(){
        accountService.transfer(1,2,1000);
    }
}