• 动态切换数据源总结学习

            要实现动态数据源切换,离不开Spring框架的AbstractRoutingDataSource这个抽象类。这是实现动态数据源切换的关键。我们先看下这个抽象类。

            AbstractRoutingDataSource的源码如下：

    1. //
    2. // Source code recreated from a .class file by IntelliJ IDEA
    3. // (powered by Fernflower decompiler)
    4. //
    5.  
    6. package org.springframework.jdbc.datasource.lookup;
    7.  
    8. import java.sql.Connection;
    9. import java.sql.SQLException;
    10. import java.util.Collections;
    11. import java.util.Map;
    12. import javax.sql.DataSource;
    13. import org.springframework.beans.factory.InitializingBean;
    14. import org.springframework.jdbc.datasource.AbstractDataSource;
    15. import org.springframework.lang.Nullable;
    16. import org.springframework.util.Assert;
    17. import org.springframework.util.CollectionUtils;
    18.  
    19. public abstract class AbstractRoutingDataSource extends AbstractDataSource implements InitializingBean {
    20.     @Nullable
    21.     private Map targetDataSources;
    22.     @Nullable
    23.     private Object defaultTargetDataSource;
    24.     private boolean lenientFallback = true;
    25.     private DataSourceLookup dataSourceLookup = new JndiDataSourceLookup();
    26.     @Nullable
    27.     private Map resolvedDataSources;
    28.     @Nullable
    29.     private DataSource resolvedDefaultDataSource;
    30.  
    31.     public AbstractRoutingDataSource() {
    32.     }
    33.  
    34.     public void setTargetDataSources(Map targetDataSources) {
    35.         this.targetDataSources = targetDataSources;
    36.     }
    37.  
    38.     public void setDefaultTargetDataSource(Object defaultTargetDataSource) {
    39.         this.defaultTargetDataSource = defaultTargetDataSource;
    40.     }
    41.  
    42.     public void setLenientFallback(boolean lenientFallback) {
    43.         this.lenientFallback = lenientFallback;
    44.     }
    45.  
    46.     public void setDataSourceLookup(@Nullable DataSourceLookup dataSourceLookup) {
    47.         this.dataSourceLookup = (DataSourceLookup)(dataSourceLookup != null ? dataSourceLookup : new JndiDataSourceLookup());
    48.     }
    49.  
    50.     public void afterPropertiesSet() {
    51.         if (this.targetDataSources == null) {
    52.             throw new IllegalArgumentException("Property 'targetDataSources' is required");
    53.         } else {
    54.             this.resolvedDataSources = CollectionUtils.newHashMap(this.targetDataSources.size());
    55.             this.targetDataSources.forEach((key, value) -> {
    56.                 Object lookupKey = this.resolveSpecifiedLookupKey(key);
    57.                 DataSource dataSource = this.resolveSpecifiedDataSource(value);
    58.                 this.resolvedDataSources.put(lookupKey, dataSource);
    59.             });
    60.             if (this.defaultTargetDataSource != null) {
    61.                 this.resolvedDefaultDataSource = this.resolveSpecifiedDataSource(this.defaultTargetDataSource);
    62.             }
    63.  
    64.         }
    65.     }
    66.  
    67.     protected Object resolveSpecifiedLookupKey(Object lookupKey) {
    68.         return lookupKey;
    69.     }
    70.  
    71.     protected DataSource resolveSpecifiedDataSource(Object dataSource) throws IllegalArgumentException {
    72.         if (dataSource instanceof DataSource) {
    73.             return (DataSource)dataSource;
    74.         } else if (dataSource instanceof String) {
    75.             return this.dataSourceLookup.getDataSource((String)dataSource);
    76.         } else {
    77.             throw new IllegalArgumentException("Illegal data source value - only [javax.sql.DataSource] and String supported: " + dataSource);
    78.         }
    79.     }
    80.  
    81.     public Map getResolvedDataSources() {
    82.         Assert.state(this.resolvedDataSources != null, "DataSources not resolved yet - call afterPropertiesSet");
    83.         return Collections.unmodifiableMap(this.resolvedDataSources);
    84.     }
    85.  
    86.     @Nullable
    87.     public DataSource getResolvedDefaultDataSource() {
    88.         return this.resolvedDefaultDataSource;
    89.     }
    90.  
    91.     public Connection getConnection() throws SQLException {
    92.         return this.determineTargetDataSource().getConnection();
    93.     }
    94.  
    95.     public Connection getConnection(String username, String password) throws SQLException {
    96.         return this.determineTargetDataSource().getConnection(username, password);
    97.     }
    98.  
    99.     public  T unwrap(Class iface) throws SQLException {
    100.         return iface.isInstance(this) ? this : this.determineTargetDataSource().unwrap(iface);
    101.     }
    102.  
    103.     public boolean isWrapperFor(Class iface) throws SQLException {
    104.         return iface.isInstance(this) || this.determineTargetDataSource().isWrapperFor(iface);
    105.     }
    106.  
    107.     protected DataSource determineTargetDataSource() {
    108.         Assert.notNull(this.resolvedDataSources, "DataSource router not initialized");
    109.         Object lookupKey = this.determineCurrentLookupKey();
    110.         DataSource dataSource = (DataSource)this.resolvedDataSources.get(lookupKey);
    111.         if (dataSource == null && (this.lenientFallback || lookupKey == null)) {
    112.             dataSource = this.resolvedDefaultDataSource;
    113.         }
    114.  
    115.         if (dataSource == null) {
    116.             throw new IllegalStateException("Cannot determine target DataSource for lookup key [" + lookupKey + "]");
    117.         } else {
    118.             return dataSource;
    119.         }
    120.     }
    121.  
    122.     @Nullable
    123.     protected abstract Object determineCurrentLookupKey();
    124. }

            首先，这个类AbstractRoutingDataSource这个抽象类是继承了AbstractDataSource抽象类，并且实现了InitializingBean接口。InitializingBean接口提供了一个afterPropertiesSet()方法，凡是继承了该接口的类那么在初始化Bean的时候就会执行该方法。所以AbstractRoutingDataSource类中的afterPropertiesSet正是用于初始化一些信息。要想了解InitializingBean这个接口，可以参考我的这篇blog：Spring框架中InitializingBean的作用 

            其次，这个类AbstractRoutingDataSource类有个抽象方法，这个抽象方法需要我们实现，这个方法的作用就是指定用哪个数据源，也就是告诉dao层现在连接数据源用我们指定的数据源了。

                    

    protected abstract Object determineCurrentLookupKey();

            AbstractRoutingDataSource还继承了抽象类AbstractDataSource，而AbstractDataSource抽象类又继承了DataSource接口，在DataSource中只有两个方法，这两个方法会在AbstractDataSource抽象类中得到具体实现。
            

            现在看看AbstractRoutingDataSource中的一些属性都有什么作用

    1. @Nullable
    2.     private Map targetDataSources;  目标数据源，也就是我们要切换的多个数据源都存放到这里
    3.     @Nullable
    4.     private Object defaultTargetDataSource; 默认数据源，如果想指定默认数据源，可以给它赋值
    5.     private boolean lenientFallback = true;
    6.     private DataSourceLookup dataSourceLookup = new JndiDataSourceLookup();
    7.     @Nullable
    8.     private Map resolvedDataSources;存放真正的数据源信息，将targetDataSources的信息copy一份
    9.     @Nullable
    10.     private DataSource resolvedDefaultDataSource; 默认数据源，将defaultTargetDataSource转为DataSource赋值给resolvedDefaultDataSource
    11.  
    12.     public AbstractRoutingDataSource() {
    13.     }

               AbstractRoutingDataSource抽象类中afterPropertiesSet()方法是核心，那看看他到底做了哪些初始化操作。

            

    1. public void afterPropertiesSet() {
    2.         if (this.targetDataSources == null) {
    3.             throw new IllegalArgumentException("Property 'targetDataSources' is required");
    4.         } else {
    5.             this.resolvedDataSources = CollectionUtils.newHashMap(this.targetDataSources.size());
    6.             this.targetDataSources.forEach((key, value) -> {
    7.                 Object lookupKey = this.resolveSpecifiedLookupKey(key);
    8.                 DataSource dataSource = this.resolveSpecifiedDataSource(value);
    9.                 this.resolvedDataSources.put(lookupKey, dataSource);
    10.             });
    11.             if (this.defaultTargetDataSource != null) {
    12.                 this.resolvedDefaultDataSource = this.resolveSpecifiedDataSource(this.defaultTargetDataSource);
    13.             }
    14.  
    15.         }
    16.     }

            第一，当targetDataSources为空时，会抛出IllegalArgumentException错误，所以我们在配置多数据源时，至少需要传入一个数据源。

            第二， 初始化了resolvedDataSources大小，resolvedDataSources只是把targetDataSources的内容copy了一份，不同之处在于targetDataSources的value是Object类型，而resolvedDataSources的value是DataSource类型。
            第三，遍历targetDataSources集合，然后调用了resolveSpecifiedLookupKey()方法和resolveSpecifiedDataSource()方法，最后将返回值当作Key-Value放入resolvedDataSources集合中。

            第四，那么方法resolveSpecifiedLookupKey()和方法resolveSpecifiedDataSource()分别做了什么呢？我们可以查看两个方法的实现。其实可以看到resolveSpecifiedLookupKey并没有做什么操作就直接返回了值，而resolveSpecifiedDataSource只是把Object转为DataSource对象返回。
            

            所以afterPropertiesSet()初始话就是将targetDataSources的内容转化一下放到resolvedDataSources中，将defaultTargetDataSource转为DataSource赋值给resolvedDefaultDataSource。

            我们再看getConnection()方法是如何实现的。调用了determineTargetDataSource()方法。

            

    1. public Connection getConnection() throws SQLException {
    2.         return this.determineTargetDataSource().getConnection();
    3.     }

            那么determineTargetDataSource方法到底做了什么，我们可以看一下determineTargetDataSource的实现。该方法返回DataSource类型的对象，并且调用了determineCurrentLookupKey方法，可能这时有人发现了这个方法就是我们自定义数据源类要实现的那个方法。determineCurrentLookupKey返回一个Object，命名为lookupKey，将lookupKey作为key，到resolvedDataSources集合中去拿数据源，如果没有拿到数据源，那么它会拿默认数据源resolvedDefaultDataSource。如果还是没有拿到，此时就报错啦!

            通过上面的分析，我们自己实现的方法determineCurrentLookupKey()是什么时候别调用的呢？从逻辑上看determineCurrentLookupKey()被determineTargetDataSource()调用，而determineTargetDataSource()被getConnection()调用，那getConnection()方法是被谁在什么时候调用的呢？通过代码跟踪，是我们在service层调用dao层方法时，这时候调用的。

            

            了解了AbstractRoutingDataSource这个抽象类，也就该实现一个动态数据源切换功能了，涉及的源码如下：

            

    1. package com.lsl.mylsl.config;
    2.  
    3. import org.springframework.jdbc.datasource.lookup.AbstractRoutingDataSource;
    4.  
    5. /**
    6.  * 动态数据源实现类
    7.  */
    8. public class DynamicDataSource extends AbstractRoutingDataSource {
    9.  
    10.  
    11.     @Override
    12.     protected Object determineCurrentLookupKey() {
    13.         String dataSource = DBContextHolder.getDataSource();
    14.         if (dataSource == null || "".equals(dataSource)){
    15.             dataSource = "ds1";
    16.         }
    17.         return dataSource;
    18.     }
    19. }

            当没有指定数据源时，默认指定ds1为当前数据源

            

    1. package com.lsl.mylsl.config;
    2.  
    3. public class DBContextHolder {
    4.  
    5.     private static final ThreadLocal CONTEXT_HOLDER = new ThreadLocal<>();
    6.  
    7.     /**
    8.      * 动态切换数据源
    9.      * @param dataSource
    10.      */
    11.     public static void setDataSource(String dataSource){
    12.  
    13.         if (SpringbootConfig.DBMAP.containsKey(dataSource)){
    14.             CONTEXT_HOLDER.set(dataSource);
    15.         }else {
    16.             System.out.println("数据源" + dataSource + "不存在");
    17.         }
    18.     }
    19.  
    20.     /**
    21.      * 获取数据源
    22.      * @return
    23.      */
    24.     public static String getDataSource(){
    25.         return CONTEXT_HOLDER.get();
    26.     }
    27.  
    28.     /**
    29.      * 清空数据源
    30.      */
    31.     public static void clearDataSource(){
    32.         CONTEXT_HOLDER.remove();
    33.     }
    34. }

            

            

    1. package com.lsl.mylsl.config;
    2.  
    3. import com.alibaba.druid.pool.DruidDataSource;
    4. import com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceBuilder;
    5. import org.springframework.context.annotation.Bean;
    6. import org.springframework.context.annotation.Configuration;
    7. import org.springframework.jdbc.datasource.DataSourceTransactionManager;
    8. import org.springframework.transaction.PlatformTransactionManager;
    9.  
    10. import javax.sql.DataSource;
    11. import java.util.HashMap;
    12. import java.util.Map;
    13.  
    14. /**
    15.  * 初始化多个数据源
    16.  * 注册动态数据源
    17.  */
    18. @Configuration
    19. public class SpringbootConfig {
    20.  
    21.     public static final Map DBMAP = new HashMap<>();
    22.  
    23.     /**
    24.      * 初始化数据源1
    25.      */
    26.     public void initDataSource1(){
    27.         try {
    28.             DruidDataSource dds1 = DruidDataSourceBuilder.create().build();
    29.             dds1.setUsername("admin");
    30.             dds1.setPassword("123456");
    31.             dds1.setUrl("jdbc:oracle:thin:@10.10.10.10:1521/oracle1");
    32.             dds1.setInitialSize(5);
    33.             dds1.setMinIdle(5);
    34.             dds1.setMaxActive(20);
    35.             dds1.setMaxWait(60000);
    36.             dds1.setTimeBetweenEvictionRunsMillis(60000);
    37.             dds1.setMinEvictableIdleTimeMillis(300000);
    38.             dds1.setValidationQuery("SELECT * FROM DUAL");
    39.             dds1.setTestWhileIdle(true);
    40.             dds1.setTestOnBorrow(false);
    41.             dds1.setTestOnReturn(false);
    42.             dds1.setMaxPoolPreparedStatementPerConnectionSize(20);
    43.             dds1.setFilters("stat,wall");
    44.             dds1.setConnectionProperties("druid.stat.mergeSql=true;druid.stat.slow.slowSqlMillis=5000");
    45.             dds1.setUseGlobalDataSourceStat(true);
    46.             //添加数据源到map
    47.             SpringbootConfig.DBMAP.put("ds1",dds1);
    48.         } catch (Exception e) {
    49.  
    50.         }
    51.  
    52.  
    53.     }
    54.  
    55.     /**
    56.      * 初始化数据源2
    57.      */
    58.     public void initDataSource2(){
    59.         try {
    60.             DruidDataSource dds2 = DruidDataSourceBuilder.create().build();
    61.             dds2.setUsername("admin");
    62.             dds2.setPassword("123456");
    63.             dds2.setUrl("jdbc:mysql://10.10.10.10:1521/mysql1");
    64.             dds2.setInitialSize(5);
    65.             dds2.setMinIdle(5);
    66.             dds2.setMaxActive(20);
    67.             dds2.setMaxWait(60000);
    68.             dds2.setTimeBetweenEvictionRunsMillis(60000);
    69.             dds2.setMinEvictableIdleTimeMillis(300000);
    70.             dds2.setValidationQuery("SELECT 1");
    71.             dds2.setTestWhileIdle(true);
    72.             dds2.setTestOnBorrow(false);
    73.             dds2.setTestOnReturn(false);
    74.             dds2.setMaxPoolPreparedStatementPerConnectionSize(20);
    75.             dds2.setFilters("stat,wall");
    76.             dds2.setConnectionProperties("druid.stat.mergeSql=true;druid.stat.slow.slowSqlMillis=5000");
    77.             dds2.setUseGlobalDataSourceStat(true);
    78.             dds2.setDbType("mysql");
    79.             //添加数据源到map
    80.             SpringbootConfig.DBMAP.put("ds2",dds2);
    81.         } catch (Exception e) {
    82.  
    83.         }
    84.     }
    85.  
    86.     /**
    87.      * 把DynamicDataSource交给spring托管
    88.      * @return
    89.      */
    90.     @Bean
    91.     public DataSource dynamicDataSource(){
    92.         DynamicDataSource myDs = new DynamicDataSource();
    93.         initDataSource1();
    94.         initDataSource2();
    95.         myDs.setTargetDataSources(SpringbootConfig.DBMAP);
    96.         myDs.afterPropertiesSet();
    97.         return myDs;
    98.     }
    99.  
    100.     /**
    101.      * 事务管理
    102.      * @return
    103.      */
    104.     @Bean
    105.     public PlatformTransactionManager transactionManager(){
    106.         return new DataSourceTransactionManager(dynamicDataSource());
    107.     }
    108. }

            如何实现数据源切换，代码很简单，如下：

    1. package com.lsl.mylsl.service.impl;
    2.  
    3. import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
    4. import com.lsl.mylsl.BO.CatBO;
    5. import com.lsl.mylsl.config.DBContextHolder;
    6. import com.lsl.mylsl.mapper.CatMapper;
    7. import com.lsl.mylsl.service.ICatService;
    8. import org.springframework.beans.factory.annotation.Autowired;
    9. import org.springframework.stereotype.Service;
    10.  
    11. import java.util.List;
    12. import java.util.Map;
    13.  
    14. @Service
    15. public class CatServiceImpl extends ServiceImpl implements ICatService {
    16.  
    17.     @Autowired
    18.     CatMapper catMapper;
    19.  
    20.     @Override
    21.     public List qryCatByAge(Map params) {
    22.         //切换数据源到ds2
    23.         DBContextHolder.setDataSource("ds2");
    24.         return catMapper.qryCatByAge(params);
    25.     }
    26. }

  • 相关阅读:
    【mmdetection代码解读 3.x版本】FPN层的解读
    学生HTML个人网页作业作品 HTML+CSS校园环保(大学生环保网页设计与实现)
    oracle高级
    深入剖析：HTML页面从用户请求到完整呈现的多阶段加载与渲染全流程详解
    详解C语言—预处理
    CorelDRAW Graphics Suite2022免费图形设计软件
    【Linux】项目自动化构建工具——make/Makefile及拓展
    Nginx 配置Nextjs和SpringBoot项目的https并解决跨域问题
    4款.NET开源的Redis客户端驱动库
    44.【list链表的简单属性】
  • 原文地址：https://blog.csdn.net/dhklsl/article/details/127671314