Java实现双数据源（库、表）

本文已参与「新人创作礼」活动，一起开启掘金创作之路。

1. 创建一个springboot项目
2. 引入pom依赖

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.21</version>
        </dependency>

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

3. yml文件配置两个数据源

spring:
  datasource:
    # 配置主数据库
    primary:
      jdbc-url: jdbc:mysql://localhost:3306/boot-shiro?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC&useSSL=false
      username: root
      password: 123456
      driver-class-name: com.mysql.jdbc.Driver

    # 配置次数据库
    secondary:
      jdbc-url: jdbc:mysql://localhost:3306/how2java?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC&useSSL=false
      username: root
      password: 123456
      driver-class-name: com.mysql.jdbc.Driver

4. 创建主数据源配置类

@Configuration
@MapperScan(basePackages = "com.xlj.datasource.dao.one", sqlSessionFactoryRef = "PrimarySqlSessionFactory")    // 配置mybatis的接口类放的地方
public class PrimaryDataSourceConfig {

    @Primary    // 表示这个数据源是默认数据源
    @Bean(name = "PrimaryDataSource")   // 将这个对象放入Spring容器中
    @ConfigurationProperties(prefix = "spring.datasource.primary")  // 读取application.properties中的配置参数映射成为一个对象
    public DataSource getPrimaryDateSource() {
        return DataSourceBuilder.create().build();
    }

    @Primary
    @Bean(name = "PrimarySqlSessionFactory")
    // @Qualifier表示查找Spring容器中名字为test1DataSource的对象
    public SqlSessionFactory primarySqlSessionFactory(@Qualifier("PrimaryDataSource") DataSource datasource) throws Exception {
        SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
        bean.setDataSource(datasource);
        return bean.getObject();
    }

    @Primary
    @Bean(name = "PrimarySqlSessionTemplate")
    public SqlSessionTemplate primarySqlSessionTemplate(@Qualifier("PrimarySqlSessionFactory") SqlSessionFactory sessionfactory) {
        return new SqlSessionTemplate(sessionfactory);
    }
}

5. 创建次数据源配置类

@Configuration
@MapperScan(basePackages = "com.xlj.datasource.dao.two", sqlSessionFactoryRef = "SecondarySqlSessionFactory")
public class SecondaryDataSourceConfig {

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

    @Bean(name = "SecondarySqlSessionFactory")
    public SqlSessionFactory secondarySqlSessionFactory(@Qualifier("SecondaryDataSource") DataSource datasource) throws Exception {
        SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
        bean.setDataSource(datasource);
        return bean.getObject();
    }

    @Bean(name = "SecondarySqlSessionTemplate")
    public SqlSessionTemplate secondarySqlSessionTemplate(@Qualifier("SecondarySqlSessionFactory") SqlSessionFactory sessionfactory) {
        return new SqlSessionTemplate(sessionfactory);
    }
}

6. 编写主配置类对应的接口（此处使用注解方式编写sql，注意与主配置的basePackages对应）

@Mapper
public interface DatasourceOne {
    @Insert("insert into data_test (name) values (\"test\")")
    void insert();
}

7. 编写次配置类对应的接口（此处使用注解方式编写sql，注意与主配置的basePackages对应）

@Mapper
public interface DatasourceTwo {
    @Insert(" insert into data_test (name) values (\"test\")")
    void insert();
}

8. controller调用接口

@RestController
public class DataSourceController {
    @Resource
    private DatasourceOne datasourceOne;

    @Resource
    private DatasourceTwo datasourceTwo;

    @GetMapping(value = "/insertOne")
    public void insertOne(){
        datasourceOne.insert();
    }

    @GetMapping(value = "/insertTwo")
    public void insertTwo(){
        datasourceTwo.insert();
    }
}

9. 启动springboot主main方法，进行接口测试