springboot整合druid(多数据源配置)

最新推荐文章于 2024-08-15 21:36:29 发布

web15285868498

最新推荐文章于 2024-08-15 21:36:29 发布

阅读量6k

点赞数 1

分类专栏：面试阿里巴巴 java 文章标签： spring boot sqlserver java java-ee 数据库

本文链接：https://blog.csdn.net/web15285868498/article/details/125345233

版权

本文详细介绍了如何在SpringBoot项目中整合Druid数据连接池，包括pom依赖引入、数据源配置（如SQLServer、MySQL）、配置类设置以及DAO支持类的创建。此外，还提及了Druid的监控功能和动态数据源配置的可能性。

摘要由CSDN通过智能技术生成

Druid 是阿里巴巴一个开源项目，之前(_hikari_出现之前)一直被认为是Java语言中各方面最好的数据库连接池，并且Druid还能够提供强大的监控和扩展功能，备受软件开发人员推崇。本文主要介绍springboot整合druid流程，及多数据配置。

一、pom引入druid依赖

<dependency>
	<groupId>com.alibaba</groupId>
	<artifactId>druid-spring-boot-starter</artifactId>
	<version>1.1.10</version>
</dependency>
<dependency>
	<groupId>com.alibaba</groupId>
	<artifactId>druid</artifactId>
	<version>1.1.10</version>
</dependency>

二、properties或yml文件配置数据源信息(SQLServer、mySQL多数据源)

## SQLServer数据源信息
spring.datasource.druid.sqlserver.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.druid.sqlserver.driver-class-name=com.microsoft.sqlserver.jdbc.SQLServerDriver
spring.datasource.druid.sqlserver.url=jdbc:sqlserver://192.168.1.8:1433;DatabaseName=myDB;useUnicode=true;characterEncoding=utf8;characterSetResults=utf8;allowMultiQueries=true;multiStatementAllow=true    
spring.datasource.druid.sqlserver.username=sa
spring.datasource.druid.sqlserver.password=DBadmin
spring.datasource.druid.sqlserver.initial-size=5
spring.datasource.druid.sqlserver.min-idle=5
spring.datasource.druid.sqlserver.max-active=300
spring.datasource.druid.sqlserver.max-wait=30000
spring.datasource.druid.sqlserver.time-between-eviction-runs-millis=60000
spring.datasource.druid.sqlserver.min-evictable-idle-time-millis=30000
spring.datasource.druid.sqlserver.validation-query=SELECT 1
spring.datasource.druid.sqlserver.test-while-idle=true
spring.datasource.druid.sqlserver.test-on-borrow=false
spring.datasource.druid.sqlserver.test-on-return=false
spring.datasource.druid.sqlserver.pool-prepared-statements=true
spring.datasource.druid.sqlserver.max-pool-prepared-statement-per-connection-size=20
spring.datasource.druid.sqlserver.filters=stat
spring.datasource.druid.sqlserver.connection-properties=druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000
spring.datasource.druid.sqlserver.use-global-data-source-stat=true

## mySql数据源信息
spring.datasource.druid.mysql.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.druid.mysql.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.druid.mysql.url=jdbc:sqlserver://192.168.1.8:3306;DatabaseName=myDB;useUnicode=true;characterEncoding=utf8;characterSetResults=utf8;allowMultiQueries=true;multiStatementAllow=true    
spring.datasource.druid.mysql.username=sa
spring.datasource.druid.mysql.password=DBadmin
spring.datasource.druid.mysql.initial-size=5
spring.datasource.druid.mysql.min-idle=5
spring.datasource.druid.mysql.max-active=300
spring.datasource.druid.mysql.max-wait=30000
spring.datasource.druid.mysql.time-between-eviction-runs-millis=60000
spring.datasource.druid.mysql.min-evictable-idle-time-millis=30000
spring.datasource.druid.mysql.validation-query=SELECT 1
spring.datasource.druid.mysql.test-while-idle=true
spring.datasource.druid.mysql.test-on-borrow=false
spring.datasource.druid.mysql.test-on-return=false
spring.datasource.druid.mysql.pool-prepared-statements=true
spring.datasource.druid.mysql.max-pool-prepared-statement-per-connection-size=20
spring.datasource.druid.mysql.filters=stat
spring.datasource.druid.mysql.connection-properties=druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000
sp