源码地址: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