From e6c729f96678f70aed8f8d3baabe8fb46c1b79b4 Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期五, 25 八月 2023 10:01:07 +0800
Subject: [PATCH] V3.106 lijun edit 2023-08-25 1.修复历史实时数据中的超时历史实时数据表循环删除功能优化 2.优化设备通信计数设备通信断开后重新计数
---
BattFBS9600XSP2/src/com/sql/Sql_Mysql.java | 19 +++++++++++++++++++
1 files changed, 19 insertions(+), 0 deletions(-)
diff --git a/BattFBS9600XSP2/src/com/sql/Sql_Mysql.java b/BattFBS9600XSP2/src/com/sql/Sql_Mysql.java
index 19c72f5..9ef4f59 100644
--- a/BattFBS9600XSP2/src/com/sql/Sql_Mysql.java
+++ b/BattFBS9600XSP2/src/com/sql/Sql_Mysql.java
@@ -318,6 +318,11 @@
sql.setQueryTimeout(30);
sql.execute(sql_str);
}
+ public void sqlMysqlTotalExecute(String sql_str) throws SQLException {
+ Statement sql = this.mysql_con.createStatement();
+ sql.setQueryTimeout(60*10);
+ sql.execute(sql_str);
+ }
public boolean makeManualCommit(ArrayList<String> al_sql_strs) {
boolean exe_res = true;
@@ -368,6 +373,20 @@
return res;
}
+
+ public ResultSet sqlMysqlTotalQuery(String sql_str) {
+ ResultSet res = null;
+ try {
+ Statement sql = this.mysql_con.createStatement();
+ sql.setQueryTimeout(60*5);
+ String query = sql_str;
+ res = sql.executeQuery(query);
+ } catch (SQLException ex) {
+ System.err.println("SQLException:" + ex.getMessage());
+ }
+
+ return res;
+ }
public void sqlMysqlUpdate(String sql_str) {
try {
--
Gitblit v1.9.1