spring boot配置多个数据源

快来打我* 2023-06-19 01:59 2阅读 0赞

我们平时肯定有很多需要用到多个数据库的需求（在一个项目里面）  
那么就得配置一下多个数据源，在springboot很是方便，在配置文件里面加配置和创建一个配置信息类就好了  
在application.properties

# test1
    test1.spring.datasource.jdbcUrl=jdbc:mysql://127.0.0.1:3306/test1?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf-8&autoReconnect=true&useSSL=false
    test1.spring.datasource.driverClassName = com.mysql.cj.jdbc.Driver
    test1.spring.datasource.username=test1
    test1.spring.datasource.password=test1
    
    # test2
    test2.spring.datasource.jdbcUrl=jdbc:mysql://127.0.0.1:3306/test2?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf-8&autoReconnect=true&useSSL=false
    test2.spring.datasource.driverClassName = com.mysql.cj.jdbc.Driver
    test2.spring.datasource.username=test2
    test2.spring.datasource.password=test2

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2NzI1Mjgy_size_16_color_FFFFFF_t_70]  
OrgDataSourceConfig 一个数据源一个config  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2NzI1Mjgy_size_16_color_FFFFFF_t_70 1]

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.boot.context.properties.ConfigurationProperties;
    import org.springframework.boot.jdbc.DataSourceBuilder;
    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 javax.sql.DataSource;
     
    @Configuration
    @MapperScan(basePackages = "com.example.demo1.mapper.test1",sqlSessionFactoryRef = "orgSqlSessionFactory")
    public class OrgDataSourceConfig {
        @Primary
        @Bean(name = "orgDataSource")
        @ConfigurationProperties("test1.spring.datasource")
        public DataSource masterDataSource(){
            return DataSourceBuilder.create().build();
        }
     
        @Bean(name = "orgSqlSessionFactory")
        public SqlSessionFactory sqlSessionFactory(@Qualifier("orgDataSource") DataSource dataSource) throws Exception {
            SqlSessionFactoryBean sessionFactoryBean = new SqlSessionFactoryBean();
            sessionFactoryBean.setDataSource(dataSource);
            sessionFactoryBean.setMapperLocations(new PathMatchingResourcePatternResolver()
                    .getResources("classpath:sqlmapper/test1/*.xml"));
            return sessionFactoryBean.getObject();
        }
    }

启动类加上注解

//EnableAutoConfiguration注解，关闭springBoot关于mybatis的一些自动注入
    @EnableAutoConfiguration(exclude = {DataSourceAutoConfiguration.class,DataSourceTransactionManagerAutoConfiguration.class, MybatisAutoConfiguration.class})
    //加入定时器
    @EnableScheduling
    @SpringBootApplication
    public class DataTransGsiotApplication {
     
        public static void main(String[] args) {
            SpringApplication.run(DataTransGsiotApplication.class, args);
        }
    }

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2NzI1Mjgy_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20191203170955282.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2NzI1Mjgy,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2NzI1Mjgy_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20191203171634354.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM2NzI1Mjgy,size_16,color_FFFFFF,t_70