Spring Boot整合多数据源配置详细教程

首先是配置文件

• 我这里使用yml配置文件
• 这里我配置了test1,test2两个数据源，如果想配置更多的数据源，可以继续加即可

application.yml：

spring:
  datasource:
    test1:
        jdbc-url: jdbc:mysql://localhost:3306/test
        username: root
        password: root
        driver-class-name: com.mysql.jdbc.Driver
    test2:
        jdbc-url: jdbc:mysql://localhost:3306/test2
        username: root
        password: root
        driver-class-name: com.mysql.jdbc.Driver

myBatis多数据源配置文件

为每个数据源增加一个SpringBoot配置类
myBatis多数据源的原理是根据不同包，调用不同的数据源，所以只需要把mapper.java和mapper.xml（用注解，可不需要)建立在不同的package下，springboot会自动根据包实现数据源切换。
代码目录结构如下：

• test1数据源配置类DataSource1Config.java:

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.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.jdbc.datasource.DataSourceTransactionManager;

import javax.sql.DataSource;

@Configuration //注册到springboot容器中
@MapperScan(basePackages = "com.multiDatasource.test1",sqlSessionFactoryRef = "test1SqlSessionFactory")
public class DataSource1Config {

    /**
     *
     * @methodDesc: 功能描述:(配置test1数据源)
     */
    @Bean(name = "test1DataSource")
    @Primary
    @ConfigurationProperties(prefix = "spring.datasource.test1")
    public DataSource testDataSource() {
        return DataSourceBuilder.create().build();
    }

    /**
     *
     * @methodDesc: 功能描述:(test1 sql会话工厂)
     */
    @Bean(name = "test1SqlSessionFactory")
    @Primary
    public SqlSessionFactory testSqlSessionFactory(@Qualifier("test1DataSource") DataSource dataSource)
            throws Exception {
        SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
        bean.setDataSource(dataSource);
//		bean.setMapperLocations(
//				new PathMatchingResourcePatternResolver().getResources("classpath:mybatis/mapper/test1/*.xml"));
        return bean.getObject();
    }

    /**
     *
     * @methodDesc: 功能描述:(test1 事物管理)
     */
    @Bean(name = "test1TransactionManager")
    @Primary  //主数据源
    public DataSourceTransactionManager testTransactionManager(@Qualifier("test1DataSource") DataSource dataSource) {
        return new DataSourceTransactionManager(dataSource);
    }

    @Bean(name = "test1SqlSessionTemplate")
    public SqlSessionTemplate testSqlSessionTemplate(
            @Qualifier("test1SqlSessionFactory") SqlSessionFactory sqlSessionFactory) throws Exception {
        return new SqlSessionTemplate(sqlSessionFactory);
    }
}

• test2数据源配置类DataSource2Config.java:

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.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.jdbc.datasource.DataSourceTransactionManager;

import javax.sql.DataSource;

@Configuration //注册到springboot容器中
@MapperScan(basePackages = "com.multiDatasource.test2",sqlSessionFactoryRef = "test2SqlSessionFactory")
public class DataSource2Config {

    /**
     *
     * @methodDesc: 功能描述:(配置test1数据源)
     */
    @Bean(name = "test2DataSource")
    @ConfigurationProperties(prefix = "spring.datasource.test2")
    public DataSource testDataSource() {
        return DataSourceBuilder.create().build();
    }

    /**
     *
     * @methodDesc: 功能描述:(test1 sql会话工厂)
     */
    @Bean(name = "test2SqlSessionFactory")
    public SqlSessionFactory testSqlSessionFactory(@Qualifier("test2DataSource") DataSource dataSource)
            throws Exception {
        SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
        bean.setDataSource(dataSource);
//		bean.setMapperLocations(
//				new PathMatchingResourcePatternResolver().getResources("classpath:mybatis/mapper/test1/*.xml"));
        return bean.getObject();
    }

    /**
     *
     * @methodDesc: 功能描述:(test1 事物管理)
     */
    @Bean(name = "test2TransactionManager")
    public DataSourceTransactionManager testTransactionManager(@Qualifier("test2DataSource") DataSource dataSource) {
        return new DataSourceTransactionManager(dataSource);
    }

    @Bean(name = "test2SqlSessionTemplate")
    public SqlSessionTemplate testSqlSessionTemplate(
            @Qualifier("test2SqlSessionFactory") SqlSessionFactory sqlSessionFactory) throws Exception {
        return new SqlSessionTemplate(sqlSessionFactory);
    }
}

• 在test1包下建立test1数据源的mapper:

import com.multiDatasource.entity.User1;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

//mapper要在启动类中被扫描到才能使用
@Mapper
public interface User1Mapper {

    @Select("SELECT * FROM user_table WHERE username = #{username}")
    User1 findByName(@Param("username") String username);
    @Insert("INSERT INTO USERS(id,username, password) VALUES(5,#{name}, #{pwd})")
    int insert(@Param("name") String name, @Param("pwd") String pwd);

}

mapper文件

• 在test2包下建立test2数据源的mapper:

import com.multiDatasource.entity.User1;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

//mapper要在启动类中被扫描到才能使用
@Mapper
public interface User2Mapper {

    @Select("SELECT * FROM user2 WHERE username = #{username}")
    User1 findByName(@Param("username") String username);
    @Insert("INSERT INTO USERS(id,username, password) VALUES(5,#{name}, #{pwd})")
    int insert(@Param("name") String name, @Param("pwd") String pwd);

}

业务代码

其余service，controller,entity可在同一个package下，也可以分开，我这里都用写在同一个文件进行测试：

• UserService.java:

import com.multiDatasource.entity.User1;
import com.multiDatasource.test1.User1Mapper;
import com.multiDatasource.test2.User2Mapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

@Service
public class UserService {

    @Autowired
    private User1Mapper mapper1;

    @Autowired
    private User2Mapper mapper2;

    public User1 getByMapper1(String name) {
        User1 user = mapper1.findByName(name);
        return user;
    }

    public User1 getByMapper2(String name) {
        User1 user = mapper2.findByName(name);
        return user;
    }
}

• TestController.java:

import com.multiDatasource.entity.User1;
import com.multiDatasource.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

@RestController
@RequestMapping("/find")
public class TestController {


    @Autowired
    private UserService service;

    @RequestMapping("/test1")
    public String find1() {
        User1 user = service.getByMapper1("张三");
        return user.getPassword();
    }

    @RequestMapping("/test2")
    public String find2() {
        User1 user = service.getByMapper2("张三2");
        return user.getPassword();
    }

}

• User1.java:

import org.springframework.stereotype.Component;

@Component
public class User1 {

    private String username;

    private String password;

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }
}

• 项目启动类：

import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;


//标识为springboot启动类,必须是父路径，其他包路径必须是其子路径
@SpringBootApplication(scanBasePackages = {"com.multiDatasource"})
//@ComponentScan(basePackages = "com")
//@MapperScan("com.test1.mapper")//扫描mapper
public class DemoApplication {

    public static void main(String[] args) {

        SpringApplication.run(DemoApplication.class, args);
    }

}

• 启动项目测试，url输入：http://localhost:8080/find/test1
  
  测试数据源2，url输入：http://localhost:8080/find/test2
  

配置成功！