springboot配置Oracle多数据源,Tip:服务名是斜杠'/'，sid是冒号':'

步骤：

1.在.yml文件中配置数据源连接信息。

spring:
  datasource:
    wms:
      wmsDbUser: test
      wmsDbHost: 127.0.0.1
      dbType: 1
      wmsDbInstance: test
      jdbcUrl: jdbc:oracle:thin:@127.0.0.1:1521:test
    local:
      localDbUser: system
      DbPassword: 123456
      localDbHost: 127.0.0.1
      localDbInstance: orcl
      jdbcUrl: jdbc:oracle:thin:@127.0.0.1:1521/orcl

ps: jdbcUrl最后面是 ‘/’ 还是 ‘:’ ,取决于后面的orcl是服务名，还是sid。

服务名是斜杠，sid是冒号。

2.编写配置类sqlSessionFactory

每一个数据源对应一个配置类。

@Configuration
@MapperScan(basePackages = "com.demo.timetask.wms_p_wmsdb_duanxin_bmsxywebdb.local.mapper", sqlSessionFactoryRef = "localSqlSessionFactory")
public class SqlSessionFactory_Local {

    @Value("${spring.datasource.local.localDbHost}")
    private String ipAddress;
    @Value("${spring.datasource.local.localDbUser}")
    private String dbUser;
    @Value("${spring.datasource.bms.dbType}")
    private String dbType;
    @Value("${spring.datasource.local.localDbInstance}")
    private String dbInstance;
    @Value("${spring.datasource.local.jdbcUrl}")
    private String jdbcUrl;
    @Value("${spring.datasource.local.DbPassword}")
    private String password;

    @Bean(name = "localDataSource")
    public DataSource getDateSourceMed() {
        return DataSourceBuilder.create().password(password).url(jdbcUrl).username(dbUser).driverClassName("oracle.jdbc.driver.OracleDriver").build();
    }

    @Bean(name = "localSqlSessionFactory")
    public SqlSessionFactory medSqlSessionFactory(@Qualifier("localDataSource") DataSource datasource)
            throws Exception {
        SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
        bean.setDataSource(datasource);
        bean.setMapperLocations(
                new PathMatchingResourcePatternResolver().getResources("classpath*:mappers/localMappers/*.xml"));
        return bean.getObject();
    }

    @Bean("localSqlSessionTemplate")
    public SqlSessionTemplate medSqlSessionTemplate(
            @Qualifier("localSqlSessionFactory") SqlSessionFactory sessionFactory) {
        return new SqlSessionTemplate(sessionFactory);
    }

}

ps:属性注入可以有多种注入方式。如下：

    @Bean(name = "localDataSource")
    // 表示这个数据源是默认数据源
    @Primary
    // 读取application.properties中的配置参数映射成为一个对象
    // prefix表示参数的前缀
    @ConfigurationProperties(prefix = "spring.datasource.local")
    public DataSource getDateSourceMed() {
        return DataSourceBuilder.create().build();
    }

3.编写mapper文件和mapper.xml文件即可。