yml连接sqlserver_spring boot 配置双数据源mysql、sqlServer

最新推荐文章于 2023-08-01 22:45:09 发布

骆驼奇

最新推荐文章于 2023-08-01 22:45:09 发布

阅读量562

点赞数

文章标签： yml连接sqlserver

本文链接：https://blog.csdn.net/weixin_42511217/article/details/112867612

版权

这是一个关于如何在Spring Boot应用中配置双数据源的示例，具体涉及到使用YML文件连接MySQL和SQL Server。通过@Configuration注解的SqlServerDataSourceConfig类，设置数据源、JdbcTemplate、SqlSessionFactory以及TransactionManager。代码展示了如何创建DataSourceBean，以及为SQL Server数据源定义特定的JdbcTemplate和SqlSessionTemplate。

摘要由CSDN通过智能技术生成

1 packagecom.ieou.qmt.common;2

3 importorg.apache.ibatis.session.SqlSessionFactory;4 importorg.mybatis.spring.SqlSessionFactoryBean;5 importorg.springframework.beans.factory.annotation.Qualifier;6 importorg.springframework.boot.context.properties.ConfigurationProperties;7 importorg.springframework.boot.jdbc.DataSourceBuilder;8 importorg.springframework.context.annotation.Bean;9 importorg.springframework.context.annotation.Configuration;10 importorg.springframework.core.io.support.PathMatchingResourcePatternResolver;11 importorg.springframework.core.io.support.ResourcePatternResolver;12 importorg.springframework.jdbc.core.JdbcTemplate;13 importorg.springframework.jdbc.datasource.DataSourceTransactionManager;14 importorg.springframework.transaction.PlatformTransactionManager;15

16 importjavax.sql.DataSource;17

18 @Configuration19 public classSqlServerDataSourceConfig {20

21 private static final String MAPPER_PATH = "classpath:mybatis/mapping/mapper/*.xml";22

23 private static final String ENTITY_PACKAGE = "com.ieou.qmt.mapper";24

25 @Bean(name = "sqlServerDataSource")26 @Qualifier("sqlServerDataSource")27 @ConfigurationProperties(prefix="spring.datasource.second")28 publicDataSource getMyDataSource(){29 returnDataSourceBuilder.create().build();30 }31

32 @Bean(name = "secondaryJdbcTemplate")33 publicJdbcTemplate secondaryJdbcTemplate(34 @Qualifier("sqlServerDataSource") DataSource dataSource) {35 return newJdbcTemplate(dataSource);36 }37

38 @Bean(name = "second.SqlSessionTemplate")39 publicSqlSessionFactory devSqlSessionFactory(40 @Qualifier("sqlServerDataSource") DataSource ddataSource)41 throwsException {42 final SqlSessionFactoryBean sessionFactory = newSqlSessionFactoryBean();43 sessionFactory.setDataSource(ddataSource);44 ResourcePatternResolver resolver = newPathMatchingResourcePatternResolver();45 sessionFactory.setMapperLocations(resolver.getResources(MAPPER_PATH));46 sessionFactory.setTypeAliasesPackage(ENTITY_PACKAGE);47 returnsessionFactory.getObject();48 }49

50 @Bean51 public PlatformTransactionManager sqlServerTransactionManager(@Qualifier("sqlServerDataSource") DataSource sqlServerDataSource)52 {53 return newDataSourceTransactionManager(sqlServerDataSource);54 }55

56 }