Mybatis-plus配置多数据源

梦里梦外; 2022-10-05 00:41 279阅读 0赞

## Mybatis-plus配置双数据源 ##

*  引入依赖
    
     *      <dependency>
                <groupId>com.baomidou</groupId>
                <artifactId>dynamic-datasource-spring-boot-starter</artifactId>
                <version>3.3.6</version>
            </dependency>
 *  添加配置
    
     *      spring:
              datasource:
            # platform: mysql
            # url: jdbc:mysql://192.168.233.128:3306/hyspring?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true&autoReconnect=true&failOverReadOnly=false&useAffectedRows=true
            # username: root
            # password: root
            # driver-class-name: com.mysql.cj.jdbc.Driver
            # initialization-mode: never
                dynamic:
                  primary: admin
                  strict: false
                  datasource:
                    admin:
                      platform: mysql
                      url: jdbc:mysql://192.168.233.128:3306/hyspring?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true&autoReconnect=true&failOverReadOnly=false&useAffectedRows=true
                      username: root
                      password: root
                      driver-class-name: com.mysql.cj.jdbc.Driver
                      initialization-mode: never
                    news:
                      platform: mysql
                      url: jdbc:mysql://192.168.233.128:3306/hynews?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true&autoReconnect=true&failOverReadOnly=false&useAffectedRows=true
                      username: root
                      password: root
                      driver-class-name: com.mysql.cj.jdbc.Driver
                      initialization-mode: never
 *  在对应的mapper上添加@DS注解,括号里边对应yml文件的名称，如果不加@DS注解，默认使用主数据源
    
     *      package com.hyspring.mapper;
            
            import com.baomidou.dynamic.datasource.annotation.DS;
            import com.baomidou.mybatisplus.core.mapper.BaseMapper;
            import com.hyspring.entity.News;
            
            @DS("news")
            public interface NewsMapper extends BaseMapper<News> { 
            }