1、在application.properties添加数据源配置
# 配置多数据源
spring.datasource.db1.url=jdbc:mysql://127.0.0.1:3306/test1
spring.datasource.db1.username=root
spring.datasource.db1.password=admin
# 使用druid数据源
spring.datasource.db1.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.db1.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.db1.max-idle=10
spring.datasource.db1.max-wait=10000
spring.datasource.db1.min-idle=5
spring.datasource.db1.initial-size=5
# 第二个数据库
spring.datasource.db2.url=jdbc:mysql://127.0.0.1:3306/test2
spring.datasource.db2.username=root
spring.datasource.db2.password=admin
spring.datasource.db2.driver-class-name=com.mysql.jdbc.Driver
2、建立数据源配置文件
设置第一个为默认数据源,使用 @Primary 注解,多个数据源必须设置一个
package com.test.spike.datasources.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.boot.autoconfigure.jdbc.DataSourceBuilder;
import org.springframework.boot.context.properties.ConfigurationProperties;
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 javax.sql.DataSource;
@Configuration
@MapperScan(basePackages = "com.test.spike.dao", sqlSessionFactoryRef = "db1SqlSessionFactory")
public class DataSourceConfig1 {
@Bean(name="db1DataSource")
// 默认数据源
@Primary
// 读取配置文件
@ConfigurationProperties(prefix="spring.datasource.db1")
public DataSource getDataSource() {
return DataSourceBuilder.create().build();
}
@Bean(name="db1SqlSessionFactory")
@Primary
// @Qualifier表示查找Spring容器中名字为test1DataSource的对象
public SqlSessionFactory db1SqlSessionFactory(@Qualifier("db1DataSource") DataSource datasource) throws Exception {
SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
bean.setDataSource(datasource);
// 设置mybatis的xml所在位置
bean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath*:com/test/spike/dao/mapper/*.xml"));
return bean.getObject();
}
@Bean(name="db1SqlSessionTemplate")
@Primary
public SqlSessionTemplate db1SqlSessionTemplate(@Qualifier("db1SqlSessionFactory") SqlSessionFactory sessionfactory) {
return new SqlSessionTemplate(sessionfactory);
}
}
第二个数据源
package com.test.spike.datasources.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.boot.autoconfigure.jdbc.DataSourceBuilder;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
import javax.sql.DataSource;
@Configuration
@MapperScan(basePackages = "com.test.spike.db2", sqlSessionFactoryRef = "db2SqlSessionFactory")
public class DataSourceConfig2 {
@Bean(name="db2DataSource")
// 读取配置文件
@ConfigurationProperties(prefix="spring.datasource.db2")
public DataSource getDataSource() {
return DataSourceBuilder.create().build();
}
@Bean(name="db2SqlSessionFactory")
// @Qualifier表示查找Spring容器中名字为test1DataSource的对象
public SqlSessionFactory db2SqlSessionFactory(@Qualifier("db2DataSource") DataSource datasource) throws Exception {
SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
bean.setDataSource(datasource);
// 设置mybatis的xml所在位置
bean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath*:com/test/spike/db2/*.xml"));
return bean.getObject();
}
@Bean(name="db2SqlSessionTemplate")
public SqlSessionTemplate db2SqlSessionTemplate(@Qualifier("db2SqlSessionFactory") SqlSessionFactory sessionfactory) {
return new SqlSessionTemplate(sessionfactory);
}
}
注意:使用此方法解决多数据源,dao层代码不能嵌套,嵌套后,默认数据源访问正常,其他数据源访问会报
invalid bound statement (not found)
经过一番折腾,参考各种文档的解释,最后找到了一种解决办法。因为将dao和mybatis的映射文件都放在了嵌套的目录里,所以在spring扫描的时候,记录了首次扫描到dao的方法,然后使用首次扫描到dao的方法,调用其他路径的映射文件时,就会提示无法找到映射文件的方法。
解决办法就是将不同的数据源dao层文件进行归类存放,各自的数据库配置放各自的目录
目录结构