From dbbdd1006f15da8579d709598ce11116e8f70bfe Mon Sep 17 00:00:00 2001
From: whyclj <1525436766@qq.com>
Date: 星期一, 14 十二月 2020 14:22:14 +0800
Subject: [PATCH] 修复bug
---
Central_Monitor/src/com/data/Comm/Central_DataParsing_Thread_SQL.java | 8 ++++----
1 files changed, 4 insertions(+), 4 deletions(-)
diff --git a/Central_Monitor/src/com/data/Comm/Central_DataParsing_Thread_SQL.java b/Central_Monitor/src/com/data/Comm/Central_DataParsing_Thread_SQL.java
index 4e4f67b..289fb3c 100644
--- a/Central_Monitor/src/com/data/Comm/Central_DataParsing_Thread_SQL.java
+++ b/Central_Monitor/src/com/data/Comm/Central_DataParsing_Thread_SQL.java
@@ -55,9 +55,9 @@
*/
public static void insertOrUpdateTb_Central_Monitor_Sys_St(MysqlConnPool pool,Central_ST_Data stdata) {
String sql_str_sel = " select dev_id from " + Sql_Mysql.Tb_Central_Monitor_Sys_St + " where dev_id = " + stdata.getDev_id();
- String sql_str_ins = " intsert into " + Sql_Mysql.Tb_Central_Monitor_Sys_St + "(dev_id) values("+stdata.getDev_id()+")";
+ String sql_str_ins = " insert into " + Sql_Mysql.Tb_Central_Monitor_Sys_St + "(dev_id) values("+stdata.getDev_id()+")";
String sql_str_upd = " update " + Sql_Mysql.Tb_Central_Monitor_Sys_St + ""
- + " SET record_time '" + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms)
+ + " SET record_time = '" + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms)
+ "',switch_close_1st_2500A = " + stdata.getSwitch_close_1st_2500A()
+ ",switch_open_1st_2500A = " + stdata.getSwitch_open_1st_2500A()
+ ",switch_fault_1st_2500A = " + stdata.getSwitch_fault_1st_2500A()
@@ -108,9 +108,9 @@
*/
public static void insertOrUpdateTb_Central_Monitor_Sys_Rt(MysqlConnPool pool,Central_RT_Data rtdata) {
String sql_str_sel = " select dev_id from " + Sql_Mysql.Tb_Central_Monitor_Sys_Rt + " where dev_id = " + rtdata.getDev_id();
- String sql_str_ins = " intsert into " + Sql_Mysql.Tb_Central_Monitor_Sys_Rt + "(dev_id) values("+rtdata.getDev_id()+")";
+ String sql_str_ins = " insert into " + Sql_Mysql.Tb_Central_Monitor_Sys_Rt + "(dev_id) values("+rtdata.getDev_id()+")";
String sql_str_upd = " update " + Sql_Mysql.Tb_Central_Monitor_Sys_Rt + ""
- + " SET record_time '" + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms)
+ + " SET record_time = '" + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms)
+ "',switch_close = " + rtdata.getSwitch_close()
+ ",switch_open = " + rtdata.getSwitch_open()
+ ",switch_fault = " + rtdata.getSwitch_fault()
--
Gitblit v1.9.1