Mybatis Plus 多数据源和Druid集成

最新推荐文章于 2023-11-24 16:38:27 发布

naturessdfsafagf

最新推荐文章于 2023-11-24 16:38:27 发布

阅读量507

点赞数

分类专栏： java 文章标签： mybatis mysql java

本文链接：https://blog.csdn.net/naturessdfsafagf/article/details/125414234

版权

java 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

Mybatis Plus 多数据源和Druid集成

添加maven依赖

  <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
            <version>1.2.4</version>
        </dependency>

   <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>dynamic-datasource-spring-boot-starter</artifactId>
            <version>3.3.2</version>
        </dependency>

排除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类型连接池，也可以是其他类型