From 6ffac77ff7d9d0f1be85a67dcece6d05b3a3d5c3 Mon Sep 17 00:00:00 2001
From: DELL <1525436766@qq.com>
Date: 星期二, 18 三月 2025 09:31:37 +0800
Subject: [PATCH] V2.10 edit at date 2025-03-18 1.新增东峰系统对接bms实时数据表'db_ram_db.tb_dfxt_bms_state'
---
BattMonitor_DB_Builder/src/com/database_util/DB_Ram_db.java | 137 +++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 136 insertions(+), 1 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/database_util/DB_Ram_db.java b/BattMonitor_DB_Builder/src/com/database_util/DB_Ram_db.java
index 02da49f..579b7d5 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_Ram_db.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/DB_Ram_db.java
@@ -147,6 +147,9 @@
//创建 交直流监控屏实时数据表
createAcdc_Secuity_Table(pool, recreate);
+
+ //创建东峰BMS实时数据表
+ createTb_Dfxt_Bms_State_Table(pool, recreate);
System.out.println(" Db_Ram_Db init end at " + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms));
}
@@ -4975,7 +4978,7 @@
+ " AND column_name='control_fail_type'");
if(false == res.next()) {
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattRtState_Table
- + " ADD COLUMN `control_fail_type` int(11) NOT NULL DEFAULT '0' COMMENT '启动失败原因\\r\\n6186-[\\r\\n0x00-成功\\r\\n0x03-内部通信故障\\r\\n0x04-系统存在告警\\r\\n0x05-系统测试中\\r\\n0x06-输入电压过高\\r\\n0x07-输入电压过低\\r\\n0X08-负载功率太小\\r\\n0x09-两段直流母线压差大\\r\\n0x0A-两段电池组压差大\\r\\n0x0B-远程闭锁状态\\r\\n0x0C-急停状态\\r\\n0x0D-切换开关粘连或电源状态异常\\r\\n0x0E-启动频繁\\r\\n0x0F-系统正在内阻测试\\r\\n0xFF-未知\\r\\n]';");
+ + " ADD COLUMN `control_fail_type` int(11) NOT NULL DEFAULT '0' COMMENT '启动失败原因\\r6186-[\\r0x00-成功\\r0x03-内部通信故障\\r0x04-系统存在告警\\r0x05-系统测试中\\r0x06-输入电压过高\\r0x07-输入电压过低\\r0X08-负载功率太小\\r0x09-两段直流母线压差大\\r0x0A-两段电池组压差大\\r0x0B-远程闭锁状态\\r0x0C-急停状态\\r0x0D-切换开关粘连或电源状态异常\\r0x0E-启动频繁\\r0x0F-系统正在内阻测试\\r0xFF-未知\\r]';");
}
//新增字段'last_captest_stop_type' --上一次核容终止原因
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
@@ -5372,6 +5375,138 @@
}
/**
+ * 创建 tb_lithium_data 表
+ * @param pool
+ * @param recreate
+ */
+ public static void createTb_Dfxt_Bms_State_Table(MysqlConnPool pool, boolean recreate) {
+ String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Dfxt_Bms_State_Table;
+ String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Dfxt_Bms_State_Table+ " (" +
+ " `num` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '自增主键'," +
+ " `dev_id` int(11) NOT NULL DEFAULT '1' COMMENT '设备ID'," +
+ " `record_time` datetime NOT NULL DEFAULT '2000-01-01 00:00:00' COMMENT '更新时间[从平台获取数据更新时间]'," +
+ " `battery_type` int(11) NOT NULL DEFAULT '0' COMMENT '电池类型'," +
+ " `bcst` int(11) NOT NULL DEFAULT '0' COMMENT '电池串数'," +
+ " `cpbv` float(11,0) NOT NULL DEFAULT '0' COMMENT '单体充电保护电压'," +
+ " `srbv` float(11,0) NOT NULL DEFAULT '0' COMMENT '单体充电恢复电压'," +
+ " `dpbv` float(11,0) NOT NULL DEFAULT '0' COMMENT '单体放电保护电压'," +
+ " `drbv` float(11,0) NOT NULL DEFAULT '0' COMMENT '单体放电恢复电压'," +
+ " `sspv` float(11,0) NOT NULL DEFAULT '0' COMMENT '单节压差保护电压'," +
+ " `acpbv` float NOT NULL DEFAULT '0' COMMENT '总充电保护电压'," +
+ " `asrbv` float(11,0) NOT NULL DEFAULT '0' COMMENT '总充电恢复电压'," +
+ " `adpbv` float NOT NULL DEFAULT '0' COMMENT '总放电保护电压'," +
+ " `adrbv` float NOT NULL DEFAULT '0' COMMENT '总放电恢复电压'," +
+ " `ascpv` float NOT NULL DEFAULT '0' COMMENT '二次充电保护电压'," +
+ " `asdpv` float NOT NULL DEFAULT '0' COMMENT '二次放电保护电压'," +
+ " `nchp_1` varchar(64) NOT NULL DEFAULT '0,0,0' COMMENT '充电过流保护档位1'," +
+ " `nchp_2` varchar(64) NOT NULL DEFAULT '0,0,0' COMMENT '充电过流保护档位2'," +
+ " `nchp_3` varchar(64) NOT NULL DEFAULT '0,0,0' COMMENT '充电过流保护档位3'," +
+ " `ndhp_1` varchar(64) NOT NULL DEFAULT '0,0,0' COMMENT '放电过流保护档位1'," +
+ " `ndhp_2` varchar(64) NOT NULL DEFAULT '0,0,0' COMMENT '放电过流保护档位2'," +
+ " `ndhp_3` varchar(64) NOT NULL DEFAULT '0,0,0' COMMENT '放电过流保护档位3'," +
+ " `npcm_1` varchar(64) NOT NULL DEFAULT '0,0,0,0' COMMENT '主板温度保护值'," +
+ " `npcm_2` varchar(64) NOT NULL DEFAULT '0,0,0,0' COMMENT '电池温度1保护值'," +
+ " `npcm_3` varchar(64) NOT NULL DEFAULT '0,0,0,0' COMMENT '电池温度2保护值'," +
+ " `npcm_4` varchar(64) NOT NULL DEFAULT '0,0,0,0' COMMENT '电池温度3保护值'," +
+ " `npcm_5` varchar(64) NOT NULL DEFAULT '0,0,0,0' COMMENT '电池温度4保护值'," +
+ " `bcrl` int(11) NOT NULL DEFAULT '0' COMMENT '标称容量'," +
+ " `boardrated` float NOT NULL DEFAULT '0' COMMENT '额定电流'," +
+ " `emst` int(11) NOT NULL DEFAULT '0' COMMENT '均衡开关'," +
+ " `esbv` float NOT NULL DEFAULT '0' COMMENT '均衡启控电压'," +
+ " `esba` float NOT NULL DEFAULT '0' COMMENT '均衡电流'," +
+ " `chon` int(11) NOT NULL DEFAULT '0' COMMENT '充电开关'," +
+ " `dhon` int(11) NOT NULL DEFAULT '0' COMMENT '放电开关'," +
+ " `lrlav` float(11,0) NOT NULL DEFAULT '0' COMMENT '低容量报警值'," +
+ " `bms_datetime` bigint(20) NOT NULL DEFAULT '0' COMMENT 'bms时间'," +
+ " `batterytype` int(11) NOT NULL DEFAULT '0' COMMENT '电池类型(0-三元 1-铁锂）'," +
+ " `workstate` int(11) NOT NULL DEFAULT '0' COMMENT '0-放电中 1-充电中 2-闲置'," +
+ " `batteryc` int(11) NOT NULL DEFAULT '0' COMMENT '电池数量'," +
+ " `battery_v1` float NOT NULL DEFAULT '0' COMMENT '电池1电压'," +
+ " `battery_v2` float NOT NULL DEFAULT '0' COMMENT '电池2电压'," +
+ " `battery_v3` float NOT NULL DEFAULT '0' COMMENT '电池3电压'," +
+ " `battery_v4` float NOT NULL DEFAULT '0' COMMENT '电池4电压'," +
+ " `battery_v5` float NOT NULL DEFAULT '0' COMMENT '电池5电压'," +
+ " `battery_v6` float NOT NULL DEFAULT '0' COMMENT '电池6电压'," +
+ " `battery_v7` float NOT NULL DEFAULT '0' COMMENT '电池7电压'," +
+ " `battery_v8` float NOT NULL DEFAULT '0' COMMENT '电池8电压'," +
+ " `battery_v9` float NOT NULL DEFAULT '0' COMMENT '电池9电压'," +
+ " `battery_v10` float NOT NULL DEFAULT '0' COMMENT '电池10电压'," +
+ " `battery_v11` float NOT NULL DEFAULT '0' COMMENT '电池11电压'," +
+ " `battery_v12` float NOT NULL DEFAULT '0' COMMENT '电池12电压'," +
+ " `battery_v13` float NOT NULL DEFAULT '0' COMMENT '电池13电压'," +
+ " `battery_v14` float NOT NULL DEFAULT '0' COMMENT '电池14电压'," +
+ " `battery_v15` float NOT NULL DEFAULT '0' COMMENT '电池15电压'," +
+ " `battery_v16` float NOT NULL DEFAULT '0' COMMENT '电池16电压'," +
+ " `battery_v17` float NOT NULL DEFAULT '0' COMMENT '电池17电压'," +
+ " `battery_v18` float NOT NULL DEFAULT '0' COMMENT '电池18电压'," +
+ " `battery_v19` float NOT NULL DEFAULT '0' COMMENT '电池19电压'," +
+ " `battery_v20` float NOT NULL DEFAULT '0' COMMENT '电池20电压'," +
+ " `battery_v21` float NOT NULL DEFAULT '0' COMMENT '电池21电压'," +
+ " `battery_v22` float NOT NULL DEFAULT '0' COMMENT '电池22电压'," +
+ " `battery_v23` float NOT NULL DEFAULT '0' COMMENT '电池23电压'," +
+ " `battery_v24` float NOT NULL DEFAULT '0' COMMENT '电池24电压'," +
+ " `battery_v25` float NOT NULL DEFAULT '0' COMMENT '电池25电压'," +
+ " `battery_v26` float NOT NULL DEFAULT '0' COMMENT '电池26电压'," +
+ " `battery_v27` float NOT NULL DEFAULT '0' COMMENT '电池27电压'," +
+ " `battery_v28` float NOT NULL DEFAULT '0' COMMENT '电池28电压'," +
+ " `battery_v29` float NOT NULL DEFAULT '0' COMMENT '电池29电压'," +
+ " `battery_v30` float NOT NULL DEFAULT '0' COMMENT '电池30电压'," +
+ " `battery_v31` float NOT NULL DEFAULT '0' COMMENT '电池31电压'," +
+ " `battery_v32` float NOT NULL DEFAULT '0' COMMENT '电池32电压'," +
+ " `ceilingvoltage` float NOT NULL DEFAULT '0' COMMENT '单体最高电压'," +
+ " `minimumvoltage` float NOT NULL DEFAULT '0' COMMENT '单体最低电压'," +
+ " `cvoltagesub` float NOT NULL DEFAULT '0' COMMENT '单体最大压差'," +
+ " `single_over_pressure` int(11) NOT NULL DEFAULT '0' COMMENT '单体过压次数'," +
+ " `single_under_voltage` int(11) NOT NULL DEFAULT '0' COMMENT '单体欠压次数'," +
+ " `betteryv_all` float NOT NULL DEFAULT '0' COMMENT '总电压'," +
+ " `whole_over_pressure` int(11) NOT NULL DEFAULT '0' COMMENT '整体过压次数'," +
+ " `whole_under_pressure` int(11) NOT NULL DEFAULT '0' COMMENT '整体欠压次数'," +
+ " `cpowera` float NOT NULL DEFAULT '0' COMMENT '充电电流'," +
+ " `outcharging_highcount` int(11) NOT NULL DEFAULT '0' COMMENT '充电过流次数'," +
+ " `dpowera` float NOT NULL DEFAULT '0' COMMENT '放电电流'," +
+ " `outuncharging_highcount` int(11) NOT NULL DEFAULT '0' COMMENT '放电过流次数'," +
+ " `cpstatus` int(11) NOT NULL DEFAULT '0' COMMENT '充电保护状态（0-正常 1-硬控保护 2-软控保护）'," +
+ " `cpcount` int(11) NOT NULL DEFAULT '0' COMMENT '充电保护次数'," +
+ " `dpstatus` int(11) NOT NULL DEFAULT '0' COMMENT '放电保护状态（0-正常 1-硬控保护 2-软控保护）'," +
+ " `dpcount` int(11) NOT NULL DEFAULT '0' COMMENT '放电保护次数'," +
+ " `scprotect` int(11) NOT NULL DEFAULT '0' COMMENT '短路保护（0-正常 1-保护）'," +
+ " `scpcount` int(11) NOT NULL DEFAULT '0' COMMENT '短路保护次数'," +
+ " `balance_type` int(11) NOT NULL DEFAULT '0' COMMENT '均衡类型（0-无均衡 1-被动 2-主动）'," +
+ " `em` int(11) NOT NULL DEFAULT '0' COMMENT '均衡开关（0-关 1-开）'," +
+ " `ems_1` int(11) NOT NULL DEFAULT '0' COMMENT '电池1均衡状态（0-关 1-开）'," +
+ " `ems_2` int(11) NOT NULL DEFAULT '0' COMMENT '电池2均衡状态（0-关 1-开）'," +
+ " `bxhc` int(11) NOT NULL DEFAULT '0' COMMENT '循环使用次数'," +
+ " `tc_t` float NOT NULL DEFAULT '0' COMMENT '保护板温度'," +
+ " `tc_b1` float NOT NULL DEFAULT '0' COMMENT '电池温度1'," +
+ " `tc_b2` float NOT NULL DEFAULT '0' COMMENT '电池温度2'," +
+ " `cpsuperheat` int(11) NOT NULL DEFAULT '0' COMMENT '充电过温次数'," +
+ " `cpsubcooled` int(11) NOT NULL DEFAULT '0' COMMENT '充电低温次数'," +
+ " `dpsuperheat` int(11) NOT NULL DEFAULT '0' COMMENT '放电过温次数'," +
+ " `dpsubcooled` int(11) NOT NULL DEFAULT '0' COMMENT '放电低温次数'," +
+ " `fcc` float NOT NULL DEFAULT '0' COMMENT '标称容量'," +
+ " `syla` float NOT NULL DEFAULT '0' COMMENT '剩余容量'," +
+ " `soc` float NOT NULL DEFAULT '0' COMMENT '剩余容量百分比'," +
+ " `ccxx` varchar(255) NOT NULL DEFAULT '' COMMENT '出厂日期'," +
+ " `bmscode` varchar(255) NOT NULL DEFAULT '' COMMENT '厂商编码'," +
+ " `bms_dev_datetime` bigint(20) NOT NULL DEFAULT '0' COMMENT '设备时间'," +
+ " PRIMARY KEY (`num`)" +
+ ") ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;";
+ Sql_Mysql sql = new Sql_Mysql(pool.getConn());
+
+ try {
+ if(true == recreate) {
+ sql.sqlMysqlExecute(sql_str01);
+ }
+ sql.sqlMysqlExecute(sql_str02);
+
+ } catch (SQLException e) {
+ e.printStackTrace();
+ } finally {
+ sql.close_con();
+ }
+ }
+
+ /**
* 创建组端信息告警记录表
* @param pool
* @param recreate
--
Gitblit v1.9.1