From 9867b6134a7e4026e6105c9e70ba7be46c22864b Mon Sep 17 00:00:00 2001
From: DELL <DELL@WIN-3EOIPEE9ML1>
Date: 星期一, 08 四月 2024 09:07:58 +0800
Subject: [PATCH] V1.98 edit at date 2024-04-08 1.表'db_pwrdev_inf.tb_pwrapp_acdcinf'新增字段 `ModuleSwitchStatus` varchar(45) DEFAULT '68719476735' COMMENT '高频开关柜交流模块是否启用', 2.表'db_ram.db.tb_fbs9100s_stemnode_state'新增字段,用于定制版本干接点状态读取 `mode_state` int(11) NOT NULL DEFAULT '0' COMMENT '模块总状态', `drynode_commst` int(11) NOT NULL DEFAULT '43690' COMMENT '干接点通信状态(0xAAAA-正常 0xBBBB-异常)', `k1_check_st` int(11) NOT NULL DEFAULT '43690' COMMENT '接触器k1检测状态(0xAAAA-正常 0xBBBB-异常)', `k2_check_st` int(11) NOT NULL DEFAULT '43690' COMMENT '接触器k2检测状态(0xAAAA-正常 0xBBBB-异常)', `urgentswitch_st` int(11) NOT NULL DEFAULT '43690' COMMENT '急停状态(0xAAAA-未触发 0xBBBB-触发)', `bypassswitch_st` int(11) NOT NULL DEFAULT '43690' COMMENT '旁路状态（0xAAAA-未接入 0xBBBB-接入旁路）', `k1_st` int(11) NOT NULL DEFAULT '0' COMMENT '接触器k1状态（0-断开 1-闭合）',
---
BattMonitor_DB_Builder/src/com/database_util/DB_Ram_db.java | 67 +++++++++++++++++++++++++++++++++
1 files changed, 66 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 f0a787b..0dd7b01 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
@@ -4849,17 +4849,82 @@
" `outputVolt2` float NOT NULL DEFAULT '0' COMMENT '输出电压2'," +
" `outputVolt3` float NOT NULL DEFAULT '0' COMMENT '输出电压3'," +
" `outputVolt4` float NOT NULL DEFAULT '0' COMMENT '输出电压4'," +
+ " `mode_state` int(11) NOT NULL DEFAULT '0' COMMENT '模块总状态'," +
+ " `drynode_commst` int(11) NOT NULL DEFAULT '43690' COMMENT '干接点通信状态(0xAAAA-正常 0xBBBB-异常)'," +
+ " `k1_check_st` int(11) NOT NULL DEFAULT '43690' COMMENT '接触器k1检测状态(0xAAAA-正常 0xBBBB-异常)'," +
+ " `k2_check_st` int(11) NOT NULL DEFAULT '43690' COMMENT '接触器k2检测状态(0xAAAA-正常 0xBBBB-异常)'," +
+ " `urgentswitch_st` int(11) NOT NULL DEFAULT '43690' COMMENT '急停状态(0xAAAA-未触发 0xBBBB-触发)'," +
+ " `bypassswitch_st` int(11) NOT NULL DEFAULT '43690' COMMENT '旁路状态（0xAAAA-未接入 0xBBBB-接入旁路）'," +
+ " `k1_st` int(11) NOT NULL DEFAULT '0' COMMENT '接触器k1状态（0-断开 1-闭合）'," +
" PRIMARY KEY (`num`)," +
" UNIQUE KEY `index_dev_id` (`dev_id`) USING BTREE" +
") ENGINE=InnoDB 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);
+ res = sql.sqlMysqlTotalQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_ram_db'"
+ + " AND table_name='tb_fbs9100s_stemnode_state'"
+ + " AND column_name='mode_state'");
+ if(false == res.next()) {
+ sql.sqlMysqlTotalExecute("ALTER TABLE " + Sql_Mysql.FBS9100s_stemnode_state_Table
+ + " ADD COLUMN `mode_state` int(11) NOT NULL DEFAULT '0' COMMENT '模块总状态';");
+ }
+ res = sql.sqlMysqlTotalQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_ram_db'"
+ + " AND table_name='tb_fbs9100s_stemnode_state'"
+ + " AND column_name='drynode_commst'");
+ if(false == res.next()) {
+ sql.sqlMysqlTotalExecute("ALTER TABLE " + Sql_Mysql.FBS9100s_stemnode_state_Table
+ + " ADD COLUMN `drynode_commst` int(11) NOT NULL DEFAULT '43690' COMMENT '干接点通信状态(0xAAAA-正常 0xBBBB-异常)';");
+ }
+ res = sql.sqlMysqlTotalQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_ram_db'"
+ + " AND table_name='tb_fbs9100s_stemnode_state'"
+ + " AND column_name='k1_check_st'");
+ if(false == res.next()) {
+ sql.sqlMysqlTotalExecute("ALTER TABLE " + Sql_Mysql.FBS9100s_stemnode_state_Table
+ + " ADD COLUMN `k1_check_st` int(11) NOT NULL DEFAULT '43690' COMMENT '接触器k1检测状态(0xAAAA-正常 0xBBBB-异常)';");
+ }
+ res = sql.sqlMysqlTotalQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_ram_db'"
+ + " AND table_name='tb_fbs9100s_stemnode_state'"
+ + " AND column_name='k2_check_st'");
+ if(false == res.next()) {
+ sql.sqlMysqlTotalExecute("ALTER TABLE " + Sql_Mysql.FBS9100s_stemnode_state_Table
+ + " ADD COLUMN `k2_check_st` int(11) NOT NULL DEFAULT '43690' COMMENT '接触器k2检测状态(0xAAAA-正常 0xBBBB-异常)';");
+ }
+ res = sql.sqlMysqlTotalQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_ram_db'"
+ + " AND table_name='tb_fbs9100s_stemnode_state'"
+ + " AND column_name='urgentswitch_st'");
+ if(false == res.next()) {
+ sql.sqlMysqlTotalExecute("ALTER TABLE " + Sql_Mysql.FBS9100s_stemnode_state_Table
+ + " ADD COLUMN `urgentswitch_st` int(11) NOT NULL DEFAULT '43690' COMMENT '急停状态(0xAAAA-未触发 0xBBBB-触发)';");
+ }
+ res = sql.sqlMysqlTotalQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_ram_db'"
+ + " AND table_name='tb_fbs9100s_stemnode_state'"
+ + " AND column_name='bypassswitch_st'");
+ if(false == res.next()) {
+ sql.sqlMysqlTotalExecute("ALTER TABLE " + Sql_Mysql.FBS9100s_stemnode_state_Table
+ + " ADD COLUMN `bypassswitch_st` int(11) NOT NULL DEFAULT '43690' COMMENT '旁路状态（0xAAAA-未接入 0xBBBB-接入旁路）';");
+ }
+ res = sql.sqlMysqlTotalQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_ram_db'"
+ + " AND table_name='tb_fbs9100s_stemnode_state'"
+ + " AND column_name='k1_st'");
+ if(false == res.next()) {
+ sql.sqlMysqlTotalExecute("ALTER TABLE " + Sql_Mysql.FBS9100s_stemnode_state_Table
+ + " ADD COLUMN `k1_st` int(11) NOT NULL DEFAULT '0' COMMENT '接触器k1状态（0-断开 1-闭合）';");
+ }
+
+
} catch (SQLException e) {
e.printStackTrace();
} finally {
--
Gitblit v1.9.1