Mybatis Plus 多数据源和Druid集成
- 添加maven依赖
com.alibaba
druid-spring-boot-starter
1.2.4
com.baomidou
dynamic-datasource-spring-boot-starter
3.3.2
- 排除Druid的配置类
@SpringBootApplication(exclude = DruidDataSourceAutoConfigure.class)
- 在application.yml中添加druid配置
spring:
servlet:
multipart:
max-file-size: 52428800
max-request-size: 52428800
datasource:
druid:
stat-view-servlet:
enabled: true
loginUsername: admin
loginPassword: 123456
dynamic:
# 配置全局druid参数
druid:
initial-size: 5
max-active: 8
min-idle: 3
max-wait: 1000
validation-query: 'select 10'
primary: master
strict: false
datasource:
master:
driver-class-name: org.postgresql.Driver
url: jdbc:postgresql://192.168.1.27:9998/BugManager
username: postgres
password: admin
type: com.alibaba.druid.pool.DruidDataSource #Druid类型连接池
plat:
driver-class-name: org.postgresql.Driver
url: jdbc:postgresql://192.168.1.237:15432/OnMapQZS
username: OnMap
password: OnMap
type: com.alibaba.druid.pool.DruidDataSource #Druid类型连接池,也可以是其他类型
- 在浏览器打开http://127.0.0.1:端口/druid/login.html