dynamic-datasource-spring-boot-starter支持多数据源

1、增加maven依赖

 		<dependency><groupId>com.microsoft.sqlserver</groupId><artifactId>mssql-jdbc</artifactId></dependency><dependency><groupId>com.alibaba</groupId><artifactId>druid-spring-boot-starter</artifactId></dependency><dependency><groupId>com.baomidou</groupId><artifactId>dynamic-datasource-spring-boot-starter</artifactId></dependency><dependency><groupId>com.oracle.database.jdbc</groupId><artifactId>ojdbc6</artifactId></dependency><dependency><groupId>org.mybatis.spring.boot</groupId><artifactId>mybatis-spring-boot-starter</artifactId></dependency><dependency><groupId>com.baomidou</groupId><artifactId>mybatis-plus-boot-starter</artifactId></dependency>

2、修改数据源配置

spring:datasource:type: com.alibaba.druid.pool.DruidDataSourcedynamic:druid:initialSize: 5minIdle: 5maxActive: 20maxWait: 60000timeBetweenEvictionRunsMillis: 60000minEvictableIdleTimeMillis: 300000testWhileIdle: truetestOnBorrow: falsetestOnReturn: false# 配置监控统计拦截的filters，去掉后监控界面sql无法统计，'wall'用于防火墙filters: stat,wall,slf4j# 通过connectProperties属性来打开mergeSql功能；慢SQL记录connectionProperties: druid.stat.mergeSql\=true;druid.stat.slowSqlMillis\=5000# 配置DruidStatFilterweb-stat-filter:enabled: trueurl-pattern: "/*"exclusions: "*.js,*.gif,*.jpg,*.bmp,*.png,*.css,*.ico,/druid/*"# 配置DruidStatViewServletstat-view-servlet:enabled: trueurl-pattern: "/druid/*"# IP白名单(没有配置或者为空，则允许所有访问)allow: 127.0.0.1,192.168.*# IP黑名单 (存在共同时，deny优先于allow)#deny: 192.168.1.100#  禁用HTML页面上的“Reset All”功能reset-enable: false# 登录名login-username: admin# 登录密码login-password: 123456validation-query: select 1primary: masterstrict: falsedatasource:master:driver-class-name: oracle.jdbc.driver.OracleDriverurl: jdbc:oracle:thin:@192.168.20.13:1521:CMusername: userpassword: pwddruid:validation-query: select 1 from dualmssql:username: sapassword: 123456url: jdbc:sqlserver://192.168.8.11:1433;DatabaseName=EMAppConfigdriver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriverdruid:validation-query: select 2

3、java代码中指定数据源

@Service
@DS("mssql")
public class UserServiceImpl extends ServiceImpl<UserMapper, User> implements IUserService {}