Springboot多数据源配置

spring：

datasource：

    type: com.alibaba.druid.pool.DruidDataSource

    driver-class-name: oracle.jdbc.OracleDriver

druid:

   hczz:

      url:

      username:

      password:

     initial-size: 5

      max-active: 5

      min-idle: 5

     max-wait: 60000

     pool-prepared-statements: true

     max-pool-prepared-statement-per-connection-size: 20

     validation-query: SELECT 1 FROM DUAL

     test-while-idle: true

      test-on-borrow: false

      time-between-eviction-runs-millis: 300000

      soft-min-evictable-idle-time-millis: 600000

@Configuration

@MapperScan(basePackages = "com.ccf.mapper.hczz",sqlSessionTemplateRef = "hczzSqlSessionTemplate")

public class HczzDataSourceConfig {

@Bean("hczz")

@Primary

@ConfigurationProperties(prefix = "spring.dataSource.druid.hczz")

public DataSource hczzDataSource(){

System.out.println("hczz DataSource");

return DataSourceBuilder.create().build();

}

@Bean("hczzSqlSessionFactory")

@Primary

public SqlSessionFactory sqlSessionFactory(@Qualifier("hczz") DataSource dataSource)throws Exception{

SqlSessionFactoryBean bean = new SqlSessionFactoryBean();

bean.setDataSource(dataSource);

bean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath:mapper/hczz/*.xml"));

bean.setConfigLocation(new ClassPathResource("mybatis-config.xml"));

return bean.getObject();

}

@Bean("hczzTransactionManager")

@Primary

public DataSourceTransactionManager transactionManager(@Qualifier("hczz") DataSource dataSource) throws Exception{

return new DataSourceTransactionManager(dataSource);

}

@Bean("hczzSqlSessionTemplate")

@Primary

public SqlSessionTemplate sqlSessionTemplate(@Qualifier("hczzSqlSessionFactory") SqlSessionFactory sqlSessionFactory)throws Exception{

return new SqlSessionTemplate(sqlSessionFactory);

}

}