注解切换双数据源

使用注解，调取相应的库

application.yml配置：

spring:
    datasource:
        url: jdbc:sqlite:/appservice/db/app.db
        driver-class-name: org.sqlite.JDBC
        auto-reconnect: true
        max-active: 50
        test-on-borrow: true
    symbol-datasource:
        url: jdbc:sqlite:/appservice/db/symbol.db
        driver-class-name: org.sqlite.JDBC
        auto-reconnect: true
        max-active: 50
        test-on-borrow: true

添加调取哪个数据源的标记注解，通过注解就能调取相应的库了

 // 1. 主库标记注解
@Target(ElementType.TYPE)
@Retention(RetentionPolicy.RUNTIME)
@Documented
public @interface TargetAppDataSource {
}
//  2. 第二个库的标记注解
@Target(ElementType.TYPE)
@Retention(RetentionPolicy.RUNTIME)
@Documented
public @interface TargetSymbolDataSource {
}

添加数据库配置Java类

  //1. 主库配置AppDbConfig.java
@Configuration
@MapperScan(basePackages = {"com.abc.mapper"}, annotationClass = TargetAppDataSource.class, sqlSessionFactoryRef = "appSqlSessionFactory")
public class AppDbConfig {

    @Bean(name = "appDataSource")
    @Primary
    @ConfigurationProperties(prefix = "spring.datasource")
    public DataSource appDataSource() {
        return DataSourceBuilder.create().build();
    }

    @Bean(name = "appSqlSessionFactory")
    @Primary
    public SqlSessionFactory appSqlSessionFactory(@Qualifier("appDataSource") DataSource appDataSource) throws Exception {
        SqlSessionFactoryBean sessionFactoryBean = new SqlSessionFactoryBean();
        sessionFactoryBean.setDataSource(appDataSource());
        sessionFactoryBean.setTypeAliasesPackage("com.abc.domain");
        return sessionFactoryBean.getObject();
    }
}

 // 2. 第二个库的配置Java类SymbolDbConfig.java
@Configuration
@MapperScan(basePackages = {"com.abc.mapper"}, annotationClass = TargetSymbolDataSource.class, sqlSessionFactoryRef = "symbolSqlSessionFactory")
public class SymbolDbConfig {

    @Bean(name = "symbolDataSource")
    @ConfigurationProperties(prefix = "spring.symbol-datasource")
    public DataSource symbolDataSource(){
        return DataSourceBuilder.create().build();
    }

    @Bean(name = "symbolSqlSessionFactory")
    public SqlSessionFactory symbolSqlSessionFactory(@Qualifier("symbolDataSource") DataSource symbolDataSource) throws Exception {
        SqlSessionFactoryBean sessionFactoryBean = new SqlSessionFactoryBean();
        sessionFactoryBean.setDataSource(symbolDataSource());
        sessionFactoryBean.setTypeAliasesPackage("com.abc.domain");
        return sessionFactoryBean.getObject();
    }    
}

使用注解，调取相应的库

//  1.使用App库
@TargetAppDataSource
public interface AppDao {
……
}

//  2. 使用Symbol库
@TargetSymbolDataSource
public interface SymbolFileDao {
……
}

请参考下方

SpringBoot2实现多数据源及分布式事务