多数据源配置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