From 26696408ae5298bd6773f7c768417eb964f530ad Mon Sep 17 00:00:00 2001
From: DELL <DELL@WIN-3EOIPEE9ML1>
Date: 星期二, 23 一月 2024 16:55:56 +0800
Subject: [PATCH] V1.102 2024-01-22 1.电源通信程序运行时不再删除配电柜实时状态表重新创建 2.读取方式改为从集合中读取 3.ACDC高频开关柜数据中的整流模块的输出电流,开关机状态，故障状态 新增至20个
---
IEC61850_ForPowerSupply_ForNW/src/com/power/datasave/PowerDataSave_SQL.java | 8 ++++----
1 files changed, 4 insertions(+), 4 deletions(-)
diff --git a/IEC61850_ForPowerSupply_ForNW/src/com/power/datasave/PowerDataSave_SQL.java b/IEC61850_ForPowerSupply_ForNW/src/com/power/datasave/PowerDataSave_SQL.java
index 8afe607..5f92e41 100644
--- a/IEC61850_ForPowerSupply_ForNW/src/com/power/datasave/PowerDataSave_SQL.java
+++ b/IEC61850_ForPowerSupply_ForNW/src/com/power/datasave/PowerDataSave_SQL.java
@@ -107,14 +107,14 @@
" from information_schema.tables " +
" where table_schema='db_pwrdev_data_history' " +
" AND TABLE_NAME like 'tb_pwrdev_historydata_%' " +
- " AND UPDATE_TIME <= '"+Com.getDateTimeFormat(deldate, Com.DTF_YMDhms)+"';" ;
+ " AND CREATE_TIME <= '"+Com.getDateTimeFormat(deldate, Com.DTF_YMDhms)+"';" ;
String sql_delete_strs = " DROP TABLE IF EXISTS ";
Sql_Mysql sql = new Sql_Mysql(conn_pool.getConn());
ResultSet res = null;
int count = 0;
- res = sql.sqlMysqlQuery(sql_select_strs);
+ res = sql.sqlMysqlTotalQuery(sql_select_strs);
try {
while(res.next()) {
if(count > 0) {
@@ -126,7 +126,7 @@
count++;
}
if(count > 0) {
- sql.sqlMysqlExecute(sql_delete_strs);
+ sql.sqlMysqlTotalExecute(sql_delete_strs);
}
res.close();
@@ -284,9 +284,9 @@
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
- //System.out.println(sql_str);
try {
+ System.out.println(sql_str);
sql.sqlMysqlExecute(sql_str);
} catch (SQLException e) {
sql.logger.error(e.toString(), e);
--
Gitblit v1.9.1