| 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/version_inf/version_inf.txt
@@ -1,5 +1,46 @@ 蓄电池监控平台建表程序 V1.68 edit at date 2023-04-14 1.表'db_ram_db.tb_fbs9140_topology_state'新增字段 `total_vol` float NOT NULL DEFAULT '0' COMMENT '总电压', `total_curr` float NOT NULL DEFAULT '0' COMMENT '总电流', 2.新增表'db_ram_db.tb_fbs9149_setparam' - 并联BTS9组参数表 CREATE TABLE `tb_fbs9149_setparam` ( `num` bigint(20) NOT NULL AUTO_INCREMENT, `dev_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '设备Id', `op_cmd` int(11) NOT NULL DEFAULT '0' COMMENT '命令字段', `test_cmd` int(11) NOT NULL DEFAULT '0' COMMENT '测试类型', `groupnum` int(11) NOT NULL DEFAULT '0' COMMENT '组号0-组1 1-组2 2-组3 3-组4...', `paramtype` int(11) NOT NULL DEFAULT '0' COMMENT '参数类型，0-实时核容参数 1-计划核容参数 2-活化参数 3-充电参数', `battauto` int(11) NOT NULL DEFAULT '0' COMMENT '0-自动 1-手动 电池管理方式', `timerchargeable` int(11) NOT NULL DEFAULT '0' COMMENT '0-开启 1-关闭 定时均充功能', `battnominalcap` int(11) NOT NULL DEFAULT '0' COMMENT '50-200Ah 电池标称容量 ', `battfloatvol` float NOT NULL DEFAULT '0' COMMENT '电池浮充电压', `battchargevol` float NOT NULL DEFAULT '0' COMMENT '电池均充电压', `battchargecurr1` float NOT NULL DEFAULT '0' COMMENT '电池充电限流', `battchargecurr2` float NOT NULL DEFAULT '0' COMMENT '浮充转均充电流', `battchargecurr3` float NOT NULL DEFAULT '0' COMMENT '均充转浮充电流', `tailcurrchargetime` int(11) NOT NULL DEFAULT '0' COMMENT '0-5H 尾电流充电时间', `timerchargeperiod` int(11) NOT NULL DEFAULT '0' COMMENT '30-180天 定时均充周期', `maxchargetimehour` int(11) NOT NULL DEFAULT '0' COMMENT '最长均充时间', `tempcompensatedable` int(11) NOT NULL DEFAULT '0' COMMENT '0-开启 1-关闭 温度补偿开关', `batthightemp` int(11) NOT NULL DEFAULT '0' COMMENT '20-80℃ 电池过温点', `battlowtemp` int(11) NOT NULL DEFAULT '0' COMMENT '-40-10℃ 电池欠温点', `compensatedtemp` int(11) NOT NULL DEFAULT '0' COMMENT '10-40℃ 温补中心点', `tempcompensatedcoe` int(11) NOT NULL DEFAULT '0' COMMENT '0-50mV/℃ 温补系数', `battdischargelowvol` float NOT NULL DEFAULT '0' COMMENT '电池放电终止电压', `mondischargelowvol` float NOT NULL DEFAULT '0' COMMENT '单节放电终止电压', `localremoteset` int(11) NOT NULL DEFAULT '0' COMMENT '本地远程设置 0-远程 1-本地', `battchrgctrl` int(11) NOT NULL DEFAULT '0' COMMENT '电池充电控制 0-开启 1-关闭 ', `battdisctrl` int(11) NOT NULL DEFAULT '0' COMMENT '电池放电控制 0-开启 1-关闭 ', `herongcurr` float NOT NULL DEFAULT '0' COMMENT '核容限流 0.1C-0.5C ', `herongtimehour` int(11) NOT NULL DEFAULT '0' COMMENT '核容时限', `monvollow` float NOT NULL DEFAULT '0' COMMENT '内部单体下限值[1.6-13.6]', PRIMARY KEY (`num`), KEY `index_dev_id` (`dev_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='并联电源9组参数表'; V1.67 edit at date 2023-04-10 1.新增创建数据库`db_pwrdev_data_history` - 南网历史实时数据库 BattMonitor_DB_Builder/src/com/database_util/DB_Ram_db.java
@@ -126,6 +126,9 @@ //创建并联BTS拓扑状态信息表 createFBS9140_Topology_State(pool, recreate); //创建并联BTS9组参数表 createFBS9149_SetParam(pool,recreate); System.out.println(" Db_Ram_Db init end at " + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms)); } @@ -496,7 +499,7 @@ " `mod_outcurr6` float NOT NULL DEFAULT '0' COMMENT '组6输出电流'," + " `mod_enable7` int(11) NOT NULL DEFAULT '0' COMMENT '组7模块使能状态[0-断开 1-闭合]'," + " `batt_state7` int(11) NOT NULL DEFAULT '0' COMMENT '组7电池状态[0:浮充 1：均充 2：供电 3：核容 4：尾充]'," + " `mod_outVol7` float NOT NULL DEFAULT '0' COMMENT '组7输出电压'," + " `mod_outvol7` float NOT NULL DEFAULT '0' COMMENT '组7输出电压'," + " `mod_outcurr7` float NOT NULL DEFAULT '0' COMMENT '组7输出电流'," + " `mod_enable8` int(11) NOT NULL DEFAULT '0' COMMENT '组8模块使能状态[0-断开 1-闭合]'," + " `batt_state8` int(11) NOT NULL DEFAULT '0' COMMENT '组8电池状态[0:浮充 1：均充 2：供电 3：核容 4：尾充]'," + @@ -510,14 +513,100 @@ " `batt_state10` int(11) NOT NULL DEFAULT '0' COMMENT '组10电池状态[0:浮充 1：均充 2：供电 3：核容 4：尾充]'," + " `mod_outvol10` float NOT NULL DEFAULT '0' COMMENT '组10输出电压'," + " `mod_outcurr10` float NOT NULL DEFAULT '0' COMMENT '组10输出电流'," + " `total_vol` float NOT NULL DEFAULT '0' COMMENT '总电压'," + " `total_curr` float NOT NULL DEFAULT '0' COMMENT '总电流'," + " PRIMARY KEY (`num`)" + ") ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='并联BTS拓扑状态信息'; "; Sql_Mysql sql = new Sql_Mysql(pool.getConn()); ResultSet res = null; try { if(true == recreate) { sql.sqlMysqlExecute(sql_str01); } sql.sqlMysqlExecute(sql_str02); //添加total_vol 总电压 res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns" + " WHERE table_schema='db_ram_db'" + " AND table_name='tb_fbs9140_topology_state'" + " AND column_name='total_vol'"); if(false == res.next()) { sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9140_Topology_State + " ADD COLUMN `total_vol` float NOT NULL DEFAULT '0' COMMENT '总电压';"); } res = null; //添加total_curr 总电流 res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns" + " WHERE table_schema='db_ram_db'" + " AND table_name='tb_fbs9140_topology_state'" + " AND column_name='total_curr'"); if(false == res.next()) { sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9140_Topology_State + " ADD COLUMN `total_curr` float NOT NULL DEFAULT '0' COMMENT '总电流';"); } } catch (SQLException e) { e.printStackTrace(); } finally { if(null != res) { try { res.close(); } catch (SQLException e) { e.printStackTrace(); } } sql.close_con(); } } /** * 创建并联BTS拓扑状态信息 * @param pool * @param recreate */ private static void createFBS9149_SetParam(MysqlConnPool pool, boolean recreate) { String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.FBS9149_SetParam; String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.FBS9149_SetParam + " (" + " `num` bigint(20) NOT NULL AUTO_INCREMENT," + " `dev_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '设备Id'," + " `op_cmd` int(11) NOT NULL DEFAULT '0' COMMENT '命令字段'," + " `test_cmd` int(11) NOT NULL DEFAULT '0' COMMENT '测试类型'," + " `groupnum` int(11) NOT NULL DEFAULT '0' COMMENT '组号0-组1 1-组2 2-组3 3-组4...'," + " `paramtype` int(11) NOT NULL DEFAULT '0' COMMENT '参数类型，0-实时核容参数 1-计划核容参数 2-活化参数 3-充电参数'," + " `battauto` int(11) NOT NULL DEFAULT '0' COMMENT '0-自动 1-手动 电池管理方式'," + " `timerchargeable` int(11) NOT NULL DEFAULT '0' COMMENT '0-开启 1-关闭 定时均充功能'," + " `battnominalcap` int(11) NOT NULL DEFAULT '0' COMMENT '50-200Ah 电池标称容量 '," + " `battfloatvol` float NOT NULL DEFAULT '0' COMMENT '电池浮充电压'," + " `battchargevol` float NOT NULL DEFAULT '0' COMMENT '电池均充电压'," + " `battchargecurr1` float NOT NULL DEFAULT '0' COMMENT '电池充电限流'," + " `battchargecurr2` float NOT NULL DEFAULT '0' COMMENT '浮充转均充电流'," + " `battchargecurr3` float NOT NULL DEFAULT '0' COMMENT '均充转浮充电流'," + " `tailcurrchargetime` int(11) NOT NULL DEFAULT '0' COMMENT '0-5H 尾电流充电时间'," + " `timerchargeperiod` int(11) NOT NULL DEFAULT '0' COMMENT '30-180天 定时均充周期'," + " `maxchargetimehour` int(11) NOT NULL DEFAULT '0' COMMENT '最长均充时间'," + " `tempcompensatedable` int(11) NOT NULL DEFAULT '0' COMMENT '0-开启 1-关闭 温度补偿开关'," + " `batthightemp` int(11) NOT NULL DEFAULT '0' COMMENT '20-80℃ 电池过温点'," + " `battlowtemp` int(11) NOT NULL DEFAULT '0' COMMENT '-40-10℃ 电池欠温点'," + " `compensatedtemp` int(11) NOT NULL DEFAULT '0' COMMENT '10-40℃ 温补中心点'," + " `tempcompensatedcoe` int(11) NOT NULL DEFAULT '0' COMMENT '0-50mV/℃ 温补系数'," + " `battdischargelowvol` float NOT NULL DEFAULT '0' COMMENT '电池放电终止电压'," + " `mondischargelowvol` float NOT NULL DEFAULT '0' COMMENT '单节放电终止电压'," + " `localremoteset` int(11) NOT NULL DEFAULT '0' COMMENT '本地远程设置 0-远程 1-本地'," + " `battchrgctrl` int(11) NOT NULL DEFAULT '0' COMMENT '电池充电控制 0-开启 1-关闭 '," + " `battdisctrl` int(11) NOT NULL DEFAULT '0' COMMENT '电池放电控制 0-开启 1-关闭 '," + " `herongcurr` float NOT NULL DEFAULT '0' COMMENT '核容限流 0.1C-0.5C '," + " `herongtimehour` int(11) NOT NULL DEFAULT '0' COMMENT '核容时限'," + " `monvollow` float NOT NULL DEFAULT '0' COMMENT '内部单体下限值[1.6-13.6]'," + " PRIMARY KEY (`num`)," + " KEY `index_dev_id` (`dev_id`) USING BTREE" + ") ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='并联电源9组参数表';; "; Sql_Mysql sql = new Sql_Mysql(pool.getConn()); try { if(true == recreate) { sql.sqlMysqlExecute(sql_str01); } sql.sqlMysqlExecute(sql_str02); sql.sqlMysqlExecute(sql_str02); } catch (SQLException e) { e.printStackTrace(); } finally { BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java
@@ -166,6 +166,7 @@ public final static String DEV60870_Inverter_State = DB_RamDB + ".tb_dev_60870_inverter_state"; //电操开关遥信实时状态表 public final static String DEV60870_Inverter_Info = DB_RamDB + ".tb_dev_60870_inverter_info"; //电操开关遥测实时状态表 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组参数表 /**************************** db_user数据库 ***************************************************/ BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt
@@ -1,5 +1,46 @@ 蓄电池监控平台建表程序 V1.68 edit at date 2023-04-14 1.表'db_ram_db.tb_fbs9140_topology_state'新增字段 `total_vol` float NOT NULL DEFAULT '0' COMMENT '总电压', `total_curr` float NOT NULL DEFAULT '0' COMMENT '总电流', 2.新增表'db_ram_db.tb_fbs9149_setparam' - 并联BTS9组参数表 CREATE TABLE `tb_fbs9149_setparam` ( `num` bigint(20) NOT NULL AUTO_INCREMENT, `dev_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '设备Id', `op_cmd` int(11) NOT NULL DEFAULT '0' COMMENT '命令字段', `test_cmd` int(11) NOT NULL DEFAULT '0' COMMENT '测试类型', `groupnum` int(11) NOT NULL DEFAULT '0' COMMENT '组号0-组1 1-组2 2-组3 3-组4...', `paramtype` int(11) NOT NULL DEFAULT '0' COMMENT '参数类型，0-实时核容参数 1-计划核容参数 2-活化参数 3-充电参数', `battauto` int(11) NOT NULL DEFAULT '0' COMMENT '0-自动 1-手动 电池管理方式', `timerchargeable` int(11) NOT NULL DEFAULT '0' COMMENT '0-开启 1-关闭 定时均充功能', `battnominalcap` int(11) NOT NULL DEFAULT '0' COMMENT '50-200Ah 电池标称容量 ', `battfloatvol` float NOT NULL DEFAULT '0' COMMENT '电池浮充电压', `battchargevol` float NOT NULL DEFAULT '0' COMMENT '电池均充电压', `battchargecurr1` float NOT NULL DEFAULT '0' COMMENT '电池充电限流', `battchargecurr2` float NOT NULL DEFAULT '0' COMMENT '浮充转均充电流', `battchargecurr3` float NOT NULL DEFAULT '0' COMMENT '均充转浮充电流', `tailcurrchargetime` int(11) NOT NULL DEFAULT '0' COMMENT '0-5H 尾电流充电时间', `timerchargeperiod` int(11) NOT NULL DEFAULT '0' COMMENT '30-180天 定时均充周期', `maxchargetimehour` int(11) NOT NULL DEFAULT '0' COMMENT '最长均充时间', `tempcompensatedable` int(11) NOT NULL DEFAULT '0' COMMENT '0-开启 1-关闭 温度补偿开关', `batthightemp` int(11) NOT NULL DEFAULT '0' COMMENT '20-80℃ 电池过温点', `battlowtemp` int(11) NOT NULL DEFAULT '0' COMMENT '-40-10℃ 电池欠温点', `compensatedtemp` int(11) NOT NULL DEFAULT '0' COMMENT '10-40℃ 温补中心点', `tempcompensatedcoe` int(11) NOT NULL DEFAULT '0' COMMENT '0-50mV/℃ 温补系数', `battdischargelowvol` float NOT NULL DEFAULT '0' COMMENT '电池放电终止电压', `mondischargelowvol` float NOT NULL DEFAULT '0' COMMENT '单节放电终止电压', `localremoteset` int(11) NOT NULL DEFAULT '0' COMMENT '本地远程设置 0-远程 1-本地', `battchrgctrl` int(11) NOT NULL DEFAULT '0' COMMENT '电池充电控制 0-开启 1-关闭 ', `battdisctrl` int(11) NOT NULL DEFAULT '0' COMMENT '电池放电控制 0-开启 1-关闭 ', `herongcurr` float NOT NULL DEFAULT '0' COMMENT '核容限流 0.1C-0.5C ', `herongtimehour` int(11) NOT NULL DEFAULT '0' COMMENT '核容时限', `monvollow` float NOT NULL DEFAULT '0' COMMENT '内部单体下限值[1.6-13.6]', PRIMARY KEY (`num`), KEY `index_dev_id` (`dev_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='并联电源9组参数表'; V1.67 edit at date 2023-04-10 1.新增创建数据库`db_pwrdev_data_history` - 南网历史实时数据库 BattMonitor_DB_Builder/src/main/main_BTS_DB_Builder.java
@@ -32,7 +32,7 @@ /**************************************************************************/ /**************************************************************************/ public final static boolean app_debug = false; public final static float m_VersionNum = (float) 1.67; public final static float m_VersionNum = (float) 1.68; public final static String m_Version = "Welcome To Use BTS DB BUILDER V" + m_VersionNum + " RC_20180908"; /**************************************************************************/ /**************************************************************************/
