springboot 配置多数据源

springboot 配置多数据源

在启动类上加上@SpringBootApplication(exclude=DataSourceAutoConfiguration.class)注解 ，代表项目启动时不加载这个类

application.properties 配置文件 三个数据源

spring.mvc.view.prefix = classpath:/templates/
spring.mvc.view.suffix = .html
datasource.secondary.type: com.alibaba.druid.pool.DruidDataSource
datasource.secondary.driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver
datasource.secondary.url: xxxxxxxxx
datasource.secondary.username: xxx
datasource.secondary.password: xxx
datasource.secondary.initialSize: 5   
datasource.secondary.minIdle: 5      
datasource.secondary.maxActive: 20     
datasource.secondary.maxWait: 60000   
datasource.secondary.timeBetweenEvictionRunsMillis: 60000   
datasource.secondary.minEvictableIdleTimeMillis: 300000     
datasource.secondary.validationQuery: SELECT 1 FROM DUAL
datasource.secondary.testWhileIdle: true
datasource.secondary.testOnBorrow: false
datasource.secondary.testOnReturn: false
datasource.secondary.poolPreparedStatements: true                   
datasource.secondary.maxPoolPreparedStatementPerConnectionSize: 20   
datasource.secondary.filters: stat,wall,log4j                       
datasource.secondary.connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000 


datasource.primary.type: com.alibaba.druid.pool.DruidDataSource
datasource.primary.driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver
datasource.primary.url: jdbc:sqlserver:xxx
datasource.primary.username: xxx
datasource.primary.password: xxx
datasource.primary.initialSize: 5   
datasource.primary.minIdle: 5      
datasource.primary.maxActive: 20     
datasource.primary.maxWait: 60000   
datasource.primary.timeBetweenEvictionRunsMillis: 60000   
datasource.primary.minEvictableIdleTimeMillis: 300000     
datasource.primary.validationQuery: SELECT 1
datasource.primary.testWhileIdle: true
datasource.primary.testOnBorrow: false
datasource.primary.testOnReturn: false
datasource.primary.poolPreparedStatements: true                   
datasource.primary.maxPoolPreparedStatementPerConnectionSize: 20   
datasource.primary.filters: stat,wall,log4j                       
datasource.primary.connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000 



datasource.third.type: com.alibaba.druid.pool.DruidDataSource
datasource.third.driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver
datasource.third.url: jdbc:sqlserver:xxx
datasource.third.username: xxx
datasource.third.password: xxx
datasource.third.initialSize: 5   
datasource.third.minIdle: 5      
datasource.third.maxActive: 20     
datasource.third.maxWait: 60000   
datasource.third.timeBetweenEvictionRunsMillis: 60000   
datasource.third.minEvictableIdleTimeMillis: 300000     
datasource.third.validationQuery: SELECT 1 FROM DUAL
datasource.third.testWhileIdle: true
datasource.third.testOnBorrow: false
datasource.third.testOnReturn: false
datasource.third.poolPreparedStatements: true                   
datasource.third.maxPoolPreparedStatementPerConnectionSize: 20   
datasource.third.filters: stat,wall,log4j                       
datasource.third.connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000 

第一个数据源 中配置了两个数据源，一个mybatis的，一个jdbcTemplate的

@Configuration
@MapperScan(basePackages = "com.deng.dubbo.dao" , sqlSessionFactoryRef = "test1SqlSessionFactory")
public class DataSourceConfig {

    private static final Logger log = LoggerFactory.getLogger(DataSourceConfig.class);


    @Bean(name = "test1DataSource")
    @ConfigurationProperties(prefix = "datasource.primary")
    @Primary
    public DataSource testDataSource() {
        return DataSourceBuilder.create().build();
    }
    @Bean(name = "test1SqlSessionFactory")
    @Primary
    public SqlSessionFactory testSqlSessionFactory(@Qualifier("test1DataSource") DataSource dataSource) throws Exception {
        SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
        bean.setDataSource(dataSource);
        bean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath:/mybatis/*.xml"));
        return bean.getObject();
    }



    @Bean(name = "test1TransactionManager")
    @Primary
    public DataSourceTransactionManager testTransactionManager(@Qualifier("test1DataSource") DataSource dataSource) {
        return new DataSourceTransactionManager(dataSource);
    }

    @Bean(name = "test1SqlSessionTemplate")
    @Primary
    public SqlSessionTemplate testSqlSessionTemplate(@Qualifier("test1SqlSessionFactory") SqlSessionFactory sqlSessionFactory) throws Exception {
        return new SqlSessionTemplate(sqlSessionFactory);
    }




    @Bean(name = "secondaryDataSource")
    @ConfigurationProperties(prefix = "datasource.third")
    public DataSource secondaryDataSource() {
        log.info("-------------------- secondaryDataSource init ---------------------");
        return DataSourceBuilder.create().type(DruidDataSource.class).build();
    }


    @Bean(name = "secondaryJdbcTemplate")
    public JdbcTemplate secondaryJdbcTemplate(@Qualifier("secondaryDataSource") DataSource dataSource) {
        return new JdbcTemplate(dataSource);



    }

}

第二个数据源

@Configuration
@MapperScan(basePackages = "com.deng.pay.dao", sqlSessionFactoryRef = "paySqlSessionFactory")
public class PayDataSourceConfig {

    private static final Logger log = LoggerFactory.getLogger(PayDataSourceConfig.class);

    @Bean(name = "payDataSource")
    @ConfigurationProperties(prefix = "datasource.secondary")
    public DataSource testDataSource() {
        return DataSourceBuilder.create().build();
    }
    @Bean(name = "paySqlSessionFactory")
    public SqlSessionFactory testSqlSessionFactory(@Qualifier("payDataSource") DataSource dataSource) throws Exception {
        SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
        bean.setDataSource(dataSource);
        bean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath:/mybatis2/*.xml"));
        return bean.getObject();
    }

    @Bean(name = "payTransactionManager")
    public DataSourceTransactionManager testTransactionManager(@Qualifier("payDataSource") DataSource dataSource) {
        return new DataSourceTransactionManager(dataSource);
    }

    @Bean(name = "paySqlSessionTemplate")
    public SqlSessionTemplate testSqlSessionTemplate(@Qualifier("paySqlSessionFactory") SqlSessionFactory sqlSessionFactory) throws Exception {
        return new SqlSessionTemplate(sqlSessionFactory);
    }  
}