动态数据源

maven：

<dependency>
    <groupId>com.baomidou</groupId>
    &lt;artifactId&gt;dynamic-datasource-spring-boot-starter</artifactId>
    <version>3.5.2</version>
</dependency>

yml配置文件：

spring:
  datasource:
    dynamic:
      primary: mysql # 默认数据源
      strict: false
      datasource:
        mysql:
          url: ***
          username: ***
          password: ***
          driver-class-name: ***
        dm:
          url: ***
          username: ***
          password: ***
          driver-class-name: ***

获取所有数据源：

import com.baomidou.dynamic.datasource.spring.boot.autoconfigure.DataSourceProperty;
import com.baomidou.dynamic.datasource.spring.boot.autoconfigure.DynamicDataSourceProperties;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

import java.util.Map;

@Configuration
public class DynamicDataSourceConfig {
    @Autowired
    DynamicDataSourceProperties dynamicDataSourceProperties;

    @Bean
    public Map<String, DataSourceProperty> dynamicDataSource() {
        return dynamicDataSourceProperties.getDatasource();
    }
}

然后直接注入使用：

@Autowired
Map<String, DataSourceProperty> dynamicDataSource;

动态切换数据源：

DynamicDataSourceContextHolder.push("mysql/dm");

代码007普通

打赏 收藏 海报 链接