多数据源配置1

a、        job/pom.xml

b、        /resources/dev/application-dev.yml

c、        /job/config/MybatisPlusConfig.java

d、        /job/config/DataSourceContextHolder.java

e、        /job/config/DynamicDataSource.java

f、         /core/enums/DbSourceEnum.java

g、        /job/controller/HomeController.java

  1. 引包
  2. yml数据源配置spring节点(配置了德国节点及新加坡节点数据源)
<dependency>
    <
groupId>com.baomidou</groupId>
    <
artifactId>mybatis-plus-boot-starter</artifactId>
    <
version>3.4.1</version>
</
dependency>
<
dependency>
    <
groupId>com.baomidou</groupId>
    <
artifactId>dynamic-datasource-spring-boot-starter</artifactId>
    <
version>3.2.0</version>
</
dependency>
datasource:
  dynamic:
    primary: sqlserver-sg #设置默认的数据源或者数据源组,默认值即为master
   
strict: false #设置严格模式,默认false不启动. 启动后在未匹配到指定数据源时候会抛出异常,不启动则使用默
   
datasource:
      sqlserver-sg:
        driverClassName: com.microsoft.sqlserver.jdbc.SQLServerDri
        jdbcUrl: jdbc:sqlserver://10.1.1.146:1443;DatabaseName=DHB
        username: b2b_sa
        password: '******'
        max-active: 100
        initial-size: 1
        max-wait: 60000
        min-idle: 1
        time-between-eviction-runs-millis: 60000
        min-evictable-idle-time-millis: 300000
        validation-query: select 1
        test-while-idle: true
        test-on-borrow: false
        test-on-return: false
        pool-prepared-statements: true
        max-open-prepared-statements: 50
        max-pool-prepared-statement-per-connection-size: 20
      sqlserver-de:
        driverClassName: com.microsoft.sqlserver.jdbc.SQLServerDri
        jdbcUrl: jdbc:sqlserver://10.1.1.146:1443;DatabaseName=DHB
        username: b2b_sa
        password: '******'
        max-active: 100
        initial-size: 1
        max-wait: 60000
        min-idle: 1
        time-between-eviction-runs-millis: 60000
        min-evictable-idle-time-millis: 300000
        validation-query: select 1
        test-while-idle: true
        test-on-borrow: false
        test-on-return: false
        pool-prepared-statements: true
        max-open-prepared-statements: 50
        max-pool-prepared-statement-per-connection-size: 20

 

 

posted @ 2021-11-07 21:09  yydssc  阅读(24)  评论(0)    收藏  举报