SpringBoot-Mybatis 配置双数据源

SpringBoot-Mybatis 配置双数据源

SpringBoot -Mybatis 配置双数据源！

Demo简介

• 本地两个数据库multi_datasource_mybatis_demo_db_01& multi_datasource_mybatis_demo_db_01
• 两个数据库分别含有一张表user&activity’
• 功能： 增加&查询

构建数据库

multi_datasource_mybatis_demo_db_01

建user表：

create table user (
    `id` bigint  unsigned not null auto_increment,
    `username` varchar(50) not null,
    `password` varchar(50) not null,
    `gmt_create` datetime default current_timestamp,
    `gmt_modified` datetime default current_timestamp  on update  current_timestamp,
    primary key(`id`)
)engine=InnoDB default charset =utf8;

multi_datasource_mybatis_demo_db_02

建activity表：

create  table  activity (
    `id` bigint unsigned not null auto_increment,
    `activity_id` varchar(50) not null,
    `activity_name` varchar(50) not null,
    `gmt_create` datetime default current_timestamp ,
    `gmt_modified` datetime default current_timestamp on update current_timestamp,
    primary key(`id`)
)engine=InnoDB default charset =utf8;

构建SpringBoot项目添加Mybatis 依赖和MySql 驱动

 <!-- https://mvnrepository.com/artifact/org.mybatis.spring.boot/mybatis-spring-boot-starter -->
 
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.3.2</version>
        </dependency>
        <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.38</version>
        </dependency>

目录结构如图所示

[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-SpiMzNea-1601457821688)(D:%5CUsers%5CFangJunXiong%5CPictures%5C%E5%8D%9A%E5%AE%A2%E6%88%AA%E5%9B%BE%5Cimage-20200930171229482.png)]

配置数据库信息

#主数据源配置信息
spring.datasource.primary.username=root
spring.datasource.primary.password=password
spring.datasource.primary.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.primary.jdbc-url=jdbc:mysql://localhost:3306/multi_datasource_mybatis_demo_db_01?useUnicode=true\
  &characterEncoding=utf-8&useSSL=false
#副数据源配置信息
spring.datasource.secondary.username=root
spring.datasource.secondary.password=password
spring.datasource.secondary.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.secondary.jdbc-url=jdbc:mysql://localhost:3306/multi_datasource_mybatis_demo_db_02?useUnicode=true\
  &characterEncoding=utf-8&useSSL=false

#mybatis mapper.xml 位置信息配置
mybatis.primary.mapper-locations=classpath:/mapper/primary/*.xml
mybatis.sceondary.config-locations=classpath:/mapper/secondary/*.xml

编写配置类PrimaryDBConfig&SecondaryDBConfig 类

• PrimaryDBConfig 类

package cn.wsharkcoder.multi_datasource_mybatis_demo.config;

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.beans.factory.annotation.Value;
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 org.springframework.jdbc.datasource.DataSourceTransactionManager;

import javax.sql.DataSource;

/**
 * @Author WSharkCoder
 * @Date 2020/9/30 15:49
 * @Version V1.0
 * @ClassName PrimaryDBConfig
 */
@Configuration
@MapperScan(
        basePackages =  "cn.wsharkcoder.multi_datasource_mybatis_demo.dao.primary",//扫描的包
        sqlSessionTemplateRef = "primarySqlSessionTemplate"                         //指定使用Spring容器中SqlSessionTemplate Bean
)
public class PrimaryDBConfig {
    @Value("${mybatis.primary.mapper-locations}")
    private String primaryMapperXMlLocation;
    @Primary
    //  指定默认数据源
    @ConfigurationProperties("spring.datasource.primary")
    //  从Spring抽象环境(主要application.properties 文件中的配置信息)注入DataSource Bean 中
    @Bean(name="primaryDataSource")
    public DataSource  primaryDataSource(){
        return DataSourceBuilder.create().build();
    }
    @Primary
    @Bean(name="primarySqlSessionFactory")
    public SqlSessionFactory primarySqlSessionFactory(@Qualifier("primaryDataSource")DataSource dataSource) throws Exception {
        SqlSessionFactoryBean sqlSessionFactoryBean=new SqlSessionFactoryBean();
        sqlSessionFactoryBean.setDataSource(dataSource);

        sqlSessionFactoryBean.setMapperLocations(
                new PathMatchingResourcePatternResolver().getResources(
                        primaryMapperXMlLocation
                )
        );
        return sqlSessionFactoryBean.getObject();
    }

    @Primary
    @Bean("primaryDataSourceTransactionManager")
    public DataSourceTransactionManager primaryDataSourceTransactionManager(@Qualifier("primaryDataSource") DataSource dataSource) {
        return new DataSourceTransactionManager(dataSource);
    }

    @Primary
    @Bean(name = "primarySqlSessionTemplate")
    public SqlSessionTemplate primarySqlSessionTemplate(@Qualifier("primarySqlSessionFactory") SqlSessionFactory sqlSessionFactory) {
        return new SqlSessionTemplate(sqlSessionFactory);
    }

}

• SecondaryDBConfig类

package cn.wsharkcoder.multi_datasource_mybatis_demo.config;

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.beans.factory.annotation.Value;
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 org.springframework.jdbc.datasource.DataSourceTransactionManager;

import javax.sql.DataSource;

/**
 * @Author WSharkCoder
 * @Date 2020/9/30 15:49
 * @Version V1.0
 * @ClassName PrimaryDBConfig
 */
@Configuration
@MapperScan(
        basePackages =  "cn.wsharkcoder.multi_datasource_mybatis_demo.dao.secondary",//扫描的包
        sqlSessionTemplateRef = "secondarySqlSessionTemplate"                        //指定使用Spring容器中SqlSessionTemplate Bean
)
public class SecondaryDBConfig {
    @Value("${mybatis.sceondary.config-locations}")
    private String primaryMapperXMlLocation;

//  配置数据源
    @ConfigurationProperties("spring.datasource.secondary")
    @Bean(name="secondaryDataSource")
    public DataSource  primaryDataSource(){
        return DataSourceBuilder.create().build();
    }

//
    @Bean(name="secondarySqlSessionFactory")
    public SqlSessionFactory primarySqlSessionFactory(@Qualifier("secondaryDataSource")DataSource dataSource) throws Exception {
        SqlSessionFactoryBean sqlSessionFactoryBean=new SqlSessionFactoryBean();
        sqlSessionFactoryBean.setDataSource(dataSource);
//      设置mapper.xml映射文件
        sqlSessionFactoryBean.setMapperLocations(
                new PathMatchingResourcePatternResolver().getResources(
                        primaryMapperXMlLocation
                )
        );
        return sqlSessionFactoryBean.getObject();
    }

//  配置事务处理器
    @Bean("secondaryDataSourceTransactionManager")
    public DataSourceTransactionManager primaryDataSourceTransactionManager(@Qualifier("secondaryDataSource") DataSource dataSource) {
        return new DataSourceTransactionManager(dataSource);
    }


    @Bean(name = "secondarySqlSessionTemplate")
    public SqlSessionTemplate primarySqlSessionTemplate(@Qualifier("secondarySqlSessionFactory") SqlSessionFactory sqlSessionFactory) {
        return new SqlSessionTemplate(sqlSessionFactory);
    }

}

注意: @ScanMapper(basePackages ="")Dao接口路径！

Git hub 项目地址