MybatisPlus集成多数据源

3.6.0 开始支持spirngboot3

官方地址：文档-documentation

		<!--MybatisPlus多数据源-->
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>dynamic-datasource-spring-boot-starter</artifactId>
            <version>3.6.1</version>
        </dependency>

yml 配置

# 配置数据源信息
  datasource:
    dynamic:
      # 设置默认的数据源或者数据源组,默认值即为master
      primary: master
      # 严格匹配数据源,默认false.true未匹配到指定数据源时抛异常,false使用默认数据源
      strict: false
      datasource:
        master:
          url: jdbc:mysql://localhost:3306/wind?characterEncoding=utf8&useSSL=false
          driver-class-name: com.mysql.cj.jdbc.Driver
          username: root
          password: 123456
        slave_1:
          url: jdbc:sqlserver://127.0.0.1;database=wind;encrypt=false
          driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver
          username: gaopo
          password: 123456..

注解的使用

@DS("slave_1")
//@DS("master")

参考:https://blog.csdn.net/weixin_40106067/article/details/126398739?utm_medium=distribute.pc_relevant.none-task-blog-2_defaultbaidujs_baidulandingword~default-0-126398739-blog-125940474.235^v29pc_relevant_default_base3&spm=1001.2101.3001.4242.1&utm_relevant_index=2

若链接sqlserver报错
点击