From ffb382ba34aca2dce08ab9e4ef09adc946cf23c8 Mon Sep 17 00:00:00 2001 From: ZY <zc857179121@qq.com> Date: 星期日, 27 四月 2025 17:26:31 +0800 Subject: [PATCH] 双数据源 --- src/main/java/com/zy/common/config/ds/PrimaryDataSourceConfig.java | 35 +++++++++++++++++++++++++++++++++++ 1 files changed, 35 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/zy/common/config/ds/PrimaryDataSourceConfig.java b/src/main/java/com/zy/common/config/ds/PrimaryDataSourceConfig.java new file mode 100644 index 0000000..f6f5cb3 --- /dev/null +++ b/src/main/java/com/zy/common/config/ds/PrimaryDataSourceConfig.java @@ -0,0 +1,35 @@ +package com.zy.common.config.ds; + +import org.apache.ibatis.session.SqlSessionFactory; +import org.mybatis.spring.SqlSessionFactoryBean; +import org.mybatis.spring.annotation.MapperScan; +import org.springframework.beans.factory.annotation.Qualifier; +import org.springframework.context.annotation.Bean; +import org.springframework.context.annotation.Configuration; +import org.springframework.context.annotation.Primary; +import org.springframework.core.io.support.PathMatchingResourcePatternResolver; +import org.springframework.jdbc.datasource.DataSourceTransactionManager; + +import javax.sql.DataSource; + +@Configuration +@MapperScan(basePackages = {"com.zy.asrs.*.*", "com.zy.system.*.*"}, sqlSessionFactoryRef = "primarySqlSessionFactory") +public class PrimaryDataSourceConfig { + + @Bean(name = "primarySqlSessionFactory") + @Primary + public SqlSessionFactory primarySqlSessionFactory(@Qualifier("dataSource") DataSource dataSource) throws Exception { + SqlSessionFactoryBean sessionFactory = new SqlSessionFactoryBean(); + sessionFactory.setDataSource(dataSource); + // 璁剧疆MyBatis鐨凪apper XML鏂囦欢璺緞 + sessionFactory.setMapperLocations(new PathMatchingResourcePatternResolver() + .getResources("classpath:mapper/*.xml")); + return sessionFactory.getObject(); + } + + @Bean(name = "transactionManager") + @Primary + public DataSourceTransactionManager primaryTransactionManager(@Qualifier("dataSource") DataSource dataSource) { + return new DataSourceTransactionManager(dataSource); + } +} -- Gitblit v1.9.1