@Bean(name = "dataSource")
    public DataSource dataSource() {
        DruidDataSource druidDataSource = new DruidDataSource();
        druidDataSource.setUrl(url);
        druidDataSource.setUsername(username);
        druidDataSource.setDriverClassName(driverClassName);
        druidDataSource.setPassword(password);
        return druidDataSource;
    }

<!--druid連接池-->
<dependency>
   <groupId>com.alibaba</groupId>
   <artifactId>druid-spring-boot-starter</artifactId>
   <version>1.1.9</version>
</dependency>

@EnableConfigurationProperties({DruidStatProperties.class, DataSourceProperties.class})

spring.datasource.url=jdbc:mysql://120.26.101.xxx:3306/xxx?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull&useSSL=false&allowMultiQueries=true&serverTimezone=Asia/Shanghai
spring.datasource.username=root
spring.datasource.password=xxxx
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
#初始化連接大小
spring.datasource.druid.initial-size=0
#連接池最大使用連接數(shù)量
spring.datasource.druid.max-active=20
#連接池最小空閑
spring.datasource.druid.min-idle=0
#獲取連接最大等待時(shí)間
spring.datasource.druid.max-wait=6000
spring.datasource.druid.validation-query=SELECT 1
#spring.datasource.druid.validation-query-timeout=6000
spring.datasource.druid.test-on-borrow=false
spring.datasource.druid.test-on-return=false
spring.datasource.druid.test-while-idle=true
#配置間隔多久才進(jìn)行一次檢測(cè)，檢測(cè)需要關(guān)閉的空閑連接，單位是毫秒
spring.datasource.druid.time-between-eviction-runs-millis=60000
#置一個(gè)連接在池中最小生存的時(shí)間，單位是毫秒
spring.datasource.druid.min-evictable-idle-time-millis=25200000
#spring.datasource.druid.max-evictable-idle-time-millis=
#打開(kāi)removeAbandoned功能,多少時(shí)間內(nèi)必須關(guān)閉連接
spring.datasource.druid.removeAbandoned=true
#1800秒，也就是30分鐘
spring.datasource.druid.remove-abandoned-timeout=1800
#<!-- 1800秒，也就是30分鐘 -->
spring.datasource.druid.log-abandoned=true
spring.datasource.druid.filters=mergeStat

@Bean(initMethod = "init")
    @ConditionalOnMissingBean
    public DataSource dataSource() {
        LOGGER.info("Init DruidDataSource");
        return new DruidDataSourceWrapper();
    }

/**
     * @Bean：向IOC容器中注入一個(gè)Bean
     * @ConfigurationProperties：使得配置文件中以spring.datasource為前綴的屬性映射到Bean的屬性中
     * @return
     */
    @ConfigurationProperties(prefix = "spring.datasource")
    @Bean
    public DataSource dataSource(){
        //做一些其他的自定義配置，比如密碼加密等......
        return new DruidDataSource();
    }

<dependency>
     <groupId>org.mybatis.spring.boot</groupId>
     <artifactId>mybatis-spring-boot-starter</artifactId>
     <version>2.0.0</version>
</dependency>

@EnableConfigurationProperties(MybatisProperties.class)

mybatis.type-handlers-package=com.demo.typehandler
mybatis.configuration.map-underscore-to-camel-case=true

@Bean
  @ConditionalOnMissingBean
  public SqlSessionFactory sqlSessionFactory(DataSource dataSource) throws Exception {}

/**
     * 注入SqlSessionFactory
     */
    @Bean("sqlSessionFactory1")
    public SqlSessionFactory sqlSessionFactory(DataSource dataSource) throws Exception {
        SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();
        sqlSessionFactoryBean.setDataSource(dataSource);
        sqlSessionFactoryBean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath*:/mapper/**/*.xml"));
        org.apache.ibatis.session.Configuration configuration = new org.apache.ibatis.session.Configuration();
        // 自動(dòng)將數(shù)據(jù)庫(kù)中的下劃線轉(zhuǎn)換為駝峰格式
        configuration.setMapUnderscoreToCamelCase(true);
        configuration.setDefaultFetchSize(100);
        configuration.setDefaultStatementTimeout(30);
        sqlSessionFactoryBean.setConfiguration(configuration);
        return sqlSessionFactoryBean.getObject();
    }

@ConditionalOnSingleCandidate(DataSource.class)

@ConditionalOnSingleCandidate(DataSource.class)

private Map<Object, Object> targetDataSources;

protected abstract Object determineCurrentLookupKey();

/**
 * 使用ThreadLocal存儲(chǔ)切換數(shù)據(jù)源后的KEY
 */
public class DataSourceHolder {
    //線程  本地環(huán)境
    private static final ThreadLocal<String> dataSources = new InheritableThreadLocal();

    //設(shè)置數(shù)據(jù)源
    public static void setDataSource(String datasource) {
        dataSources.set(datasource);
    }
    //獲取數(shù)據(jù)源
    public static String getDataSource() {
        return dataSources.get();
    }

    //清除數(shù)據(jù)源
    public static void clearDataSource() {
        dataSources.remove();
    }
}

/**
 * 動(dòng)態(tài)數(shù)據(jù)源，繼承AbstractRoutingDataSource
 */
public class DynamicDataSource extends AbstractRoutingDataSource {

    /**
     * 返回需要使用的數(shù)據(jù)源的key，將會(huì)按照這個(gè)KEY從Map獲取對(duì)應(yīng)的數(shù)據(jù)源（切換）
     * @return
     */
    @Override
    protected Object determineCurrentLookupKey() {
        //從ThreadLocal中取出KEY
        return DataSourceHolder.getDataSource();
    }

    /**
     * 構(gòu)造方法填充Map，構(gòu)建多數(shù)據(jù)源
     */
    public DynamicDataSource(DataSource defaultTargetDataSource, Map<Object, Object> targetDataSources) {
        //默認(rèn)的數(shù)據(jù)源，可以作為主數(shù)據(jù)源
        super.setDefaultTargetDataSource(defaultTargetDataSource);
        //目標(biāo)數(shù)據(jù)源
        super.setTargetDataSources(targetDataSources);
        //執(zhí)行afterPropertiesSet方法，完成屬性的設(shè)置
        super.afterPropertiesSet();
    }
}

/**
 * 切換數(shù)據(jù)源的注解
 */
@Target(value = ElementType.METHOD)
@Retention(value = RetentionPolicy.RUNTIME)
@Documented
public @interface SwitchSource {
    /**
     * 默認(rèn)切換的數(shù)據(jù)源KEY
     */
    String DEFAULT_NAME = "hisDataSource";

    /**
     * 需要切換到數(shù)據(jù)的KEY
     */
    String value() default DEFAULT_NAME;
}

@Aspect
//優(yōu)先級(jí)要設(shè)置在事務(wù)切面執(zhí)行之前
@Order(1)
@Component
@Slf4j
public class DataSourceAspect {
    @Pointcut("@annotation(SwitchSource)")
    public void pointcut() {
    }
    /**
     * 在方法執(zhí)行之前切換到指定的數(shù)據(jù)源
     * @param joinPoint
     */
    @Before(value = "pointcut()")
    public void beforeOpt(JoinPoint joinPoint) {
        /*因?yàn)槭菍?duì)注解進(jìn)行切面，所以這邊無(wú)需做過(guò)多判定，直接獲取注解的值，進(jìn)行環(huán)繞，將數(shù)據(jù)源設(shè)置成遠(yuǎn)方，然后結(jié)束后，清楚當(dāng)前線程數(shù)據(jù)源*/
        Method method = ((MethodSignature) joinPoint.getSignature()).getMethod();
        SwitchSource switchSource = method.getAnnotation(SwitchSource.class);
        log.info("[Switch DataSource]:" + switchSource.value());
        DataSourceHolder.setDataSource(switchSource.value());
    }

    /**
     * 方法執(zhí)行之后清除掉ThreadLocal中存儲(chǔ)的KEY，這樣動(dòng)態(tài)數(shù)據(jù)源會(huì)使用默認(rèn)的數(shù)據(jù)源
     */
    @After(value = "pointcut()")
    public void afterOpt() {
        DataSourceHolder.clearDataSource();
        log.info("[Switch Default DataSource]");
    }
}

/**
     * 創(chuàng)建動(dòng)態(tài)數(shù)據(jù)源的SqlSessionFactory，傳入的是動(dòng)態(tài)數(shù)據(jù)源
     * @Primary這個(gè)注解很重要，如果項(xiàng)目中存在多個(gè)SqlSessionFactory，這個(gè)注解一定要加上
     */
    @Primary
    @Bean("sqlSessionFactory2")
    public SqlSessionFactory sqlSessionFactoryBean(DynamicDataSource dynamicDataSource) throws Exception {
        SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();
        sqlSessionFactoryBean.setDataSource(dynamicDataSource);
        sqlSessionFactoryBean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath*:/mapper/**/*.xml"));
        org.apache.ibatis.session.Configuration configuration = new org.apache.ibatis.session.Configuration();
        configuration.setMapUnderscoreToCamelCase(true);
        configuration.setDefaultFetchSize(100);
        configuration.setDefaultStatementTimeout(30);
        sqlSessionFactoryBean.setConfiguration(configuration);
        return sqlSessionFactoryBean.getObject();
    }

/**
     * @Bean：向IOC容器中注入一個(gè)Bean
     * @ConfigurationProperties：使得配置文件中以spring.datasource為前綴的屬性映射到Bean的屬性中
     */
    @ConfigurationProperties(prefix = "spring.datasource")
    @Bean("dataSource")
    public DataSource dataSource(){
        return new DruidDataSource();
    }

    /**
     * 向IOC容器中注入另外一個(gè)數(shù)據(jù)源
     * 全局配置文件中前綴是spring.datasource.his
     */
    @Bean(name = SwitchSource.DEFAULT_NAME)
    @ConfigurationProperties(prefix = "spring.datasource.his")
    public DataSource hisDataSource() {
        return DataSourceBuilder.create().build();
    }

/**
     * 創(chuàng)建動(dòng)態(tài)數(shù)據(jù)源的SqlSessionFactory，傳入的是動(dòng)態(tài)數(shù)據(jù)源
     * @Primary這個(gè)注解很重要，如果項(xiàng)目中存在多個(gè)SqlSessionFactory，這個(gè)注解一定要加上
     */
    @Primary
    @Bean("sqlSessionFactory2")
    public SqlSessionFactory sqlSessionFactoryBean(DynamicDataSource dynamicDataSource) throws Exception {
        SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();
        sqlSessionFactoryBean.setDataSource(dynamicDataSource);
        org.apache.ibatis.session.Configuration configuration = new org.apache.ibatis.session.Configuration();
        configuration.setMapUnderscoreToCamelCase(true);
        configuration.setDefaultFetchSize(100);
        configuration.setDefaultStatementTimeout(30);
        sqlSessionFactoryBean.setConfiguration(configuration);
        return sqlSessionFactoryBean.getObject();
    }

/**
     * 重寫(xiě)事務(wù)管理器，管理動(dòng)態(tài)數(shù)據(jù)源
     */
    @Primary
    @Bean(value = "transactionManager2")
    public PlatformTransactionManager annotationDrivenTransactionManager(DynamicDataSource dataSource) {
        return new DataSourceTransactionManager(dataSource);
    }

//不開(kāi)啟事務(wù)
    @Transactional(propagation = Propagation.NOT_SUPPORTED)
    //切換到HIS的數(shù)據(jù)源
    @SwitchSource
    @Override
    public List<DeptInfo> list() {
        return hisDeptInfoMapper.listDept();
    }