文章目錄

• • • • • 一、mybatisplus3.x
        • • 1. 依賴
          • 2. 啟動(dòng)類添加注解
          • 3. 添加多數(shù)據(jù)源注解
          • 4. yml
          • 5. 測試類
          • 6. 源碼地址

為了適配新的需求，需要同時(shí)支持mysql和oracle數(shù)據(jù)庫操作多數(shù)據(jù)源，因此項(xiàng)目中集成dynamic-datasource-spring-boot-starter,支持很多場景。
例如：在不配置注解@DS("oracle")的場景，默認(rèn)加載master主數(shù)據(jù)源，如果配置了@DS("oracle")則會(huì)加載配置的數(shù)據(jù)源。

一、mybatisplus3.x

1. 依賴

<!--整合Knife4j--><dependency><groupId>com.github.xiaoymin</groupId><artifactId>knife4j-spring-boot-starter</artifactId><version>2.0.4</version></dependency><!--mybatis-plus--><dependency><groupId>com.baomidou</groupId><artifactId>mybatis-plus-boot-starter</artifactId><version>3.3.0</version></dependency><!--多數(shù)據(jù)源 以下版本任選其一--><dependency><groupId>com.baomidou</groupId><artifactId>dynamic-datasource-spring-boot-starter</artifactId><version>3.2.0</version></dependency><!--oracle 數(shù)據(jù)庫驅(qū)動(dòng)--><dependency><groupId>com.oracle</groupId><artifactId>ojdbc6</artifactId><version>11.2.0.3</version></dependency><!--druid 監(jiān)控--><dependency><groupId>com.alibaba</groupId><artifactId>druid-spring-boot-starter</artifactId><version>1.1.13</version></dependency><!--mysql 數(shù)據(jù)庫驅(qū)動(dòng)--><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>8.0.21</version></dependency><!--lombok 代碼工具--><dependency><groupId>org.projectlombok</groupId><artifactId>lombok</artifactId></dependency><!--devtools熱部署--><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-devtools</artifactId><optional>true</optional><scope>true</scope></dependency><!--springMVC 啟動(dòng)器--><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-web</artifactId></dependency>

2. 啟動(dòng)類添加注解

3. 添加多數(shù)據(jù)源注解

4. yml

spring:datasource:dynamic:primary: master #設(shè)置默認(rèn)的數(shù)據(jù)源或者數(shù)據(jù)源組,默認(rèn)值即為masterstrict: falsedatasource:master:username: rootpassword: rooturl: jdbc:mysql://127.0.0.1:3306/test?autoReconnect=true&useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=CONVERT_TO_NULL&useSSL=false&serverTimezone=CTTdriver-class-name: com.mysql.cj.jdbc.Driverslave_1:username: rootpassword: rooturl: jdbc:mysql://127.0.0.1:3306/test1?autoReconnect=true&useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=CONVERT_TO_NULL&useSSL=false&serverTimezone=CTTdriver-class-name: com.mysql.cj.jdbc.Driverslave_2:username: rootpassword: rooturl: jdbc:mysql://127.0.0.1:3306/test2?autoReconnect=true&useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=CONVERT_TO_NULL&useSSL=false&serverTimezone=CTTdriver-class-name: com.mysql.cj.jdbc.Driveroracle:driver-class-name: oracle.jdbc.OracleDriverurl: jdbc:oracle:thin:@127.0.0.1:1521:orclusername: orclpassword: orclfilters: wall,mergeStat logging:level:com.gblfy: debug

5. 測試類

在瀏覽器訪問：http://localhost:8080/doc.html
咱們寫的接口就會(huì)顯示，依次測試即可！

6. 源碼地址

https://gitee.com/gb_90/dynamic-datasource

具體詳細(xì)：請(qǐng)參考官網(wǎng)https://mybatis.plus/guide/dynamic-datasource.html

總結(jié)

以上是生活随笔為你收集整理的SpringBoot Mybatisplus 多数据源使用的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。