JdbcTemplate 手动开启/提交/回滚事务

源码地址：https://github.com/dongguabai/thinkingTest/tree/master/jdbcTemplateDemo

配置类：

package demo.dongguabai.tx.dongguabaidtx.config;

import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;
import org.springframework.jdbc.datasource.DriverManagerDataSource;

import javax.sql.DataSource;

/**
 * @author dongguabai
 * @date 2019-03-09 01:40
 */
@Configuration
public class JdbcConfig {

    /**
     * 配置 DataSource
     * @return
     */
    @Bean
    public DataSource dataSource1(){
        // JDBC模板依赖于连接池来获得数据的连接，所以必须先要构造数据源
        DriverManagerDataSource dataSource = new DriverManagerDataSource();
        dataSource.setDriverClassName("com.mysql.jdbc.Driver");
        dataSource.setUrl("jdbc:mysql://172.16.140.135:3306/Demo1");
        dataSource.setUsername("root");
        dataSource.setPassword("root");
        return dataSource;
    }

    /**
     * 配置DataSource
     * @return
     */
    @Bean
    public DataSource dataSource2(){
        // JDBC模板依赖于连接池来获得数据的连接，所以必须先要构造数据源
        DriverManagerDataSource dataSource = new DriverManagerDataSource();
        dataSource.setDriverClassName("com.mysql.jdbc.Driver");
        dataSource.setUrl("jdbc:mysql://172.16.140.135:3306/Demo2");
        dataSource.setUsername("root");
        dataSource.setPassword("root");
        return dataSource;
    }

    /**
     * 配置 JdbcTemplate
     * @return
     */
    @Bean
    public JdbcTemplate jdbcTemplate1(DataSource dataSource1) {
        return new JdbcTemplate(dataSource1);
    }

    /**
     * 配置 JdbcTemplate
     * @return
     */
    @Bean
    public JdbcTemplate jdbcTemplate2(DataSource dataSource2) {
        return new JdbcTemplate(dataSource2);
    }

    /**
     * 装配事务管理器
     * @return
     */
    @Bean
    public DataSourceTransactionManager transactionManager1(DataSource dataSource1) {
        return new DataSourceTransactionManager(dataSource1);
    }

    /**
     * 装配事务管理器
     * @return
     */
    @Bean
    public DataSourceTransactionManager transactionManager2(DataSource dataSource2) {
        return new DataSourceTransactionManager(dataSource2);
    }

}

事务操作：

package demo.dongguabai.tx.dongguabaidtx.controller;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;
import org.springframework.transaction.TransactionDefinition;
import org.springframework.transaction.TransactionStatus;
import org.springframework.transaction.support.DefaultTransactionDefinition;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import java.sql.SQLException;

/**
 * @author dongguabai
 * @date 2019-03-09 00:25
 */
@RestController
public class BusinessController {

    @Autowired
    private JdbcTemplate jdbcTemplate1;
    @Autowired
    private DataSourceTransactionManager transactionManager1;

    @Autowired
    private JdbcTemplate jdbcTemplate2;
    @Autowired
    private DataSourceTransactionManager transactionManager2;

    @RequestMapping("/b1")
    public Integer doBusiness1() throws SQLException {

        TransactionStatus status = null;

        int update;
        try {
            status =  begin1();
            update = jdbcTemplate1.update("UPDATE user_account SET balance = balance -100 WHERE id = 1");
           // int o = 1/0;
            commit1(status);
        } catch (Exception e) {
            update = -100;
            e.printStackTrace();
            rollback1(status);
        }
        return update;
    }


    @RequestMapping("/b2")
    public Integer doBusiness2() {

        int update = jdbcTemplate2.update("UPDATE user_account SET balance = balance -100 WHERE id = 2");
        return update;
    }

    /**
     * 开启事务1
     * @return
     */
    public TransactionStatus begin1(){
        return beginTransaction(transactionManager1);
    }

    /**
     * 提交事务1
     * @param status
     */
    public void commit1(TransactionStatus status){
        commitTransaction(transactionManager1,status);
    }

    /**
     * 回滚事务1
     * @param status
     */
    public void rollback1(TransactionStatus status){
        rollbackTransaction(transactionManager1,status);
    }

    /**
     * 开启事务2
     * @return
     */
    public TransactionStatus begin2(){
        return beginTransaction(transactionManager2);
    }

    /**
     * 提交事务2
     * @param status
     */
    public void commit2(TransactionStatus status){
        commitTransaction(transactionManager2,status);
    }

    /**
     * 回滚事务2
     * @param status
     */
    public void rollback2(TransactionStatus status){
        rollbackTransaction(transactionManager2,status);
    }


    /**
     * 开启事务
     */
    public TransactionStatus beginTransaction(DataSourceTransactionManager transactionManager){
        DefaultTransactionDefinition def = new DefaultTransactionDefinition();//事务定义类
        def.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRED);
        TransactionStatus status = transactionManager.getTransaction(def);// 返回事务对象
        return status;
    }

    /**
     * 提交事务
     * @param transactionManager
     * @param status
     */
    public void commitTransaction(DataSourceTransactionManager transactionManager,TransactionStatus status){
        transactionManager.commit(status);
    }

    /**
     * 事务回滚
     * @param transactionManager
     * @param status
     */
    public void rollbackTransaction(DataSourceTransactionManager transactionManager,TransactionStatus status){
        transactionManager.rollback(status);
    }
}

参考资料：

https://blog.csdn.net/Cheat1173010256/article/details/52464866

https://www.e-learn.cn/index.php/content/qita/804978