BattMonitor_DB_Builder/bin/com/database_util/DB_Pwrdev_Inf.classBinary files differ
BattMonitor_DB_Builder/bin/com/database_util/DB_Ram_db.classBinary files differ
BattMonitor_DB_Builder/bin/com/version_inf/version_inf.txt
@@ -1,6 +1,19 @@ 蓄电池监控平台建表程序 注意:1.新增电源机房时需要重新运行 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-闭合）', V1.97 edit at date 2024-03-27 1.新增数据表 'web_site.tb_resset_station' CREATE TABLE `tb_resset_station` ( BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Inf.java
@@ -397,18 +397,37 @@ " `ModuleInUseCount` int(11) NOT NULL DEFAULT '0'," + " `ModuleCap` int(11) NOT NULL DEFAULT '0'," + " `ModuleSlotCount` int(11) NOT NULL DEFAULT '0'," + " `ModuleSwitchStatus` varchar(45) DEFAULT '68719476735' COMMENT '高频开关柜交流模块是否启用'," + " PRIMARY KEY (`num`)," + " KEY `index_pwrdev_id` (`PowerDeviceId`)" + ") 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); res = sql.sqlMysqlTotalQuery("SELECT * FROM information_schema.columns" + " WHERE table_schema='db_pwrdev_inf'" + " AND table_name='tb_pwrapp_acdcinf'" + " AND column_name='ModuleSwitchStatus'"); if(false == res.next()) { sql.sqlMysqlTotalExecute("ALTER TABLE " + Sql_Mysql.Pwrapp_Acdcinf_Table + " ADD COLUMN `ModuleSwitchStatus` varchar(45) DEFAULT '68719476735' COMMENT '高频开关柜交流模块是否启用';"); } } catch (SQLException e) { e.printStackTrace(); } finally { if(null != res) { try { res.close(); } catch (SQLException e) { e.printStackTrace(); } } sql.close_con(); } } 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 { BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt
@@ -1,6 +1,19 @@ 蓄电池监控平台建表程序 注意:1.新增电源机房时需要重新运行 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-闭合）', V1.97 edit at date 2024-03-27 1.新增数据表 'web_site.tb_resset_station' CREATE TABLE `tb_resset_station` ( BattMonitor_DB_Builder/src/main/main_BTS_DB_Builder.java
@@ -37,7 +37,7 @@ /**************************************************************************/ /**************************************************************************/ public final static boolean app_debug = false; public final static float m_VersionNum = (float) 1.97; public final static float m_VersionNum = (float) 1.98; public final static String m_Version = "Welcome To Use BTS DB BUILDER V" + m_VersionNum + " RC_20180908"; /**************************************************************************/ /**************************************************************************/
