不会吧！ 现在还有搜索springboot mybatis配置多数据源不能用吧

废话不多说,直接上代码

数据源1：

import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.SqlSessionTemplate;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.boot.jdbc.DataSourceBuilder;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;

import javax.sql.DataSource;

/**
 * 数据源配置
 * @author clx
 * @createDate 2020/11/3
 */
@Configuration 
@MapperScan(basePackages = "com.qianqu.book.mapper", sqlSessionFactoryRef = "db1SqlSessionFactory")
public class DataSourceConfig1 {
    // 表示这个数据源是默认数据源, 这个注解必须要加，因为不加的话spring将分不清楚那个为主数据源（默认数据源）
    @Primary
    @Bean("db1DataSource")
    //这段是拿配置文件上面配置
    @ConfigurationProperties(prefix = "spring.datasource.db1")
    public DataSource getDb1DataSource(){
        return DataSourceBuilder.create().build();
    }



    @Primary
    @Bean("db1SqlSessionFactory")
    public SqlSessionFactory db1SqlSessionFactory(@Qualifier("db1DataSource") DataSource dataSource) throws Exception {
        SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
       
        org.apache.ibatis.session.Configuration configurationDb1 = new org.apache.ibatis.session.Configuration();
        configurationDb1.setDefaultStatementTimeout(30);
        configurationDb1.setMapUnderscoreToCamelCase(true);
        configurationDb1.setLogImpl(org.apache.ibatis.logging.stdout.StdOutImpl.class);

        bean.setDataSource(dataSource);
        bean.setConfiguration(configurationDb1);
        // mapper的xml形式文件位置必须要配置，不然将报错：no statement （这种错误也可能是mapper的xml中，namespace与项目的路径不一致导致）
        bean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath*:mapper/book/*/*.xml"));
        return bean.getObject();
    }

    @Primary
    @Bean("db1SqlSessionTemplate")
    public SqlSessionTemplate db1SqlSessionTemplate(@Qualifier("db1SqlSessionFactory") SqlSessionFactory sqlSessionFactory){
        return new SqlSessionTemplate(sqlSessionFactory);
    }
}

数据源2：

import org.apache.ibatis.plugin.Interceptor;
import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.SqlSessionTemplate;
import org.mybatis.spring.annotation.MapperScan;
import org.mybatis.spring.boot.autoconfigure.MybatisProperties;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.boot.jdbc.DataSourceBuilder;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;
import org.springframework.transaction.PlatformTransactionManager;

import com.github.pagehelper.PageInterceptor;

import java.util.Properties;

import javax.sql.DataSource;

/**
 * 数据源配置
 * @author clx
 * @createDate 2020/11/3
 */
@Configuration 
@MapperScan(basePackages = "com.qianqu.book.basicdata", sqlSessionFactoryRef = "db2SqlSessionFactory")
public class DataSourceConfig2 {

    @Bean("db2DataSource")
    @ConfigurationProperties(prefix = "spring.datasource.db2")
    public DataSource getDb2DataSource(){
        return DataSourceBuilder.create().build();
    }




    // TODO : 多数据源事务管理器
    @Bean(name = "memberTransactionManager")
    public DataSourceTransactionManager  memberTransactionManager(@Qualifier("db2DataSource") DataSource dataSource) {
        return new DataSourceTransactionManager(dataSource);
    }
    @Bean("db2SqlSessionFactory")
    public SqlSessionFactory db2SqlSessionFactory(@Qualifier("db2DataSource") DataSource dataSource) throws Exception {
        SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
        org.apache.ibatis.session.Configuration configurationDb2 = new org.apache.ibatis.session.Configuration();
        configurationDb2.setDefaultStatementTimeout(30);
        configurationDb2.setMapUnderscoreToCamelCase(true);
        configurationDb2.setLogImpl(org.apache.ibatis.logging.stdout.StdOutImpl.class);

        bean.setDataSource(dataSource);
        bean.setConfiguration(configurationDb2);
        bean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath*:mapper/basedata/*/*.xml"));
        
        //分页插件
        //Interceptor interceptor = new PageInterceptor();
        //Properties properties = new Properties();
        //properties.setProperty("helperDialect", "mysql");
        //properties.setProperty("offsetAsPageNum", "true");
        //properties.setProperty("rowBoundsWithCount", "true");
        //properties.setProperty("reasonable", "true");
        //properties.setProperty("supportMethodsArguments","true");
        //properties.setProperty("params","pageNum=pageNumKey;pageSize=pageSizeKey;");
        //interceptor.setProperties(properties);
        //bean.setPlugins(new Interceptor[] {interceptor});
        
        
        return bean.getObject();
    }

    @Bean("db2SqlSessionTemplate")
    public SqlSessionTemplate db2SqlSessionTemplate(@Qualifier("db2SqlSessionFactory") SqlSessionFactory sqlSessionFactory){
        return new SqlSessionTemplate(sqlSessionFactory);
    }
}

yml 数据源配置

spring:
  datasource:
    db1: # 数据源1配置
      jdbc-url: 
      username: 
      password: 
      driver-class-name: com.mysql.cj.jdbc.Driver
       #初始化链接数量
      initialSize: 
    #最小空闲链接数
      minIdle: 
     #最大并发连接数
      maxActive: 
    #获取链接等待超时的时间
      maxWait: 
    #配置间隔多久才进行一次检测,检测需要关闭的空闲链接,单位是毫秒
      timeBetweenEvictionRunsMillis: 
    db2: # 数据源2配置
      jdbc-url: jdbc:mysql://47.108.67.104:3306/qq_basic_data?useUnicode=true&characterEncoding=utf-8&useSSL=true&serverTimezone=UTC
      username:
      password: 
      driver-class-name: com.mysql.cj.jdbc.Driver
       #初始化链接数量
      initialSize: 
    #最小空闲链接数
      minIdle: 
     #最大并发连接数
      maxActive: 
    #获取链接等待超时的时间
      maxWait: 
    #配置间隔多久才进行一次检测,检测需要关闭的空闲链接,单位是毫秒
      timeBetweenEvictionRunsMillis: 

@ConfigurationProperties(prefix = "spring.datasource.(这里拿到的就是yml上数据源配置)") @MapperScan(basePackages = "com.qianqu.book.basicdata(maaper Dao层目录位置)", sqlSessionFactoryRef = "db2SqlSessionFactory" (这是被管理的数据源对象));

经常用mybatis的都知道在执行sql 的时候的都会有一个sqlSessionFactory对象在管理

bean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath*:mapper/basedata//.xml")); 这是改mapper.xml 的目录位置

select 
    (查询参数)
 from
    表名 a，数据源2(库名).表名 b
where
    a.(参数) = b.(参数)
 
 
 
如果数据源2 想查询2和1的数据
select 
    (查询参数)
 from
    表名 a，数据源1(库名).表名 b
where
    a.(参数) = b.(参数)
 
重要部分在于from