快捷導(dǎo)航

springboot后端配置多個數(shù)據(jù)源、Mysql數(shù)據(jù)庫的便捷方法

更新時間：2021年08月11日 17:36:13 作者：JACKLI71

實現(xiàn)springboot 后端配置多個數(shù)據(jù)源、Mysql數(shù)據(jù)庫，只需要新建 Mapper、實體類相應(yīng)的文件夾，將不同數(shù)據(jù)源的文件保存到對應(yīng)的文件夾下，添加綁定數(shù)據(jù)庫配置Config，就可以輕松完成

1、修改application.properties

新建 Mapper、實體類相應(yīng)的文件夾，將不同數(shù)據(jù)源的文件保存到對應(yīng)的文件夾下

# test1 數(shù)據(jù)庫的配置
test1.spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
test1.spring.datasource.jdbc-url=jdbc:mysql://localhost:3306/database1&#63;useUnicode=true&amp;characterEncoding=utf-8&amp;useSSL=false&amp;serverTimezone=GMT
test1.spring.datasource.username=username
test1.spring.datasource.password=password
# test2 數(shù)據(jù)庫的配置
test2.spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
test2.spring.datasource.jdbc-url=jdbc:mysql://localhost:3306/database2&#63;useUnicode=true&amp;characterEncoding=utf-8&amp;useSSL=false&amp;serverTimezone=GMT
test2.spring.datasource.username=username
test2.spring.datasource.password=password
# 配置 mybatis 配置 mapper.xml 文件路徑mybatis.mapper-locations=classpath:/mapper/*.xml,classpath:/mapper/test1/*.xml,classpath:/mapper/test2/*.xml
# 配置 mybatis 配置 實體類 文件路徑
mybatis.type-aliases-package=com.xxx.entity.test1, com.xxx.entity.test2

2、添加綁定數(shù)據(jù)庫配置Config

1）Test1DataSourceConfig.java

package com.xxx.config.dataSource;
import com.alibaba.druid.pool.DruidDataSource;
import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.beans.factory.annotation.Value;
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;
import javax.sql.DataSource;
/** * @program: test1 主數(shù)據(jù)源配置
* @author: JackLee 
* @create: 2020-08-09 09:30 
* @version: 1.0
**/// 
掃描 Mapper 接口并容器管理
@MapperScan(basePackages = Test1DataSourceConfig.PACKAGE, sqlSessionFactoryRef = "test1SqlSessionFactory")
@Configuration
public class Test1DataSourceConfig {
// 精確到 test1 目錄，以便跟其他數(shù)據(jù)源隔離 
static final String PACKAGE = "com.xxx.dao.test1"; 
static final String MAPPER_LOCATION = "classpath:mapper/test1/*.xml"; 
@Value("${test1.spring.datasource.jdbc-url}") 
private String url; 
@Value("${test1.spring.datasource.username}") 
private String user; 
@Value("${test1.spring.datasource.password}") 
private String password; 
@Value("${test1.spring.datasource.driver-class-name}") 
private String driverClass; 
@Bean(name = "test1DataSource") 
@Primary 
public DataSource test1DataSource() {
DruidDataSource dataSource = new DruidDataSource(); 
dataSource.setDriverClassName(driverClass); 
dataSource.setUrl(url); 
dataSource.setUsername(user); 
dataSource.setPassword(password); 
return dataSource; 
} 
@Bean(name = "test1TransactionManager") 
@Primary 
public DataSourceTransactionManager test1TransactionManager() { 
return new DataSourceTransactionManager(test1DataSource()); 
} 
@Bean(name = "test1SqlSessionFactory") 
@Primary 
public SqlSessionFactory test1SqlSessionFactory(@Qualifier("test1DataSource") DataSource test1DataSource) 
throws Exception { 
final SqlSessionFactoryBean sessionFactory = new SqlSessionFactoryBean(); 
sessionFactory.setDataSource(test1DataSource); 
sessionFactory.setMapperLocations(new PathMatchingResourcePatternResolver() 
.getResources(Test1DataSourceConfig.MAPPER_LOCATION)); 
return sessionFactory.getObject(); 
}

}

2）Test2DataSourceConfig.java

package com.xxx.config.dataSource;
import com.alibaba.druid.pool.DruidDataSource;
import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;
import javax.sql.DataSource;
/** 
* @program: test2 其他數(shù)據(jù)源配置 
* @author: JackLee 
* @create: 2020-08-09 09:30 
* @version: 1.0 
**/
// 掃描 Mapper 接口并容器管理
@MapperScan(basePackages = Test2DataSourceConfig.PACKAGE, sqlSessionFactoryRef = "test2SqlSessionFactory")
@Configuration
public class Test2DataSourceConfig {   
 // 精確到 test2 目錄，以便跟其他數(shù)據(jù)源隔離    
 static final String PACKAGE = "com.xxx.dao.test2";    
 static final String MAPPER_LOCATION = "classpath:mapper/test2/*.xml";   

 @Value("${test2.spring.datasource.jdbc-url}")    
 private String url;   

 @Value("${test2.spring.datasource.username}")    
 private String user;   

 @Value("${test2.spring.datasource.password}")    
 private String password;   

 @Value("${test2.spring.datasource.driver-class-name}")   
 private String driverClass;  
 
 @Bean(name = "test2DataSource")    
 public DataSource test2DataSource() {       
 DruidDataSource dataSource = new DruidDataSource();        
 dataSource.setDriverClassName(driverClass);        
 dataSource.setUrl(url);        
 dataSource.setUsername(user);        
 dataSource.setPassword(password);        
 return dataSource;    
 }   
 @Bean(name = "test2TransactionManager")   
 public DataSourceTransactionManager test2TransactionManager() {       
 return new DataSourceTransactionManager(test2DataSource());    
 }    
 @Bean(name = "test2SqlSessionFactory")   
 public SqlSessionFactory test2SqlSessionFactory(@Qualifier("test2DataSource") DataSource test2DataSource)           
 throws Exception {       
 final SqlSessionFactoryBean sessionFactory = new SqlSessionFactoryBean();        
 sessionFactory.setDataSource(test2DataSource);        
 sessionFactory.setMapperLocations(new PathMatchingResourcePatternResolver()                
 .getResources(Test2DataSourceConfig.MAPPER_LOCATION));
 return sessionFactory.getObject();    }

}

搞定，輕輕松松~

注：

mapper文件夾下新建的文件夾需要有 *.xml 文件（即:classpath:/mapper/xxx/*.xml下要存在文件），不然可能檢測不到
需要繼續(xù)添加數(shù)據(jù)源就再加一個其他數(shù)據(jù)源

以上就是方便快捷實現(xiàn)springboot 后端配置多個數(shù)據(jù)源、Mysql數(shù)據(jù)庫的詳細(xì)內(nèi)容，更多關(guān)于springboot 后端配置多個數(shù)據(jù)源、Mysql數(shù)據(jù)庫的資料請關(guān)注腳本之家其它相關(guān)文章！希望大家以后多多支持腳本之家！

您可能感興趣的文章: