From ea96e4fd148c14b94b939e3deaa43cb049b810ef Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期二, 08 七月 2025 11:13:10 +0800
Subject: [PATCH] 解决druid访问失败
---
/dev/null | 0
se-system/src/main/java/com/terra/system/config/InitConfig.java | 5 +
se-system/src/main/resources/application-dev.yml | 137 ++++++++++++++++++++++++++++++++++
se-system/src/main/java/com/terra/system/config/DruidConfig.java | 30 +++++++
se-system/pom.xml | 6
pom.xml | 2
se-system/src/main/java/com/terra/system/config/WebConfig.java | 1
7 files changed, 177 insertions(+), 4 deletions(-)
diff --git a/pom.xml b/pom.xml
index 209453b..94e8fa0 100644
--- a/pom.xml
+++ b/pom.xml
@@ -23,7 +23,7 @@
<tobato.version>1.27.2</tobato.version>
<kaptcha.version>2.3.3</kaptcha.version>
<pagehelper.boot.version>2.0.0</pagehelper.boot.version>
-<!-- <druid.version>1.2.23</druid.version>-->
+ <druid.version>1.2.25</druid.version>
<dynamic-ds.version>4.3.1</dynamic-ds.version>
<commons.io.version>2.19.0</commons.io.version>
<velocity.version>2.3</velocity.version>
diff --git a/se-system/pom.xml b/se-system/pom.xml
index 98a2fe3..4ef2b7a 100644
--- a/se-system/pom.xml
+++ b/se-system/pom.xml
@@ -47,7 +47,7 @@
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-thymeleaf</artifactId>
-<!-- <version>2.2.2.RELEASE</version>-->
+ <!--<version>2.2.2.RELEASE</version>-->
</dependency>
<!--lombok-->
@@ -98,12 +98,12 @@
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
- <version>1.1.22</version>
+ <version>1.2.25</version>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid-spring-boot-starter</artifactId>
- <version>1.1.22</version>
+ <version>1.2.25</version>
</dependency>
<!--text-->
diff --git a/se-system/src/main/java/com/terra/system/config/DruidConfig.java b/se-system/src/main/java/com/terra/system/config/DruidConfig.java
new file mode 100644
index 0000000..ad85cea
--- /dev/null
+++ b/se-system/src/main/java/com/terra/system/config/DruidConfig.java
@@ -0,0 +1,30 @@
+package com.terra.system.config;
+
+import com.alibaba.druid.support.http.StatViewServlet;
+import org.springframework.boot.web.servlet.ServletRegistrationBean;
+import org.springframework.context.annotation.Bean;
+import org.springframework.context.annotation.Configuration;
+
+import java.util.HashMap;
+import java.util.Map;
+
+@Configuration
+@SuppressWarnings("ALL")
+public class DruidConfig {
+ @Bean
+ public ServletRegistrationBean druidServlet() {
+ ServletRegistrationBean bean = new ServletRegistrationBean();
+ bean.setServlet(new StatViewServlet());
+ bean.addUrlMappings("/druid/*");
+ Map<String, String> initParameters = new HashMap<>();
+ //initParameters.put("resetEnable", "false"); //绂佺敤HTML椤甸潰涓婄殑鈥淩est All鈥濆姛鑳�
+ //initParameters.put("allow", "127.0.0.1"); //ip鐧藉悕鍗曪紙娌℃湁閰嶇疆鎴栬�呬负绌猴紝鍒欏厑璁告墍鏈夎闂級
+ //initParameters.put("loginUsername", "admin"); //++鐩戞帶椤甸潰鐧诲綍鐢ㄦ埛鍚�
+ //initParameters.put("loginPassword", "admin"); //++鐩戞帶椤甸潰鐧诲綍鐢ㄦ埛瀵嗙爜
+ //initParameters.put("deny", ""); //ip榛戝悕鍗�
+
+ bean.setInitParameters(initParameters);
+
+ return bean;
+ }
+}
diff --git a/se-system/src/main/java/com/terra/system/config/InitConfig.java b/se-system/src/main/java/com/terra/system/config/InitConfig.java
index d2b4e00..598f400 100644
--- a/se-system/src/main/java/com/terra/system/config/InitConfig.java
+++ b/se-system/src/main/java/com/terra/system/config/InitConfig.java
@@ -49,6 +49,11 @@
public void run(ApplicationArguments args) {
// noinspection AlibabaRemoveCommentedCode
try {
+ //String enable1 = env.getProperty("spring.datasource.druid.stat-view-servlet.enabled");
+ //String enable2 = env.getProperty("spring.datasource.druid.web-stat-filter.enabled");
+ //String filters = env.getProperty("spring.datasource.druid.filters");
+ //String pattern = env.getProperty("spring.datasource.druid.stat-view-servlet.url-pattern");
+
GdalHelper.init(env.getProperty("sys.gdal_path"));
UploadAttachService.init(env.getProperty("sys.attachTabs"));
diff --git a/se-system/src/main/java/com/terra/system/config/WebConfig.java b/se-system/src/main/java/com/terra/system/config/WebConfig.java
index 2ebce58..27ea468 100644
--- a/se-system/src/main/java/com/terra/system/config/WebConfig.java
+++ b/se-system/src/main/java/com/terra/system/config/WebConfig.java
@@ -49,6 +49,7 @@
protected void addResourceHandlers(ResourceHandlerRegistry registry) {
registry.addResourceHandler("/webjars/**").addResourceLocations("classpath:/META-INF/resources/webjars/");
registry.addResourceHandler("swagger-ui.html").addResourceLocations("classpath:/META-INF/resources/");
+ registry.addResourceHandler("/druid/**").addResourceLocations("classpath:/META-INF/resources/druid/");
registry.addResourceHandler("/**").addResourceLocations("classpath:/static/");
super.addResourceHandlers(registry);
}
diff --git a/se-system/src/main/resources/application-dev.yml b/se-system/src/main/resources/application-dev.yml
new file mode 100644
index 0000000..a5a2758
--- /dev/null
+++ b/se-system/src/main/resources/application-dev.yml
@@ -0,0 +1,137 @@
+server:
+ tomcat:
+ uri-encoding: UTF-8
+ max-connections: 5000
+ max-http-form-post-size: 100MB
+ threads:
+ max: 2000
+ servlet:
+ context-path: /
+
+spring:
+ application:
+ name: se-system
+ mvc:
+ static-path-pattern: /static/**
+ # redis
+ redis:
+ database: 0
+ host: 127.0.0.1
+ port: 6369
+ password: rediS_5L#F4_Server
+ # 杩炴帴瓒呮椂鏃堕暱锛堟绉掞級
+ timeout: 10000
+ lettuce:
+ pool:
+ # 杩炴帴姹犳渶澶ц繛鎺ユ暟锛堜娇鐢ㄨ礋鍊艰〃绀烘病鏈夐檺鍒讹級
+ max-active: 1000
+ # 杩炴帴姹犳渶澶ч樆濉炵瓑寰呮椂闂达紙浣跨敤璐熷�艰〃绀烘病鏈夐檺鍒讹級
+ max-wait: -1
+ # 杩炴帴姹犱腑鐨勬渶澶х┖闂茶繛鎺�
+ max-idle: 10
+ # 杩炴帴姹犱腑鐨勬渶灏忕┖闂茶繛鎺�
+ min-idle: 5
+ # session
+ session:
+ # 20鍒嗛挓
+ timeout: PT20M
+ # 璁剧疆涓婁紶鏂囦欢澶у皬
+ servlet:
+ multipart:
+ enabled: true
+ max-file-size: 204800MB
+ max-request-size: 1048576MB
+ # jackson
+ jackson:
+ time-zone: GMT+8
+ date-format: yyyy-MM-dd HH:mm:ss
+ locale: zh_CN
+ thymeleaf:
+ cache: false
+ # datasource
+ datasource:
+ type: com.alibaba.druid.pool.DruidDataSource
+ #url: jdbc:postgresql://192.168.11.205:5433/jhs?useAffectedRows=true
+ url: jdbc:postgresql://127.0.0.1:5433/jhs?useAffectedRows=true
+ username: postgres
+ #password: Postgres!_14_Lf
+ password: postgres
+ driver-class-name: org.postgresql.Driver
+ platform: POSTGRESQL
+ filters: stat,wall,log4j
+ connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000
+ logAbandoned: true
+ # 閰嶇疆杩炴帴姹犱俊鎭�
+ druid:
+ initial-size: 5
+ min-idle: 5
+ max-active: 100
+ 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
+ validation-query: SELECT 1
+ test-while-idle: true
+ test-on-borrow: false
+ test-on-return: false
+ filters: stat,wall
+ web-stat-filter:
+ enabled: true
+ stat-view-servlet:
+ enabled: true
+ url-pattern: /druid/*
+ reset-enable: false
+ login-username: admin
+ login-password: ad_!Druid!_min
+
+mybatis-plus:
+ type-aliases-package: com.terra.system.entity
+ config-location: classpath:mybatis.xml
+ mapper-locations: classpath:mapper/**/*.xml
+
+# logging
+logging:
+ config: classpath:logback-spring.xml
+
+# RestTemplate config
+remote:
+ maxTotalConnect: 0
+ maxConnectPerRoute: 1000
+ connectTimeout: 30000
+ readTimeout: -1
+
+# 绯荤粺閰嶇疆
+sys:
+ # 鍚敤swagger
+ swaggerEnable: true
+ # 鑷姩鏌ヨ
+ autoQuery: 0
+ # 绠＄悊鍛業D
+ admin: ad_Lf1122_min
+ # IIS鐨勪富鏈哄湴鍧�
+ iisHost: 127.0.0.1
+ # FME鏈嶅姟鍦板潃
+ fmeUrl: http://192.168.11.205:88/
+ # FME浠ょ墝
+ fmeToken: c36e4f94-dfde-401e-9967-2c4a449f1300
+ # 鍑哄浘鏈嶅姟
+ exportServer: http://127.0.0.1/ExportMap
+ # Turf鏈嶅姟
+ turfServer: http://127.0.0.1/Turf
+ # Gdal椹卞姩鐩綍
+ gdal_path: E:\terrait\TianJin\Zip\release-1928-x64-dev\release-1928-x64\bin
+ # 鐡︾墖鍦板潃
+ tile_path: E:\data\2d\tiles
+ path:
+ # 涓嬭浇鐩綍
+ download: D:\JHS\data\download
+ # 涓婁紶鐩綍
+ upload: D:\JHS\data\upload
+ # 涓存椂鐩綍
+ temp: D:\JHS\data\temp
+ cad:
+ exePath: C:/360/MxDrawCloudServer1.0TryVersion/MxDrawCloudServer/Bin/MxCAD/Release/mxcadassembly.exe
+ targetPath: C:/360/MxDrawCloudServer1.0TryVersion/MxDrawCloudServer/SRC/TsWeb/public/data
+ # 涓婁紶闄勪欢琛�
+ attachTabs: bd.b_pac_hydrogeology,bd.b_pac_frozensoil
diff --git a/se-system/src/main/resources/static/favicon.ico b/se-system/src/main/resources/static/favicon.ico
deleted file mode 100644
index f13658b..0000000
--- a/se-system/src/main/resources/static/favicon.ico
+++ /dev/null
Binary files differ
--
Gitblit v1.9.3