| BattMonitor_DB_Builder/bin/com/database_util/DB_Ied_Scout.class | 补丁 | 查看 | 原始文档 | blame | 历史 | |
| BattMonitor_DB_Builder/bin/com/version_inf/version_inf.txt | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| BattMonitor_DB_Builder/src/com/database_util/DB_Ied_Scout.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_Ied_Scout.classBinary files differ
BattMonitor_DB_Builder/bin/com/version_inf/version_inf.txt
@@ -1,5 +1,31 @@ 蓄电池监控平台建表程序 注意:1.新增电源机房时需要重新运行 V1.96 edit at date 2024-02-21 1.创建数据'db_ied_scout' 2.创建表'db_ied_scout.tb_connect_inf' CREATE TABLE `tb_connect_inf` ( `num` bigint(20) NOT NULL COMMENT '主键', `target_ip` varchar(255) NOT NULL DEFAULT '127.0.0.1' COMMENT '目标IP地址', `target_port` int(11) NOT NULL DEFAULT '102' COMMENT '目的端口号', `target_icd` varchar(255) NOT NULL DEFAULT '' COMMENT '目的设备icd文件路径', `conn_st` int(11) NOT NULL DEFAULT '0' COMMENT '连接状态0-默认 1-开始连接[平台设置] 2-连接中 3-连接成功 4-连接失败', `fail_reasion` int(11) NOT NULL DEFAULT '0' COMMENT '失败原因：0-无 1-ICD文件不存在 2-ICD文件不匹配', `comm_num` bigint(20) NOT NULL DEFAULT '0' COMMENT '通信计数', `error_num` bigint(20) NOT NULL DEFAULT '0' COMMENT '通信错误计数', PRIMARY KEY (`num`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='IED_Scout 连接配置信息表'; 3.创建表'db_ied_scout.tb_ied_nodestate' CREATE TABLE `tb_ied_nodestate` ( `num` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '自增主键', `node_path` varchar(255) CHARACTER SET gbk NOT NULL DEFAULT '' COMMENT '节点路径', `node_name` varchar(255) CHARACTER SET gbk NOT NULL DEFAULT '' COMMENT '节点中文名称', `node_value` float NOT NULL DEFAULT '0' COMMENT '节点值', PRIMARY KEY (`num`), UNIQUE KEY `index_node_path` (`node_path`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='IED Scout 实时状态信息表'; V1.95 edit at date 2024-01-24 1.StationId int ->Long BattMonitor_DB_Builder/src/com/database_util/DB_Ied_Scout.java
New file @@ -0,0 +1,96 @@ package com.database_util; import java.sql.SQLException; import java.util.Date; import com.base.Com; import com.sql.MysqlConnPool; import com.sql.Sql_Mysql; public class DB_Ied_Scout { public static void init(MysqlConnPool pool, boolean recreate) { System.out.println(" db_ied_scout init start at " + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms)); createDB_IED_SCOUT(pool); createConnect_Inf_Table(pool, recreate); //创建IED Scout 配置信息表 createIed_NodeState_Table(pool, recreate); //创建IED Scout 实时状态信息表 System.out.println(" db_ied_scout init end at " + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms)); } /** * 创建 db_ied_scout 数据库 * @param pool */ public static void createDB_IED_SCOUT(MysqlConnPool pool) { Sql_Mysql sql = new Sql_Mysql(pool.getConn()); try { sql.sqlMysqlExecute("CREATE DATABASE IF NOT EXISTS " + Sql_Mysql.DB_IED_SCOUT); } catch (SQLException e) { e.printStackTrace(); } finally { sql.close_con(); } } /** * 创建 tb_connect_inf 表 * @param pool * @param recreate */ public static void createConnect_Inf_Table(MysqlConnPool pool, boolean recreate) { String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Connect_Inf_Table; String sql_str02 = " CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Connect_Inf_Table + " (" + " `num` bigint(20) NOT NULL COMMENT '主键'," + " `target_ip` varchar(255) NOT NULL DEFAULT '127.0.0.1' COMMENT '目标IP地址'," + " `target_port` int(11) NOT NULL DEFAULT '102' COMMENT '目的端口号'," + " `target_icd` varchar(255) NOT NULL DEFAULT '' COMMENT '目的设备icd文件路径'," + " `conn_st` int(11) NOT NULL DEFAULT '0' COMMENT '连接状态0-默认 1-开始连接[平台设置] 2-连接中 3-连接成功 4-连接失败'," + " `fail_reasion` int(11) NOT NULL DEFAULT '0' COMMENT '失败原因：0-无 1-ICD文件不存在 2-ICD文件不匹配'," + " `comm_num` bigint(20) NOT NULL DEFAULT '0' COMMENT '通信计数'," + " `error_num` bigint(20) NOT NULL DEFAULT '0' COMMENT '通信错误计数'," + " PRIMARY KEY (`num`)" + ") ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='IED_Scout 连接配置信息表';"; 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(); } } /** * 创建 tb_ied_nodestate 表 * @param pool * @param recreate */ public static void createIed_NodeState_Table(MysqlConnPool pool, boolean recreate) { String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Ied_NodeState_Table; String sql_str02 = " CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Ied_NodeState_Table + " (" + " `num` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '自增主键'," + " `node_path` varchar(255) CHARACTER SET gbk NOT NULL DEFAULT '' COMMENT '节点路径'," + " `node_name` varchar(255) CHARACTER SET gbk NOT NULL DEFAULT '' COMMENT '节点中文名称'," + " `node_value` float NOT NULL DEFAULT '0' COMMENT '节点值'," + " PRIMARY KEY (`num`)," + " UNIQUE KEY `index_node_path` (`node_path`) USING BTREE" + ") ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='IED Scout 实时状态信息表';"; 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(); } } } BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java
@@ -41,6 +41,8 @@ final public static String DB_UPSPWRDEV_ALARM = "`db_upspwrdev_alarm`"; //UPS告警数据库 final public static String DB_UPSPWRDEV_DATA_HISTORY = "`db_upspwrdev_data_history`"; //UPS历史实时数据库 final public static String DB_IED_SCOUT = "`db_ied_scout`"; //UPS历史实时数据库 //--------------------------------------------------------------------------------------------// public final static String TB_HardDevSmsState = "tb_hard_dev_sms_state"; //--------------------------------------------------------------------------------------------// @@ -377,6 +379,11 @@ public final static String UPSpwrdev_Alarm_Table = DB_UPSPWRDEV_ALARM + ".tb_upspwrdev_alarm"; //UPS设备实时告警记录表 public final static String UPSpwrdev_Alarm_History_Table = DB_DEV_TESTPARAM + ".tb_upspwrdev_alarm_history"; //UPS设备历史告警记录表 /***************************** db_ied_scout 数据库 **********************************/ public final static String Connect_Inf_Table = DB_IED_SCOUT + ".tb_connect_inf"; //ied连接信息表 public final static String Ied_NodeState_Table = DB_IED_SCOUT + ".tb_ied_nodestate"; //ied状态信息表 //--------------------------------------------------------------------------------------------// //--------------------------------------------------------------------------------------------// public Connection mysql_con; BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt
@@ -1,5 +1,31 @@ 蓄电池监控平台建表程序 注意:1.新增电源机房时需要重新运行 V1.96 edit at date 2024-02-21 1.创建数据'db_ied_scout' 2.创建表'db_ied_scout.tb_connect_inf' CREATE TABLE `tb_connect_inf` ( `num` bigint(20) NOT NULL COMMENT '主键', `target_ip` varchar(255) NOT NULL DEFAULT '127.0.0.1' COMMENT '目标IP地址', `target_port` int(11) NOT NULL DEFAULT '102' COMMENT '目的端口号', `target_icd` varchar(255) NOT NULL DEFAULT '' COMMENT '目的设备icd文件路径', `conn_st` int(11) NOT NULL DEFAULT '0' COMMENT '连接状态0-默认 1-开始连接[平台设置] 2-连接中 3-连接成功 4-连接失败', `fail_reasion` int(11) NOT NULL DEFAULT '0' COMMENT '失败原因：0-无 1-ICD文件不存在 2-ICD文件不匹配', `comm_num` bigint(20) NOT NULL DEFAULT '0' COMMENT '通信计数', `error_num` bigint(20) NOT NULL DEFAULT '0' COMMENT '通信错误计数', PRIMARY KEY (`num`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='IED_Scout 连接配置信息表'; 3.创建表'db_ied_scout.tb_ied_nodestate' CREATE TABLE `tb_ied_nodestate` ( `num` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '自增主键', `node_path` varchar(255) CHARACTER SET gbk NOT NULL DEFAULT '' COMMENT '节点路径', `node_name` varchar(255) CHARACTER SET gbk NOT NULL DEFAULT '' COMMENT '节点中文名称', `node_value` float NOT NULL DEFAULT '0' COMMENT '节点值', PRIMARY KEY (`num`), UNIQUE KEY `index_node_path` (`node_path`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='IED Scout 实时状态信息表'; V1.95 edit at date 2024-01-24 1.StationId int ->Long BattMonitor_DB_Builder/src/main/main_BTS_DB_Builder.java
@@ -13,6 +13,7 @@ import com.database_util.DB_Dev_History; import com.database_util.DB_Dev_TestParam; import com.database_util.DB_Fbo_testdata; import com.database_util.DB_Ied_Scout; import com.database_util.DB_Ld9_Testdata; import com.database_util.DB_Param; import com.database_util.DB_Pwrdev_Alarm; @@ -35,7 +36,7 @@ /**************************************************************************/ /**************************************************************************/ public final static boolean app_debug = false; public final static float m_VersionNum = (float) 1.95; public final static float m_VersionNum = (float) 1.96; public final static String m_Version = "Welcome To Use BTS DB BUILDER V" + m_VersionNum + " RC_20180908"; /**************************************************************************/ /**************************************************************************/ @@ -190,6 +191,8 @@ DB_Upspwrdev_Data_History.init(GB_MysqlConnPool, recreate_tb); DB_Ied_Scout.init(GB_MysqlConnPool, recreate_tb); //设置重启告警线程 DB_web_site.setUpThreadRestart(GB_MysqlConnPool);
