From e7b3a5e891287b1291d2ac38f7c83d5d73bc7906 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期六, 08 十月 2022 08:49:01 +0800
Subject: [PATCH] 1

---
 src/main/resources/application.yml |  109 +++++++++++++++++++++++++++++++++++++++++++-----------
 1 files changed, 87 insertions(+), 22 deletions(-)

diff --git a/src/main/resources/application.yml b/src/main/resources/application.yml
index 70a161e..09d5061 100644
--- a/src/main/resources/application.yml
+++ b/src/main/resources/application.yml
@@ -3,40 +3,95 @@
     uri-encoding: UTF-8
     max-connections: 1000
   port: 12316
-  #servlet:
-  #  context-path: /land
+#  servlet:
+#    context-path: /land
   application:
     name: land
 
 spring:
   session:
     timeout: PT20M # 20鍒嗛挓
+
   datasource:
+    name: prod
+    # JDBC 鍩烘湰閰嶇疆
+    url: jdbc:postgresql://127.0.0.1:5432/langfang
     username : postgres
     password: postgres
-    url : jdbc:postgresql://192.168.20.39:5433/langfang
     driver-class-name: org.postgresql.Driver
-    type: com.alibaba.druid.pool.DruidDataSource # 鑷畾涔夋暟鎹簮
-    #druid 鏁版嵁婧愪笓鏈夐厤缃�
-    initialSize: 5
-    minIdle: 5
-    maxActive: 20
-    maxWait: 60000
-    timeBetweenEvictionRunsMillis: 60000
-    minEvictableIdleTimeMillis: 300000
-    validationQuery: SELECT 1 FROM now()
-    testWhileIdle: true
-    testOnBorrow: false
-    testOnReturn: false
-    poolPreparedStatements: true
-    #閰嶇疆鐩戞帶缁熻鎷︽埅鐨刦ilters锛宻tat:鐩戞帶缁熻銆乴og4j锛氭棩蹇楄褰曘�亀all锛氶槻寰ql娉ㄥ叆
-    #濡傛灉鍏佽鏃舵姤閿�  java.lang.ClassNotFoundException: org.apache.log4j.Priority
+    type: com.alibaba.druid.pool.DruidDataSource
+    # 閰嶇疆鐩戞帶缁熻鎷︽埅鐨刦ilters锛宻tat:鐩戞帶缁熻銆乴og4j锛氭棩蹇楄褰曘�亀all锛氶槻寰ql娉ㄥ叆
     filters: stat,wall,log4j
-    maxPoolPreparedStatementPerConnectionSize: 20
-    useGlobalDataSourceStat: true
+    # 閫氳繃connectProperties灞炴�ф潵鎵撳紑mergeSql鍔熻兘锛涙參SQL璁板綍
     connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500
+    # 瓒呰繃鏃堕棿闄愬埗鏄惁鍥炴敹
+    removeAbandoned: true
+    # 瓒呮椂鏃堕棿锛涘崟浣嶄负绉掋��180绉�=3鍒嗛挓
+    removeAbandonedTimeout: 180
+    # 鍏抽棴 abanded 杩炴帴鏃惰緭鍑洪敊璇棩蹇�
+    logAbandoned: true
+
+    # 閰嶇疆杩炴帴姹犱俊鎭�
+    druid:
+      ## 鍒濆鍖栧ぇ灏忥紝鏈�灏忥紝鏈�澶�
+      initial-size: 5
+      min-idle: 5
+      max-active: 50
+      ## 閰嶇疆鑾峰彇杩炴帴绛夊緟瓒呮椂鐨勬椂闂�
+      max-wait: 60000
+      # 閰嶇疆闂撮殧澶氫箙鎵嶈繘琛屼竴娆℃娴嬶紝妫�娴嬮渶瑕佸叧闂殑绌洪棽杩炴帴锛屽崟浣嶆槸姣
+      time-between-eviction-runs-millis: 60000
+      # 閰嶇疆涓�涓繛鎺ュ湪姹犱腑鏈�灏忕敓瀛樼殑鏃堕棿锛屽崟浣嶆槸姣
+      min-evictable-idle-time-millis: 300000
+      max-pool-prepared-statement-per-connection-size: 50
+      pool-prepared-statements: true
+      # 鐢ㄦ潵娴嬭瘯杩炴帴鏄惁鍙敤鐨凷QL璇彞
+      validation-query: SELECT 1
+      # 搴旂敤鍚戣繛鎺ユ睜鐢宠杩炴帴锛屽苟涓攖estOnBorrow涓篺alse鏃讹紝杩炴帴姹犲皢浼氬垽鏂繛鎺ユ槸鍚﹀浜庣┖闂茬姸鎬侊紝濡傛灉鏄紝鍒欓獙璇佽繖鏉¤繛鎺ユ槸鍚﹀彲鐢�
+      test-while-idle: true
+      # 濡傛灉涓簍rue锛岄粯璁ゆ槸false锛屽簲鐢ㄥ悜杩炴帴姹犵敵璇疯繛鎺ユ椂锛岃繛鎺ユ睜浼氬垽鏂繖鏉¤繛鎺ユ槸鍚︽槸鍙敤鐨�
+      test-on-borrow: false
+      # 濡傛灉涓簍rue锛堥粯璁alse锛夛紝褰撳簲鐢ㄤ娇鐢ㄥ畬杩炴帴锛岃繛鎺ユ睜鍥炴敹杩炴帴鐨勬椂鍊欎細鍒ゆ柇璇ヨ繛鎺ユ槸鍚﹁繕鍙敤
+      test-on-return: false
+
+      stat-view-servlet:
+        # sql鐩戞帶寮�鍏�
+        enabled: true
+        # 璁块棶鍐呯疆鐩戞帶椤甸潰鐨勮矾寰勶紝鍐呯疆鐩戞帶椤甸潰鐨勯椤垫槸/druid/index.html
+        url-pattern: /druid/*
+        # 鏄惁鍏佽娓呯┖缁熻鏁版嵁锛岄噸鏂拌绠�  true:鍏佽  false:涓嶅厑璁�
+        reset-enable: false
+        # 閰嶇疆鐩戞帶椤甸潰璁块棶璐﹀彿瀵嗙爜
+        login-username: druid_mg
+        login-password: ad_DruId!_min
+        # 鍏佽璁块棶鐨勫湴鍧�锛屽鏋渁llow娌℃湁閰嶇疆鎴栬�呬负绌猴紝鍒欏厑璁告墍鏈夎闂�
+        allow: 127.0.0.1
+        # 鎷掔粷璁块棶鐨勫湴鍧�锛宒eny浼樺厛浜巃llow锛屽鏋滃湪deny鍒楄〃涓紝灏辩畻鍦╝llow鍒楄〃涓紝涔熶細琚嫆缁�
+        deny:
+        # 閰嶇疆WebStatFilter锛岀敤浜庨噰闆唚eb鍏宠仈鐩戞帶鐨勬暟鎹�
+        web-stat-filter:
+          # web url鐩戞帶
+          enabled: true
+          # session鐩戞帶
+          session-stat-enable: true
+          # session鐨勬渶澶т釜鏁帮紝榛樿100
+          session-stat-max-count: 1000
+          # 杩囨护鎵�鏈塽rl
+          url-pattern: /*
+          # 鎺掗櫎涓�浜涗笉蹇呰鐨剈rl
+          exclusions: "*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*"
+        # 鑷繁閰嶇疆鐩戞帶缁熻鎷︽埅鐨刦ilter
+        filter:
+          # 寮�鍚疍ruidDataSource鐨勭姸鎬佺洃鎺�
+          stat:
+            enabled: true
+            db-type: postgresql
+            # 寮�鍚參sql鐩戞帶锛岃秴杩�2s 灏辫涓烘槸鎱ql锛岃褰曞埌鏃ュ織涓�
+            log-slow-sql: true
+            slow-sql-millis: 2000
+
     redis:
-      host: 192.168.20.39
+      host: 127.0.0.1
       port: 6379
       password:
       database: 1
@@ -61,4 +116,14 @@
 
 # 绯荤粺閰嶇疆
 sys:
-  path: E:\\Test\\LF\\
+  path:
+    # 瀵煎叆鐩綍
+    import: D:\LF\import
+    # 鍑哄浘鐩綍
+    export: D:\LF\export
+    # 涓婁紶鐩綍
+    upload: D:\LF\upload
+    # 鍏变韩鐩綍
+    share: D:\LF\share
+    # 涓存椂鐩綍
+    temp: D:\LF\temp
\ No newline at end of file

--
Gitblit v1.9.3