SpringBoot整合Dynamic DataSource案例。

提示：文章写完后，目录可以自动生成，如何生成可参考右边的帮助文档

---

前言

---

一、Dynamic DataSource是什么？

多数据源配置

二、使用步骤

1.引入库

代码如下（示例）：

<dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <!-- https://mvnrepository.com/artifact/com.baomidou/dynamic-datasource-spring-boot-starter -->
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>dynamic-datasource-spring-boot-starter</artifactId>
            <version>2.5.6</version>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>fastjson</artifactId>
            <version>1.2.54</version>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.3.2</version>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
            <version>1.1.20</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.16</version>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
    </dependencies>

2.引入相关配置，切记配置需要如下配置才可，否在会出现一些列意想不到的问题。

代码如下（示例）：

server:
  port: 3333

spring:
  datasource:
    dynamic:
      primary: db2
      datasource:
        db1:
          driver-class-name: com.mysql.cj.jdbc.Driver
          username: **
          password: ***
          url: jdbc:mysql://******:3306/user?useUnicode=true&characterEncoding=UTF8&useSSL=false
        db2:
          driver-class-name: com.mysql.cj.jdbc.Driver
          username: **
          password: ***
          url: jdbc:mysql://******:3306/user?useUnicode=true&characterEncoding=UTF8&useSSL=false
      durid:
        test-on-borrow: true
        test-while-idle: true
        initial-size: 1
        max-active: 20
        min-idle: 1
        max-wait: 60000
  autoconfigure:
    exclude:  com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure # 去除druid配置

mybatis:
  mapper-locations: classpath:mapper/*.xml
  type-aliases-package: com.hh.userservicedynamicdatasource.pojo
  configuration:
    map-underscore-to-camel-case: true

3.自己整合mybatis框架，写个demo看一下是否成功了。

---

总结

人生物语：善于领悟人生的人，懂得如何思考和行动，能够从碎屑的事物中发现闪光的契机。