From 80ef12799a70a916846aa9cf50562c919e6e9357 Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期四, 13 五月 2021 09:09:48 +0800
Subject: [PATCH] V1.201 edit at date 2021-02-12 1.通过识别当前模块是否是锂电池进行读取锂电池数据
---
BattFBS9600XSP2/src/com/dev/fbs9600/FBS9600_State_SQL.java | 63 +++++++++++++++++++++++++++++++
1 files changed, 63 insertions(+), 0 deletions(-)
diff --git a/BattFBS9600XSP2/src/com/dev/fbs9600/FBS9600_State_SQL.java b/BattFBS9600XSP2/src/com/dev/fbs9600/FBS9600_State_SQL.java
index 6709ea3..9a37fc9 100644
--- a/BattFBS9600XSP2/src/com/dev/fbs9600/FBS9600_State_SQL.java
+++ b/BattFBS9600XSP2/src/com/dev/fbs9600/FBS9600_State_SQL.java
@@ -10,6 +10,60 @@
public class FBS9600_State_SQL {
+ /**
+ * 鎻掑叆鎴栨洿鏂伴攤鐢垫睜鏁版嵁
+ * @param pool
+ * @param data
+ */
+ public static void insertOrUpdate(MysqlConnPool pool,FBS9600_Lithium_Data data) {
+ String sql_str = " SELECT BattGroupId,record_time FROM "+Sql_Mysql.Tb_Lithium_Data_Table+" WHERE BattGroupId = " + data.BattGroupId;
+ String sql_ins = " INSERT INTO "+Sql_Mysql.Tb_Lithium_Data_Table+"(BattGroupId,record_time) VALUES("+data.BattGroupId+",'"+Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms)+"'); ";
+ String sql_upd = " UPDATE " + Sql_Mysql.Tb_Lithium_Data_Table +
+ " Set record_time= '" + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms) +
+ "',envir_tmp= " +data.envir_tmp +
+ ",power_tmp= " + data.power_tmp +
+ ",rest_cap= " + data.rest_cap +
+ ",remote_control_count= " + data.remote_control_count +
+ ",batt_total_cap= " + data.batt_total_cap +
+ ",batt_cycles= " + data.batt_cycles +
+ ",evir_tmp_alm_state= " + data.evir_tmp_alm_state +
+ ",power_tmp_alm_state= " + data.power_tmp_alm_state +
+ ",discharge_curr_alm_state= " + data.discharge_curr_alm_state +
+ ",batt_totalvol_alm_state= " + data.batt_totalvol_alm_state +
+ ",custom_alm_count= " + data.custom_alm_count +
+ ",junheng_event_code= " + data.junheng_event_code +
+ ",vol_event_code= " + data.vol_event_code +
+ ",tmp_event_code= " + data.tmp_event_code +
+ ",curr_event_code= " + data.curr_event_code +
+ ",fet_state_code= " + data.fet_state_code +
+ ",junheng_state_code= " + data.junheng_state_code +
+ ",sys_state_code= " + data.sys_state_code +
+ " WHERE BattGroupId = " + data.BattGroupId;
+ ResultSet res = null;
+ Sql_Mysql sql = new Sql_Mysql(pool.getConn());
+ try {
+ res = sql.sqlMysqlQuery(sql_str);
+ if(res.next()) {
+ sql.sqlMysqlExecute(sql_upd);
+ }else {
+ sql.sqlMysqlExecute(sql_ins);
+ }
+ } catch (Exception e) {
+ e.printStackTrace();
+ } finally {
+ if(null != res) {
+ try {
+ res.close();
+ } catch (SQLException e) {
+ e.printStackTrace();
+ }
+ }
+ sql.close_con();
+ }
+ }
+
+
+
/**
* 鏌ヨ褰撳墠鏄惁鏈夋帶鍒舵搷浣�
@@ -378,4 +432,13 @@
}
}
+
+ public static void main(String[] args) {
+ MysqlConnPool pool = new MysqlConnPool("127.0.0.1", 3360, 10);
+ FBS9600_Lithium_Data data = new FBS9600_Lithium_Data(1000003);
+ insertOrUpdate(pool, data);
+
+
+
+ }
}
--
Gitblit v1.9.1