From 5e765b7358c0a1f91b30acf48d442c08073fdbed Mon Sep 17 00:00:00 2001
From: liurunyu <lry9898@163.com>
Date: 星期二, 30 九月 2025 16:06:58 +0800
Subject: [PATCH] 优化数据源配置

---
 pipIrr-platform/pipIrr-global/src/main/resources/application-database-test.yml |   10 +++++++---
 1 files changed, 7 insertions(+), 3 deletions(-)

diff --git a/pipIrr-platform/pipIrr-global/src/main/resources/application-database-test.yml b/pipIrr-platform/pipIrr-global/src/main/resources/application-database-test.yml
index 778e7bc..ca6ebd0 100644
--- a/pipIrr-platform/pipIrr-global/src/main/resources/application-database-test.yml
+++ b/pipIrr-platform/pipIrr-global/src/main/resources/application-database-test.yml
@@ -5,9 +5,9 @@
       #name: test
       type: com.alibaba.druid.pool.DruidDataSource
       driverClassName: com.mysql.cj.jdbc.Driver
-      url: jdbc:mysql://192.168.40.166:3306/pipIrr_test?useUnicode=true&characterEncoding=utf-8&autoReconnect=true&useSSL=false&serverTimezone=GMT%2B8&zeroDateTimeBehavior=convertToNull
+#      url: jdbc:mysql://192.168.40.166:3306/pipIrr_test?useUnicode=true&characterEncoding=utf-8&autoReconnect=true&useSSL=false&serverTimezone=GMT%2B8&zeroDateTimeBehavior=convertToNull
 #      url: jdbc:mysql://8.130.130.233:3306/pipIrr_test?useUnicode=true&characterEncoding=utf-8&autoReconnect=true&useSSL=false&serverTimezone=GMT%2B8&zeroDateTimeBehavior=convertToNull
-#      url: jdbc:mysql://127.0.0.1:3306/pipIrr_test?useUnicode=true&characterEncoding=utf-8&autoReconnect=true&useSSL=false&serverTimezone=GMT%2B8&zeroDateTimeBehavior=convertToNull
+      url: jdbc:mysql://127.0.0.1:3306/pipIrr_test?useUnicode=true&characterEncoding=utf-8&autoReconnect=true&useSSL=false&serverTimezone=GMT%2B8&zeroDateTimeBehavior=convertToNull
       username: root
       password: dysql,;.abc!@#
       druid:
@@ -45,9 +45,13 @@
         #鎸囧畾姣忎釜杩炴帴涓奝SCache鐨勫ぇ灏�
         maxPoolPreparedStatementPerConnectionSize: 20
         #灞炴�х被鍨嬫槸瀛楃涓诧紝閫氳繃鍒悕鐨勬柟寮忛厤缃墿灞曟彃浠讹紝甯哥敤鐨勬彃浠舵湁锛�
-        #鐩戞帶缁熻鐢ㄧ殑filter:stat锛屾棩蹇楃敤鐨刦ilter:log4j锛岄槻寰ql娉ㄥ叆鐨刦ilter:wall
+        #鐩戞帶缁熻鐢ㄧ殑filter:stat锛屽惎鐢ㄦ閰嶇疆锛孞dbcDataSourceStat闈欐�佸彉閲廘inkedHashMap<String, JdbcSqlStat> sqlStatMap鐨凪ap浼氫竴鐩磋鎸佹湁鎵�鏈塖QL涓嶈兘琚獹C閲婃斁锛屽鏄撳唴瀛樻硠闇�
+        #鏃ュ織鐢ㄧ殑filter:log4j锛�
+        #闃插尽sql娉ㄥ叆鐨刦ilter:wall
         #filters: stat,wall,config
         filters: wall,config
+        #褰� Druid 鏁版嵁婧愶紙DataSource锛夎繖涓� Bean 琚� Spring 瀹瑰櫒閿�姣佹椂锛岄渶瑕佽皟鐢ㄧ殑鏂规硶
+        destroy-method: close
         webStatFilter:
           # 娣诲姞杩囨护瑙勫垯
           urlPattern: /*

--
Gitblit v1.8.0