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-mj.yml   |    6 ++
 pipIrr-platform/pipIrr-global/src/main/resources/application-database-gz.yml   |    6 ++
 pipIrr-platform/pipIrr-global/src/main/resources/application-database-yq.yml   |    6 ++
 pipIrr-platform/pipIrr-global/src/main/resources/application-database-sp.yml   |    7 ++-
 pipIrr-platform/pipIrr-global/src/main/resources/application-database-test.yml |    6 ++
 pipIrr-platform/pipIrr-global/src/main/resources/application-database-jyg.yml  |    6 ++
 pipIrr-platform/pipIrr-global/src/main/resources/application-database-hlj.yml  |    6 ++
 pipIrr-platform/pipIrr-global/src/main/resources/application-database-mq.yml   |    6 ++
 pipIrr-platform/pipIrr-global/src/main/resources/application-database-jc.yml   |    6 ++
 pipIrr-platform/pipIrr-global/src/main/resources/application-database-ym.yml   |    6 ++
 pipIrr-platform/pipIrr-global/src/main/resources/application-database-lz.yml   |    6 ++
 11 files changed, 55 insertions(+), 12 deletions(-)

diff --git a/pipIrr-platform/pipIrr-global/src/main/resources/application-database-gz.yml b/pipIrr-platform/pipIrr-global/src/main/resources/application-database-gz.yml
index c07cb84..45dee79 100644
--- a/pipIrr-platform/pipIrr-global/src/main/resources/application-database-gz.yml
+++ b/pipIrr-platform/pipIrr-global/src/main/resources/application-database-gz.yml
@@ -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: /*
diff --git a/pipIrr-platform/pipIrr-global/src/main/resources/application-database-hlj.yml b/pipIrr-platform/pipIrr-global/src/main/resources/application-database-hlj.yml
index 767b6b1..27d8e7e 100644
--- a/pipIrr-platform/pipIrr-global/src/main/resources/application-database-hlj.yml
+++ b/pipIrr-platform/pipIrr-global/src/main/resources/application-database-hlj.yml
@@ -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: /*
diff --git a/pipIrr-platform/pipIrr-global/src/main/resources/application-database-jc.yml b/pipIrr-platform/pipIrr-global/src/main/resources/application-database-jc.yml
index 068180f..f34eee2 100644
--- a/pipIrr-platform/pipIrr-global/src/main/resources/application-database-jc.yml
+++ b/pipIrr-platform/pipIrr-global/src/main/resources/application-database-jc.yml
@@ -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: /*
diff --git a/pipIrr-platform/pipIrr-global/src/main/resources/application-database-jyg.yml b/pipIrr-platform/pipIrr-global/src/main/resources/application-database-jyg.yml
index 61218aa..58ee85b 100644
--- a/pipIrr-platform/pipIrr-global/src/main/resources/application-database-jyg.yml
+++ b/pipIrr-platform/pipIrr-global/src/main/resources/application-database-jyg.yml
@@ -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: /*
diff --git a/pipIrr-platform/pipIrr-global/src/main/resources/application-database-lz.yml b/pipIrr-platform/pipIrr-global/src/main/resources/application-database-lz.yml
index ef29b81..8a397b0 100644
--- a/pipIrr-platform/pipIrr-global/src/main/resources/application-database-lz.yml
+++ b/pipIrr-platform/pipIrr-global/src/main/resources/application-database-lz.yml
@@ -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: /*
diff --git a/pipIrr-platform/pipIrr-global/src/main/resources/application-database-mj.yml b/pipIrr-platform/pipIrr-global/src/main/resources/application-database-mj.yml
index f4663c4..76b8eb4 100644
--- a/pipIrr-platform/pipIrr-global/src/main/resources/application-database-mj.yml
+++ b/pipIrr-platform/pipIrr-global/src/main/resources/application-database-mj.yml
@@ -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: /*
diff --git a/pipIrr-platform/pipIrr-global/src/main/resources/application-database-mq.yml b/pipIrr-platform/pipIrr-global/src/main/resources/application-database-mq.yml
index 1c5dd33..b1d4d35 100644
--- a/pipIrr-platform/pipIrr-global/src/main/resources/application-database-mq.yml
+++ b/pipIrr-platform/pipIrr-global/src/main/resources/application-database-mq.yml
@@ -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: /*
diff --git a/pipIrr-platform/pipIrr-global/src/main/resources/application-database-sp.yml b/pipIrr-platform/pipIrr-global/src/main/resources/application-database-sp.yml
index 190348e..96e489b 100644
--- a/pipIrr-platform/pipIrr-global/src/main/resources/application-database-sp.yml
+++ b/pipIrr-platform/pipIrr-global/src/main/resources/application-database-sp.yml
@@ -45,10 +45,13 @@
                 #鎸囧畾姣忎釜杩炴帴涓奝SCache鐨勫ぇ灏�
                 maxPoolPreparedStatementPerConnectionSize: 20
                 #灞炴�х被鍨嬫槸瀛楃涓诧紝閫氳繃鍒悕鐨勬柟寮忛厤缃墿灞曟彃浠讹紝甯哥敤鐨勬彃浠舵湁锛�
-                #鐩戞帶缁熻鐢ㄧ殑filter:stat锛屾棩蹇楃敤鐨刦ilter:log4j锛岄槻寰ql娉ㄥ叆鐨刦ilter:wall
-                #寮冪敤filter:stat锛岃https://blog.csdn.net/K_520_W/article/details/132382812
+                #鐩戞帶缁熻鐢ㄧ殑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: /*
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 4e972d0..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
@@ -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: /*
diff --git a/pipIrr-platform/pipIrr-global/src/main/resources/application-database-ym.yml b/pipIrr-platform/pipIrr-global/src/main/resources/application-database-ym.yml
index ed9eb26..7ebcfe7 100644
--- a/pipIrr-platform/pipIrr-global/src/main/resources/application-database-ym.yml
+++ b/pipIrr-platform/pipIrr-global/src/main/resources/application-database-ym.yml
@@ -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: /*
diff --git a/pipIrr-platform/pipIrr-global/src/main/resources/application-database-yq.yml b/pipIrr-platform/pipIrr-global/src/main/resources/application-database-yq.yml
index d16ad9b..7b19bb9 100644
--- a/pipIrr-platform/pipIrr-global/src/main/resources/application-database-yq.yml
+++ b/pipIrr-platform/pipIrr-global/src/main/resources/application-database-yq.yml
@@ -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