spring boot 集成dynamic-datasource-spring-boot-starter动态数据源

 一、增加依赖项

  

   

    

     

    
    

     
 
     
    
   

    

     

    
    

     
   <!--多数据源依赖开始-->
     
    
   

    

     

    
    

     
 <dependency>
     
    
   

    

     

    
    

     
 <groupId>com.baomidou</groupId>
     
    
   

    

     

    
    

     
 <artifactId>dynamic-datasource-spring-boot-starter</artifactId>
     
    
   

    

     

    
    

     
 <version>3.4.0</version>
     
    
   

    

     

    
    

     
 </dependency>
     
    
   

    

     

    
    

     
		
     
    
   

    

     

    
    

     
 <dependency>
     
    
   

    

     

    
    

     
 <groupId>com.oracle.database.jdbc</groupId>
     
    
   

    

     

    
    

     
 <artifactId>ojdbc8</artifactId>
     
    
   

    

     

    
    

     
 <scope>runtime</scope>
     
    
   

    

     

    
    

     
 </dependency>
     
    
  
 

 二、编写动态数据源配置项

  

   

    

     

    
    

     

      spring:
     
    
   

    

     

    
    

     
  datasource:
     
    
   

    

     

    
    

     
 dynamic:
     
    
   

    

     

    
    

     
 primary: mysql
     
    
   

    

     

    
    

     
 strict: true
     
    
   

    

     

    
    

     
 datasource:
     
    
   

    

     

    
    

     
 mysql:
     
    
   

    

     

    
    

     
 type: com.zaxxer.hikari.HikariDataSource
     
    
   

    

     

    
    

     
 driverClassName: com.mysql.cj.jdbc.Driver
     
    
   

    

     

    
    

     
 url: jdbc:mysql://127.0.0.1:3306/ds0serverTimezone=UTC&useSSL=false&useUnicode=true&characterEncoding=UTF-8
     
    
   

    

     

    
    

     
 username: root
     
    
   

    

     

    
    

     
 password: 123456
     
    
   

    

     

    
    

     
 oracle:
     
    
   

    

     

    
    

     
 type: com.zaxxer.hikari.HikariDataSource
     
    
   

    

     

    
    

     
 driverClassName: oracle.jdbc.driver.OracleDriver
     
    
   

    

     

    
    

     
 url: jdbc:oracle:thin:@localhost:1521:orcl
     
    
   

    

     

    
    

     
 username: root
     
    
   

    

     

    
    

     
 password: 123456
     
    
  
 

三、直接在service层或者mapper层接口和方法上增加DS("数据库名")注解即可

四、详细官方文档请查看

https://mybatis.plus/guide/dynamic-datasource.html#%E6%96%87%E6%A1%A3-documentation

文章来源: blog.csdn.net，作者：血煞风雨城2018，版权归原作者所有，如需转载，请联系作者。

原文链接：blog.csdn.net/qq_31905135/article/details/118027057