SSM 多数据源同一事务控制

最新推荐文章于 2023-03-21 10:44:07 发布

mjf853912229

最新推荐文章于 2023-03-21 10:44:07 发布

阅读量428

点赞数

分类专栏： java 文章标签：多数据源事务

本文链接：https://blog.csdn.net/mjf853912229/article/details/120839754

版权

java 专栏收录该内容

5 篇文章 1 订阅

订阅专栏

整合

springboot基于注解动态配置多数据源以及多数据源的事务统一 - 炫舞风中 - 博客园

Spring多数据源事务管理_bug猫的博客-CSDN博客_spring多数据源事务管理两位博有中出现的不足，进行优化后得出新的总结，废话不多说直接上代码，本人亲测有效

1.application.xml 数据源配置

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
       destroy-method="close">
       <property name="driverClassName" value="com.mysql.jdbc.Driver" />
       <property name="url" value="jdbc:mysql://XXXXX:XXXX/XXXX?characterEncoding=UTF-8&autoReconnect=true&zeroDateTimeBehavior=convertToNull&serverTimezone=UTC" />
<property name="username" value="XXXX" />
<property name="password" value="XXXXX" />

<property name="initialSize" value="5"></property>
       
       <property name="maxActive" value="200"></property>
       
       <property name="maxIdle" value="100"></property>
       
       <property name="minIdle" value="10"></property>
       
       <property name="maxWait" value="10"></property>

<bean id="dataSource_oracle" class="org.apache.commons.dbcp.BasicDataSource"
       destroy-method="close">
       <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver" />
       <property name="url" value="jdbc:oracle:thin:@XXXXXX:1521:orcl" />
       <property name="username" value="XXXXXX"></property>
       <property name="password" value="XXXX"></property>

2.核心java代码

2.1 Pointcuts 切面

import org.apache.commons.lang.ArrayUtils;
import org.aspectj.lang.ProceedingJoinPoint;
import org.aspectj.lang.annotation.Around;
import org.aspectj.lang.annotation.Aspect;
import org.aspectj.lang.annotation.Pointcut;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;
import org.springframework.stereotype.Component;
import org.springframework.transaction.TransactionStatus;
import org.springframework.transaction.support.DefaultTransactionDefinition;

import java.util.Stack;

@Aspect
@Component
public class Pointcuts {

/**
* 多数据源组合事务控制
* */
@Pointcut("@annotation(com.local.datasouse.TransactionalControl)")
public void pointcut() {};

@Around(value = "pointcut()&&@annotation(annotation)")
public Object twiceAsOld(ProceedingJoinPoint point, TransactionalGroup annotation) throws Throwable {
Stack<DataSourceTransactionManager> dataSourceTransactionManagerStack = new Stack<DataSourceTransactionManager>();
Stack<TransactionStatus> transactionStatuStack = new Stack<TransactionStatus>();
try {
if (!openTransaction(dataSourceTransactionManagerStack, transactionStatuStack, annotation)) {
return null;
}
Object ret = point.proceed();
commit(dataSourceTransactionManagerStack, transactionStatuStack);
return ret;
} catch (Throwable e) {
rollback(dataSourceTransactionManagerStack, transactionStatuStack);
throw e;
}
}
/**
* 开启事务处理方法
*
* @param dataSourceTransactionManagerStack
* @param transactionStatuStack
* @param multiTransactional
* @return
*/
private boolean openTransaction(Stack<DataSourceTransactionManager> dataSourceTransactionManagerStack,
Stack<TransactionStatus> transactionStatuStack, TransactionalGroup multiTransactional) {

String[] transactionMangerNames = multiTransactional.name();
if (ArrayUtils.isEmpty(multiTransactional.name())) {
return false;
}

for (String beanName : transactionMangerNames) {
//根据事务名称获取具体的事务
DataSourceTransactionManager dataSourceTransactionManager = (DataSourceTransactionManager) SpringContextUtil
.getBean(beanName);
TransactionStatus transactionStatus = dataSourceTransactionManager
.getTransaction(new DefaultTransactionDefinition());
transactionStatuStack.push(transactionStatus);
dataSourceTransactionManagerStack.push(dataSourceTransactionManager);
}
return true;
}

/**
* 提交处理方法
*
* @param dataSourceTransactionManagerStack
* @param transactionStatuStack
*/
private void commit(Stack<DataSourceTransactionManager> dataSourceTransactionManagerStack,
Stack<TransactionStatus> transactionStatuStack) {
while (!dataSourceTransactionManagerStack.isEmpty()) {
dataSourceTransactionManagerStack.pop().commit(transactionStatuStack.pop());
}
}
/**
* 回滚处理方法
*
* @param dataSourceTransactionManagerStack
* @param transactionStatuStack
*/
private void rollback(Stack<DataSourceTransactionManager> dataSourceTransactionManagerStack,
Stack<TransactionStatus> transactionStatuStack) {
while (!dataSourceTransactionManagerStack.isEmpty()) {
dataSourceTransactionManagerStack.pop().rollback(transactionStatuStack.pop());
}
}
}
2.2 TransactionalControl

import java.lang.annotation.Retention;
import java.lang.annotation.Target;
import java.lang.annotation.RetentionPolicy;
import java.lang.annotation.ElementType;

@Target({ElementType.METHOD,ElementType.PARAMETER})
@Retention(RetentionPolicy.RUNTIME)
public @interface TransactionalControl {
String[] name() default {"basetx"};
}

3.获取spring容器中的bean

import org.springframework.beans.BeansException;
import org.springframework.context.ApplicationContext;
import org.springframework.context.ApplicationContextAware;
import org.springframework.stereotype.Component;

@Component
public class SpringContextUtil implements ApplicationContextAware{
private static ApplicationContext applicationContext;
@Override
public void setApplicationContext(ApplicationContext applicationContext) throws BeansException {
SpringContextUtil.applicationContext = applicationContext;
}

/**
* @Description: 获取spring容器中的bean,通过bean名称获取
* @param beanName bean名称
* @return: Object 返回Object,需要做强制类型转换
*/
public static Object getBean(String beanName){
return applicationContext.getBean(beanName);
}

/**
* @Description: 获取spring容器中的bean, 通过bean类型获取
* @param beanClass bean 类型
* @return: T 返回指定类型的bean实例
*/
public static <T> T getBean(Class<T> beanClass) {
return applicationContext.getBean(beanClass);
}

/**
* @Description: 获取spring容器中的bean, 通过bean名称和bean类型精确获取
* @param beanName bean 名称
* @param beanClass bean 类型
* @return: T 返回指定类型的bean实例
*/
public static <T> T getBean(String beanName, Class<T> beanClass){
return applicationContext.getBean(beanName,beanClass);
}
}

mjf853912229

关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
SSM 多数据源同一事务控制

整合springboot基于注解动态配置多数据源以及多数据源的事务统一 - 炫舞风中 - 博客园Spring多数据源事务管理_bug猫的博客-CSDN博客_spring多数据源事务管理两位博有中出现的不足，进行优化后得出新的总结，废话不多说直接上代码，本人亲测有效1.application.xml 数据源配置 <bean id="dataSource" class="org.apache.commons.dbcp.Basi...
复制链接

扫一扫