package com.database_util;
|
|
import java.sql.ResultSet;
|
import java.sql.SQLException;
|
import java.util.Date;
|
|
import com.base.Com;
|
import com.sql.MysqlConnPool;
|
import com.sql.Sql_Mysql;
|
|
public class DB_Pwrdev_Alarm {
|
public static void init(MysqlConnPool pool, boolean recreate) {
|
System.out.println(" db_pwrdev_alarm start end at " + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms));
|
|
createDB_Pwrdev_Alarm (pool);
|
|
createPwrdev_Alarm_Table(pool, recreate);
|
|
createPwrdev_Alarm_History_Table(pool, recreate);
|
|
createPwrdev_Alarm_Param_Table(pool, recreate);
|
|
createPwrdev_Alarm_Config_Table(pool, recreate);
|
|
createPwrdev_Time_Adj_Alarm_Table(pool, recreate);
|
|
createPwrdev_Time_Out_Alarm_Table(pool, recreate);
|
|
createPwrdev_Alarm_Param_ForSX_Table(pool, recreate);
|
|
System.out.println(" db_pwrdev_alarm init end at " + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms));
|
|
}
|
|
private static void createPwrdev_Time_Out_Alarm_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Pwrdev_Time_Out_Alarm_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Pwrdev_Time_Out_Alarm_Table + " (" +
|
" `num` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `PowerDeviceId` bigint(20) NOT NULL DEFAULT '0'," +
|
" `alarm_typeId` int(11) NOT NULL DEFAULT '0'," +
|
" `alarm_index` int(11) NOT NULL DEFAULT '0'," +
|
" `timeout_tag` int(11) NOT NULL DEFAULT '0'," +
|
" `read_datetime` datetime NOT NULL DEFAULT '2005-01-01 00:00:00'," +
|
" `system_datetime` datetime NOT NULL DEFAULT '2005-01-01 00:00:00'," +
|
" `resume_datetime` datetime NOT NULL DEFAULT '2005-01-01 00:00:00'," +
|
" PRIMARY KEY (`num`)," +
|
" KEY `index_powerdev_id` (`PowerDeviceId`)" +
|
") ENGINE=InnoDB AUTO_INCREMENT=65 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();
|
}
|
}
|
private static void createPwrdev_Time_Adj_Alarm_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Pwrdev_Time_Adj_Alarm_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Pwrdev_Time_Adj_Alarm_Table + " (" +
|
" `num` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `PowerDeviceId` bigint(20) NOT NULL DEFAULT '0'," +
|
" `alarm_typeId` int(11) NOT NULL DEFAULT '0'," +
|
" `detect_datetime` datetime NOT NULL DEFAULT '2005-01-01 00:00:00'," +
|
" `record_datetime` datetime NOT NULL DEFAULT '2005-01-01 00:00:00'," +
|
" PRIMARY KEY (`num`)," +
|
" KEY `index_powerdev_id` (`PowerDeviceId`)" +
|
") ENGINE=InnoDB AUTO_INCREMENT=38 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();
|
}
|
}
|
private static void createPwrdev_Alarm_Config_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Pwrdev_Alarm_Config_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Pwrdev_Alarm_Config_Table + " (" +
|
" `num` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `SMS_CommPort` varchar(10) NOT NULL DEFAULT ' '," +
|
" `SMS_CommPort_ReInit` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `Beeper_CommPort` varchar(10) NOT NULL DEFAULT ' '," +
|
" `Beeper_CommPort_ReInit` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `SMS_Alarm_Text` varchar(100) NOT NULL DEFAULT ' '," +
|
" `SMS_Alarm_EN` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `Beeper_Alarm_EN` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `Beeper_Sound_OFF` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `AlarmDevIP` varchar(30) NOT NULL DEFAULT '192.168.10.223'," +
|
" `SMS_Alarm_ipPort` int(11) NOT NULL DEFAULT '26'," +
|
" `Beeper_Alarm_ipPort` int(11) NOT NULL DEFAULT '27'," +
|
" PRIMARY KEY (`num`)" +
|
") ENGINE=InnoDB AUTO_INCREMENT=2 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();
|
}
|
}
|
private static void createPwrdev_Alarm_Param_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Pwrdev_Alarm_Param_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Pwrdev_Alarm_Param_Table + " (" +
|
" `num` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `alarm_id` bigint(20) NOT NULL DEFAULT '0'," +
|
" `alarm_limitH` float NOT NULL DEFAULT '0'," +
|
" `alarm_limitL` float NOT NULL DEFAULT '0'," +
|
" `alarm_limitEn` int(11) NOT NULL DEFAULT '0' COMMENT 'ÊÇ·ñ¿ÉÒÔÉèÖÃÉÏÏÂÏÞ'," +
|
" `UserAlarm_EN` int(11) NOT NULL DEFAULT '1' COMMENT '¸æ¾¯¹æÔòÊÇ·ñÆô¶¯'," +
|
" `alarm_level` int(11) NOT NULL DEFAULT '0'," +
|
" `alarm_devtype` int(11) NOT NULL DEFAULT '0'," +
|
" `alarm_name` varchar(100) NOT NULL DEFAULT '0'," +
|
" PRIMARY KEY (`num`)," +
|
" UNIQUE KEY `unique_alarm_id` (`alarm_id`)," +
|
" KEY `index_alarm_id` (`alarm_id`)" +
|
") 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();
|
}
|
}
|
|
/**
|
* ´´½¨ db_pwrdev_alarm Êý¾Ý¿â
|
* @param pool
|
*/
|
private static void createDB_Pwrdev_Alarm(MysqlConnPool pool) {
|
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
|
try {
|
sql.sqlMysqlExecute("CREATE DATABASE IF NOT EXISTS " + Sql_Mysql.DB_PWRDEV_ALARM);
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
sql.close_con();
|
}
|
}
|
|
/**
|
* ´´½¨ tb_pwrdev_alarm ±í
|
* @param pool
|
* @param recreate
|
*/
|
public static void createPwrdev_Alarm_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Pwrdev_Alarm_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Pwrdev_Alarm_Table + " (" +
|
" `num` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `record_id` bigint(20) NOT NULL DEFAULT '0'," +
|
" `PowerDeviceId` bigint(20) NOT NULL DEFAULT '0'," +
|
" `alm_type` int(11) NOT NULL DEFAULT '0'," +
|
" `alm_level` int(11) NOT NULL DEFAULT '0'," +
|
" `alm_source` int(11) NOT NULL DEFAULT '0'," +
|
" `alm_index` int(11) NOT NULL DEFAULT '0',"+
|
" `alm_start_time` datetime NOT NULL DEFAULT '1982-01-01 00:00:00'," +
|
" `alm_end_time` datetime NOT NULL DEFAULT '1982-01-01 00:00:00'," +
|
" `alm_value` float NOT NULL DEFAULT '0'," +
|
" `alm_is_confirmed` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `alm_confirmed_time` datetime NOT NULL DEFAULT '1982-01-01 00:00:00'," +
|
" `alm_cleared_type` int(11) NOT NULL DEFAULT '0'," +
|
" `usr_Id` int(11) NOT NULL DEFAULT '0'," +
|
" `alm_trigger` int(11) NOT NULL DEFAULT '0' COMMENT '¸æ¾¯À´Ô´[0-À´Ô´ÓÚµã±í£»1-À´Ô´ÓÚµçÔ´¸æ¾¯²ÎÊý]'," +
|
" PRIMARY KEY (`num`)," +
|
" KEY `index_record_id` (`record_id`)," +
|
" KEY `index_pwrdev_id` (`PowerDeviceId`)," +
|
" KEY `index_alm_type` (`alm_type`)," +
|
" KEY `index_alm_start_time` (`alm_start_time`)," +
|
" KEY `index_alm_cleared_type` (`alm_cleared_type`)" +
|
") ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8;";
|
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
|
ResultSet res = null;
|
try {
|
if(true == recreate) {
|
sql.sqlMysqlExecute(sql_str01);
|
}
|
sql.sqlMysqlExecute(sql_str02);
|
|
|
//Ìí¼Ó alm_source
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_alarm'"
|
+ " AND table_name='tb_pwrdev_alarm'"
|
+ " AND column_name='alm_source'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_Table
|
+ " ADD COLUMN `alm_source` int(11) NOT NULL DEFAULT '0'");
|
}
|
|
//Ìí¼Ó alm_index
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_alarm'"
|
+ " AND table_name='tb_pwrdev_alarm'"
|
+ " AND column_name='alm_index'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_Table
|
+ " ADD COLUMN `alm_index` int(11) NOT NULL DEFAULT '0'");
|
}
|
//Ìí¼Ó alm_trigger ¸æ¾¯´¥·¢À´Ô´[0-À´Ô´ÓÚµã±í£»1-À´Ô´ÓÚµçÔ´¸æ¾¯²ÎÊý]
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_alarm'"
|
+ " AND table_name='tb_pwrdev_alarm'"
|
+ " AND column_name='alm_trigger'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_Table
|
+ " ADD COLUMN `alm_trigger` int(11) NOT NULL DEFAULT '0' COMMENT '¸æ¾¯´¥·¢À´Ô´[0-À´Ô´ÓÚµã±í£»1-À´Ô´ÓÚµçÔ´¸æ¾¯²ÎÊý]'");
|
}
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
sql.close_con();
|
}
|
}
|
|
/**
|
* ´´½¨ tb_pwrdev_alarm_history ±í
|
* @param pool
|
* @param recreate
|
*/
|
public static void createPwrdev_Alarm_History_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Pwrdev_Alarm_History_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Pwrdev_Alarm_History_Table + " (" +
|
" `num` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `record_id` bigint(20) NOT NULL DEFAULT '0'," +
|
" `PowerDeviceId` bigint(20) NOT NULL DEFAULT '0'," +
|
" `alm_type` int(11) NOT NULL DEFAULT '0'," +
|
" `alm_level` int(11) NOT NULL DEFAULT '0'," +
|
" `alm_source` int(11) NOT NULL DEFAULT '0'," +
|
" `alm_index` int(11) NOT NULL DEFAULT '0',"+
|
" `alm_start_time` datetime NOT NULL DEFAULT '1982-01-01 00:00:00'," +
|
" `alm_end_time` datetime NOT NULL DEFAULT '1982-01-01 00:00:00'," +
|
" `alm_value` float NOT NULL DEFAULT '0'," +
|
" `alm_is_confirmed` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `alm_confirmed_time` datetime NOT NULL DEFAULT '1982-01-01 00:00:00'," +
|
" `alm_cleared_type` int(11) NOT NULL DEFAULT '0'," +
|
" `usr_Id` int(11) NOT NULL DEFAULT '0'," +
|
" `alm_trigger` int(11) NOT NULL DEFAULT '0' COMMENT '¸æ¾¯´¥·¢À´Ô´[0-À´Ô´ÓÚµã±í£»1-À´Ô´ÓÚµçÔ´¸æ¾¯²ÎÊý]'," +
|
" PRIMARY KEY (`num`)," +
|
" KEY `index_record_id` (`record_id`)," +
|
" KEY `index_pwrdev_id` (`PowerDeviceId`)," +
|
" KEY `index_alm_type` (`alm_type`)," +
|
" KEY `index_alm_start_time` (`alm_start_time`)," +
|
" KEY `index_alm_cleared_type` (`alm_cleared_type`)" +
|
") ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8;";
|
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
|
ResultSet res = null;
|
try {
|
if(true == recreate) {
|
sql.sqlMysqlExecute(sql_str01);
|
}
|
sql.sqlMysqlExecute(sql_str02);
|
|
|
//Ìí¼Ó alm_source
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_alarm'"
|
+ " AND table_name='tb_pwrdev_alarm_history'"
|
+ " AND column_name='alm_source'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_History_Table
|
+ " ADD COLUMN `alm_source` int(11) NOT NULL DEFAULT '0'");
|
}
|
|
//Ìí¼Ó alm_index
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_alarm'"
|
+ " AND table_name='tb_pwrdev_alarm_history'"
|
+ " AND column_name='alm_index'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_History_Table
|
+ " ADD COLUMN `alm_index` int(11) NOT NULL DEFAULT '0'");
|
}
|
//Ìí¼Ó alm_trigger -- ¸æ¾¯´¥·¢À´Ô´[0-À´Ô´ÓÚµã±í£»1-À´Ô´ÓÚµçÔ´¸æ¾¯²ÎÊý]
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_pwrdev_alarm'"
|
+ " AND table_name='tb_pwrdev_alarm_history'"
|
+ " AND column_name='alm_trigger'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Alarm_History_Table
|
+ " ADD COLUMN `alm_trigger` int(11) NOT NULL DEFAULT '0' COMMENT '¸æ¾¯´¥·¢À´Ô´[0-À´Ô´ÓÚµã±í£»1-À´Ô´ÓÚµçÔ´¸æ¾¯²ÎÊý]'");
|
}
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
sql.close_con();
|
}
|
}
|
|
private static void createPwrdev_Alarm_Param_ForSX_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Pwrdev_Alarm_Param_ForSX_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Pwrdev_Alarm_Param_ForSX_Table + " (" +
|
" `num` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'Ö÷¼ü'," +
|
" `PowerDeviceId` int(11) NOT NULL DEFAULT '0' COMMENT 'µçÔ´id'," +
|
" `alm_id` int(11) NOT NULL DEFAULT '0' COMMENT '¸æ¾¯id'," +
|
" `alm_level` int(11) NOT NULL DEFAULT '4' COMMENT '¸æ¾¯µÈ¼¶'," +
|
" `alarm_limitH` float NOT NULL DEFAULT '0' COMMENT '¸æ¾¯ÉÏÏÞãÐÖµ'," +
|
" `alarm_limitH_EN` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'ÉÏÏ޸澯ʹÄÜ'," +
|
" `alarm_limitL` float NOT NULL DEFAULT '0' COMMENT '¸æ¾¯ÏÂÏÞãÐÖµ'," +
|
" `alarm_limitL_EN` tinyint(4) NOT NULL DEFAULT '0' COMMENT '¸æ¾¯ÏÂÏÞʹÄÜ'," +
|
" `alarm_source` int(11) NOT NULL DEFAULT '0' COMMENT '¸æ¾¯Êý¾ÝÀ´Ô´[0-É豸¸æ¾¯µãλÅжϣ»1-µ±Ç°ãÐÖµÅжÏ]'," +
|
" `alarm_name` varchar(255) NOT NULL DEFAULT '' COMMENT 'µ±Ç°¸æ¾¯ÃèÊö'," +
|
" `alarm_type` int(11) NOT NULL DEFAULT '0' COMMENT '0-ÉÏÏÂÏÞÓÐЧ 1-ÉÏÏÞÓÐЧ 2-ÏÂÏÞÓÐЧ'," +
|
" PRIMARY KEY (`num`)" +
|
") ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='ɽÎ÷µçÔ´¸æ¾¯²ÎÊý±í';";
|
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
|
ResultSet res = null;
|
try {
|
if(true == recreate) {
|
sql.sqlMysqlExecute(sql_str01);
|
}
|
sql.sqlMysqlExecute(sql_str02);
|
res = sql.sqlMysqlQuery("SELECT PowerDeviceId FROM " + Sql_Mysql.Pwrdev_Inf_Table);
|
StringBuffer buf_base = new StringBuffer("INSERT INTO " + Sql_Mysql.Pwrdev_Alarm_Param_ForSX_Table + "(PowerDeviceId,alm_id,alm_level,alarm_limitH,alarm_limitH_EN,alarm_limitL,alarm_limitL_EN,alarm_name,alarm_type) VALUES");
|
StringBuffer buf_body = new StringBuffer();
|
while(res.next()) {
|
int PowerDeviceId = res.getInt("PowerDeviceId");
|
|
//½»Á÷AÏà¹ýѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_A_OverV_ID,SqlsUtils.Alarm_Level_Second,198,true, 135.4f,false,"½»Á÷AÏà¹ýѹ¸æ¾¯",1,pool);
|
//½»Á÷AÏàǷѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_A_UnderV_ID,SqlsUtils.Alarm_Level_Second,198,false, 135.4f,true,"½»Á÷AÏàǷѹ¸æ¾¯",2,pool);
|
//½»Á÷AÏàȱÏà¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_A_Less_ID,SqlsUtils.Alarm_Level_Second,198,false, 110,true,"½»Á÷AÏàȱÏà¸æ¾¯",2,pool);
|
//½»Á÷BÏà¹ýѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_B_OverV_ID,SqlsUtils.Alarm_Level_Second,198,true, 135.4f,false,"½»Á÷BÏà¹ýѹ¸æ¾¯",1,pool);
|
//½»Á÷BÏàǷѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_B_UnderV_ID,SqlsUtils.Alarm_Level_Second,198,false, 135.4f,true,"½»Á÷BÏàǷѹ¸æ¾¯",2,pool);
|
//½»Á÷BÏàȱÏà¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_B_Less_ID,SqlsUtils.Alarm_Level_Second,198,false, 110,true,"½»Á÷BÏàȱÏà¸æ¾¯",2,pool);
|
//½»Á÷CÏà¹ýѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_C_OverV_ID,SqlsUtils.Alarm_Level_Second,198,true, 135.4f,false,"½»Á÷CÏà¹ýѹ¸æ¾¯",1,pool);
|
//½»Á÷CÏàǷѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_C_UnderV_ID,SqlsUtils.Alarm_Level_Second,198,false, 135.4f,true,"½»Á÷CÏàǷѹ¸æ¾¯",2,pool);
|
//½»Á÷CÏàȱÏà¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_AcIn1_C_Less_ID,SqlsUtils.Alarm_Level_Second,198,false, 110,true,"½»Á÷CÏàȱÏà¸æ¾¯",2,pool);
|
|
//½»Á÷AÏà¹ýÁ÷¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Acb1_OverCurrA_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"½»Á÷AÏà¹ýÁ÷¸æ¾¯",1,pool);
|
//½»Á÷BÏà¹ýÁ÷¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Acb1_OverCurrB_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"½»Á÷BÏà¹ýÁ÷¸æ¾¯",1,pool);
|
//½»Á÷CÏà¹ýÁ÷¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Acb1_OverCurrC_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"½»Á÷CÏà¹ýÁ÷¸æ¾¯",1,pool);
|
|
|
//ÕûÁ÷Æ÷1¹ýѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod1_OverVol_ID,SqlsUtils.Alarm_Level_Second,54,true, 48,false,"ÕûÁ÷Æ÷1¹ýѹ¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷2¹ýѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod2_OverVol_ID,SqlsUtils.Alarm_Level_Second,54,true, 48,false,"ÕûÁ÷Æ÷2¹ýѹ¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷3¹ýѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod3_OverVol_ID,SqlsUtils.Alarm_Level_Second,54,true, 48,false,"ÕûÁ÷Æ÷3¹ýѹ¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷4¹ýѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod4_OverVol_ID,SqlsUtils.Alarm_Level_Second,54,true, 48,false,"ÕûÁ÷Æ÷4¹ýѹ¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷5¹ýѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod5_OverVol_ID,SqlsUtils.Alarm_Level_Second,54,true, 48,false,"ÕûÁ÷Æ÷5¹ýѹ¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷6¹ýѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod6_OverVol_ID,SqlsUtils.Alarm_Level_Second,54,true, 48,false,"ÕûÁ÷Æ÷6¹ýѹ¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷7¹ýѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod7_OverVol_ID,SqlsUtils.Alarm_Level_Second,54,true, 48,false,"ÕûÁ÷Æ÷7¹ýѹ¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷8¹ýѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod8_OverVol_ID,SqlsUtils.Alarm_Level_Second,54,true, 48,false,"ÕûÁ÷Æ÷8¹ýѹ¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷9¹ýѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod9_OverVol_ID,SqlsUtils.Alarm_Level_Second,54,true, 48,false,"ÕûÁ÷Æ÷9¹ýѹ¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷10¹ýѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod10_OverVol_ID,SqlsUtils.Alarm_Level_Second,54,true, 48,false,"ÕûÁ÷Æ÷10¹ýѹ¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷11¹ýѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod11_OverVol_ID,SqlsUtils.Alarm_Level_Second,54,true, 48,false,"ÕûÁ÷Æ÷11¹ýѹ¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷12¹ýѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod12_OverVol_ID,SqlsUtils.Alarm_Level_Second,54,true, 48,false,"ÕûÁ÷Æ÷12¹ýѹ¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷13¹ýѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod13_OverVol_ID,SqlsUtils.Alarm_Level_Second,54,true, 48,false,"ÕûÁ÷Æ÷13¹ýѹ¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷14¹ýѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod14_OverVol_ID,SqlsUtils.Alarm_Level_Second,54,true, 48,false,"ÕûÁ÷Æ÷14¹ýѹ¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷15¹ýѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod15_OverVol_ID,SqlsUtils.Alarm_Level_Second,54,true, 48,false,"ÕûÁ÷Æ÷15¹ýѹ¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷16¹ýѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod16_OverVol_ID,SqlsUtils.Alarm_Level_Second,54,true, 48,false,"ÕûÁ÷Æ÷16¹ýѹ¸æ¾¯",1,pool);
|
|
//ÕûÁ÷Æ÷1Ƿѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod1_UnderVol_ID,SqlsUtils.Alarm_Level_Second,54,false, 48,true,"ÕûÁ÷Æ÷1Ƿѹ¸æ¾¯",2,pool);
|
//ÕûÁ÷Æ÷2Ƿѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod2_UnderVol_ID,SqlsUtils.Alarm_Level_Second,54,false, 48,true,"ÕûÁ÷Æ÷2Ƿѹ¸æ¾¯",2,pool);
|
//ÕûÁ÷Æ÷3Ƿѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod3_UnderVol_ID,SqlsUtils.Alarm_Level_Second,54,false, 48,true,"ÕûÁ÷Æ÷3Ƿѹ¸æ¾¯",2,pool);
|
//ÕûÁ÷Æ÷4Ƿѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod4_UnderVol_ID,SqlsUtils.Alarm_Level_Second,54,false, 48,true,"ÕûÁ÷Æ÷4Ƿѹ¸æ¾¯",2,pool);
|
//ÕûÁ÷Æ÷5Ƿѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod5_UnderVol_ID,SqlsUtils.Alarm_Level_Second,54,false, 48,true,"ÕûÁ÷Æ÷5Ƿѹ¸æ¾¯",2,pool);
|
//ÕûÁ÷Æ÷6Ƿѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod6_UnderVol_ID,SqlsUtils.Alarm_Level_Second,54,false, 48,true,"ÕûÁ÷Æ÷6Ƿѹ¸æ¾¯",2,pool);
|
//ÕûÁ÷Æ÷7Ƿѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod7_UnderVol_ID,SqlsUtils.Alarm_Level_Second,54,false, 48,true,"ÕûÁ÷Æ÷7Ƿѹ¸æ¾¯",2,pool);
|
//ÕûÁ÷Æ÷8Ƿѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod8_UnderVol_ID,SqlsUtils.Alarm_Level_Second,54,false, 48,true,"ÕûÁ÷Æ÷8Ƿѹ¸æ¾¯",2,pool);
|
//ÕûÁ÷Æ÷9Ƿѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod9_UnderVol_ID,SqlsUtils.Alarm_Level_Second,54,false, 48,true,"ÕûÁ÷Æ÷9Ƿѹ¸æ¾¯",2,pool);
|
//ÕûÁ÷Æ÷10Ƿѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod10_UnderVol_ID,SqlsUtils.Alarm_Level_Second,54,false, 48,true,"ÕûÁ÷Æ÷10Ƿѹ¸æ¾¯",2,pool);
|
//ÕûÁ÷Æ÷11Ƿѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod11_UnderVol_ID,SqlsUtils.Alarm_Level_Second,54,false, 48,true,"ÕûÁ÷Æ÷11Ƿѹ¸æ¾¯",2,pool);
|
//ÕûÁ÷Æ÷12Ƿѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod12_UnderVol_ID,SqlsUtils.Alarm_Level_Second,54,false, 48,true,"ÕûÁ÷Æ÷12Ƿѹ¸æ¾¯",2,pool);
|
//ÕûÁ÷Æ÷13Ƿѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod13_UnderVol_ID,SqlsUtils.Alarm_Level_Second,54,false, 48,true,"ÕûÁ÷Æ÷13Ƿѹ¸æ¾¯",2,pool);
|
//ÕûÁ÷Æ÷14Ƿѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod14_UnderVol_ID,SqlsUtils.Alarm_Level_Second,54,false, 48,true,"ÕûÁ÷Æ÷14Ƿѹ¸æ¾¯",2,pool);
|
//ÕûÁ÷Æ÷15Ƿѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod15_UnderVol_ID,SqlsUtils.Alarm_Level_Second,54,false, 48,true,"ÕûÁ÷Æ÷15Ƿѹ¸æ¾¯",2,pool);
|
//ÕûÁ÷Æ÷16Ƿѹ¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod16_UnderVol_ID,SqlsUtils.Alarm_Level_Second,54,false, 48,true,"ÕûÁ÷Æ÷16Ƿѹ¸æ¾¯",2,pool);
|
|
//ÕûÁ÷Æ÷1¹ýÁ÷¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod1_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"ÕûÁ÷Æ÷1¹ýÁ÷¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷2¹ýÁ÷¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod2_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"ÕûÁ÷Æ÷2¹ýÁ÷¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷3¹ýÁ÷¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod3_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"ÕûÁ÷Æ÷3¹ýÁ÷¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷4¹ýÁ÷¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod4_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"ÕûÁ÷Æ÷4¹ýÁ÷¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷5¹ýÁ÷¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod5_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"ÕûÁ÷Æ÷5¹ýÁ÷¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷6¹ýÁ÷¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod6_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"ÕûÁ÷Æ÷6¹ýÁ÷¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷7¹ýÁ÷¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod7_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"ÕûÁ÷Æ÷7¹ýÁ÷¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷8¹ýÁ÷¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod8_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"ÕûÁ÷Æ÷8¹ýÁ÷¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷9¹ýÁ÷¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod9_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"ÕûÁ÷Æ÷9¹ýÁ÷¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷10¹ýÁ÷¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod10_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"ÕûÁ÷Æ÷10¹ýÁ÷¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷11¹ýÁ÷¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod11_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"ÕûÁ÷Æ÷11¹ýÁ÷¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷12¹ýÁ÷¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod12_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"ÕûÁ÷Æ÷12¹ýÁ÷¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷13¹ýÁ÷¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod13_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"ÕûÁ÷Æ÷13¹ýÁ÷¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷14¹ýÁ÷¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod14_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"ÕûÁ÷Æ÷14¹ýÁ÷¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷15¹ýÁ÷¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod15_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"ÕûÁ÷Æ÷15¹ýÁ÷¸æ¾¯",1,pool);
|
//ÕûÁ÷Æ÷16¹ýÁ÷¸æ¾¯
|
checkPowerAlarmParam(buf_body,PowerDeviceId,SqlsUtils.ALM_TYPE_ACDC_Mod16_OverCurr_ID,SqlsUtils.Alarm_Level_Second,100,true, 0,false,"ÕûÁ÷Æ÷16¹ýÁ÷¸æ¾¯",1,pool);
|
|
|
//System.out.println(PowerDeviceId +" == " + buf_body );
|
}
|
if(buf_body.length() > 0) {
|
sql.sqlMysqlExecute((buf_base.append(buf_body)).toString());
|
}
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
if(null != res) {
|
try {
|
res.close();
|
} catch (SQLException e) {
|
e.printStackTrace();
|
}
|
}
|
sql.close_con();
|
}
|
}
|
|
/**
|
*
|
* @param buf_body sql_str
|
* @param PowerDeviceId µçÔ´id
|
* @param alm_id ¸æ¾¯id
|
* @param alm_level ¸æ¾¯µÈ¼¶
|
* @param alarm_limitH ÉÏÏÞãÐÖµ
|
* @param alarm_limitH_EN ÉÏÏÞãÐֵʹÄÜ
|
* @param alarm_limitL ÏÂÏÞãÐÖµ
|
* @param alarm_limitL_EN ÏÂÏÞãÐֵʹÄÜ
|
* @param alarm_name ¸æ¾¯ÃèÊö
|
* @param alarm_type ¸æ¾¯ÓÐЧ 0-ÉÏÏÂÏÞÓÐЧ 1-ÉÏÏÞÓÐЧ 2-ÏÂÏÞÓÐЧ
|
*/
|
public static void checkPowerAlarmParam(StringBuffer buf_body,int PowerDeviceId,int alm_id,int alm_level,float alarm_limitH,boolean alarm_limitH_EN, float alarm_limitL, boolean alarm_limitL_EN,String alarm_name,int alarm_type,MysqlConnPool pool) {
|
String sql_str_sel = "SELECT PowerDeviceId FROM " + Sql_Mysql.Pwrdev_Alarm_Param_ForSX_Table + " WHERE PowerDeviceId = " + PowerDeviceId + " AND alm_id = " + alm_id;
|
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
|
ResultSet res = null;
|
res = sql.sqlMysqlQuery(sql_str_sel);
|
//System.out.println(sql_str_sel);
|
try {
|
if(!res.next()) {
|
if(buf_body.length() > 0) {
|
buf_body.append(",");
|
}
|
buf_body.append("("+PowerDeviceId+","+alm_id+","+alm_level+","+alarm_limitH+","+alarm_limitH_EN+","+alarm_limitL+","+alarm_limitL_EN+",'"+alarm_name+"',"+alarm_type+")");
|
}
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
if(null != res) {
|
try {
|
res.close();
|
} catch (SQLException e) {
|
e.printStackTrace();
|
}
|
}
|
sql.close_con();
|
}
|
}
|
|
|
public static void main(String[] args) {
|
MysqlConnPool pool = new MysqlConnPool("192.168.10.79", 3360, 5);
|
createPwrdev_Alarm_Param_ForSX_Table(pool, false);
|
}
|
}
|
