From 9abea15a209abe0ee319b3b8486b0fdcdf46ac82 Mon Sep 17 00:00:00 2001
From: Administrator <15274802129@163.com>
Date: Thu, 04 Jun 2026 14:13:48 +0800
Subject: [PATCH] refactor(gateApi): 更新MySQL驱动并优化ApiClient配置

---
 src/main/resources/application-newprice.yml                              |    2 +-
 src/main/java/com/xcong/excoin/modules/gateApi/GateGridTradeService.java |   27 ++++++---------------------
 src/main/resources/application-loop.yml                                  |    2 +-
 src/main/resources/application-app.yml                                   |    2 +-
 src/main/resources/application-test.yml                                  |    2 +-
 src/main/resources/application.yml                                       |    2 +-
 src/main/resources/application-dayline.yml                               |    2 +-
 7 files changed, 12 insertions(+), 27 deletions(-)

diff --git a/src/main/java/com/xcong/excoin/modules/gateApi/GateGridTradeService.java b/src/main/java/com/xcong/excoin/modules/gateApi/GateGridTradeService.java
index d190e26..e277173 100644
--- a/src/main/java/com/xcong/excoin/modules/gateApi/GateGridTradeService.java
+++ b/src/main/java/com/xcong/excoin/modules/gateApi/GateGridTradeService.java
@@ -11,9 +11,6 @@
 import io.gate.gateapi.models.*;
 import lombok.extern.slf4j.Slf4j;
 
-import okhttp3.ConnectionPool;
-import okhttp3.OkHttpClient;
-
 import java.io.IOException;
 import java.math.BigDecimal;
 import java.math.RoundingMode;
@@ -22,7 +19,6 @@
 import java.util.LinkedHashMap;
 import java.util.List;
 import java.util.Map;
-import java.util.concurrent.TimeUnit;
 
 import com.xcong.excoin.modules.gateApi.wsHandler.handler.CandlestickChannelHandler;
 import com.xcong.excoin.modules.gateApi.wsHandler.handler.PositionClosesChannelHandler;
@@ -153,24 +149,11 @@
 
     public GateGridTradeService(GateConfig config) {
         this.config = config;
-        ApiClient apiClient = createApiClient(config);
+        ApiClient apiClient = new ApiClient();
+        apiClient.setBasePath(config.getRestBasePath());
+        apiClient.setApiKeySecret(config.getApiKey(), config.getApiSecret());
         this.futuresApi = new FuturesApi(apiClient);
         this.executor = new GateTradeExecutor(apiClient, config.getContract());
-    }
-
-    private static ApiClient createApiClient(GateConfig config) {
-        OkHttpClient httpClient = new OkHttpClient.Builder()
-                .connectTimeout(30, TimeUnit.SECONDS)
-                .readTimeout(60, TimeUnit.SECONDS)
-                .writeTimeout(20, TimeUnit.SECONDS)
-                .connectionPool(new ConnectionPool(5, 5, TimeUnit.SECONDS))
-                .retryOnConnectionFailure(true)
-                .build();
-        ApiClient client = new ApiClient();
-        client.setBasePath(config.getRestBasePath());
-        client.setApiKeySecret(config.getApiKey(), config.getApiSecret());
-        client.setHttpClient(httpClient);
-        return client;
     }
 
     // ---- 初始化 ----
@@ -191,7 +174,9 @@
      */
     public void init() {
         try {
-            ApiClient detailClient = createApiClient(config);
+            ApiClient detailClient = new ApiClient();
+            detailClient.setBasePath(config.getRestBasePath());
+            detailClient.setApiKeySecret(config.getApiKey(), config.getApiSecret());
             AccountDetail detail = new AccountApi(detailClient).getAccountDetail();
             this.userId = detail.getUserId();
             log.info("[Gate] 用户ID: {}", userId);
diff --git a/src/main/resources/application-app.yml b/src/main/resources/application-app.yml
index 54399b2..ff8f05a 100644
--- a/src/main/resources/application-app.yml
+++ b/src/main/resources/application-app.yml
@@ -10,7 +10,7 @@
     url: jdbc:mysql://127.0.0.1:3306/db_base?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=GMT%2b8
     username: db_base
     password: P@ssw0rd!123
-    driver-class-name: com.mysql.jdbc.Driver
+    driver-class-name: com.mysql.cj.jdbc.Driver
     type: com.alibaba.druid.pool.DruidDataSource
     druid:
       initial-size: ${spring_datasource_druid_initial_size:10}
diff --git a/src/main/resources/application-dayline.yml b/src/main/resources/application-dayline.yml
index ebe047a..416ae8d 100644
--- a/src/main/resources/application-dayline.yml
+++ b/src/main/resources/application-dayline.yml
@@ -10,7 +10,7 @@
     url: jdbc:mysql://rm-bp151tw8er79ig9kb5o.mysql.rds.aliyuncs.com:3306/db_biue?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=GMT%2b8
     username: ctcoin_data
     password: ctcoin_123
-    driver-class-name: com.mysql.jdbc.Driver
+    driver-class-name: com.mysql.cj.jdbc.Driver
     type: com.alibaba.druid.pool.DruidDataSource
     druid:
       initial-size: ${spring_datasource_druid_initial_size:10}
diff --git a/src/main/resources/application-loop.yml b/src/main/resources/application-loop.yml
index a77d03e..a79046c 100644
--- a/src/main/resources/application-loop.yml
+++ b/src/main/resources/application-loop.yml
@@ -10,7 +10,7 @@
     url: jdbc:mysql://rm-bp151tw8er79ig9kb5o.mysql.rds.aliyuncs.com:3306/db_biue?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=GMT%2b8
     username: ctcoin_data
     password: ctcoin_123
-    driver-class-name: com.mysql.jdbc.Driver
+    driver-class-name: com.mysql.cj.jdbc.Driver
     type: com.alibaba.druid.pool.DruidDataSource
     druid:
       initial-size: ${spring_datasource_druid_initial_size:10}
diff --git a/src/main/resources/application-newprice.yml b/src/main/resources/application-newprice.yml
index 75aadb3..a363e34 100644
--- a/src/main/resources/application-newprice.yml
+++ b/src/main/resources/application-newprice.yml
@@ -10,7 +10,7 @@
     url: jdbc:mysql://rm-bp151tw8er79ig9kb5o.mysql.rds.aliyuncs.com:3306/db_biue?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=GMT%2b8
     username: ctcoin_data
     password: ctcoin_123
-    driver-class-name: com.mysql.jdbc.Driver
+    driver-class-name: com.mysql.cj.jdbc.Driver
     type: com.alibaba.druid.pool.DruidDataSource
     druid:
       initial-size: ${spring_datasource_druid_initial_size:10}
diff --git a/src/main/resources/application-test.yml b/src/main/resources/application-test.yml
index 91f5dcc..21cd98d 100644
--- a/src/main/resources/application-test.yml
+++ b/src/main/resources/application-test.yml
@@ -10,7 +10,7 @@
     url: jdbc:mysql://120.27.238.55:3406/db_base?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=GMT%2b8
     username: ct_test
     password: 123456
-    driver-class-name: com.mysql.jdbc.Driver
+    driver-class-name: com.mysql.cj.jdbc.Driver
     type: com.alibaba.druid.pool.DruidDataSource
     druid:
       initial-size: ${spring_datasource_druid_initial_size:10}
diff --git a/src/main/resources/application.yml b/src/main/resources/application.yml
index 3553379..e7c31eb 100644
--- a/src/main/resources/application.yml
+++ b/src/main/resources/application.yml
@@ -12,7 +12,7 @@
     url: jdbc:mysql://120.27.238.55:3406/db_base?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=GMT%2b8
     username: ct_test
     password: 123456
-    driver-class-name: com.mysql.jdbc.Driver
+    driver-class-name: com.mysql.cj.jdbc.Driver
     type: com.alibaba.druid.pool.DruidDataSource
     druid:
       initial-size: ${spring_datasource_druid_initial_size:10}

--
Gitblit v1.9.1