springboot mybatis 多数据源配置

//首先：配置文件 配置数据源local,other为连接名称
spring.datasource.local.url=jdbc:postgresql://6.6.6.666:6666/tc?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8
spring.datasource.local.username=admin
spring.datasource.local.password=666666

spring.datasource.other.url=jdbc:postgresql://1.1.1.1:1111/other?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8
spring.datasource.other.username=admin
spring.datasource.other.password=666666

//驱动：

spring.datasource.driver-class-name=org.postgresql.Driver

配置文件注释掉mybatis 配置：

#mybatis.mapperLocations=classpath:mapper/**/*.xml  //改由各数据源处配置

最后添加第二个数据源的日志层级（如果有）

#日志
logging.config=classpath:logback-spring.xml
#Start logging
logging.level.root=INFO
logging.level.test.business.TC.mapper=debug
logging.level.test.business.other.mapper=debug  //

至此application.properties文件 的  更改  结束

第二关键：Application类注解，启动入口 须移除 自动装载数据源

@SpringBootApplication(exclude =  DataSourceAutoConfiguration.class)

最后奉上数据源配置类：

//从数据源
@Configuration
//@MapperScan为配置此数据源的扫描包
@MapperScan(basePackages = "test.business.other.mapper", sqlSessionTemplateRef  = "otherSqlSessionTemplate")
public class OtherDataSource {

    @Bean(name = "otherData")
//    @Primary
    @ConfigurationProperties(prefix = "spring.datasource.other") // application.properteis中对应属性的前缀
    public DataSource otherData() {
        return DataSourceBuilder.create().build();
    }

    @Bean(name = "otherSqlSessionFactory")
//    @Primary
    public SqlSessionFactory otherSqlSessionFactory(@Qualifier("otherData") DataSource dataSource) throws Exception {
        System.out.println(" ");
        SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
        bean.setDataSource(dataSource);
        bean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath:mapper/other/*.xml"));//xml文件路径
        return bean.getObject();
    }

    @Bean(name = "otherTransactionManager")
//    @Primary
    public DataSourceTransactionManager otherTransactionManager(@Qualifier("otherData") DataSource dataSource) {
        return new DataSourceTransactionManager(dataSource);
    }

    @Bean(name = "otherSqlSessionTemplate")
//    @Primary
    public SqlSessionTemplate otherSqlSessionTemplate(@Qualifier("otherSqlSessionFactory") SqlSessionFactory sqlSessionFactory) throws Exception {
        return new SqlSessionTemplate(sqlSessionFactory);
    }

}

//主数据源类：
@Configuration
@MapperScan(basePackages = "test.business.TC.mapper", sqlSessionTemplateRef  = "tcSqlSessionTemplate")
public class TcDataSource {

    @Bean(name = "tcData")
    @ConfigurationProperties(prefix = "spring.datasource.tc") // application.properteis中对应属性的前缀
    @Primary
    public DataSource tcData() {
        return DataSourceBuilder.create().build();
    }

    @Bean(name = "tcSqlSessionFactory")
    @Primary
    public SqlSessionFactory tcSqlSessionFactory(@Qualifier("tcData") DataSource dataSource) throws Exception {
        SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
        bean.setDataSource(dataSource);
        bean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath:mapper/TC/*.xml"));
        return bean.getObject();
    }

    @Bean(name = "tcTransactionManager")
    @Primary
    public DataSourceTransactionManager sentinelTransactionManager(@Qualifier("tcData") DataSource dataSource) {
        return new DataSourceTransactionManager(dataSource);
    }

    @Bean(name = "tcSqlSessionTemplate")
    @Primary
    public SqlSessionTemplate tcSqlSessionTemplate(@Qualifier("tcSqlSessionFactory") SqlSessionFactory sqlSessionFactory) throws Exception {
        return new SqlSessionTemplate(sqlSessionFactory);
    }
}

类中名称  自行相应改改易于理解的名称就好！