| BattMonitor_DB_Builder/bin/com/database_util/DB_Ram_db.class | 补丁 | 查看 | 原始文档 | blame | 历史 | |
| BattMonitor_DB_Builder/bin/com/version_inf/version_inf.txt | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| BattMonitor_DB_Builder/src/com/database_util/DB_Ram_db.java | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| BattMonitor_DB_Builder/src/main/main_BTS_DB_Builder.java | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
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,33 @@ 蓄电池监控平台建表程序 注意:1.新增电源机房时需要重新运行 V2.01 edit at date 2024-04-25 1.新增表'db_ram_db.tb_intelligentbusbar_state'-智能母联实时状态表 CREATE TABLE `tb_intelligentbusbar_state` ( `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 '记录时间', `dcdc1_temp` float NOT NULL DEFAULT '0' COMMENT 'DCDC1_实时温度', `dcdc2_temp` float NOT NULL DEFAULT '0' COMMENT 'DCDC2实时温度', `dcdc1_outputvol` float NOT NULL DEFAULT '0' COMMENT 'DCDC1实时输出电压', `dcdc2_outputvol` float NOT NULL DEFAULT '0' COMMENT 'DCDC2实时输出电压', `dcdc1_outputcurr` float NOT NULL DEFAULT '0' COMMENT 'DCDC1实时输出电流', `dcdc2_outputcurr` float NOT NULL DEFAULT '0' COMMENT 'DCDC2实时输出电流', `dcdc1_inputvol` float NOT NULL DEFAULT '0' COMMENT 'DCDC1实时输入电压', `dcdc2_inputvol` float NOT NULL DEFAULT '0' COMMENT 'DCDC2实时输入电压', `dcdc1_inputcurr` float NOT NULL DEFAULT '0' COMMENT 'DCDC1实时输入电流', `dcdc2_inputcurr` float unsigned NOT NULL DEFAULT '0' COMMENT 'DCDC1实时输入电流', `dcdc1_errcode` int(11) NOT NULL DEFAULT '0' COMMENT 'DCDC1 异常代码-状态', `dcdc2_errcode` int(11) NOT NULL DEFAULT '0' COMMENT 'DCDC2 异常代码-状态', PRIMARY KEY (`num`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='智能母联实时状态表'; 2.表'db_ram_db.tb_fbs9100_setparam'新增字段 --智能母联参数信息 `dcdc1_outputvol` float NOT NULL DEFAULT '0' COMMENT 'DCDC1输出电压', `dcdc2_outputvol` float NOT NULL DEFAULT '0' COMMENT 'DCDC2输出电压', `dcdc1_outputcurr` float NOT NULL DEFAULT '0' COMMENT 'DCDC1输出限流值', `dcdc2_outputcurr` float NOT NULL DEFAULT '0' COMMENT 'DCDC2输出限流值', `screensaver_time` int(11) NOT NULL DEFAULT '10' COMMENT '进入屏幕保护时间（不能小于10分钟）', V1.99 edit at date 2024-04-19 1.表新增字段 'web_site.tb_badbatt_mon'新增字段 `flag` int(11) DEFAULT '4' 1：损坏，2：劣化，3：优秀时(note 1)，4，无法判断 BattMonitor_DB_Builder/src/com/database_util/DB_Ram_db.java
@@ -132,6 +132,9 @@ //创建充放电一体机离线检测表 createCheck_Dialog_Table(pool,recreate); //创建智能母联实时状态信息表 createIntelligentBusbar_State_Table(pool, recreate); System.out.println(" Db_Ram_Db init end at " + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms)); } @@ -149,6 +152,44 @@ " `test_start_time` datetime NOT NULL DEFAULT '1982-01-01 00:00:00'," + " PRIMARY KEY (`num`)" + ") ENGINE=InnoDB 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 */ private static void createIntelligentBusbar_State_Table(MysqlConnPool pool, boolean recreate) { String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.IntelligentBusbar_State_Table; String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.IntelligentBusbar_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 '记录时间'," + " `dcdc1_temp` float NOT NULL DEFAULT '0' COMMENT 'DCDC1_实时温度'," + " `dcdc2_temp` float NOT NULL DEFAULT '0' COMMENT 'DCDC2实时温度'," + " `dcdc1_outputvol` float NOT NULL DEFAULT '0' COMMENT 'DCDC1实时输出电压'," + " `dcdc2_outputvol` float NOT NULL DEFAULT '0' COMMENT 'DCDC2实时输出电压'," + " `dcdc1_outputcurr` float NOT NULL DEFAULT '0' COMMENT 'DCDC1实时输出电流'," + " `dcdc2_outputcurr` float NOT NULL DEFAULT '0' COMMENT 'DCDC2实时输出电流'," + " `dcdc1_inputvol` float NOT NULL DEFAULT '0' COMMENT 'DCDC1实时输入电压'," + " `dcdc2_inputvol` float NOT NULL DEFAULT '0' COMMENT 'DCDC2实时输入电压'," + " `dcdc1_inputcurr` float NOT NULL DEFAULT '0' COMMENT 'DCDC1实时输入电流'," + " `dcdc2_inputcurr` float unsigned NOT NULL DEFAULT '0' COMMENT 'DCDC1实时输入电流'," + " `dcdc1_errcode` int(11) NOT NULL DEFAULT '0' COMMENT 'DCDC1 异常代码-状态'," + " `dcdc2_errcode` int(11) NOT NULL DEFAULT '0' COMMENT 'DCDC2 异常代码-状态'," + " PRIMARY KEY (`num`)" + ") ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='智能母联实时状态表';"; Sql_Mysql sql = new Sql_Mysql(pool.getConn()); try { if(true == recreate) { @@ -3933,6 +3974,61 @@ + " ADD COLUMN `CellDiffVolHigh` float NOT NULL DEFAULT '0' COMMENT '压差上限(mV)';"); } /****************************************************************/ res = null; //添加 dcdc1_outputvol [DCDC1输出电压] res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns" + " WHERE table_schema='db_ram_db'" + " AND table_name='tb_fbs9100_setparam'" + " AND column_name='dcdc1_outputvol'"); if(false == res.next()) { sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SetParam_Table + " ADD COLUMN `dcdc1_outputvol` float NOT NULL DEFAULT '0' COMMENT 'DCDC1输出电压';"); } /****************************************************************/ res = null; //添加 dcdc2_outputvol [DCDC2输出电压] res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns" + " WHERE table_schema='db_ram_db'" + " AND table_name='tb_fbs9100_setparam'" + " AND column_name='dcdc2_outputvol'"); if(false == res.next()) { sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SetParam_Table + " ADD COLUMN `dcdc2_outputvol` float NOT NULL DEFAULT '0' COMMENT 'DCDC2输出电压';"); } /****************************************************************/ res = null; //添加 dcdc1_outputcurr [DCDC1输出限流值] res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns" + " WHERE table_schema='db_ram_db'" + " AND table_name='tb_fbs9100_setparam'" + " AND column_name='dcdc1_outputcurr'"); if(false == res.next()) { sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SetParam_Table + " ADD COLUMN `dcdc1_outputcurr` float NOT NULL DEFAULT '0' COMMENT 'DCDC1输出限流值';"); } /****************************************************************/ res = null; //添加 dcdc2_outputcurr [DCDC2输出限流值] res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns" + " WHERE table_schema='db_ram_db'" + " AND table_name='tb_fbs9100_setparam'" + " AND column_name='dcdc2_outputcurr'"); if(false == res.next()) { sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SetParam_Table + " ADD COLUMN `dcdc2_outputcurr` float NOT NULL DEFAULT '0' COMMENT 'DCDC2输出限流值';"); } /****************************************************************/ res = null; //添加 screensaver_time [进入屏幕保护时间] res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns" + " WHERE table_schema='db_ram_db'" + " AND table_name='tb_fbs9100_setparam'" + " AND column_name='screensaver_time'"); if(false == res.next()) { sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SetParam_Table + " ADD COLUMN `screensaver_time` int(11) NOT NULL DEFAULT '10' COMMENT '进入屏幕保护时间（不能小于10分钟）';"); } /****************************************************************/ } catch (SQLException e) { e.printStackTrace(); } finally { BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java
@@ -174,6 +174,7 @@ public final static String FBS9140_Topology_State = DB_RamDB + ".tb_fbs9140_topology_state"; //并联BTS拓扑状态信息 public final static String FBS9149_SetParam = DB_RamDB + ".tb_fbs9149_setparam"; //并联BTS9组参数表 public final static String Check_Dialog_Table = DB_RamDB + ".tb_check_dialog"; //充放电一体机离线检测表 public final static String IntelligentBusbar_State_Table = DB_RamDB + ".tb_intelligentbusbar_state"; //充放电一体机离线检测表 /**************************** db_user数据库 ***************************************************/ BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt
@@ -1,6 +1,33 @@ 蓄电池监控平台建表程序 注意:1.新增电源机房时需要重新运行 V2.01 edit at date 2024-04-25 1.新增表'db_ram_db.tb_intelligentbusbar_state'-智能母联实时状态表 CREATE TABLE `tb_intelligentbusbar_state` ( `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 '记录时间', `dcdc1_temp` float NOT NULL DEFAULT '0' COMMENT 'DCDC1_实时温度', `dcdc2_temp` float NOT NULL DEFAULT '0' COMMENT 'DCDC2实时温度', `dcdc1_outputvol` float NOT NULL DEFAULT '0' COMMENT 'DCDC1实时输出电压', `dcdc2_outputvol` float NOT NULL DEFAULT '0' COMMENT 'DCDC2实时输出电压', `dcdc1_outputcurr` float NOT NULL DEFAULT '0' COMMENT 'DCDC1实时输出电流', `dcdc2_outputcurr` float NOT NULL DEFAULT '0' COMMENT 'DCDC2实时输出电流', `dcdc1_inputvol` float NOT NULL DEFAULT '0' COMMENT 'DCDC1实时输入电压', `dcdc2_inputvol` float NOT NULL DEFAULT '0' COMMENT 'DCDC2实时输入电压', `dcdc1_inputcurr` float NOT NULL DEFAULT '0' COMMENT 'DCDC1实时输入电流', `dcdc2_inputcurr` float unsigned NOT NULL DEFAULT '0' COMMENT 'DCDC1实时输入电流', `dcdc1_errcode` int(11) NOT NULL DEFAULT '0' COMMENT 'DCDC1 异常代码-状态', `dcdc2_errcode` int(11) NOT NULL DEFAULT '0' COMMENT 'DCDC2 异常代码-状态', PRIMARY KEY (`num`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='智能母联实时状态表'; 2.表'db_ram_db.tb_fbs9100_setparam'新增字段 --智能母联参数信息 `dcdc1_outputvol` float NOT NULL DEFAULT '0' COMMENT 'DCDC1输出电压', `dcdc2_outputvol` float NOT NULL DEFAULT '0' COMMENT 'DCDC2输出电压', `dcdc1_outputcurr` float NOT NULL DEFAULT '0' COMMENT 'DCDC1输出限流值', `dcdc2_outputcurr` float NOT NULL DEFAULT '0' COMMENT 'DCDC2输出限流值', `screensaver_time` int(11) NOT NULL DEFAULT '10' COMMENT '进入屏幕保护时间（不能小于10分钟）', V1.99 edit at date 2024-04-19 1.表新增字段 'web_site.tb_badbatt_mon'新增字段 `flag` int(11) DEFAULT '4' 1：损坏，2：劣化，3：优秀时(note 1)，4，无法判断 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.99; public final static float m_VersionNum = (float) 2.01; public final static String m_Version = "Welcome To Use BTS DB BUILDER V" + m_VersionNum + " RC_20180908"; /**************************************************************************/ /**************************************************************************/ @@ -206,14 +206,7 @@ } //修改tb_app_sys表中的关键字,让主程序识别 for(int i=0;i<5;i++) { if(BattData_RT_RamDB_Thread_SQL.updateTb_App_Sys_AppServerTable(GB_MysqlConnPool)) { break; } try { Thread.sleep(1000); } catch (InterruptedException e) { e.printStackTrace(); } } try { Thread.sleep(1000);
