springboot多数据源配置

最新推荐文章于 2023-12-03 10:16:58 发布

ZHANGCHENGLONG520

最新推荐文章于 2023-12-03 10:16:58 发布

阅读量243

点赞数

文章标签： spring boot 数据库后端

本文链接：https://blog.csdn.net/weixin_46019392/article/details/126229283

版权

数据源配置

spring:
  http:
    encoding:
      force: true
      charset: utf-8
      enabled: true
  datasource:
    one: #mysql
      jdbc-url: jdbc:mysql://127.0.0.1:3306/hbdx?serverTimezone=GMT%2B8&useUnicode=true&characterEncoding=utf-8&useSSL=false&allowMultiQueries=true
      driver-class-name: com.mysql.cj.jdbc.Driver
      username: root
      password: root

    two: #SQLServer
      jdbc-url: jdbc:sqlserver://127.0.0.1:1433;DatabaseName=hbdx
      driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver
      username: root
      password: root

    three: #Oracle
      jdbc-url: jdbc:oracle:thin:@127.0.0.1:1521/ORCLPDB
      driver-class-name: oracle.jdbc.driver.OracleDriver
      username: IOT_USER
      password: root
      # connect IOT_USER/123456 as sysdba

    four: #dameng
      jdbc-url: jdbc:dm://127.0.0.1:5236/HBDX_ZJK?zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf-8
      driver-class-name: dm.jdbc.driver.DmDriver
      username: HBDX_ZJK
      password: root

多数据源配置

/**
 * @author XXXX
 * @date 2022/08/08 16:11
 * @des 多数据源配置
 */
@Configuration
public class DataSourceConfig {
    @Bean
    @ConfigurationProperties(prefix = "spring.datasource.one")
    DataSource dsOne() {
        return DataSourceBuilder.create().type(HikariDataSource.class).build();
    }

    @Bean
    @ConfigurationProperties(prefix = "spring.datasource.two")
    DataSource dsTwo() {
        return DataSourceBuilder.create().type(HikariDataSource.class).build();
    }

    @Bean
    @ConfigurationProperties(prefix = "spring.datasource.three")
    DataSource dsThree() {
        return DataSourceBuilder.create().type(HikariDataSource.class).build();
    }

    @Bean
    @ConfigurationProperties(prefix = "spring.datasource.four")
    DataSource dsFour() {
        return DataSourceBuilder.create().type(HikariDataSource.class).build();
    }
    
}