SpringBoot + Mybatis多数据源

一、配置文件

spring:
#  datasource:
#    username: root
#    password: 123456
#    url: jdbc:mysql://127.0.0.1:3306/jun01?characterEncoding=utf-8&serverTimezone=UTC
#    driver-class-name: com.mysql.cj.jdbc.Driver
  datasource:
    # 数据源1
    onedata:
      jdbc-url: jdbc:mysql://127.0.0.1:3306/jun01?useUnicode=true&characterEncoding=utf-8
      username: root
      password: 123456
      driver-class-name: com.mysql.cj.jdbc.Driver
    # 数据源2
    twodata:
      jdbc-url: jdbc:mysql://127.0.0.1:3306/jun02?useUnicode=true&characterEncoding=utf-8
      username: root
      password: 123456
      driver-class-name: com.mysql.cj.jdbc.Driver

二、数据源配置类

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 javax.sql.DataSource;

@Configuration
public class DataSourceConfiguration {

    // Primary 注解是在没有指明使用哪个数据源的时候指定默认使用的主数据源
    @Primary
    @Bean("oneDataSource")
    @ConfigurationProperties(prefix = "spring.datasource.onedata")
    public DataSource primaryDataSource() {
        return DataSourceBuilder.create().build();
    }

    @Bean("twoDataSource")
    @ConfigurationProperties(prefix = "spring.datasource.twodata")
    public DataSource secondaryDataSource() {
        return DataSourceBuilder.create().build();
    }
}

三、数据源与 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.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;

import javax.annotation.Resource;
import javax.sql.DataSource;

@Configuration
// 指定该数据源扫描指定包下面的Mapper接口 与 *.xml文件
@MapperScan(
        basePackages = "com.south.mapper1",
        sqlSessionFactoryRef = "sqlSessionFactoryOne",
        sqlSessionTemplateRef = "sqlSessionTemplateOne")
public class DataSourceOneConfig {

    // 注入数据源1
    @Resource
    private DataSource oneDataSource;

    @Bean
    @Primary
    public SqlSessionFactory sqlSessionFactoryOne() throws Exception {
        SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();
        sqlSessionFactoryBean.setDataSource(oneDataSource);
        return sqlSessionFactoryBean.getObject();
    }

    @Bean
    @Primary
    public SqlSessionTemplate sqlSessionTemplateOne() throws Exception {
        return new SqlSessionTemplate(sqlSessionFactoryOne());
    }
}

2、数据源二(两种不同的配置方式,都能实现多数据源的效果)

import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.core.io.Resource;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;

import javax.sql.DataSource;

@Configuration
@MapperScan(
        basePackages = "com.example.mapper2",
        sqlSessionFactoryRef = "sqlSessionFactoryTwo")
public class DataSourceTwoConfig {

    // mapper 扫描 xml 文件的路径
    private static final String MAPPER_LOCATION = "classpath:mapper2/*.xml";

    private DataSource twoDataSource;

    // 通过构造方法进行注入
    public DataSourceTwoConfig(DataSource dataSource) {
        this.twoDataSource = dataSource;
    }

    @Bean
    public SqlSessionFactory sqlSessionFactoryTwo() throws Exception {
        SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();
        // 指定数据源
        sqlSessionFactoryBean.setDataSource(twoDataSource);
        /*
		 * 获取xml文件资源对象
		 * 当Mapper接口所对应的.xml文件与Mapper接口文件分离,存储在 resources
		 * 文件夹下的时候,需要手动指定.xml文件所在的路径
		 */
        Resource[] resources = new PathMatchingResourcePatternResolver().getResources(MAPPER_LOCATION);
        sqlSessionFactoryBean.setMapperLocations(resources);
        return sqlSessionFactoryBean.getObject();
    }

    @Bean
    public DataSourceTransactionManager SecondaryDataSourceManager() {
        return new DataSourceTransactionManager(twoDataSource);
    }
}

四、使用案例

import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;

import javax.annotation.Resource;
import java.util.List;

@Controller
@RequestMapping("/testController")
public class TestController {

    // 数据源1Mapper注入
    @Resource
    private OneMapper oneMapper;

    // 数据源2Mapper注入
    @Resource
    private TwoMapper twoMapper;

    @GetMapping("/selectManyDataSouroneMapperceData")
    @ResponseBody
    public void selectManyDataSourceDatwoMapperta() {

        // 查询数据源1中的数据
        List<String> message = oneMapper.getMessage();
        System.out.println(message);

        // 查询数据源2中的数据
        List<String> tag = twoMapper.getTag();
        System.out.println(tag);
    }
}

 

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
在Spring Boot中使用MyBatis实现多数据源配置,可以通过以下步骤实现: 1. 在`application.properties`文件中配置多个数据源的连接信息,例如: ``` # 数据源1 spring.datasource.primary.url=jdbc:mysql://localhost:3306/db1 spring.datasource.primary.username=user1 spring.datasource.primary.password=pass1 spring.datasource.primary.driver-class-name=com.mysql.jdbc.Driver # 数据源2 spring.datasource.secondary.url=jdbc:mysql://localhost:3306/db2 spring.datasource.secondary.username=user2 spring.datasource.secondary.password=pass2 spring.datasource.secondary.driver-class-name=com.mysql.jdbc.Driver ``` 2. 创建多个数据源的配置类,分别继承`org.springframework.boot.autoconfigure.jdbc.DataSourceProperties`类,并使用`@ConfigurationProperties`注解来注入对应的配置信息,例如: ```java @Configuration public class PrimaryDataSourceConfig extends DataSourceProperties { @Bean @Primary public DataSource dataSource() { return createDataSource(); } private DataSource createDataSource() { return DataSourceBuilder.create().url(getUrl()) .username(getUsername()).password(getPassword()) .driverClassName(getDriverClassName()).build(); } } @Configuration public class SecondaryDataSourceConfig extends DataSourceProperties { @Bean public DataSource dataSource() { return createDataSource(); } private DataSource createDataSource() { return DataSourceBuilder.create().url(getUrl()) .username(getUsername()).password(getPassword()) .driverClassName(getDriverClassName()).build(); } } ``` 3. 创建多个`SqlSessionFactory`,并分别注入对应的数据源,例如: ```java @Configuration @MapperScan(basePackages = "com.example.mapper.primary", sqlSessionFactoryRef = "primarySqlSessionFactory") public class PrimaryMyBatisConfig { @Bean @Primary public SqlSessionFactory primarySqlSessionFactory(@Qualifier("primaryDataSource") DataSource dataSource) throws Exception { SqlSessionFactoryBean sessionFactoryBean = new SqlSessionFactoryBean(); sessionFactoryBean.setDataSource(dataSource); return sessionFactoryBean.getObject(); } } @Configuration @MapperScan(basePackages = "com.example.mapper.secondary", sqlSessionFactoryRef = "secondarySqlSessionFactory") public class SecondaryMyBatisConfig { @Bean public SqlSessionFactory secondarySqlSessionFactory(@Qualifier("secondaryDataSource") DataSource dataSource) throws Exception { SqlSessionFactoryBean sessionFactoryBean = new SqlSessionFactoryBean(); sessionFactoryBean.setDataSource(dataSource); return sessionFactoryBean.getObject(); } } ``` 4. 在`Mapper`接口上使用`@Qualifier`注解指定对应的`SqlSessionFactory`,例如: ```java @Mapper public interface PrimaryUserMapper { @Select("SELECT * FROM user") @Results(id = "userMap", value = { @Result(property = "id", column = "id"), @Result(property = "name", column = "name") }) List<User> findAll(); @Insert("INSERT INTO user(name) VALUES(#{name})") @Options(useGeneratedKeys = true, keyProperty = "id") void save(User user); } @Mapper public interface SecondaryUserMapper { @Select("SELECT * FROM user") @Results(id = "userMap", value = { @Result(property = "id", column = "id"), @Result(property = "name", column = "name") }) List<User> findAll(); @Insert("INSERT INTO user(name) VALUES(#{name})") @Options(useGeneratedKeys = true, keyProperty = "id") void save(User user); } ``` 这样就可以在同一个应用中使用多个数据源了。

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值