springboot shardingsphere druid 动态数据源切换及分库分表

最新推荐文章于 2025-08-07 16:51:25 发布

原创

最新推荐文章于 2025-08-07 16:51:25 发布 · 3.8k 阅读

17 ·

CC 4.0 BY-SA版权

文章标签：

#spring boot #java #spring #shardingsphere #分库分表

引入依赖

<dependency>
    <groupId>org.apache.shardingsphere</groupId>
    <artifactId>sharding-jdbc-spring-boot-starter</artifactId>
    <version>4.0.0-RC1</version>
</dependency>

yml配置文件

spring:
  datasource:
    type: com.alibaba.druid.pool.DruidDataSource
    druid:
      first:  #数据源1
        driverClassName: com.mysql.jdbc.Driver
        url: ******
        username: ******
        password: YmqMysql123
      second:  #数据源2
        driverClassName: oracle.jdbc.OracleDriver
        url: ******
        username: ******
        password: ******
      third:  #数据源3
        driverClassName: oracle.jdbc.OracleDriver
        url: ******
        username: ******
        password: ******
      fourth:  #数据源4
        driverClassName: oracle.jdbc.OracleDriver
        url: ******
        username: ******
        password: ******
      fifth:  #数据源5
        driverClassName: com.mysql.jdbc.Driver
        url: ******
        username: ******
        password: ******

创建读取数据源配置类

import com.alibaba.druid.pool.DruidDataSource;
import lombok.Data;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.context.annotation.Configuration;

/**
 * @author wuzhenyong
 * ClassName:DataSourceProperties.java
 * date:2022-06-21 16:12
 * Description:
 */
@Data
@Configuration
@ConfigurationProperties(prefix = "spring.datasource.druid")
public class DataSourceProperties {
   
   
    private DruidDataSource first;
    private DruidDataSource second;
    private DruidDataSource third;
    private DruidDataSource fourth;
    private DruidDataSource fifth;

}