背景

Druid連接池是阿里巴巴開源的數(shù)據(jù)庫連接池項(xiàng)目。Druid連接池為監(jiān)控而生，內(nèi)置強(qiáng)大的監(jiān)控功能，監(jiān)控特性不影響性能。功能強(qiáng)大，能防SQL注入，內(nèi)置Loging能診斷Hack應(yīng)用行為?，F(xiàn)在已經(jīng)SpringBoot3，Druid的配置也需要隨著更新。

SpringBoot3整合Druid

在SpringBoot3中整合Druid連接池，可以通過以下步驟進(jìn)行配置：

1. 添加依賴：在項(xiàng)目的pom.xml文件中添加Druid的Spring Boot Starter依賴。

   <druid.version>1.2.23</druid.version><!-- https://mvnrepository.com/artifact/com.alibaba/druid-spring-boot-3-starter -->
   <dependency><groupId>com.alibaba</groupId><artifactId>druid-spring-boot-3-starter</artifactId><version>${druid.version}</version>
   </dependency>

   同時(shí)，確保已經(jīng)添加了數(shù)據(jù)庫驅(qū)動(dòng)的依賴，例如MySQL：

   <!--<dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>${mysql.version}</version>
   </dependency>-->
   <dependency><groupId>org.postgresql</groupId><artifactId>postgresql</artifactId><version>${postgresql.version}</version>
   </dependency>

2. 配置YAML：在application.yml中配置數(shù)據(jù)源和Druid連接池的參數(shù)。

   spring:datasource:type: com.alibaba.druid.pool.DruidDataSourcedriver-class-name: com.mysql.cj.jdbc.Driverurl: jdbc:mysql://localhost:3306/test?characterEncoding=utf8&serverTimezone=Asia/Shanghaiusername: rootpassword: root123druid:initial-size: 5min-idle: 5max-active: 20max-wait: 60000time-between-eviction-runs-millis: 60000min-evictable-idle-time-millis: 30000validation-query: select 'x'test-while-idle: truetest-on-borrow: falsetest-on-return: falsepool-prepared-statements: falsefilters: stat,wall,slf4jmax-pool-prepared-statement-per-connection-size: -1use-global-data-source-stat: trueconnect-properties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000web-stat-filter:enabled: trueurl-pattern: /*exclusions: /druid/*,*.js,*.gif,*.jpg,*.png,*.css,*.icostat-view-servlet:enabled: trueurl-pattern: /druid/*reset-enable: falselogin-username: druidlogin-password: druidallow: 127.0.0.1deny:

3. 啟動(dòng)項(xiàng)目：啟動(dòng)Spring Boot應(yīng)用后，Druid連接池將自動(dòng)配置并可以使用。你可以通過訪問Druid提供的監(jiān)控頁面來查看數(shù)據(jù)庫連接池的狀態(tài)。監(jiān)控頁面的訪問地址通常是http://localhost:8080/druid/login.html，輸入配置的用戶名和密碼即可登錄。

以上步驟是基本方法，僅供，具體配置可能會(huì)根據(jù)Druid版本和Spring Boot版本的不同有所變化。在實(shí)際操作時(shí)，建議參考Druid的官方文檔和Spring Boot的官方文檔進(jìn)行配置。

Druid監(jiān)控

http://localhost:12666/api/system/druid/login.html

http://localhost:12666/api/system/druid/index.html

?

?

Github參考代碼

當(dāng)然你也可以參考SpringBoot3腳手架之MySpringBootAPI部分，下載即可開始使用，DRUID已配置。https://github.com/moshowgame/MySpringBootAPIhttps://github.com/moshowgame/MySpringBootAPI

filters=log4j "ClassNotFoundException: org.apache.log4j.Priority" issue?

可以改為 filters: stat,wall,slf4j 或者干脆不要log4j和slf4j

Error starting ApplicationContext. To display the condition evaluation report re-run your application with 'debug' enabled.
2024-09-29T19:24:22.892+08:00 ERROR 9648 --- [MySpringBootAPI] [           main] o.s.b.d.LoggingFailureAnalysisReporter   : ***************************
APPLICATION FAILED TO START
***************************Description:Failed to bind properties under 'spring.datasource.druid' to com.alibaba.druid.spring.boot3.autoconfigure.DruidDataSourceWrapper:Property: spring.datasource.druid.filtersValue: "stat,wall,log4j"Origin: class path resource [application-dev.yml] - 52:18Reason: java.lang.ClassNotFoundException: org.apache.log4j.PriorityAction:Update your application's configurationProcess finished with exit code 1

?Application 完整YAML參考

server:port: 12666servlet:context-path: /apiundertow:threads:io: 4worker: 20url-charset: UTF-8
spring:banner:charset: UTF-8application:name: MySpringBootAPIfreemarker:request-context-attribute: requestsuffix: .htmlcontent-type: text/htmlenabled: truecache: falsecharset: UTF-8allow-request-override: falseexpose-request-attributes: trueexpose-session-attributes: trueexpose-spring-macro-helpers: truetemplate-loader-path: classpath:/templates/settings:number_format: 0.##mvc:static-path-pattern: /static/**servlet:multipart:max-file-size: 10MBmax-request-size: 10MBdatasource:type: com.alibaba.druid.pool.DruidDataSourcedriverClassName: org.postgresql.Driverurl: jdbc:postgresql://127.0.0.1:5432/test?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=Asia/Shanghaiusername: postgrespassword: root123druid:initialSize: 5minIdle: 5maxActive: 20maxWait: 60000timeBetweenEvictionRunsMillis: 60000minEvictableIdleTimeMillis: 300000validationQuery: SELECT 1testWhileIdle: truetestOnBorrow: falsetestOnReturn: falsefilters: stat,wall,slf4j# 通過connectProperties屬性來打開mergeSql功能；慢SQL記錄connectionProperties: druid.stat.mergeSql\=true;druid.stat.slowSqlMillis\=5000# 配置DruidStatFilterweb-stat-filter:enabled: trueurl-pattern: "/*"exclusions: "*.js,*.gif,*.jpg,*.bmp,*.png,*.css,*.ico,/druid/*,/system/druid/*"# 配置DruidStatViewServletstat-view-servlet:enabled: trueurl-pattern: "/system/druid/*"# IP白名單(沒有配置或者為空，則允許所有訪問)allow: localhost,127.0.0.1,192.168.*# IP黑名單 (存在共同時(shí)，deny優(yōu)先于allow)deny: 10.1.*#  禁用HTML頁面上的“Reset All”功能reset-enable: false# 登錄名login-username: admin# 登錄密碼login-password: 123456