| BattMonitor_DB_Builder/bin/com/version_inf/version_inf.txt | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| BattMonitor_DB_Builder/config.xml | ●●●●● 补丁 | 查看 | 原始文档 | 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
@@ -138,4 +138,7 @@ V1.50 edit at date 2020-10-16 1.在db_ram_db.tb_batt_rtdata表中添加'mon_LY_vol'字段用于表示单体漏液电压信息。 2.在db_ram_db.tb_fbs9100s_fod_param表中添加第5个模块的除硫参数字段信息 3.在db_ram_db.tb_fbs9100s_fod_state表中添加'BattGroupId'字段并设置成唯一索引 3.在db_ram_db.tb_fbs9100s_fod_state表中添加'BattGroupId'字段并设置成唯一索引 V1.51 edit at date 2020-10-18 1.在db_ram_db库中添加逆变信息表'tb_fbs9100s_nibian_state'的创建 BattMonitor_DB_Builder/config.xml
@@ -2,7 +2,7 @@ <root> <mysql_ramdb_recreate_en>false</mysql_ramdb_recreate_en> <mysql_server_ip>192.168.10.221</mysql_server_ip> <mysql_server_ip>192.168.10.222</mysql_server_ip> <!--SOURCE_BATTDATA_TYPE_FBSDEV = 0--> <!--SOURCE_BATTDATA_TYPE_SQLSERVER = 1--> <!--SOURCE_BATTDATA_TYPE_C_INTERFACE = 2--> BattMonitor_DB_Builder/src/com/database_util/DB_Ram_db.java
@@ -9,9 +9,13 @@ public class DB_Ram_db { public static void init(MysqlConnPool pool, boolean recreate) { createFBS9100s_fod_state(pool,recreate); //创建除硫状态表tb_fbs9100s_fod_state createFBS9100SetDLParam_Table(pool,recreate); //创建除硫参数表 createFBS9100s_fod_state(pool,recreate); //创建除硫状态表tb_fbs9100s_fod_state createFBS9100SetDLParam_Table(pool,recreate); //创建除硫参数表 createFBS9100_NiBian_State_Table(pool, recreate); //创建逆变信息表 } @@ -129,7 +133,7 @@ if(!res.next()) { //添加唯一索引前先删除表中记录 sql.sqlMysqlExecute("DELETE FROM "+Sql_Mysql.FBS9100s_fod_state+" WHERE num>0"); sql.sqlMysqlExecute("alter table "+Sql_Mysql.FBS9100s_fod_state+" add UNIQUE `unique_BattGroupId`(`BattGroupId`);"); sql.sqlMysqlExecute("alter table "+Sql_Mysql.FBS9100s_fod_state+" add UNIQUE unique_BattGroupId(BattGroupId);"); } } catch (SQLException e) { e.printStackTrace(); @@ -256,4 +260,57 @@ sql.close_con(); } } /** * 创建逆变信息表 */ public static void createFBS9100_NiBian_State_Table(MysqlConnPool pool, boolean recreate) { String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.FBS9100_NiBian_State; String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.FBS9100_NiBian_State + " (" + " num bigint(20) NOT NULL AUTO_INCREMENT," + " dev_id bigint(11) NOT NULL DEFAULT '0'," + " nb_num bigint(11) NOT NULL DEFAULT '0'," + " record_time datetime NOT NULL DEFAULT '2000-01-01 00:00:00'," + " AC_ASimVol float NOT NULL DEFAULT '0'," + " AC_ASimCur float NOT NULL DEFAULT '0'," + " AC_BSimVol float NOT NULL DEFAULT '0'," + " AC_BSimCur float NOT NULL DEFAULT '0'," + " AC_CSimVol float NOT NULL DEFAULT '0'," + " AC_CSimCur float NOT NULL DEFAULT '0'," + " A_HZ float NOT NULL DEFAULT '0'," + " B_HZ float NOT NULL DEFAULT '0'," + " C_HZ float NOT NULL DEFAULT '0'," + " Power_Pa float NOT NULL DEFAULT '0'," + " Power_Pb float NOT NULL DEFAULT '0'," + " Power_Pc float NOT NULL DEFAULT '0'," + " Power_Sa float NOT NULL DEFAULT '0'," + " Power_Sb float NOT NULL DEFAULT '0'," + " Power_Sc float NOT NULL DEFAULT '0'," + " Temp1 float NOT NULL DEFAULT '0'," + " Temp2 float NOT NULL DEFAULT '0'," + " RunState float NOT NULL DEFAULT '0'," + " DcACState int(11) NOT NULL DEFAULT '0'," + " InsulaTionRes1 int(11) NOT NULL DEFAULT '0'," + " InsulaTionRes2 int(11) NOT NULL DEFAULT '0'," + " DCInputVol float NOT NULL DEFAULT '0'," + " DCInputCur float NOT NULL DEFAULT '0'," + " SetRun_Stop int(11) NOT NULL DEFAULT '0'," + " SetDischargeCur float NOT NULL DEFAULT '0'," + " CommTxCnt int(11) NOT NULL DEFAULT '0'," + " CommRxCnt int(11) NOT NULL DEFAULT '0'," + " PRIMARY KEY (num)," + " UNIQUE KEY nb_num_index (nb_num) USING HASH" + ") ENGINE=InnoDB AUTO_INCREMENT=1 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(); } } } BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java
@@ -87,6 +87,8 @@ public final static String FBS9100_offlineyhplan = DB_RamDB + ".tb_fbs9100_offlineyhplan"; //61850离线养护计划参数表 public final static String FBS9100_NiBian_State = DB_RamDB + ".tb_fbs9100s_nibian_state"; //61850离线养护计划参数表 public final static String FBS9100s_fod_state = DB_RamDB + ".tb_fbs9100s_fod_state"; //61850除硫状态表 public final static String FBS9100SetDLParam_Table = DB_RamDB + ".`tb_fbs9100s_fod_param`"; //61850除硫参数表 BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt
@@ -138,4 +138,7 @@ V1.50 edit at date 2020-10-16 1.在db_ram_db.tb_batt_rtdata表中添加'mon_LY_vol'字段用于表示单体漏液电压信息。 2.在db_ram_db.tb_fbs9100s_fod_param表中添加第5个模块的除硫参数字段信息 3.在db_ram_db.tb_fbs9100s_fod_state表中添加'BattGroupId'字段并设置成唯一索引 3.在db_ram_db.tb_fbs9100s_fod_state表中添加'BattGroupId'字段并设置成唯一索引 V1.51 edit at date 2020-10-18 1.在db_ram_db库中添加逆变信息表'tb_fbs9100s_nibian_state'的创建 BattMonitor_DB_Builder/src/main/main_BTS_DB_Builder.java
@@ -18,7 +18,7 @@ /**************************************************************************/ /**************************************************************************/ public final static boolean app_debug = false; public final static float m_VersionNum = (float) 1.50; public final static float m_VersionNum = (float) 1.51; public final static String m_Version = "Welcome To Use BTS DB BUILDER V" + m_VersionNum + " RC_20180908"; /**************************************************************************/ /**************************************************************************/
