springboot双数据源配置

一个项目里面有多个数据源，配置如下

import javax.sql.DataSource;

import org.springframework.boot.autoconfigure.jdbc.DataSourceBuilder;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;

@Configuration
public class DataSourceConfig {

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

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

}

首先创建数据源，数据库位置信息

其次配置双数据源所需要扫描的实体类以及xml的配置信息

import javax.sql.DataSource;

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.SpringBootVFS;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;

@Configuration
@MapperScan(basePackages = { "com.pactera.vds.member.mapper.second" }, sqlSessionFactoryRef = "sqlSessionFactory1")
public class MybatisDbAConfig {

    @Autowired
    @Qualifier("db2")
    private DataSource db2;

    @Bean
    public SqlSessionFactory sqlSessionFactory1() throws Exception {
        SqlSessionFactoryBean factoryBean = new SqlSessionFactoryBean();
        factoryBean.setDataSource(db2); // 使用titan数据源, 连接titan库
        PathMatchingResourcePatternResolver resolver = new PathMatchingResourcePatternResolver();
        factoryBean.setVfs(SpringBootVFS.class); // 必须这么样设置，否则，不能识别别名
        factoryBean.setTypeAliasesPackage("com.pactera.vds.member.model");
        factoryBean.setMapperLocations(resolver.getResources("classpath:/mybatis/second/*.xml"));
        return factoryBean.getObject();

    }

    @Bean
    public SqlSessionTemplate sqlSessionTemplate1() throws Exception {
        SqlSessionTemplate template = new SqlSessionTemplate(sqlSessionFactory1());
        // 使用上面配置的Factory
        return template;
    }
}

修改信息basePackages = “” 后面的值，标识着mapper位置， factoryBean.setTypeAliasesPackage("com.pactera.vds.member.model");对应着实体对象的包名， factoryBean.setMapperLocations(resolver.getResources("classpath:/mybatis/second/*.xml"));对应这着xml的配置信息，第二个数据源配置同理

import javax.sql.DataSource;

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.SpringBootVFS;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;

@Configuration
@MapperScan(basePackages = { "com.pactera.vds.member.mapper" }, sqlSessionFactoryRef = "sqlSessionFactory2")
public class MybatisDbBConfig {
    @Autowired
    @Qualifier("mysql")
    private DataSource mysql;

    @Bean
    public SqlSessionFactory sqlSessionFactory2() throws Exception {
        SqlSessionFactoryBean factoryBean = new SqlSessionFactoryBean();
        factoryBean.setDataSource(mysql);
        PathMatchingResourcePatternResolver resolver = new PathMatchingResourcePatternResolver();
        factoryBean.setVfs(SpringBootVFS.class); // 必须这么样设置，否则，不能识别别名
        factoryBean.setTypeAliasesPackage("com.pactera.vds.member.model");
        factoryBean.setMapperLocations(resolver.getResources("classpath:/mybatis/*.xml"));
        return factoryBean.getObject();

    }

    @Bean
    public SqlSessionTemplate sqlSessionTemplate2() throws Exception {
        SqlSessionTemplate template = new SqlSessionTemplate(sqlSessionFactory2());
        return template;
    }
}

创建两个包的位置 ： com.pactera.vds.member.mapper；com.pactera.vds.member.mapper.second 

其次创建xml文件位置 ： /member/src/main/resources/mybatis   ；/member/src/main/resources/mybatis/second

最后在配置信息上写一下数据源的信息

spring:
  session:
    store-type: none
  datasource:
    first:  
      url: xxxxxxxxxx
      username: xxxxxxxxxx
      password: xxxxxxxxxx
      driver-class-name: com.mysql.jdbc.Driver
    second: 
      url: xxxxxxxxxx
      username: xxxxxxxxxx
      password: xxxxxxxxxx
      driver-class-name: com.mysql.jdbc.Driver 

driver-class-name 标识驱动

以上就完成了双数据源的信息配置，

package com.pactera.vds.member.mapper;

包里面写文件读取的是数据库mysql 这个数据源