From 9feee6597dc1bb88f7af9eba117a038670f7839d Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期二, 20 九月 2022 15:04:52 +0800
Subject: [PATCH] V1.41 edit at date 2022-09-20 1.新增表'db_ram_db.tb_dev_61851_state'--远程重启装置状态信息表 2.表'db_ram_db.tb_fbs9100_sysparam'新增远程重启装置参数字段 `dev_addr` int(11) NOT NULL DEFAULT '0' COMMENT '61851_设备地址', `tempH_Env` float NOT NULL DEFAULT '0' COMMENT '61851_环境温度高阈值', `tempH_JCQ` float NOT NULL DEFAULT '0' COMMENT '61851_接触器温度高阈值', `currH_ZL` float NOT NULL DEFAULT '0' COMMENT '61851_支路电流高阈值', `km1_switch` tinyint(4) NOT NULL DEFAULT '0' COMMENT '61851_控制KM1开关[1闭合；0：断开]', `km2_switch` tinyint(4) NOT NULL DEFAULT '0' COMMENT '61851_控制KM2开关[1闭合；0：断开]', `km3_switch` tinyint(4) NOT NULL DEFAULT '0' COMMENT '61851_控制KM3开关[1闭合；0：断开]',
---
BattMonitor_DB_Builder/src/com/database_util/DB_Ram_db.java | 153 ++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 152 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 8f7428f..c733e83 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
@@ -113,6 +113,9 @@
//创建山西储能设备实时信息表
createTB_Batt_Gtstate_Table(pool,recreate);
+
+ //创建远程重启装置状态信息表
+ createTB_Dev61851_State_Table(pool,recreate);
}
/**
@@ -143,7 +146,78 @@
" UNIQUE KEY `index_battgroupid` (`BattGroupId`) USING BTREE" +
") ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8";
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
- ResultSet res = null;
+ 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
+ */
+ private static void createTB_Dev61851_State_Table(MysqlConnPool pool, boolean recreate) {
+ String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.TB_Dev61851_State_Table;
+ String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.TB_Dev61851_State_Table + " (" +
+ " `num` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键'," +
+ " `dev_id` int(11) NOT NULL DEFAULT '0' COMMENT '设备ID'," +
+ " `record_time` datetime NOT NULL DEFAULT '2000-01-01 00:00:00' COMMENT '更新时间'," +
+ " `dev_version` varchar(255) NOT NULL DEFAULT '' COMMENT '版本号'," +
+ " `temp_JCQ1` float NOT NULL DEFAULT '0' COMMENT '接触器1温度'," +
+ " `temp_JCQ2` float NOT NULL DEFAULT '0' COMMENT '接触器2温度'," +
+ " `temp_JCQ3` float NOT NULL DEFAULT '0' COMMENT '接触器3温度'," +
+ " `temp_Env` float NOT NULL DEFAULT '0' COMMENT '环境温度'," +
+ " `current1` float NOT NULL DEFAULT '0' COMMENT '电流1'," +
+ " `currentDir1` int(11) NOT NULL DEFAULT '0' COMMENT '电流1方向'," +
+ " `current2` float NOT NULL DEFAULT '0' COMMENT '电流2'," +
+ " `currentDir2` int(11) NOT NULL DEFAULT '0' COMMENT '电流2方向'," +
+ " `current3` float NOT NULL DEFAULT '0' COMMENT '电流3'," +
+ " `currentDir3` int(11) NOT NULL DEFAULT '0' COMMENT '电流3方向'," +
+ " `vol_Power_V1` float NOT NULL DEFAULT '0' COMMENT '电源电压V1'," +
+ " `vol_Power_V2` float NOT NULL DEFAULT '0' COMMENT '电源电压V2'," +
+ " `vol_Vkdz` float NOT NULL DEFAULT '0' COMMENT '总进线电压'," +
+ " `vol_Vkdz_Out` float NOT NULL DEFAULT '0' COMMENT '总控开出电压'," +
+ " `vol_Vk1` float NOT NULL DEFAULT '0' COMMENT '出线1电压'," +
+ " `vol_Vk1_Out` float NOT NULL DEFAULT '0' COMMENT '支路1出电压'," +
+ " `vol_Vk2` float NOT NULL DEFAULT '0' COMMENT '出线2电压'," +
+ " `vol_Vk2_Out` float NOT NULL DEFAULT '0' COMMENT '支路2出电压'," +
+ " `vol_Vk3` float NOT NULL DEFAULT '0' COMMENT '出线3电压'," +
+ " `vol_Vk3_Out` float NOT NULL DEFAULT '0' COMMENT '支路3出电压'," +
+ " `km_State1` int(11) NOT NULL DEFAULT '0' COMMENT '接触器1状态'," +
+ " `km_State2` int(11) NOT NULL DEFAULT '0' COMMENT '接触器2状态'," +
+ " `km_State3` int(11) NOT NULL DEFAULT '0' COMMENT '接触器3状态'," +
+ " `kmz_State` int(11) NOT NULL DEFAULT '0' COMMENT '总空开状态'," +
+ " `kd_State1` int(11) NOT NULL DEFAULT '0' COMMENT '支路开关1状态'," +
+ " `kd_State2` int(11) NOT NULL DEFAULT '0' COMMENT '支路开关2状态'," +
+ " `kd_State3` int(11) NOT NULL DEFAULT '0' COMMENT '支路开关3状态'," +
+ " `kd_ByPass_State1` int(11) NOT NULL DEFAULT '0' COMMENT '旁路开关1状态'," +
+ " `kd_ByPass_State2` int(11) NOT NULL DEFAULT '0' COMMENT '旁路开关2状态'," +
+ " `kd_ByPass_State3` int(11) NOT NULL DEFAULT '0' COMMENT '旁路开关3状态'," +
+ " `alarm_TempEnv_High` int(11) NOT NULL DEFAULT '0' COMMENT '环境温度过高'," +
+ " `alarm_TempJCQ_High1` int(11) NOT NULL DEFAULT '0' COMMENT '接触器1温度过高'," +
+ " `alarm_TempJCQ_High2` int(11) NOT NULL DEFAULT '0' COMMENT '接触器2温度过高'," +
+ " `alarm_TempJCQ_High3` int(11) NOT NULL DEFAULT '0' COMMENT '接触器3温度过高'," +
+ " `alarm_KDZ_Break` int(11) NOT NULL DEFAULT '0' COMMENT '总空开断开'," +
+ " `alarm_KD_Break1` int(11) NOT NULL DEFAULT '0' COMMENT '支路1空开断开'," +
+ " `alarm_KD_Break2` int(11) NOT NULL DEFAULT '0' COMMENT '支路2空开断开'," +
+ " `alarm_KD_Break3` int(11) NOT NULL DEFAULT '0' COMMENT '支路3空开断开'," +
+ " `alarm_KD_BP_Connect1` int(11) NOT NULL DEFAULT '0' COMMENT '旁路1空开闭合'," +
+ " `alarm_KD_BP_Connect2` int(11) NOT NULL DEFAULT '0' COMMENT '旁路2空开闭合'," +
+ " `alarm_KD_BP_Connect3` int(11) NOT NULL DEFAULT '0' COMMENT '旁路3空开闭合'," +
+ " `alarm_CURR_ZL_High1` int(11) NOT NULL DEFAULT '0' COMMENT '支路1电流过高'," +
+ " `alarm_CURR_ZL_High2` int(11) NOT NULL DEFAULT '0' COMMENT '支路2电流过高'," +
+ " `alarm_CURR_ZL_High3` int(11) NOT NULL DEFAULT '0' COMMENT '支路3电流过高'," +
+ " PRIMARY KEY (`num`)," +
+ " KEY `index_dev_id` (`dev_id`) USING BTREE" +
+ ") ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='远程重启装置实时状态信息表';";
+ Sql_Mysql sql = new Sql_Mysql(pool.getConn());
try {
if(true == recreate) {
sql.sqlMysqlExecute(sql_str01);
@@ -1877,6 +1951,83 @@
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SysParam_Table
+ " ADD COLUMN `autoEQChargetTime` int(11) NOT NULL DEFAULT '0' COMMENT '均充时长[并联电源]';");
}
+
+ //添加字段dev_addr 61851_设备地址
+ res = null;
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_ram_db'"
+ + " AND table_name='tb_fbs9100_sysparam'"
+ + " AND column_name='dev_addr'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SysParam_Table
+ + " ADD COLUMN `dev_addr` int(11) NOT NULL DEFAULT '0' COMMENT '61851_设备地址';");
+ }
+
+ //添加字段tempH_Env 61851_环境温度高阈值
+ res = null;
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_ram_db'"
+ + " AND table_name='tb_fbs9100_sysparam'"
+ + " AND column_name='tempH_Env'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SysParam_Table
+ + " ADD COLUMN `tempH_Env` float NOT NULL DEFAULT '0' COMMENT '61851_环境温度高阈值';");
+ }
+
+ //添加字段tempH_JCQ 61851_接触器温度高阈值
+ res = null;
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_ram_db'"
+ + " AND table_name='tb_fbs9100_sysparam'"
+ + " AND column_name='tempH_JCQ'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SysParam_Table
+ + " ADD COLUMN `tempH_JCQ` float NOT NULL DEFAULT '0' COMMENT '61851_接触器温度高阈值';");
+ }
+
+ //添加字段currH_ZL 61851_支路电流高阈值
+ res = null;
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_ram_db'"
+ + " AND table_name='tb_fbs9100_sysparam'"
+ + " AND column_name='currH_ZL'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SysParam_Table
+ + " ADD COLUMN `currH_ZL` float NOT NULL DEFAULT '0' COMMENT '61851_支路电流高阈值';");
+ }
+
+ //添加字段km1_switch 61851_控制KM1开关[1闭合；0：断开]
+ res = null;
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_ram_db'"
+ + " AND table_name='tb_fbs9100_sysparam'"
+ + " AND column_name='km1_switch'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SysParam_Table
+ + " ADD COLUMN `km1_switch` tinyint(4) NOT NULL DEFAULT '0' COMMENT '61851_控制KM1开关[1闭合；0：断开]';");
+ }
+ //添加字段km2_switch 61851_控制KM2开关[1闭合；0：断开]
+ res = null;
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_ram_db'"
+ + " AND table_name='tb_fbs9100_sysparam'"
+ + " AND column_name='km2_switch'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SysParam_Table
+ + " ADD COLUMN `km2_switch` tinyint(4) NOT NULL DEFAULT '0' COMMENT '61851_控制KM2开关[1闭合；0：断开]';");
+ }
+ //添加字段km3_switch 61851_控制KM3开关[1闭合；0：断开]
+ res = null;
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_ram_db'"
+ + " AND table_name='tb_fbs9100_sysparam'"
+ + " AND column_name='km3_switch'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SysParam_Table
+ + " ADD COLUMN `km3_switch` tinyint(4) NOT NULL DEFAULT '0' COMMENT '61851_控制KM3开关[1闭合；0：断开]';");
+ }
+
+
} catch (SQLException e) {
e.printStackTrace();
} finally {
--
Gitblit v1.9.1