SpringBoot + Mybatis-Plus mysql多数据源 + mongodb 多数据源 [备忘]

1. yml

mybatis-plus:
  configuration:
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
  mapper-locations: classpath:mapping/*.xml
  global-config:
    refresh-mapper: true

spring:
  profiles:
    active: dev
  datasource:
    dynamic:
      primary: master
      strict: false
      datasource:
        master:
          driver-class-name: com.p6spy.engine.spy.P6SpyDriver
          url: jdbc:p6spy:mysql://ip1:3306/sfdoc?serverTimezone=UTC
          username: root
          password: 123456
        mysql_local:
          driver-class-name: com.mysql.cj.jdbc.Driver
          url: jdbc:mysql://ip2:3306/test?serverTimezone=UTC
          username: root
          password: 123456
          # sqlserver
        dkd_bk:
          driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver
          url: jdbc:sqlserver://ip3:1433; databaseName=IDCMon
          username: sa
          password: 13808061828
  data:
    mongodb:
#xd ubuntu
      primary:
        uri: mongodb://10.42.3.20:27017/search
      #xd Windows 
      secondary:
        uri: mongodb://账号:密码@ip地址:27017/sf-yf?authSource=admin
#xd Windows 
      thirdly:
        uri: mongodb://账号:密码@ip地址:27017/sf-zdcy?authSource=admin



  jackson:
    date-format: yyyy-MM-dd HH:mm:ss
    time-zone: GMT+8
    default-property-inclusion: non_null
server:
  port: 8001

# 没选用p6spy 请自行修改对应位置

2. 常量类

    public static final String DS_MYSQL_LOCAL = "mysql_local";

    public static final String DS_MONGODB_XD_UBUNTU = "mongodb_xd_ubuntu";

    public static final String DS_SERVER_DKY_BK = "dkd_bk" ;

3. 实现类和Dao层增加@DS注解
   @DS 可以注解在方法上或类上，同时存在就近原则 方法上注解 优先于 类上注解。
   @DS(“dsName”) dsName可以为组名也可以为具体某个库的名称
   官网推荐: 只在service的类和方法上添加注解，不建议在mapper上添加注解。

@Component
@DS(DBConstants.DS_MYSQL_LOCAL)
public interface TestMapper extends BaseMapper<TestMongoDB> {


}

4. 控制层使用

    @Autowired
    private TestDBService testDBService ;
        @ApiOperation(value = "测试mysql多数据源")
    @GetMapping("getAll")
    public Result getAll(){

        List<TestDB> list = testDBService.list();
        return Result.ok().data("data",list);
    }

结果：

{
  "success": true,
  "code": 200,
  "message": "成功",
  "data": {
    "data": [
      {
        "id": 1,
        "name": "测试1",
        "age": 19,
        "sex": "男"
      },
      {
        "id": 2,
        "name": "测试2",
        "age": 24,
        "sex": "女"
      }
    ]
  }
}