1.新建spring boot项目,sqlserver数据库的话,依赖可能无法下载,需要手动下载并且引入的maven项目中,其他数据库类型,直接在pom中引入即可。
2.项目结构
3.配置文件application.properties:
server.port=8894
#主库的配置
spring.datasource.config.jdbc-url=jdbc:sqlserver://127.0.0.1:1433;DatabaseName=config
spring.datasource.config.driver-class-name=com.microsoft.sqlserver.jdbc.SQLServerDriver
spring.datasource.config.username=sa
spring.datasource.config.password=123456
#次库
spring.datasource.factory.jdbc-url=jdbc:sqlserver://127.0.0.1:1433;DatabaseName=factory
spring.datasource.factory.driver-class-name=com.microsoft.sqlserver.jdbc.SQLServerDriver
spring.datasource.factory.username=sa
spring.datasource.factory.password=123456
4.主库和从库配置说明
package com.sheng.multipledatasources.config;
import javax.sql.DataSource;
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.core.io.support.PathMatchingResourcePatternResolver;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;
/**
* @Author: Mr sheng.z
* @Description:
* @Date: Create in 14:25 2019/6/21
*/
@Configuration//注册到springboot容器
//扫描包需要执行的数据源
@MapperScan(basePackages = {"com.sheng.multipledatasources.configdao"}, sqlSessionFactoryRef = "configSqlSessionFactory")
public class DataSourceConfig {
//注入到这个容器
@Bean(name = "configDataSource")
/**
* 表示取application.properties配置文件中的前缀
*/
@ConfigurationProperties(prefix =