springboot配置多数据源

德鲁伊和苞米豆

1、引入依赖

<dependency>
  <groupId>com.alibaba</groupId>
  <artifactId>druid-spring-boot-starter</artifactId>
</dependency>
<dependency>
   <groupId>com.baomidou</groupId>
   <artifactId>dynamic-datasource-spring-boot-starter</artifactId>
   <version>3.2.1</version>
</dependency>

2、增加配置

spring:
  autoconfigure:
    # 可能和版本有关系，加到启动类上不起作用
    exclude: com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure
  datasource:
    type: com.alibaba.druid.pool.DruidDataSource
    dynamic:
      primary: myPrimary
      datasource:
        #第一个数据源
        myPrimary: 
          # type: com.alibaba.druid.pool.DruidDataSource
          driver-class-name: com.mysql.jdbc.Driver
          url: jdbc:mysql://${mysql.host}:${mysql.port}/test1?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull&useSSL=false
          username: ${mysql.username}
          password: ${mysql.password}
          druid:
            max-active: 100
            initial-size: 1
            max-wait: 60000
            min-idle: 1
        #第二个数据源
        ds2:
          # type: com.mysql.cj.jdbc.Driver
          # type: com.alibaba.druid.pool.DruidDataSource
          driver-class-name: com.mysql.jdbc.Driver
          url: jdbc:mysql://${mysql.host}:${mysql.port}/test2?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull&useSSL=false
          username: ${mysql.username}
          password: ${mysql.password}

3、service实现类上加@DS注解