iec_61850.git - Gitblit

			@@ -15,123 +15,125 @@

			public class Sql_Mysql {
			//--------------------------------------------------------------------------------------------//
			final public static String DB_AppSys = "`db_app_sys`";
			final public static String DB_BATT_INF = "`db_battinf`";
			final public static String DB_BATT_TESTDATA = "`db_batt_testdata`";
			final public static String DB_PARAM = "`db_param`";
			final public static String DB_ALARM = "`db_alarm`";
			final public static String DB_USER = "`db_user`";
			final public static String DB_RamDB = "`db_ram_db`";
			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`";

			//--------------------------------------------------------------------------------------------//
			public final static String TB_HardDevSmsState = "tb_hard_dev_sms_state";
			//--------------------------------------------------------------------------------------------//
			public final static String TB_AppSys = "tb_app_sys";

			public final static String TB_BattTestDataInf = "tb_batttestdata_inf";

			public final static String TB_UserInf = "tb_user_inf";
			public final static String TB_UserLog = "tb_user_log";
			public final static String TB_UserBattGroup_BaoJiGroup = "tb_user_battgroup_baojigroup";
			public final static String TB_UserBattGroup_BaoJiGroup_BattGroup = "tb_user_battgroup_baojigroup_battgroup";
			public final static String TB_UserBattGroup_BaoJiGroup_Usr = "tb_user_battgroup_baojigroup_usr";
			public final static String TB_UserTaskTemplate = "tb_user_task_batt_template";
			public final static String TB_UserTask = "tb_user_task";
			public final static String TB_UserPaiXiu = "tb_user_paixiu";
			public final static String TB_UserListForTask = "tb_user_task_user_list";
			public final static String TB_UserTaskParam = "tb_user_task_param";
			public final static String TB_UserBattCkeckTask = "tb_user_task_batt_check";
			public final static String TB_UserBattTestTask = "tb_user_task_batt_test";
			public final static String TB_UserBattTaskChange = "tb_user_task_change";
			public final static String TB_UserSms = "tb_user_sms";
			public final static String TB_UserSmsFormat = "tb_user_sms_format";
			public final static String TB_UserPermitGroup = "tb_user_permitgroup";
			public final static String TB_UserPermitGroupData = "tb_user_permitgroup_data";
			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 FBS9100SysParam_Table = DB_RamDB + ".`tb_fbs9100_sysparam`"; //系统参数表
			public final static String FBS9100SetDLParam_Table = DB_RamDB + ".`tb_fbs9100s_fod_param`";
			public final static String FBS9100sFodState_Table = DB_RamDB + ".`tb_fbs9100s_fod_state`";
			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 FBS9100_61850_jhstate_Table = DB_RamDB + ".`tb_61850_jhstate`";
			//--------------------------------------------------------------------------------------------//
			//--------------------------------------------------------------------------------------------//
			public final static String AppSys_Table = DB_AppSys + ".`tb_app_sys`";
			public final static String FBSDevStateChangeInf_Table = DB_AppSys + ".`tb_fbsdev_statechange_inf`";
			public final static String BattInf_Table = DB_BATT_INF + ".`tb_battinf`";
			public final static String BattCurrInf_Table = DB_BATT_INF + ".`tb_battcurr_inf`";
			public final static String BattMainInf_Table = DB_BATT_INF + ".`tb_batt_maint_inf`";
			public final static String BattMainProcess_Table = DB_BATT_INF + ".`tb_batt_maint_process`";


			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 UserInfTable = DB_USER + ".`tb_user_inf`";
			public final static String UserLogTable = DB_USER + ".`tb_user_log`";
			public final static String UserBattGroup_BaoJiGroup_Table = DB_USER + ".`tb_user_battgroup_baojigroup`";
			public final static String UserBattGroup_BaoJiGroup_BattGroupTable = DB_USER + ".`tb_user_battgroup_baojigroup_battgroup`";
			public final static String UserBattGroup_BaoJiGroup_UsrTable = DB_USER + ".`tb_user_battgroup_baojigroup_usr`";
			public final static String UserTaskTemplateTable = DB_USER + ".`tb_user_task_batt_template`";
			public final static String UserTaskTable = DB_USER + ".`tb_user_task`";
			public final static String UserPaiXiuTable = DB_USER + ".`tb_user_paixiu`";
			public final static String UserListForTaskTable = DB_USER + ".`tb_user_task_user_list`";
			public final static String UserTaskParamTable = DB_USER + ".`tb_user_task_param`";
			public final static String UserBattCheckTaskTable = DB_USER + ".`tb_user_task_batt_check`";
			public final static String UserBattTestTaskTable = DB_USER + ".`tb_user_task_batt_test`";

			public final static String UserBattTaskChangeTable = DB_USER + ".`tb_user_task_change`";

			public final static String UsrBattMaintCheck_Table = DB_USER + ".`tb_user_battmaint_check`";
			public final static String UsrBattMaintCheckProcess_Table = DB_USER + ".`tb_user_battmaint_check_process`";

			public final static String UserSmsTable = DB_USER + ".`tb_user_sms`";
			public final static String UserSmsFormatTable = DB_USER + ".`tb_user_sms_format`";
			public final static String UserPermitGroupTable = DB_USER + ".`tb_user_permitgroup`";
			public final static String UserPermitGroupDataTable = DB_USER + ".`tb_user_permitgroup_data`";
			public final static String UserJieJiaRiTable = DB_USER + ".`tb_user_jiejiari`";
			//--------------------------------------------------------------------------------------------//
			public final static String Tb_BattDischarge_ParamTable = WEB_Site+".tb_battdischarge_param"; //��
			public final static String Tb_BattMap_InformationTable = WEB_Site+".tb_battmap_information"; //��
			public final static String Tb_Batt_DevDischargeTable = WEB_Site+".tb_batt_devdischarge"; //��
			public final static String Tb_BattDischarge_PlanTable = WEB_Site+".tb_battdischarge_plan"; //��
			public final static String Tb_Batt_ElectricityTable = WEB_Site+".tb_batt_electricity"; //��
			public final static String Tb_Batt_Devdischarge_ParamTable = WEB_Site+".tb_batt_devdischarge_param"; //��
			public final static String Tb_Batt_Devdischarge_CMTable = WEB_Site+".tb_batt_devdischarge_CM"; //��
			public final static String Tb_Batt_Devdischarge_CTTable = WEB_Site+".tb_batt_devdischarge_CT"; //��
			public final static String Tb_Batt_Devdischarge_CUTable = WEB_Site+".tb_batt_devdischarge_CU"; //��
			public final static String Tb_CustomPageTable = WEB_Site+".tb_custompage"; //��
			public final static String Tb_Vip_UserTable = WEB_Site+".tb_vip_user"; //��
			public final static String Tb_Batt_Param_LowTable = WEB_Site+".tb_batt_param_low"; //��
			public final static String Tb_AnnounceTable = WEB_Site+".tb_announce"; //��
			//--------------------------------------------------------------------------------------------//
			public final static String Tb_BtsStateChange_inf = DB_BATT_HISTORY + ".`tb_btsstaechange_inf`"; //设备事件表
			public final static String Tb_Batt_RealData = DB_BATT_HISTORY + ".tb_batt_realdata_"; //电池组历史实时数据记录表
			final public static String DB_AppSys = "`db_app_sys`";
			final public static String DB_BATT_INF = "`db_battinf`";
			final public static String DB_BATT_TESTDATA = "`db_batt_testdata`";
			final public static String DB_PARAM = "`db_param`";
			final public static String DB_ALARM = "`db_alarm`";
			final public static String DB_USER = "`db_user`";
			final public static String DB_RamDB = "`db_ram_db`";
			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`";

			//--------------------------------------------------------------------------------------------//
			public final static String TB_HardDevSmsState = "tb_hard_dev_sms_state";
			//--------------------------------------------------------------------------------------------//
			public final static String TB_AppSys = "tb_app_sys";

			public final static String TB_BattTestDataInf = "tb_batttestdata_inf";

			public final static String TB_UserInf = "tb_user_inf";
			public final static String TB_UserLog = "tb_user_log";
			public final static String TB_UserBattGroup_BaoJiGroup = "tb_user_battgroup_baojigroup";
			public final static String TB_UserBattGroup_BaoJiGroup_BattGroup = "tb_user_battgroup_baojigroup_battgroup";
			public final static String TB_UserBattGroup_BaoJiGroup_Usr = "tb_user_battgroup_baojigroup_usr";
			public final static String TB_UserTaskTemplate = "tb_user_task_batt_template";
			public final static String TB_UserTask = "tb_user_task";
			public final static String TB_UserPaiXiu = "tb_user_paixiu";
			public final static String TB_UserListForTask = "tb_user_task_user_list";
			public final static String TB_UserTaskParam = "tb_user_task_param";
			public final static String TB_UserBattCkeckTask = "tb_user_task_batt_check";
			public final static String TB_UserBattTestTask = "tb_user_task_batt_test";
			public final static String TB_UserBattTaskChange = "tb_user_task_change";
			public final static String TB_UserSms = "tb_user_sms";
			public final static String TB_UserSmsFormat = "tb_user_sms_format";
			public final static String TB_UserPermitGroup = "tb_user_permitgroup";
			public final static String TB_UserPermitGroupData = "tb_user_permitgroup_data";
			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 FBS9100SysParam_Table = DB_RamDB + ".`tb_fbs9100_sysparam`"; //绯荤粺鍙傛暟琛�
			public final static String FBS9100SetDLParam_Table = DB_RamDB + ".`tb_fbs9100s_fod_param`";
			public final static String FBS9100sFodState_Table = DB_RamDB + ".`tb_fbs9100s_fod_state`";
			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 FBS9100_61850_jhstate_Table = DB_RamDB + ".`tb_61850_jhstate`";

			public final static String FBS9100_offlineyhplan = DB_RamDB + ".tb_fbs9100_offlineyhplan"; //61850离线养护计划参数表
			//--------------------------------------------------------------------------------------------//
			//--------------------------------------------------------------------------------------------//
			public final static String AppSys_Table = DB_AppSys + ".`tb_app_sys`";
			public final static String FBSDevStateChangeInf_Table = DB_AppSys + ".`tb_fbsdev_statechange_inf`";
			public final static String BattInf_Table = DB_BATT_INF + ".`tb_battinf`";
			public final static String BattCurrInf_Table = DB_BATT_INF + ".`tb_battcurr_inf`";
			public final static String BattMainInf_Table = DB_BATT_INF + ".`tb_batt_maint_inf`";
			public final static String BattMainProcess_Table = DB_BATT_INF + ".`tb_batt_maint_process`";


			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 UserInfTable = DB_USER + ".`tb_user_inf`";
			public final static String UserLogTable = DB_USER + ".`tb_user_log`";
			public final static String UserBattGroup_BaoJiGroup_Table = DB_USER + ".`tb_user_battgroup_baojigroup`";
			public final static String UserBattGroup_BaoJiGroup_BattGroupTable = DB_USER + ".`tb_user_battgroup_baojigroup_battgroup`";
			public final static String UserBattGroup_BaoJiGroup_UsrTable = DB_USER + ".`tb_user_battgroup_baojigroup_usr`";
			public final static String UserTaskTemplateTable = DB_USER + ".`tb_user_task_batt_template`";
			public final static String UserTaskTable = DB_USER + ".`tb_user_task`";
			public final static String UserPaiXiuTable = DB_USER + ".`tb_user_paixiu`";
			public final static String UserListForTaskTable = DB_USER + ".`tb_user_task_user_list`";
			public final static String UserTaskParamTable = DB_USER + ".`tb_user_task_param`";
			public final static String UserBattCheckTaskTable = DB_USER + ".`tb_user_task_batt_check`";
			public final static String UserBattTestTaskTable = DB_USER + ".`tb_user_task_batt_test`";

			public final static String UserBattTaskChangeTable = DB_USER + ".`tb_user_task_change`";

			public final static String UsrBattMaintCheck_Table = DB_USER + ".`tb_user_battmaint_check`";
			public final static String UsrBattMaintCheckProcess_Table = DB_USER + ".`tb_user_battmaint_check_process`";

			public final static String UserSmsTable = DB_USER + ".`tb_user_sms`";
			public final static String UserSmsFormatTable = DB_USER + ".`tb_user_sms_format`";
			public final static String UserPermitGroupTable = DB_USER + ".`tb_user_permitgroup`";
			public final static String UserPermitGroupDataTable = DB_USER + ".`tb_user_permitgroup_data`";
			public final static String UserJieJiaRiTable = DB_USER + ".`tb_user_jiejiari`";
			//--------------------------------------------------------------------------------------------//
			public final static String Tb_BattDischarge_ParamTable = WEB_Site+".tb_battdischarge_param"; //电池放电参数
			public final static String Tb_BattMap_InformationTable = WEB_Site+".tb_battmap_information"; //机房定位信息表
			public final static String Tb_Batt_DevDischargeTable = WEB_Site+".tb_batt_devdischarge"; //设备用电量记录表
			public final static String Tb_BattDischarge_PlanTable = WEB_Site+".tb_battdischarge_plan"; //放电计划表
			public final static String Tb_Batt_ElectricityTable = WEB_Site+".tb_batt_electricity"; //设备三大运营商的用电量记录表
			public final static String Tb_Batt_Devdischarge_ParamTable = WEB_Site+".tb_batt_devdischarge_param"; //放电计划参数表
			public final static String Tb_Batt_Devdischarge_CMTable = WEB_Site+".tb_batt_devdischarge_CM"; //移动用电量统计
			public final static String Tb_Batt_Devdischarge_CTTable = WEB_Site+".tb_batt_devdischarge_CT"; //联通用电量统计
			public final static String Tb_Batt_Devdischarge_CUTable = WEB_Site+".tb_batt_devdischarge_CU"; //电信用电量统计
			public final static String Tb_CustomPageTable = WEB_Site+".tb_custompage"; //界面导航数据表
			public final static String Tb_Vip_UserTable = WEB_Site+".tb_vip_user"; //vip用户表
			public final static String Tb_Batt_Param_LowTable = WEB_Site+".tb_batt_param_low"; //电池下限表
			public final static String Tb_AnnounceTable = WEB_Site+".tb_announce"; //平台公告表
			//--------------------------------------------------------------------------------------------//
			public final static String Tb_BtsStateChange_inf = DB_BATT_HISTORY + ".`tb_btsstaechange_inf`"; //设备状态变换记录表
			public final static String Tb_Batt_RealData = DB_BATT_HISTORY + ".tb_batt_realdata_"; //电池实时数据记录表



			@@ -143,7 +145,7 @@
			mysql_con = conn;
			}
			/**
			* ��tb��
			* 锟斤拷锟斤拷锟斤拷tb锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟�
			* @param tb
			* @return
			* @throws SQLException
			@@ -162,7 +164,7 @@
			return exist;
			}

			//��sql��
			//锟斤拷锟斤拷锟斤拷sql锟斤拷锟斤拷锟斤拷
			public void sqlMysqlExecute(String sql_str) throws SQLException
			{
			Statement sql = mysql_con.createStatement();
			@@ -172,13 +174,13 @@
			//sql.close();
			}

			//��db��
			//锟斤拷锟斤拷锟斤拷db锟斤拷锟斤拷锟斤拷锟斤拷锟�
			public void sqlMysqlUseDB(String db) throws SQLException
			{
			sqlMysqlExecute("use " + db);
			}

			//��sql��
			//锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷sql锟斤拷锟斤拷锟斤拷
			public boolean makeManualCommit(ArrayList<String> al_sql_strs)
			{
			boolean exe_res = true;
			@@ -210,7 +212,7 @@
			return exe_res;
			}

			//��sql��sql��
			//锟斤拷锟斤拷锟斤拷sql锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷sql锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷

			public ResultSet sqlMysqlQuery(String sql_str)
			{
			@@ -228,7 +230,7 @@
			}
			return res;
			}
			public List<Db_setparm> sqlMysqlQuery1(String sql_str)//SETPARM SQL��
			public List<Db_setparm> sqlMysqlQuery1(String sql_str)//SETPARM SQL锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷
			{
			ResultSet res = null;
			List<Db_setparm> list = new ArrayList<Db_setparm>();
			@@ -259,7 +261,7 @@
			}
			return list;
			}
			//��sql��sql��
			//锟斤拷锟斤拷锟斤拷sql锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷sql锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷
			public void sqlMysqlUpdate(String sql_str)
			{
			try