看完这篇，搞定SpringBoot多数据源

最新推荐文章于 2025-07-14 21:26:40 发布

原创最新推荐文章于 2025-07-14 21:26:40 发布 · 491 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mybatis #java #spring

Spring系列专栏收录该内容

3 篇文章

订阅专栏

本文介绍了如何在Spring Boot中配置多个数据源，并结合MyBatis进行数据库操作。通过创建不同的数据源配置类，分别设置platform和mall数据源，以及对应的MyBatis配置，实现了对不同数据库的查询。最后通过测试类验证了多数据源查询的正确性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

添加多数据源配置

spring.datasource.platform.jdbc-url=jdbc:mysql://localhost:3306/platform
spring.datasource.platform.username=root
spring.datasource.platform.password=root
spring.datasource.platform.driver-class-name=com.mysql.cj.jdbc.Driver

spring.datasource.mall.jdbc-url=jdbc:mysql://localhost:3306/mall
spring.datasource.mall.username=root
spring.datasource.mall.password=root
spring.datasource.mall.driver-class-name=com.mysql.cj.jdbc.Driver

mybatis.mapper-locations=classpath:mapper/**.xml

初始化数据源与mybatis配置

新建一个多数据源的配置类

@Configuration
public class DataSourceConfig {

    @Primary
    @Bean
    @ConfigurationProperties(prefix = "spring.datasource.platform")
    public DataSource platformDataSource() {
        return DataSourceBuilder.create().build();
    }

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

分别创建两个数据源的mybatis配置

platform数据源JPA配置

@Configuration
@MapperScan(basePackages = "com.example.refreshcommodity.mapper.platform",
            sqlSessionFactoryRef = "sqlSessionFactoryPlatform",
            sqlSessionTemplateRef = "sqlSessionTemplatePlatform")
public class PlatformConfig {
    private DataSource platformDataSource;

    public PlatformConfig(@Qualifier("platformDataSource") DataSource platformDataSource) {
        this.platformDataSource = platformDataSource;
    }

    @Bean
    public SqlSessionFactory sqlSessionFactoryPlatform() throws Exception {
        SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
        bean.setDataSource(platformDataSource);
        bean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath*:mapper/platform/*.xml"));
        return bean.getObject();
    }

    @Bean
    public SqlSessionTemplate sqlSessionTemplatePlatform() throws Exception {
        return new SqlSessionTemplate(sqlSessionFactoryPlatform());
    }
}

mall数据源JPA配置

@Configuration
@MapperScan(basePackages = "com.example.refreshcommodity.mapper.mall",
            sqlSessionFactoryRef = "sqlSessionFactoryMall",
            sqlSessionTemplateRef = "sqlSessionTemplateMall")
public class MallConfig {
    private DataSource mallDataSource;

    public MallConfig(@Qualifier("mallDataSource") DataSource mallDataSource) {
        this.mallDataSource = mallDataSource;
    }

    @Bean
    public SqlSessionFactory sqlSessionFactoryMall() throws Exception {
        SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
        bean.setDataSource(mallDataSource);
        bean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath*:mapper/mall/*.xml"));
        return bean.getObject();
    }

    @Bean
    public SqlSessionTemplate sqlSessionTemplateMall() throws Exception {
        return new SqlSessionTemplate(sqlSessionFactoryMall());
    }
}

创建mapper接口

在com.example.refreshcommodity.mapper.mall目录下创建mall数据源的接口
在com.example.refreshcommodity.mapper.platform目录下创建platform数据源的接口

最后的目录结构如下：

测试

编写测试类验证
MallMapper.java代码

public interface MallMapper {

    List<Map<String,Object>> getSchoolList();
    
}

MallMapper.xml代码

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.example.refreshcommodity.mapper.mall.MallMapper">
    
    <select id="getSchoolList" resultType="java.util.Map" parameterType="java.util.List">
        select * from school
    </select>
    
</mapper>

PlatformMapper.java代码

public interface PlatformMapper {

    List<Map<String,Object>> getUserList();
    
}

PlatformMapper.xml代码

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.example.refreshcommodity.mapper.platform.PlatformMapper">

    <select id="getUserList" resultType="java.util.Map" parameterType="java.util.List">
        select * from user
    </select>
    
</mapper>

MyController.java代码

@RestController
public class MyController {

    @Autowired
    PlatformMapper platformMapper;
    @Autowired
    MallMapper mallMapper;

    @GetMapping("/test")
    public String test() {
        List<Map<String, Object>> schoolList = mallMapper.getSchoolList();
        List<Map<String, Object>> userList = platformMapper.getUserList();
        Map<String, Object> result = new HashMap<>();
        result.put("schoolList", schoolList);
        result.put("userList", userList);
        return result.toString();
    }

}

测试结果

{
	"schoolList": [{
		"address": "北京市三里屯",
		"name": "清华附属小学",
		"id": 1
	}],
	"userList": [{
		"name": "小明",
		"id": 1,
		"age": 10
	}]
}

可以看到实现了多数据源的查询