SpringBoot集成Druid實現(xiàn)多數(shù)據(jù)源的兩種方式
更新時間：2024年03月10日 14:53:33 作者：濤哥是個大帥比
這篇文章主要介紹了SpringBoot集成Druid實現(xiàn)多數(shù)據(jù)源的兩種方式,集成com.baomidou的方式和基于AOP手動實現(xiàn)多數(shù)據(jù)源原生的方式,文中通過代碼示例講解的非常詳細,需要的朋友可以參考下
項目場景：
Spring Boot集成Druid實現(xiàn)多數(shù)據(jù)源的兩種方式：
1、集成com.baomidou，引入dynamic-datasource依賴；
2、原生的方式，基于AOP手動實現(xiàn)多數(shù)據(jù)源；
一、集成com.baomidou的方式
1、maven依賴：
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>dynamic-datasource-spring-boot-starter</artifactId>
<version>3.5.1</version>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid-spring-boot-starter</artifactId>
<version>1.1.10</version>
</dependency>2、 配置文件：
1.spring.datasource.dynamic前綴，是baomidou源碼里固定的；
2.first、second是自定義的名稱，可以更改；
# 多數(shù)據(jù)源配置，默認master spring.datasource.dynamic.primary = first # 數(shù)據(jù)源1 spring.datasource.dynamic.datasource.first.driverClassName = com.mysql.cj.jdbc.Driver spring.datasource.dynamic.datasource.first.type = com.alibaba.druid.pool.DruidDataSource spring.datasource.dynamic.datasource.first.url = jdbc:mysql://127.0.0.1:3306/mp_dm?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=GMT%2B8 spring.datasource.dynamic.datasource.first.username = test spring.datasource.dynamic.datasource.first.password = test1 # 數(shù)據(jù)源2 spring.datasource.dynamic.datasource.second.driverClassName = com.mysql.cj.jdbc.Driver spring.datasource.dynamic.datasource.second.type = com.alibaba.druid.pool.DruidDataSource spring.datasource.dynamic.datasource.second.url = jdbc:mysql://127.0.0.1:18306/mp_dm?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=GMT%2B8 spring.datasource.dynamic.datasource.second.username = test spring.datasource.dynamic.datasource.second.password = test1 # druid多數(shù)據(jù)源全局配置 spring.datasource.dynamic.druid.filter.stat.log-slow-sql = true spring.datasource.dynamic.druid.filter.stat.slow-sql-millis = 1000 spring.datasource.dynamic.druid.min-evictable-idle-time-millis = 300000 spring.datasource.dynamic.druid.test-on-borrow = false spring.datasource.dynamic.druid.filter.stat.merge-sql = false spring.datasource.dynamic.druid.test-on-return = false spring.datasource.dynamic.druid.initial-size = 10 spring.datasource.dynamic.druid.min-idle = 10 spring.datasource.dynamic.druid.max-wait = 60000 spring.datasource.dynamic.druid.pool-prepared-statements = true spring.datasource.dynamic.druid.test-while-idle = true spring.datasource.dynamic.druid.validation-query = select 1 spring.datasource.dynamic.druid.filter.wall.config.multi-statement-allow = true spring.datasource.dynamic.druid.time-between-eviction-runs-millis = 60000 spring.datasource.dynamic.druid.max-pool-prepared-statement-per-connection-size = 20 spring.datasource.dynamic.druid.max-active = 100 # druid監(jiān)控全局配置 spring.datasource.druid.stat-view-servlet.enabled = true spring.datasource.druid.stat-view-servlet.url-pattern = /druid/*
驗證配置文件是否生效：Spring Boot集成Druid查看配置是否生效
3、 使用注解切換數(shù)據(jù)源：
@DS注解說明：
1.注解在方法上、類上、接口、枚舉，同時存在就近原則，方法上注解優(yōu)先于類上注解；
2.不使用@DS注解，默認主數(shù)據(jù)源；
類上：
@DS("db2")
public class test(){}方法上：
@DS("db2")
public void test(){}mapper方法上
@Select("SELECT * FROM TEST WHERE A = #{A}")
@DS("db2")
Map<String, Object> test(@Param("A") String A);二、基于AOP手動實現(xiàn)多數(shù)據(jù)源原生的方式
1、maven依賴：
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid-spring-boot-starter</artifactId>
<version>1.1.10</version>
</dependency>2、 配置文件：
1.Spring Boot 2.X 版本不再支持配置繼承，多數(shù)據(jù)源的話每個數(shù)據(jù)源的所有配置都需要單獨配置，否則配置不會生效；
2.first、second是自定義的名稱，對應DynamicDataSourceConfig配置類，可以更改；
# 多數(shù)據(jù)源配置 spring.datasource.type = com.alibaba.druid.pool.DruidDataSource # 數(shù)據(jù)源1 spring.datasource.druid.first.name = first spring.datasource.druid.first.driverClassName = com.mysql.cj.jdbc.Driver spring.datasource.druid.first.url = jdbc:mysql://127.0.0.1:3306/mp_dm?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=GMT%2B8 spring.datasource.druid.first.username = test spring.datasource.druid.first.password = test1 # 數(shù)據(jù)源2 spring.datasource.druid.second.name = second spring.datasource.druid.second.driverClassName = com.mysql.cj.jdbc.Driver spring.datasource.druid.second.url = jdbc:mysql://127.0.0.1:18306/mp_dm?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=GMT%2B8 spring.datasource.druid.second.username = test spring.datasource.druid.second.password = test1 # druid數(shù)據(jù)源1 spring.datasource.druid.first.filter.stat.log-slow-sql = true spring.datasource.druid.first.filter.stat.slow-sql-millis = 1000 spring.datasource.druid.first.min-evictable-idle-time-millis = 300000 spring.datasource.druid.test-on-borrow = false spring.datasource.druid.first.filter.stat.merge-sql = false spring.datasource.druid.test-on-return = false spring.datasource.druid.first.initial-size = 10 spring.datasource.druid.first.min-idle = 10 spring.datasource.druid.first.max-wait = 60000 spring.datasource.druid.first.pool-prepared-statements = true spring.datasource.druid.first.test-while-idle = true spring.datasource.druid.first.validation-query = select 1 spring.datasource.druid.first.filter.wall.config.multi-statement-allow = true spring.datasource.druid.first.time-between-eviction-runs-millis = 60000 spring.datasource.druid.first.max-pool-prepared-statement-per-connection-size = 20 spring.datasource.druid.first.max-active = 100 # druid數(shù)據(jù)源2 spring.datasource.druid.second.filter.stat.log-slow-sql = true spring.datasource.druid.second.filter.stat.slow-sql-millis = 1000 spring.datasource.druid.second.min-evictable-idle-time-millis = 300000 spring.datasource.druid.second.test-on-borrow = false spring.datasource.druid.second.filter.stat.merge-sql = false spring.datasource.druid.second.test-on-return = false spring.datasource.druid.second.initial-size = 10 spring.datasource.druid.second.min-idle = 10 spring.datasource.druid.second.max-wait = 60000 spring.datasource.druid.second.pool-prepared-statements = true spring.datasource.druid.second.test-while-idle = true spring.datasource.druid.second.validation-query = select 1 spring.datasource.druid.second.filter.wall.config.multi-statement-allow = true spring.datasource.druid.second.time-between-eviction-runs-millis = 60000 spring.datasource.druid.second.max-pool-prepared-statement-per-connection-size = 20 spring.datasource.druid.second.max-active = 100 # druid監(jiān)控全局配置 spring.datasource.druid.stat-view-servlet.enabled = true spring.datasource.druid.stat-view-servlet.url-pattern = /druid/*
驗證配置文件是否生效：Spring Boot集成Druid查看配置是否生效
3、 多數(shù)據(jù)源名稱類
package com.test.datasources;
/**
* 增加多數(shù)據(jù)源，在此配置
*/
public interface DataSourceNames {
String FIRST = "first";
String SECOND = "second";
} 4、自定義注解
package com.test.datasources.annotation;
import java.lang.annotation.Documented;
import java.lang.annotation.ElementType;
import java.lang.annotation.Retention;
import java.lang.annotation.RetentionPolicy;
import java.lang.annotation.Target;
/**
* 多數(shù)據(jù)源注解
*/
//同時支持方法注解和類注解
@Target({ElementType.METHOD, ElementType.TYPE})
@Retention(RetentionPolicy.RUNTIME)
@Documented
public @interface DataSource {
String value() default "";
}5、配置類
package com.test.datasources;
import java.util.HashMap;
import java.util.Map;
import javax.sql.DataSource;
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.jdbc.core.JdbcTemplate;
import com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceBuilder;
/**
* 配置多數(shù)據(jù)源
*/
@Configuration
public class DynamicDataSourceConfig {
@Bean
@ConfigurationProperties("spring.datasource.druid.first")
public DataSource firstDataSource(){
return DruidDataSourceBuilder.create().build();
}
@Bean
@ConfigurationProperties("spring.datasource.druid.second")
public DataSource secondDataSource(){
return DruidDataSourceBuilder.create().build();
}
@Bean
@Primary
public DynamicDataSource dataSource(DataSource firstDataSource, DataSource secondDataSource) {
Map<Object, Object> targetDataSources = new HashMap<>();
targetDataSources.put(DataSourceNames.FIRST, firstDataSource);
targetDataSources.put(DataSourceNames.SECOND, secondDataSource);
return new DynamicDataSource(firstDataSource, targetDataSources);
}
@Bean
public JdbcTemplate jdbcTemplate() {
return new JdbcTemplate(firstDataSource());
}
}6、動態(tài)數(shù)據(jù)源配置
package com.test.datasources;
import java.util.Map;
import javax.sql.DataSource;
import org.springframework.jdbc.datasource.lookup.AbstractRoutingDataSource;
/**
* 動態(tài)數(shù)據(jù)源，關鍵代碼
*/
public class DynamicDataSource extends AbstractRoutingDataSource {
private static final ThreadLocal<String> contextHolder = new ThreadLocal<>();
public DynamicDataSource(DataSource defaultTargetDataSource, Map<Object, Object> targetDataSources) {
super.setDefaultTargetDataSource(defaultTargetDataSource);
super.setTargetDataSources(targetDataSources);
super.afterPropertiesSet();
}
@Override
protected Object determineCurrentLookupKey() {
return getDataSource();
}
public static void setDataSource(String dataSource) {
contextHolder.set(dataSource);
}
public static String getDataSource() {
return contextHolder.get();
}
public static void clearDataSource() {
contextHolder.remove();
}
}7、AOP切面攔截注解
package com.test.datasources.aspect;
import java.lang.reflect.Method;
import org.aspectj.lang.ProceedingJoinPoint;
import org.aspectj.lang.annotation.Around;
import org.aspectj.lang.annotation.Aspect;
import org.aspectj.lang.annotation.Pointcut;
import org.aspectj.lang.reflect.MethodSignature;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.core.Ordered;
import org.springframework.stereotype.Component;
import com.test.datasources.DataSourceNames;
import com.test.datasources.DynamicDataSource;
import com.test.datasources.annotation.DataSource;
/**
* 多數(shù)據(jù)源，切面處理類
*/
@Aspect
@Component
public class DataSourceAspect implements Ordered {
protected Logger logger = LoggerFactory.getLogger(getClass());
/*
* @annotation匹配指定注解的方法
* @within匹配指定注解的類
* 注意：這里只攔截所注解的類，如果調用的是父類的方法，那么不會攔截，除非父類方法在子類中被覆蓋。
*/
@Pointcut("@annotation(com.test.datasources.annotation.DataSource) || @within(com.test.datasources.annotation.DataSource)")
public void dataSourcePointCut() {
}
@Around("dataSourcePointCut()")
public Object around(ProceedingJoinPoint point) throws Throwable {
MethodSignature signature = (MethodSignature) point.getSignature();
Method method = signature.getMethod();
Class<?> dataClass = Class.forName(signature.getDeclaringTypeName());
DataSource dsMethod = method.getAnnotation(DataSource.class);
DataSource dsClass = dataClass.getAnnotation(DataSource.class);
if(dsMethod != null){
//方法優(yōu)先，如果方法上存在注解，則優(yōu)先使用方法上的注解
DynamicDataSource.setDataSource(dsMethod.value());
logger.debug("set datasource is " + dsMethod.value());
}else if(dsClass != null){
//其次類優(yōu)先，如果類上存在注解，則使用類上的注解
DynamicDataSource.setDataSource(dsClass.value());
logger.debug("set datasource is " + dsClass.value());
}else{
//如果都不存在，則使用默認
DynamicDataSource.setDataSource(DataSourceNames.FIRST);
logger.debug("set datasource is " + DataSourceNames.FIRST);
}
try {
return point.proceed();
} finally {
DynamicDataSource.clearDataSource();
logger.debug("clean datasource");
}
}
@Override
public int getOrder() {
return 1;
}
}8、Dao層，跟正常一樣的
package com.test.mapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import com.test.entity.Test1Entity;
@Mapper
public interface Test1Dao {
@Select("select * from test1")
Test1Entity getById(@Param("id")Integer id);
}package com.test.mapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import com.test.entity.Test2Entity;
@Mapper
public interface Test2Dao {
@Select("select * from test2")
Test2Entity getById(@Param("id")Integer id);
}9、service層，加上多數(shù)據(jù)源注解
package com.test.service;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.test.datasources.DataSourceNames;
import com.test.datasources.annotation.DataSource;
import com.test.entity.Test1Entity;
import com.test.mapper.Test1Dao;
@Service
@DataSource(DataSourceNames.FIRST)
public class Test1Service {
@Autowired
private Test1Dao test1Dao;
public Test1Entity getById(int id) {
return test1Dao.getById(id);
}
}package com.test.service;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.test.datasources.DataSourceNames;
import com.test.datasources.annotation.DataSource;
import com.test.entity.Test2Entity;
import com.test.mapper.Test2Dao;
@Service
@DataSource(DataSourceNames.SECOND)
public class Test2Service {
@Autowired
private Test2Dao test2Dao;
public Test2Entity getById(int id) {
return test2Dao.getById(id);
}
}10、Controller測試
package com.test.controller;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RestController;
import com.test.entity.Test1Entity;
import com.test.entity.Test2Entity;
import com.test.service.Test1Service;
import com.test.service.Test2Service;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
/**
* 動態(tài)數(shù)據(jù)源測試
*/
@Api(tags = "動態(tài)數(shù)據(jù)源測試")
@RestController
@RequestMapping("/test")
public class DynamicController {
@Autowired
private Test1Service test1Service;
@Autowired
private Test2Service test2Service;
@ApiOperation(value = "數(shù)據(jù)源1")
@RequestMapping(value = "/test1", method = RequestMethod.GET)
public String test1() {
Test1Entity entity = test1Service.getById(1);
return entity.getName();
}
@ApiOperation(value = "數(shù)據(jù)源2")
@RequestMapping(value = "/test2", method = RequestMethod.GET)
public String test2() {
Test2Entity entity = test2Service.getById(2);
return entity.getName();
}
}三、結果展示
服務啟動會打印日志：
com.alibaba.druid.pool.DruidDataSource : {dataSource-1,first} inited
com.alibaba.druid.pool.DruidDataSource : {dataSource-2,second} initeddruid監(jiān)控頁面：
以上就是SpringBoot集成Druid實現(xiàn)多數(shù)據(jù)源的兩種方式的詳細內容，更多關于SpringBoot Druid多數(shù)據(jù)源的資料請關注腳本之家其它相關文章！
相關文章
這篇文章主要介紹了基于java計算買賣股票的最佳時機,文中通過示例代碼介紹的非常詳細，對大家的學習或者工作具有一定的參考學習價值,需要的朋友可以參考下2019-10-10
JSON（JavaScript Object Notation）是數(shù)據(jù)交換的輕量級格式,它以易于人類閱讀和機器解析的方式組織數(shù)據(jù),基于鍵值對,在Java開發(fā)中,處理JSON數(shù)據(jù)通常涉及使用Jackson、Gson、Fastjson等庫,本文給大家介紹JSON數(shù)據(jù)操作與處理全面指南,感興趣的朋友一起看看吧2024-10-10
這篇文章主要介紹了Java 使用 FFmpeg 處理視頻文件示例代碼，代碼簡單易懂，非常不錯，具有一定的參考借鑒價值，需要的朋友可以參考下2020-02-02
kafka?消息隊列中點對點與發(fā)布訂閱的區(qū)別說明
這篇文章主要介紹了kafka?消息隊列中點對點與發(fā)布訂閱的區(qū)別說明，具有很好的參考價值，希望對大家有所幫助。如有錯誤或未考慮完全的地方，望不吝賜教2022-05-05
這篇文章主要介紹了解決idea使用過程中讓你覺得不爽的一些問題，文中通過示例代碼介紹的非常詳細，對大家的學習或者工作具有一定的參考學習價值，需要的朋友們下面隨著小編來一起學習學習吧2020-08-08
Java 中的vector和list的區(qū)別和使用實例詳解
在大家還沒有了解vector,list,deque的知識之前，我先給大家介紹下stl，本文重點給大家介紹vector和list的區(qū)別及使用，感興趣的的朋友一起看看吧2017-09-09
Java中字符串String的+和+=及循環(huán)操作String原理詳解
Java編譯器在編譯時對String的+和+=操作會創(chuàng)建StringBuilder對象來進行字符串的拼接,下面這篇文章主要給大家介紹了關于Java中字符串String的+和+=及循環(huán)操作String原理的相關資料,需要的朋友可以參考下2023-01-01
jmeter是一款優(yōu)秀的開源性能測試工具，目前最新版本3.0版本，本文給大家介紹Jmeter入門教程，文中通過圖文并茂的形式給大家介紹的非常詳細，對大家的學習或工作具有一定的參考借鑒價值，需要的朋友參考下吧2021-11-11
這篇文章主要介紹了java代碼mqtt接收發(fā)送消息方式,具有很好的參考價值,希望對大家有所幫助,如有錯誤或未考慮完全的地方,望不吝賜教2023-09-09
本文主要介紹了Java實現(xiàn)堆算法的使用示例,Java中提供了一個Heap類,可以用來實現(xiàn)堆的操作,可以實現(xiàn)如插入、刪除、獲取最大最小值等,具有一定的參考價值,感興趣的可以了解一下2023-12-12