From 56c672f46d4b901b1ee4b1ee47768ed53ec5e6a8 Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期四, 08 七月 2021 11:52:25 +0800
Subject: [PATCH] V1.60 edit at date 2021-07-08 1.新建'db_ram_db.`tb_fbs9100s_buscouple_state`'-->'母联开关状态表'数据库表 1.新建'db_ram_db.`tb_fbs9100s_stemnode_state`'-->'干接点状态表'数据库表
---
BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java | 168 +++++++++++++++++++++++++++++++++++++++++++++----------
1 files changed, 136 insertions(+), 32 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java b/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java
index 443ea62..f4a38f2 100644
--- a/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java
+++ b/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java
@@ -25,6 +25,14 @@
final public static String DB_RamDB_BATT_RT = "`db_ram_batt_rt`";
final public static String WEB_Site = "`web_site`";
+ final public static String DB_BATT_HISTORY = "`db_batt_history`";
+ final public static String DB_LD9_TESTDATA = "`db_ld9_testdata`";
+
+ final public static String DB_PWRDEV_ALARM = "`db_pwrdev_alarm`";
+ final public static String DB_PWRDEV_DATA_RT = "`db_pwrdev_data_rt`";
+ final public static String DB_PWRDEV_INF = "`db_pwrdev_inf`";
+
+
//--------------------------------------------------------------------------------------------//
public final static String TB_HardDevSmsState = "tb_hard_dev_sms_state";
//--------------------------------------------------------------------------------------------//
@@ -32,8 +40,8 @@
public final static String TB_ServerState = "tb_server_state";
public final static String TB_BattTestDataInf = "tb_batttestdata_inf";
- public final static String TB_BattRtState = "tb_batt_rtstate";
public final static String TB_BattRtData = "tb_batt_rtdata";
+ public final static String TB_BattRtState = "tb_batt_rtstate";
public final static String TB_UserInf = "tb_user_inf";
public final static String TB_UserLog = "tb_user_log";
@@ -55,37 +63,11 @@
public final static String TB_UserJieJiaRi = "tb_user_jiejiari";
//--------------------------------------------------------------------------------------------//
//--------------------------------------------------------------------------------------------//
- public final static String ServerState_Table = DB_RamDB + ".`tb_server_state`";
- public final static String BattRtData_Table = DB_RamDB + ".`tb_batt_rtdata`";
- public final static String BattRtState_Table = DB_RamDB + ".`tb_batt_rtstate`";
-
public final static String CInterfaceState_Table = DB_RamDB + ".`tb_cinterface_state`";
- public final static String HardDevSmsState_Table = DB_RamDB + ".`tb_hard_dev_sms_state`";
- public final static String FBS9100State_Table = DB_RamDB + ".`tb_fbs9100_state`";
- public final static String FBS9100S_DcDcState_Table = DB_RamDB + ".`tb_fbs9100s_dcdc_state`";
- public final static String FBS9100SetParam_Table = DB_RamDB + ".`tb_fbs9100_setparam`";
- public final static String FBS9100S_DFUState_Table = DB_RamDB + ".`tb_fbs9100s_DFU_state`";
-
- public final static String BMP7100State_Table = DB_RamDB + ".`tb_bpm7100_state`";
-
- public final static String FBS9600State_Table = DB_RamDB + ".`tb_fbs9600_state`";
public final static String FBS9600SetParam_Table = DB_RamDB + ".`tb_fbs9600_setparam`";
//public final static String FBS9600Param_Table = DB_RamDB + ".`tb_fbs9600_param`";
- public final static String SocketClientStateTable = DB_RamDB + ".`tb_socketclient_state`";
- public final static String RamDB_CMCC_POWER_Data = DB_RamDB + ".`cmcc_power_data`";
- public final static String BTSStationState_Table = DB_RamDB + ".`tb_bts_station_state`"; //机房状态表
-
- public final static String FBS9100SysParam_Table = DB_RamDB + ".`tb_fbs9100_sysparam`"; //系统参数表
-
- public final static String BTSGPRSState_Table = DB_RamDB + ".`tb_bts_gprs_state`"; //gprs 信息表
-
- public final static String FBS9100BattParam_Table = DB_RamDB + ".`tb_fbs9100_battparam`"; //电池组参数表
-
- public final static String TB_61850_JHState_Table = DB_RamDB +".tb_61850_jhstate"; //61850均衡61850供电模块信息
-
- public final static String FBS9100_offlineyhplan = DB_RamDB + ".tb_fbs9100_offlineyhplan"; //61850离线养护计划参数表
//--------------------------------------------------------------------------------------------//
//--------------------------------------------------------------------------------------------//
public final static String AppSys_Table = DB_AppSys + ".`tb_app_sys`";
@@ -98,8 +80,8 @@
public final static String BattTestDataInf_Table = DB_BATT_TESTDATA + ".`tb_batttestdata_inf`";
- public final static String BattResData_Table = DB_BATT_TESTDATA + ".`tb_BattResData`";
public final static String BattResDataInf_Table = DB_BATT_TESTDATA + ".`tb_battresdata_inf`";
+ public final static String BattResData_Table = DB_BATT_TESTDATA + ".`tb_BattResData`";
public final static String UserInfTable = DB_USER + ".`tb_user_inf`";
public final static String UserLogTable = DB_USER + ".`tb_user_log`";
@@ -128,6 +110,73 @@
public final static String BTSStationEvent_Table = DB_ALARM + ".`tb_bts_station_event`"; //机房状态历史表
+ /**************************** db_ram_db数据库 ***************************************************/
+ public final static String SocketClientStateTable = DB_RamDB + ".`tb_socketclient_state`";
+ public final static String ServerState_Table = DB_RamDB + ".`tb_server_state`";
+ public final static String Ld9_Updatestatue_Table = DB_RamDB + ".`tb_ld9_updatestatue`";
+ public final static String Ld9_State_Table = DB_RamDB + ".`tb_ld9_state`";
+ public final static String Ld9_Setparam_Table = DB_RamDB + ".`tb_ld9_setparam`";
+ public final static String Ld9_Concentratestate_Table = DB_RamDB + ".`tb_ld9_concentratestate`";
+ public final static String Ld9_Concentrateparam_Table = DB_RamDB + ".`tb_ld9_concentrateparam`";
+ public final static String HardDevSmsState_Table = DB_RamDB + ".`tb_hard_dev_sms_state`";
+ public final static String FBS9600State_Table = DB_RamDB + ".`tb_fbs9600_state`";
+ 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除硫参数表
+ public final static String FBS9100S_DFUState_Table = DB_RamDB + ".`tb_fbs9100s_DFU_state`";
+ public final static String FBS9100S_DcDcState_Table = DB_RamDB + ".`tb_fbs9100s_dcdc_state`";
+ public final static String FBS9100SysParam_Table = DB_RamDB + ".`tb_fbs9100_sysparam`"; //系统参数表
+ public final static String FBS9100State_Table = DB_RamDB + ".`tb_fbs9100_state`";
+ public final static String FBS9100SetParam_Table = DB_RamDB + ".`tb_fbs9100_setparam`";
+ public final static String FBS9100_offlineyhplan = DB_RamDB + ".tb_fbs9100_offlineyhplan"; //61850离线养护计划参数表
+ public final static String FBS9100BattParam_Table = DB_RamDB + ".`tb_fbs9100_battparam`"; //电池组参数表
+ public final static String BTSStationState_Table = DB_RamDB + ".`tb_bts_station_state`"; //机房状态表
+ public final static String BTSGPRSState_Table = DB_RamDB + ".`tb_bts_gprs_state`"; //gprs 信息表
+ public final static String BMP7100State_Table = DB_RamDB + ".`tb_bpm7100_state`";
+ public final static String BattRtState_Table = DB_RamDB + ".`tb_batt_rtstate`";
+ public final static String BattRtData_Table = DB_RamDB + ".`tb_batt_rtdata`";
+ public final static String TB_61850_JHState_Table = DB_RamDB +".tb_61850_jhstate"; //61850均衡61850供电模块信息
+ public final static String RamDB_CMCC_POWER_Data = DB_RamDB + ".`cmcc_power_data`";
+ public final static String FBS9100_InsulatstateTable = DB_RamDB + ".`tb_fbs9100_insulatstate`"; //绝缘装置
+ public final static String FBS9100_CollectionstateTable = DB_RamDB + ".`tb_fbs9100_collectionstate`"; //汇集装置
+ public final static String FBS9100_ChargerstateTable = DB_RamDB + ".`tb_fbs9100_chargerstate`"; //充电机
+ public final static String Tb_Lithium_DataTable = DB_RamDB + ".`tb_lithium_data`"; //锂电池数据表
+
+ public final static String Tb_Batt_RSAlarm_Table = DB_RamDB + ".`tb_batt_rsalarm`"; //锂电池数据表
+ public final static String Tb_Batt_RTAlarm_Table = DB_RamDB + ".`tb_batt_rtalarm`"; //锂电池数据表
+
+ public final static String FBS9100s_stemnode_state_Table = DB_RamDB + ".`tb_fbs9100s_stemnode_state`"; //干节点状态表
+ public final static String FBS9100s_buscouple_state_Table = DB_RamDB + ".`tb_fbs9100s_buscouple_state`"; //母联开关状态表
+
+
+ /**************************** db_user数据库 ***************************************************/
+ public final static String User_Permitgroup_Table = DB_USER + ".`tb_user_permitgroup`"; //权限表
+ public final static String User_Permitgroup_Data_Table = DB_USER + ".`tb_user_permitgroup_data`"; //用户权限表
+ public final static String User_Task_User_List_Table = DB_USER + ".`tb_user_task_user_list`"; //
+ public final static String User_Task_Template_Table = DB_USER + ".`tb_user_task_template`"; //
+ public final static String User_Task_Param_Table = DB_USER + ".`tb_user_task_param`"; //
+ public final static String User_Task_Change_Table = DB_USER + ".`tb_user_task_change`"; //
+ public final static String User_Task_Batt_Test_Table = DB_USER + ".`tb_user_task_batt_test`"; //
+ public final static String User_Task_Batt_Template_Table = DB_USER + ".`tb_user_task_batt_template`"; //
+ public final static String User_Task_Batt_Check_Table = DB_USER + ".`tb_user_task_batt_check`"; //
+ public final static String User_Task_Table = DB_USER + ".`tb_user_task`"; //
+ public final static String User_Sms_Format_Table = DB_USER + ".`tb_user_sms_format`"; //
+ public final static String User_Sms_Table = DB_USER + ".`tb_user_sms`"; //
+ public final static String User_Paixiu_Table = DB_USER + ".`tb_user_paixiu`"; //
+ public final static String User_Log_Table = DB_USER + ".`tb_user_log`"; //
+ public final static String User_Jiejiari_Table = DB_USER + ".`tb_user_jiejiari`"; //
+ public final static String User_Face_Table = DB_USER + ".`tb_user_face`"; //
+ public final static String User_Battmaint_Check_Process_Table = DB_USER + ".`tb_user_battmaint_check_process`"; //
+ public final static String User_Battmaint_Check_Table = DB_USER + ".`tb_user_battmaint_check`"; //
+ public final static String User_Battgroup_Baojigroup_Usr_Table = DB_USER + ".`tb_user_battgroup_baojigroup_usr`"; //
+ public final static String User_Battgroup_Baojigroup_Battgroup_Table = DB_USER + ".`tb_user_battgroup_baojigroup_battgroup`"; //
+ public final static String User_Battgroup_Baojigroup_Table = DB_USER + ".`tb_user_battgroup_baojigroup`"; //
+ public final static String User_Limit_Table = DB_USER + ".`tb_user_limit`"; //
+
+
+
+
+
/**************************** web_site数据库 ***************************************************/
public final static String ThreadUtil_Table = WEB_Site + ".`tb_thread_util`"; //线程帮助表
@@ -147,12 +196,13 @@
public final static String BattParamLow_Table = WEB_Site + ".`tb_batt_param_low`"; //电池参数表
public final static String BattDischargeParam_Table = WEB_Site + ".`tb_battdischarge_param`"; //放电计划参数表
public final static String BattDischargePlan_Table = WEB_Site + ".`tb_battdischarge_plan`"; //放电计划表
- public final static String Avoid_plan_Table = WEB_Site + ".`tb_avoid_plan`"; //放电计划规避时间表
+ public final static String Avoid_plan_Table = WEB_Site + ".`tb_avoid_plan`"; //放电计划规避时间表
public final static String BattMapInformation_Table = WEB_Site + ".`tb_battmap_information`"; //基站定位表
public final static String BattDischarge_Table = WEB_Site + ".`tb_batt_discharge`"; //基站故障表
public final static String BattReplace_Table = WEB_Site + ".`tb_batt_replace`"; //电池更换记录表
-
-
+ public final static String Dev_Restart_Plan_Table = WEB_Site +".`tb_dev_restart_plan`"; //设备定期重启计划表
+ public final static String Vip_User_Table = WEB_Site +".`tb_vip_user`"; //超级用户表
+ public final static String License_Table = WEB_Site +".`tb_license`"; //超级用户表
/***************************** db_battinf数据库 ***************************************/
@@ -161,6 +211,60 @@
public final static String BattinfEx_TABLE = DB_BATT_INF + ".`tb_battinf_ex`"; //基站信息表
public final static String BattinfRebuild_TABLE = DB_BATT_INF + ".`tb_battinf_rebuild`"; //机房配组表
public final static String BattmonTestcap_TABLE = DB_BATT_INF + ".`tb_battmon_testcap`"; //机房标准测试曲线记录表
+ public final static String Battcurr_Inf_TABLE = DB_BATT_INF + ".`tb_battcurr_inf`";
+ public final static String Batt_Maint_Process_TABLE = DB_BATT_INF + ".`tb_batt_maint_process`";
+ public final static String Batt_Maint_Inf_TABLE = DB_BATT_INF + ".`tb_batt_maint_inf`";
+ public final static String Batt_Alm_Param_TABLE = DB_BATT_INF + ".`tb_batt_alm_param`";
+
+
+
+
+ /***************************** db_alarm数据库 ***************************************/
+ public final static String Devalarm_Data_Table = DB_ALARM + ".`tb_devalarm_data`";
+ public final static String Devalarm_Data__History_Table = DB_ALARM + ".`tb_devalarm_data_history`";
+ public final static String Bts_Station_Event_Table = DB_ALARM + ".`tb_bts_station_event`";
+ public final static String Battalarm_Data_Table = DB_ALARM + ".`tb_battalarm_data`";
+ public final static String Battalarm_Data_History_Table = DB_ALARM + ".`tb_battalarm_data_history`";
+
+
+ /***************************** db_app_sys 数据库 ***************************************/
+ public final static String Page_Param_Table = DB_AppSys + ".`tb_page_param`";
+ public final static String Fbsdev_Statechange_Inf_Table = DB_AppSys + ".`tb_fbsdev_statechange_inf`";
+ public final static String Dashboard_Module_Chart_Table = DB_AppSys + ".`tb_dashboard_module_chart`";
+ public final static String Dashboard_Module_Table = DB_AppSys + ".`tb_dashboard_module`";
+ public final static String Dashboard_Chart_Type_Table = DB_AppSys + ".`tb_dashboard_chart_type`";
+ public final static String App_Sys_Table = DB_AppSys + ".`tb_app_sys`";
+ public final static String App_Bts_Comm_Task_Table = DB_AppSys + ".`tb_app_bts_comm_task`";
+ public final static String App_Bts_Battgroup_Table = DB_AppSys + ".`tb_app_bts_battgroup`";
+ public final static String Menu_Table = DB_AppSys + ".`tb_menu`";
+
+ /***************************** db_ld9_testdata 数据库 ***************************************/
+ public final static String Ld9testdata_Inf_Table = DB_LD9_TESTDATA + ".`tb_ld9testdata_inf`";
+
+ /***************************** db_param 数据库 ***************************************/
+ public final static String Dev_Param_Table = DB_PARAM + ".`tb_dev_param`";
+ public final static String App_Param_Table = DB_PARAM + ".`tb_app_param`";
+ public final static String Alarm_Param_Table = DB_PARAM + ".`tb_alarm_param`";
+
+ /***************************** db_pwrdev_alarm 数据库 ************************************/
+ public final static String Pwrdev_Alarm_Table = DB_PWRDEV_ALARM + ".`tb_pwrdev_alarm`";
+ public final static String Pwrdev_Alarm_History_Table = DB_PWRDEV_ALARM + ".`tb_pwrdev_alarm_history`";
+
+ /***************************** db_pwrdev_data_rt 数据库 ************************************/
+ public final static String Pwrdev_Acdcdata_Table = DB_PWRDEV_DATA_RT + ".`tb_pwrdev_acdcdata`";
+ public final static String Pwrdev_Dcdata_Table = DB_PWRDEV_DATA_RT + ".`tb_pwrdev_dcdata`";
+ public final static String Pwrdev_Acdata_Table = DB_PWRDEV_DATA_RT + ".`tb_pwrdev_acdata`";
+
+ /***************************** db_pwrdev_inf 数据库 ************************************/
+ public final static String Pwrdev_Inf_Table = DB_PWRDEV_INF + ".`tb_pwrdev_inf`";
+ public final static String Pwrapp_Sys_Table = DB_PWRDEV_INF + ".`tb_pwrapp_sys`";
+ public final static String Display_Config_Table = DB_PWRDEV_INF + ".`tb_display_config`";
+
+ public final static String Pwrapp_Stainf_Table = DB_PWRDEV_INF + ".`tb_pwrapp_stainf`";
+ public final static String Pwrapp_Dcinf_Table = DB_PWRDEV_INF + ".`tb_pwrapp_dcinf`";
+ public final static String Pwrapp_Acinf_Table = DB_PWRDEV_INF + ".`tb_pwrapp_acinf`";
+ public final static String Pwrapp_Acdcinf_Table = DB_PWRDEV_INF + ".`tb_pwrapp_acdcinf`";
+
//--------------------------------------------------------------------------------------------//
//--------------------------------------------------------------------------------------------//
@@ -201,7 +305,7 @@
sqlMysqlExecute("CREATE DATABASE IF NOT EXISTS " + DB_USER);
sqlMysqlExecute("CREATE DATABASE IF NOT EXISTS " + DB_RamDB);
- sqlMysqlExecute("DROP DATABASE IF EXISTS " + DB_RamDB_BATT_RT);
+ //sqlMysqlExecute("DROP DATABASE IF EXISTS " + DB_RamDB_BATT_RT);
//sqlMysqlExecute("CREATE DATABASE IF NOT EXISTS " + DB_RamDB_BATT_RT);
sqlMysqlExecute("CREATE DATABASE IF NOT EXISTS " + WEB_Site);
--
Gitblit v1.9.1