package com.database_util;
|
|
import java.sql.ResultSet;
|
import java.sql.SQLException;
|
import java.util.Date;
|
|
import com.base.Com;
|
import com.battdata_rt.BattData_RT_RamDB_Thread_SQL;
|
import com.sql.MysqlConnPool;
|
import com.sql.Sql_Mysql;
|
|
public class DB_Ram_db {
|
|
public static void init(MysqlConnPool pool, boolean recreate) {
|
createDb_Ram_Db(pool);
|
|
createFBS9100s_fod_state(pool,recreate); //´´½¨³ýÁò״̬±ítb_fbs9100s_fod_state
|
|
createFBS9100SetDLParam_Table(pool,recreate); //´´½¨³ýÁò²ÎÊý±í
|
|
createFBS9100_NiBian_State_Table(pool, recreate); //´´½¨Äæ±äÐÅÏ¢±í
|
|
|
createSocketClientStateTable(pool, recreate);
|
|
createServerState_Table(pool, recreate);
|
|
createLd9_Updatestatue_Table(pool, recreate);
|
|
createLd9_State_Table(pool, recreate);
|
|
createLd9_Setparam_Table(pool, recreate);
|
|
createLd9_Concentratestate_Table(pool, recreate);
|
|
createLd9_Concentrateparam_Table(pool, recreate);
|
|
createHardDevSmsState_Table(pool, recreate);
|
|
createFBS9600State_Table(pool, recreate);
|
|
createFBS9100S_DFUState_Table(pool, recreate);
|
|
createFBS9100S_DcDcState_Table(pool, recreate);
|
|
createFBS9100SysParam_Table(pool, recreate);
|
|
createFBS9100State_Table(pool, recreate);
|
|
createFBS9100SetParam_Table(pool, recreate);
|
|
createFBS9100_offlineyhplan_Table(pool, recreate);
|
|
createFBS9100BattParam_Table(pool, recreate);
|
|
createBTSStationState_Table(pool, recreate);
|
|
createBTSGPRSState_Table(pool, recreate);
|
|
createBMP7100State_Table(pool, recreate);
|
|
createBattRtState_Table(pool, recreate);
|
|
createBattRtData_Table(pool, recreate);
|
|
create61850_JHState_Table(pool, recreate);
|
|
createRamDB_CMCC_POWER_Data_Table(pool, recreate);
|
|
createFBS9100_CollectionstateTable(pool, recreate);
|
|
createFBS9100_InsulatstateTable(pool, recreate);
|
|
createFBS9100_ChargerstateTable(pool, recreate);
|
|
createTb_Lithium_DataTable(pool, recreate);
|
|
//ÄϾ©ËͼìÌØÓÐ
|
createTb_Batt_RTAlarm_Table(pool, recreate);
|
//ÄϾ©ËͼìÌØÓÐ
|
createTb_Batt_RSAlarm_Table(pool, recreate);
|
|
//´´½¨¸É½Úµã״̬±í
|
createFBS9100s_stemnode_state_Table(pool, recreate);
|
|
//´´½¨Ä¸Áª¿ª¹Ø״̬±í
|
createFBS9100s_buscouple_state_Table(pool, recreate);
|
|
//´´½¨FGCD³ä·ÅµçÒ»Ìå»úÏÂÔØ¿ØÖƱí
|
createFgcd_filedownload_Table(pool, recreate);
|
|
//´´½¨Ë«ÏòDCDC¹¤×÷²ÎÊý±í
|
createTb_li9130_dcdc_param(pool, recreate);
|
//´´½¨Ë«ÏòDCDCÄÚ²¿Êý¾Ý±í
|
createTb_li9130_dcdc_data(pool, recreate);
|
//´´½¨ï®µç³ØBMSÄ£ÄâÁ¿±í
|
createTb_li9130_bms_state(pool, recreate);
|
//´´½¨ï®µç³ØBMS¸æ¾¯Á¿±í
|
createTb_li9130_bms_alm(pool, recreate);
|
|
|
createTb_li9130_setparam_plan(pool, recreate);
|
|
/**
|
* db_ram_db.tb_ess3100_sysstate
|
*/
|
createTb_ess3100_sysstate(pool, recreate);
|
|
/**
|
* db_ram_db.tb_ess3100_pcs_state
|
*/
|
createTb_ess3100_pcs_state(pool, recreate);
|
|
//´´½¨É½Î÷´¢ÄÜÉ豸ʵʱÐÅÏ¢±í
|
createTB_Batt_Gtstate_Table(pool,recreate);
|
}
|
|
/**
|
* ´´½¨É½Î÷´¢ÄÜÉ豸ʵʱ״̬±í
|
* @param pool
|
* @param recreate
|
*/
|
private static void createTB_Batt_Gtstate_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.TB_Batt_Gtstate_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.TB_Batt_Gtstate_Table + " (" +
|
" `num` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `BattGroupId` int(11) NOT NULL DEFAULT '0' COMMENT 'µç³Ø×éID'," +
|
" `record_timed` datetime NOT NULL DEFAULT '2000-01-01 00:00:00' COMMENT '¼Ç¼ʱ¼ä'," +
|
" `battState` int(11) NOT NULL DEFAULT '0' COMMENT 'µç³Ø״̬[1³äµç£»2·Åµç£»3¿ªÂ·£»4¹ÊÕÏ]'," +
|
" `sumVol` float NOT NULL DEFAULT '0' COMMENT '×ܵçѹ'," +
|
" `battCurr` float NOT NULL DEFAULT '0' COMMENT 'µç³Ø×éµçÁ÷'," +
|
" `battSoc` int(11) NOT NULL DEFAULT '0' COMMENT 'µç³Ø×éSoc'," +
|
" `battSoh` int(11) NOT NULL DEFAULT '0' COMMENT 'µç³Ø×éSoh'," +
|
" `maxCharCurr` float NOT NULL DEFAULT '0' COMMENT '×î´ó³äµçµçÁ÷'," +
|
" `maxDiscCurr` float NOT NULL DEFAULT '0' COMMENT '×î´ó·ÅµçµçÁ÷'," +
|
" `diState` int(11) NOT NULL DEFAULT '0' COMMENT 'DI״̬'," +
|
" `doState` int(11) NOT NULL DEFAULT '0' COMMENT 'DO״̬'," +
|
" `battAlm0` int(11) NOT NULL DEFAULT '0' COMMENT 'µç³Ø×é¸æ¾¯'," +
|
" `battAlm1` int(11) NOT NULL DEFAULT '0' COMMENT 'µç³Ø×é¸æ¾¯1'," +
|
" `battfault0` int(11) NOT NULL DEFAULT '0' COMMENT 'µç³Ø×é¹ÊÕÏ0'," +
|
" `battfault1` int(11) NOT NULL DEFAULT '0' COMMENT 'µç³Ø×é¹ÊÕÏ1'," +
|
" PRIMARY KEY (`num`)," +
|
" UNIQUE KEY `index_battgroupid` (`BattGroupId`) USING BTREE" +
|
") ENGINE=InnoDB AUTO_INCREMENT=2 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);
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
sql.close_con();
|
}
|
}
|
|
private static void createTb_ess3100_pcs_state(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Tb_ess3100_pcs_state;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Tb_ess3100_pcs_state + " (" +
|
"`num` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `dev_id` int(11) NOT NULL," +
|
" `record_time` datetime NOT NULL DEFAULT '2000-01-01 00:00:00' COMMENT '¼Ç¼ʱ¼ä'," +
|
" `acUa` float NOT NULL DEFAULT '0' COMMENT '½»Á÷AÏàµçѹ'," +
|
" `acUb` float NOT NULL DEFAULT '0' COMMENT '½»Á÷BÏàµçѹ'," +
|
" `acUc` float NOT NULL DEFAULT '0' COMMENT '½»Á÷CÏàµçѹ'," +
|
" `acIa` float NOT NULL DEFAULT '0' COMMENT '½»Á÷AÏàµçÁ÷'," +
|
" `acIb` float NOT NULL DEFAULT '0' COMMENT '½»Á÷BÏàµçÁ÷'," +
|
" `acIc` float NOT NULL DEFAULT '0' COMMENT '½»Á÷CÏàµçÁ÷'," +
|
" `acActPower` float NOT NULL DEFAULT '0' COMMENT '½»Á÷Óй¦¹¦ÂÊ'," +
|
" `acReaPower` float NOT NULL DEFAULT '0' COMMENT '½»Á÷ÎÞ¹¦¹¦ÂÊ'," +
|
" `acAppPower` float NOT NULL DEFAULT '0' COMMENT '½»Á÷ÊÓÔÚ¹¦ÂÊ'," +
|
" `acFreq` float NOT NULL DEFAULT '0' COMMENT '½»Á÷ƵÂÊ'," +
|
" `powerFact` float NOT NULL DEFAULT '0' COMMENT '¹¦ÂÊÒòÊý'," +
|
" `macInsTmp` float NOT NULL DEFAULT '0' COMMENT '»úÄÚζÈ'," +
|
" `maxFlowCharPower` float NOT NULL DEFAULT '0' COMMENT 'ϵͳ×î´óÔÊÐí³äµç¹¦ÂÊ'," +
|
" `maxFlowDiscPower` float NOT NULL DEFAULT '0' COMMENT 'ϵͳ×î´óÔÊÐí·Åµç¹¦ÂÊ'," +
|
" `dcVol1` float NOT NULL DEFAULT '0' COMMENT 'Ö±Á÷µçѹ1'," +
|
" `dcCurr1` float NOT NULL DEFAULT '0' COMMENT 'Ö±Á÷µçÁ÷1'," +
|
" `dcPower1` float NOT NULL DEFAULT '0' COMMENT 'Ö±Á÷¹¦ÂÊ1'," +
|
" `dcVol2` float NOT NULL DEFAULT '0' COMMENT 'Ö±Á÷µçѹ2'," +
|
" `dcCurr2` float NOT NULL DEFAULT '0' COMMENT 'Ö±Á÷µçÁ÷2'," +
|
" `dcPower2` float NOT NULL DEFAULT '0' COMMENT 'Ö±Á÷¹¦ÂÊ2'," +
|
" `dcVol3` float NOT NULL DEFAULT '0' COMMENT 'Ö±Á÷µçѹ3'," +
|
" `dcCurr3` float NOT NULL DEFAULT '0' COMMENT 'Ö±Á÷µçÁ÷3'," +
|
" `dcPower3` float NOT NULL DEFAULT '0' COMMENT 'Ö±Á÷¹¦ÂÊ3'," +
|
" `dcVol4` float NOT NULL DEFAULT '0' COMMENT 'Ö±Á÷µçѹ4'," +
|
" `dcCurr4` float NOT NULL DEFAULT '0' COMMENT 'Ö±Á÷µçÁ÷4'," +
|
" `dcPower4` float NOT NULL DEFAULT '0' COMMENT 'Ö±Á÷¹¦ÂÊ4'," +
|
" `dcAC1DevRun` int(11) NOT NULL DEFAULT '0' COMMENT 'DCAC1É豸ÔËÐÐ״̬×Ö'," +
|
" `dcAC1CompFault` int(11) NOT NULL DEFAULT '0' COMMENT 'DCAC1ϵͳ×ۺϹÊÕÏ×Ö'," +
|
" `dcAC1EnvirFault` int(11) NOT NULL DEFAULT '0' COMMENT 'DCAC1ϵͳ»·¾³¹ÊÕÏ×Ö'," +
|
" `dcAC1HardFault` int(11) NOT NULL DEFAULT '0' COMMENT 'DCAC1ϵͳӲ¼þ¹ÊÕÏ×Ö'," +
|
" `dcAC1TmpFault` int(11) NOT NULL DEFAULT '0' COMMENT 'DCAC1ϵͳζȹÊÕÏ×Ö'," +
|
" `dcAC2DevRun` int(11) NOT NULL DEFAULT '0' COMMENT 'DCAC2É豸ÔËÐÐ״̬×Ö'," +
|
" `dcAC2CompFault` int(11) NOT NULL DEFAULT '0' COMMENT 'DCAC2ϵͳ×ۺϹÊÕÏ×Ö'," +
|
" `dcAC2EnvirFault` int(11) NOT NULL DEFAULT '0' COMMENT 'DCAC2ϵͳ»·¾³¹ÊÕÏ×Ö'," +
|
" `dcAC2HardFault` int(11) NOT NULL DEFAULT '0' COMMENT 'DCAC2ϵͳӲ¼þ¹ÊÕÏ×Ö'," +
|
" `dcAC2TmpFault` int(11) NOT NULL DEFAULT '0' COMMENT 'DCAC2ϵͳζȹÊÕÏ×Ö'," +
|
" `dcAC3DevRun` int(11) NOT NULL DEFAULT '0' COMMENT 'DCAC3É豸ÔËÐÐ״̬×Ö'," +
|
" `dcAC3CompFault` int(11) NOT NULL DEFAULT '0' COMMENT 'DCAC3ϵͳ×ۺϹÊÕÏ×Ö'," +
|
" `dcAC3EnvirFault` int(11) NOT NULL DEFAULT '0' COMMENT 'DCAC3ϵͳ»·¾³¹ÊÕÏ×Ö'," +
|
" `dcAC3HardFault` int(11) NOT NULL DEFAULT '0' COMMENT 'DCAC3ϵͳӲ¼þ¹ÊÕÏ×Ö'," +
|
" `dcAC3TmpFault` int(11) NOT NULL DEFAULT '0' COMMENT 'DCAC3ϵͳζȹÊÕÏ×Ö'," +
|
" `dcAC4DevRun` int(11) NOT NULL DEFAULT '0' COMMENT 'DCAC4É豸ÔËÐÐ״̬×Ö'," +
|
" `dcAC4CompFault` int(11) NOT NULL DEFAULT '0' COMMENT 'DCAC4ϵͳ×ۺϹÊÕÏ×Ö'," +
|
" `dcAC4EnvirFault` int(11) NOT NULL DEFAULT '0' COMMENT 'DCAC4ϵͳ»·¾³¹ÊÕÏ×Ö'," +
|
" `dcAC4HardFault` int(11) NOT NULL DEFAULT '0' COMMENT 'DCAC4ϵͳӲ¼þ¹ÊÕÏ×Ö'," +
|
" `dcAC4TmpFault` int(11) NOT NULL DEFAULT '0' COMMENT 'DCAC4ϵͳζȹÊÕÏ×Ö'," +
|
" PRIMARY KEY (`num`)," +
|
" UNIQUE KEY `index_dev_id` (`dev_id`) USING BTREE" +
|
") ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;";
|
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 COUNT(*) num FROM db_ram_db.tb_ess3100_pcs_state;");
|
if(false != res.next()) {
|
int num = res.getInt("num");
|
if(num==0){
|
//³õʼ»¯Êý¾Ý
|
sql.sqlMysqlExecute("INSERT INTO db_ram_db.`tb_ess3100_pcs_state` VALUES "
|
+ "('1', '310000001', '2021-11-27 11:40:58', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3276.8', '3276.8', '3276.8', '3276.8', '3276.8', '3276.8', '3276.8', '3276.8', '3276.8', '3276.8', '3276.8', '3276.8', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');");
|
}else{
|
// System.out.println("db_ram_db.tb_ess3100_pcs_state ÓÐ Num ÌõÊý¾Ý "+num);
|
}
|
}
|
|
|
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
sql.close_con();
|
}
|
}
|
|
private static void createTb_ess3100_sysstate(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Tb_ess3100_sysstate;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Tb_ess3100_sysstate + " (" +
|
"`num` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `dev_id` int(11) NOT NULL DEFAULT '1' COMMENT 'É豸id'," +
|
" `sysState` int(11) NOT NULL DEFAULT '1' COMMENT 'ϵͳ¹¤×÷״̬1:Í£»ú£»2×Լ죻3ÔËÐУ»4£ºÔ¤Áô£»5£º¹ÊÕÏ'," +
|
" `record_time` datetime NOT NULL DEFAULT '2000-01-01 00:00:00' COMMENT '¼Ç¼ʱ¼ä'," +
|
" `workModel` int(11) NOT NULL DEFAULT '1' COMMENT 'ϵͳ¹¤×÷ģʽ1£ºÀëÍøģʽ£»2£ºP/Qģʽ£»3£º×Ô¶¯ÔËÐÐģʽ'," +
|
" `activePowerLimitDis` int(11) NOT NULL DEFAULT '0' COMMENT '·ÅµçÓй¦¹¦ÂÊÏÞÖµ'," +
|
" `activePowerLimitChar` int(11) NOT NULL DEFAULT '0' COMMENT '³äµçÓй¦¹¦ÂÊÏÞÖµ'," +
|
" `acUa` float NOT NULL DEFAULT '0' COMMENT '½»Á÷AÏàµçѹ'," +
|
" `acUb` float NOT NULL DEFAULT '0' COMMENT '½»Á÷BÏàµçѹ'," +
|
" `acUc` float NOT NULL DEFAULT '0' COMMENT '½»Á÷CÏàµçѹ'," +
|
" `acIa` float NOT NULL DEFAULT '0' COMMENT '½»Á÷AÏàµçÁ÷'," +
|
" `acIb` float NOT NULL DEFAULT '0' COMMENT '½»Á÷BÏàµçÁ÷'," +
|
" `acIc` float NOT NULL DEFAULT '0' COMMENT '½»Á÷CÏàµçÁ÷'," +
|
" `sysActivePowerSum` float NOT NULL DEFAULT '0' COMMENT 'ϵͳµ±Ç°Óй¦¹¦ÂʺÍ'," +
|
" `sysReactivePowerSum` float NOT NULL DEFAULT '0' COMMENT 'ϵͳµ±Ç°ÎÞ¹¦ÂʺÍ'," +
|
" `sysSoc` int(11) NOT NULL DEFAULT '0' COMMENT 'ϵͳSOC'," +
|
" `runPCSMode` float NOT NULL DEFAULT '0' COMMENT 'ÔËÐÐPCSÄ£¿éÊý'," +
|
" `parkPower` float NOT NULL DEFAULT '0' COMMENT 'Ô°Çø¹¦ÂÊ'," +
|
" `pcsState1` int(11) NOT NULL DEFAULT '0' COMMENT 'PCSÄ£¿é1״̬'," +
|
" `pcsState2` int(11) NOT NULL DEFAULT '0' COMMENT 'PCSÄ£¿é2״̬'," +
|
" `pcsState3` int(11) NOT NULL DEFAULT '0' COMMENT 'PCSÄ£¿é3״̬'," +
|
" `pcsState4` int(11) NOT NULL DEFAULT '0' COMMENT 'PCSÄ£¿é4״̬'," +
|
" `sysAlm0` int(11) NOT NULL DEFAULT '0' COMMENT 'ϵͳ¸æ¾¯ÐÅÏ¢0'," +
|
" `sysAlm1` int(11) NOT NULL DEFAULT '0' COMMENT 'ϵͳ¸æ¾¯ÐÅÏ¢1'," +
|
" `sysAlm2` int(11) NOT NULL DEFAULT '0' COMMENT 'ϵͳ¸æ¾¯ÐÅÏ¢2'," +
|
" `sysAlm3` int(11) NOT NULL DEFAULT '0' COMMENT 'ϵͳ¸æ¾¯ÐÅÏ¢3'," +
|
" `sysFault0` int(11) NOT NULL DEFAULT '0' COMMENT 'ϵͳ¹ÊÕÏÐÅÏ¢0'," +
|
" `sysFault1` int(11) NOT NULL DEFAULT '0' COMMENT 'ϵͳ¹ÊÕÏÐÅÏ¢1'," +
|
" `pcsWareTmp` float NOT NULL DEFAULT '0' COMMENT 'PCS²Ö»·¾³Î¶È'," +
|
" `battWareTmp` float NOT NULL DEFAULT '0' COMMENT 'µç³Ø²Ö»·¾³Î¶È'," +
|
" `containWareTmp` float NOT NULL DEFAULT '0' COMMENT '¼¯×°ÏäÍâ»·¾³Î¶È'," +
|
" `battWateHum` int(11) NOT NULL DEFAULT '0' COMMENT 'µç³Ø²Ö»·¾³Êª¶È'," +
|
" `pcsWateHum` int(11) NOT NULL DEFAULT '0' COMMENT 'PCS²Ö»·¾³Êª¶È'," +
|
" `containWateHum` int(11) NOT NULL DEFAULT '0' COMMENT '¼¯×°Ïä»·¾³Êª¶È'," +
|
" `airCondState1` int(11) NOT NULL DEFAULT '0' COMMENT '¿Õµ÷״̬1'," +
|
" `airCondState2` int(11) NOT NULL DEFAULT '0' COMMENT '¿Õµ÷״̬2'," +
|
" `sys_year` int(11) NOT NULL DEFAULT '0' COMMENT 'ϵͳʱ¼ä-Äê'," +
|
" `sys_month` int(11) NOT NULL DEFAULT '0' COMMENT 'ϵͳʱ¼ä-ÔÂ'," +
|
" `sys_day` int(11) NOT NULL DEFAULT '0' COMMENT 'ϵͳʱ¼ä-ÈÕ'," +
|
" `sys_hour` int(11) NOT NULL DEFAULT '0' COMMENT 'ϵͳʱ¼äʱ'," +
|
" `sys_minte` int(11) NOT NULL DEFAULT '0' COMMENT 'ϵͳʱ¼ä-·Ö'," +
|
" `sys_second` int(11) NOT NULL DEFAULT '0' COMMENT 'ϵͳʱ¼ä-Ãë'," +
|
" `auxPowerEle_ref` int(11) NOT NULL DEFAULT '0' COMMENT '¸¨Öú¹©µç-ÊäÈëÓ馵çÄܲο¼Öµ'," +
|
" `auxPowerEle_real` int(11) NOT NULL DEFAULT '0' COMMENT '¸¨Öú¹©µç-ÊäÈëÓ馵çÄÜʵ¼ÊÖµ'," +
|
" `pcsUIChanges` int(11) NOT NULL DEFAULT '0' COMMENT 'PCS UI±ä±È'," +
|
" `pcsPQChanges` int(11) NOT NULL DEFAULT '0' COMMENT 'PCS PQ±ä±È'," +
|
" `pcsUa` float NOT NULL DEFAULT '0' COMMENT 'PCSÏàµçѹUa'," +
|
" `pcsUb` float NOT NULL DEFAULT '0' COMMENT 'PCSÏàµçѹUb'," +
|
" `pcsUc` float NOT NULL DEFAULT '0' COMMENT 'PCSÏàµçѹUc'," +
|
" `pcsUab` float NOT NULL DEFAULT '0' COMMENT 'PCSÏßµçѹUab'," +
|
" `pcsUbc` float NOT NULL DEFAULT '0' COMMENT 'PCSÏßµçѹUbc'," +
|
" `pcsUca` float NOT NULL DEFAULT '0' COMMENT 'PCSÏßµçѹUca'," +
|
" `pcsIa` float NOT NULL DEFAULT '0' COMMENT 'PCSµçÁ÷Ia'," +
|
" `pcsIb` float NOT NULL DEFAULT '0' COMMENT 'PCSµçÁ÷Ib'," +
|
" `pcsIc` float NOT NULL DEFAULT '0' COMMENT 'PCSµçÁ÷Ic'," +
|
" `pcsAActPower` float NOT NULL DEFAULT '0' COMMENT 'PCS AÏàÓй¦¹¦ÂÊ'," +
|
" `pcsBActPower` float NOT NULL DEFAULT '0' COMMENT 'PCS BÏàÓй¦¹¦ÂÊ'," +
|
" `pcsCActPower` float NOT NULL DEFAULT '0' COMMENT 'PCS CÏàÓй¦¹¦ÂÊ'," +
|
" `pcsSumActPower` float NOT NULL DEFAULT '0' COMMENT 'PCS ×ÜÓй¦¹¦ÂÊ'," +
|
" `pcsAReaPower` float NOT NULL DEFAULT '0' COMMENT 'PCS AÏàÎÞ¹¦¹¦ÂÊ'," +
|
" `pcsBReaPower` float NOT NULL DEFAULT '0' COMMENT 'PCS BÏàÎÞ¹¦¹¦ÂÊ'," +
|
" `pcsCReaPower` float NOT NULL DEFAULT '0' COMMENT 'PCS CÏàÎÞ¹¦¹¦ÂÊ'," +
|
" `pcsSumReaPower` float NOT NULL DEFAULT '0' COMMENT 'PCS ×ÜÎÞ¹¦¹¦ÂÊ'," +
|
" `pcsApowerFact` float NOT NULL DEFAULT '0' COMMENT 'PCS AÏ๦ÂÊÒòÊý'," +
|
" `pcsBpowerFact` float NOT NULL DEFAULT '0' COMMENT 'PCS BÏ๦ÂÊÒòÊý'," +
|
" `pcsCpowerFact` float NOT NULL DEFAULT '0' COMMENT 'PCS CÏ๦ÂÊÒòÊý'," +
|
" `pcsSumpowerFact` float NOT NULL DEFAULT '0' COMMENT '×ܹ¦ÂÊÒòÊý'," +
|
" `pcsAAppPower` float NOT NULL DEFAULT '0' COMMENT 'PCS AÏàÊÓÔÚ¹¦ÂÊ'," +
|
" `pcsBAppPower` float NOT NULL DEFAULT '0' COMMENT 'PCS BÏàÊÓÔÚ¹¦ÂÊ'," +
|
" `pcsCAppPower` float NOT NULL DEFAULT '0' COMMENT 'PCS CÏàÊÓÔÚ¹¦ÂÊ'," +
|
" `pcsSumAppPower` float NOT NULL DEFAULT '0' COMMENT 'PCS ×ÜÊÓÔÚ¹¦ÂÊ'," +
|
" `pcsFreq` float NOT NULL DEFAULT '0' COMMENT 'PCS ƵÂÊ'," +
|
" `pcsInActPower_ref` int(11) NOT NULL DEFAULT '0' COMMENT 'PCS ÊäÈëÓ馵çÄÜ'," +
|
" `pcsOutActPower_ref` int(11) NOT NULL DEFAULT '0' COMMENT 'PCSÊä³öÓ馵çÄÜ'," +
|
" `pcsPerReaPower_ref` int(11) NOT NULL DEFAULT '0' COMMENT 'PCS ¸ÐÐÔÎÞ¹¦µçÄÜ'," +
|
" `pcsCapReaPower_ref` int(11) NOT NULL DEFAULT '0' COMMENT 'PCS ÈÝÐÔÎÞ¹¦¹¦ÂÊ'," +
|
" `pcsInActPower_real` int(11) NOT NULL DEFAULT '0' COMMENT 'PCS ÊäÈëÓ馵çÄÜʵ¼ÊÖµ'," +
|
" `pcsOutActPower_real` int(11) NOT NULL DEFAULT '0' COMMENT 'PCS Êä³öÓ馵çÄÜʵ¼ÊÖµ'," +
|
" `pcsPerReaPower_real` int(11) NOT NULL DEFAULT '0' COMMENT 'PCS ¸ÐÐÔÎÞ¹¦µçÄÜʵ¼ÊÖµ'," +
|
" `pcsCapReaPower_real` int(11) NOT NULL DEFAULT '0' COMMENT 'PCS ÈÝÐÔÎÞ¹¦¹¦ÂÊʵ¼ÊÖµ'," +
|
" PRIMARY KEY (`num`)," +
|
" UNIQUE KEY `index_dev_id` (`dev_id`) USING BTREE" +
|
") ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;";
|
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 COUNT(*) num FROM db_ram_db.tb_ess3100_sysstate;");
|
if(false != res.next()) {
|
int num = res.getInt("num");
|
if(num==0){
|
//³õʼ»¯Êý¾Ý
|
sql.sqlMysqlExecute("INSERT INTO db_ram_db.`tb_ess3100_sysstate` VALUES "
|
+ "('1', '310000001', '1', '2021-11-27 11:40:59', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '77', '0', '0', '0', '0', '0', '0', '0', '0', '32', '0', '0', '0', '7.3', '11.6', '7.6', '0', '0', '0', '0', '1', '2021', '11', '27', '11', '42', '50', '18709', '0', '771', '1536', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '100', '100', '100', '0', '0', '0', '0', '0', '35184', '32512', '52192', '5120', '23945', '38336', '1244', '9219');");
|
}else{
|
// System.out.println("db_ram_db.tb_ess3100_sysstate ÓÐ Num ÌõÊý¾Ý "+num);
|
}
|
}
|
|
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
sql.close_con();
|
}
|
}
|
|
/**
|
*
|
* @Title: createTb_li9130_setparam_plan
|
* @Description:
|
* @param pool
|
* @param recreate
|
* @author author
|
* @date 2021Äê9ÔÂ24ÈÕ
|
*/
|
private static void createTb_li9130_setparam_plan(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Tb_li9130_setparam_plan;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Tb_li9130_setparam_plan + " (" +
|
"`num` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `dev_id` int(11) NOT NULL DEFAULT '0' COMMENT 'É豸id'," +
|
" `BattGroupId` int(11) NOT NULL DEFAULT '0' COMMENT 'µç³Ø×éID'," +
|
" `test_type` int(11) NOT NULL DEFAULT '0' COMMENT '²âÊÔÀàÐÍ'," +
|
" `test_starttime` time NOT NULL DEFAULT '00:00:00' COMMENT '¿ªÊ¼Ê±¼ä'," +
|
" `test_stoptime` time NOT NULL DEFAULT '00:00:00' COMMENT 'ֹͣʱ¼ä'," +
|
" `is_startup` int(11) NOT NULL DEFAULT '0' COMMENT 'ÊÇ·ñÆôÓÃ'," +
|
" `HourRate` int(11) NOT NULL DEFAULT '0' COMMENT 'СʱÂÊ'," +
|
" `DisCurr` float NOT NULL DEFAULT '0' COMMENT '·ÅµçµçÁ÷'," +
|
" `DisCap` float NOT NULL DEFAULT '0' COMMENT '·ÅµçÈÝÁ¿'," +
|
" `DisTime` int(11) NOT NULL DEFAULT '0' COMMENT '·Åµçʱ³¤'," +
|
" `GroupVol_LOW` float NOT NULL DEFAULT '0' COMMENT '×é¶ËµçѹÏÂÏÞ'," +
|
" `MonomerVol_LOW` float NOT NULL DEFAULT '0' COMMENT 'µ¥ÌåµçѹÏÂÏÞ'," +
|
" `MonomerLowCount` int(11) NOT NULL DEFAULT '0' COMMENT 'µ¥ÌåÏÂÏÞÊýÁ¿'," +
|
" `BattGroupNum` int(11) NOT NULL DEFAULT '0' COMMENT 'µç³Ø×é±àºÅ'," +
|
" `OnlineVolLowAction` int(11) NOT NULL DEFAULT '0' COMMENT 'ÔÚÏßµçѹµÍ´¦Àí'," +
|
" `DCVolHighLimit` float NOT NULL DEFAULT '0' COMMENT 'ÉýѹÉÏÏÞ'," +
|
" `ChargeCurrSet` float NOT NULL DEFAULT '0' COMMENT '³äµçµçÁ÷'," +
|
" `MonomerTmp_High` float NOT NULL DEFAULT '0' COMMENT 'ζÈÉÏÏÞ'," +
|
" PRIMARY KEY (`num`)" +
|
") ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4;";
|
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();
|
}
|
}
|
|
|
/**
|
*
|
* @Title: createTb_li9130_bms_alm
|
* @Description: ´´½¨ï®µç³ØBMS¸æ¾¯Á¿±í
|
* @param pool
|
* @param recreate
|
* @author author
|
* @date 2021Äê9ÔÂ14ÈÕ
|
*/
|
private static void createTb_li9130_bms_alm(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Tb_li9130_bms_alm;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Tb_li9130_bms_alm + " (" +
|
"`num` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `dev_id` int(11) NOT NULL DEFAULT '0' COMMENT 'É豸ID'," +
|
" `bms_idx` int(11) NOT NULL DEFAULT '0' COMMENT 'ÐÅÏ¢Ë÷Òý'," +
|
" `op_cmd` int(11) NOT NULL DEFAULT '0' COMMENT 'ÃüÁî¿ØÖÆ'," +
|
" `data_flag` int(11) NOT NULL DEFAULT '0'," +
|
" `pack_pos` int(11) NOT NULL DEFAULT '0' COMMENT 'ÉÏλ»úÐèÒª»ñÈ¡µÄpack×éλÖÃ'," +
|
" `monomer_cnt` int(11) NOT NULL DEFAULT '0' COMMENT 'µ¥Ìåµç³ØÊýÁ¿'," +
|
" `mon_vol_alm1` int(11) NOT NULL DEFAULT '0' COMMENT 'µ¥Ìå1µçѹ¸æ¾¯'," +
|
" `mon_vol_alm2` int(11) NOT NULL DEFAULT '0' COMMENT 'µ¥Ìå2µçѹ¸æ¾¯'," +
|
" `mon_vol_alm3` int(11) NOT NULL DEFAULT '0' COMMENT 'µ¥Ìå3µçѹ¸æ¾¯'," +
|
" `mon_vol_alm4` int(11) NOT NULL DEFAULT '0' COMMENT 'µ¥Ìå4µçѹ¸æ¾¯'," +
|
" `mon_vol_alm5` int(11) NOT NULL DEFAULT '0' COMMENT 'µ¥Ìå5µçѹ¸æ¾¯'," +
|
" `mon_vol_alm6` int(11) NOT NULL DEFAULT '0' COMMENT 'µ¥Ìå6µçѹ¸æ¾¯'," +
|
" `mon_vol_alm7` int(11) NOT NULL DEFAULT '0' COMMENT 'µ¥Ìå7µçѹ¸æ¾¯'," +
|
" `mon_vol_alm8` int(11) NOT NULL DEFAULT '0' COMMENT 'µ¥Ìå8µçѹ¸æ¾¯'," +
|
" `mon_vol_alm9` int(11) NOT NULL DEFAULT '0' COMMENT 'µ¥Ìå9µçѹ¸æ¾¯'," +
|
" `mon_vol_alm10` int(11) NOT NULL DEFAULT '0' COMMENT 'µ¥Ìå10µçѹ¸æ¾¯'," +
|
" `mon_vol_alm11` int(11) NOT NULL DEFAULT '0' COMMENT 'µ¥Ìå11µçѹ¸æ¾¯'," +
|
" `mon_vol_alm12` int(11) NOT NULL DEFAULT '0' COMMENT 'µ¥Ìå12µçѹ¸æ¾¯'," +
|
" `mon_vol_alm13` int(11) NOT NULL DEFAULT '0' COMMENT 'µ¥Ìå13µçѹ¸æ¾¯'," +
|
" `mon_vol_alm14` int(11) NOT NULL DEFAULT '0' COMMENT 'µ¥Ìå14µçѹ¸æ¾¯'," +
|
" `mon_vol_alm15` int(11) NOT NULL DEFAULT '0' COMMENT 'µ¥Ìå15µçѹ¸æ¾¯'," +
|
" `mon_vol_alm16` int(11) NOT NULL DEFAULT '0' COMMENT 'µ¥Ìå16µçѹ¸æ¾¯'," +
|
" `temp_cnt` int(11) NOT NULL DEFAULT '0' COMMENT 'µçоζÈÊýÁ¿'," +
|
" `mon_tmp_alm1` int(11) NOT NULL DEFAULT '0' COMMENT 'µ¥Ìå1µçоζȸ澯'," +
|
" `mon_tmp_alm2` int(11) NOT NULL DEFAULT '0' COMMENT 'µ¥Ìå2µçоζȸ澯'," +
|
" `mon_tmp_alm3` int(11) NOT NULL DEFAULT '0' COMMENT 'µ¥Ìå3µçоζȸ澯'," +
|
" `mon_tmp_alm4` int(11) NOT NULL DEFAULT '0' COMMENT 'µ¥Ìå4µçоζȸ澯'," +
|
" `env_temp_alm` int(11) NOT NULL DEFAULT '0' COMMENT '»·¾³Î¶È'," +
|
" `mos_temp_alm` int(11) NOT NULL DEFAULT '0' COMMENT 'MOS¹ÜζÈ'," +
|
" `current_alm` int(11) NOT NULL DEFAULT '0' COMMENT 'µçÁ÷'," +
|
" `sum_vol_alm` int(11) NOT NULL DEFAULT '0' COMMENT '×Üѹ'," +
|
" `user_def_cnt` int(11) NOT NULL DEFAULT '0' COMMENT '×Ô¶¨Òå¸æ¾¯ÊýÁ¿'," +
|
" `junheng_event_code` int(11) NOT NULL DEFAULT '0' COMMENT '¾ùºâʼþ´úÂë'," +
|
" `vol_event_code` int(11) NOT NULL DEFAULT '0' COMMENT 'µçѹʼþ´úÂë'," +
|
" `temp_event_code` int(11) NOT NULL DEFAULT '0' COMMENT 'ζÈʼþ´úÂë'," +
|
" `curr_event_code` int(11) NOT NULL DEFAULT '0' COMMENT 'µçÁ÷ʼþ´úÂë'," +
|
" `rest_cap_alm` int(11) NOT NULL DEFAULT '0' COMMENT 'Ê£ÓàÈÝÁ¿¸æ¾¯'," +
|
" `fet_state_code` int(11) NOT NULL DEFAULT '0' COMMENT 'FET״̬´úÂë'," +
|
" `junheng_state_code` int(11) NOT NULL DEFAULT '0' COMMENT '¾ùºâ״̬´úÂë'," +
|
" `sys_state_code` int(11) NOT NULL DEFAULT '0' COMMENT 'ϵͳ״̬´úÂë'," +
|
" `group_num` int(11) NOT NULL DEFAULT '0' COMMENT '×éºÅ:0-×é1£»1-×é2'," +
|
" `sys_tmp_code` int(11) NOT NULL DEFAULT '0' COMMENT 'ϵͳζÈʼþ´úÂë'," +
|
" PRIMARY KEY (`num`)," +
|
" KEY `idx_dev_id` (`dev_id`) USING BTREE" +
|
") ENGINE=InnoDB AUTO_INCREMENT=11 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);
|
|
//Ìí¼Ó×éºÅ:0-×é1£»1-×é2
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_li9130_bms_alm'"
|
+ " AND column_name='group_num'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Tb_li9130_bms_alm
|
+ " ADD COLUMN `group_num` int(11) NOT NULL DEFAULT '0' COMMENT '×éºÅ:0-×é1£»1-×é2';");
|
}
|
|
//Ìí¼ÓϵͳζÈʼþ´úÂë
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_li9130_bms_alm'"
|
+ " AND column_name='sys_tmp_code'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Tb_li9130_bms_alm
|
+ " ADD COLUMN `sys_tmp_code` int(11) NOT NULL DEFAULT '0' COMMENT 'ϵͳζÈʼþ´úÂë';");
|
}
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
sql.close_con();
|
}
|
}
|
|
|
|
/**
|
*
|
* @Title: createTb_li9130_bms_state
|
* @Description: ´´½¨ï®µç³ØBMSÄ£ÄâÁ¿±í
|
* @param pool
|
* @param recreate
|
* @author author
|
* @date 2021Äê9ÔÂ14ÈÕ
|
*/
|
private static void createTb_li9130_bms_state(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Tb_li9130_bms_state;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Tb_li9130_bms_state + " (" +
|
"`num` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'Ö÷¼ü'," +
|
" `dev_id` int(11) NOT NULL DEFAULT '0' COMMENT 'É豸ID'," +
|
" `bms_idx` int(11) NOT NULL DEFAULT '0' COMMENT 'ÐÅÏ¢Ë÷Òý'," +
|
" `op_cmd` int(11) NOT NULL DEFAULT '0' COMMENT '¿ØÖÆ'," +
|
" `data_flag` int(11) NOT NULL DEFAULT '0'," +
|
" `pack_pos` int(11) NOT NULL DEFAULT '0' COMMENT 'ÉÏλ»úÐèÒª»ñÈ¡µÄpack×éλÖÃ'," +
|
" `monomer_cnt` int(11) NOT NULL DEFAULT '0' COMMENT 'µ¥Ìåµç³ØÊýÁ¿'," +
|
" `mon_vol1` float NOT NULL DEFAULT '0' COMMENT 'µ¥Ìå1µçѹ'," +
|
" `mon_vol2` float NOT NULL DEFAULT '0' COMMENT 'µ¥Ìå2µçѹ'," +
|
" `mon_vol3` float NOT NULL DEFAULT '0' COMMENT 'µ¥Ìå3µçѹ'," +
|
" `mon_vol4` float NOT NULL DEFAULT '0' COMMENT 'µ¥Ìå4µçѹ'," +
|
" `mon_vol5` float NOT NULL DEFAULT '0' COMMENT 'µ¥Ìå5µçѹ'," +
|
" `mon_vol6` float NOT NULL DEFAULT '0' COMMENT 'µ¥Ìå6µçѹ'," +
|
" `mon_vol7` float NOT NULL DEFAULT '0' COMMENT 'µ¥Ìå7µçѹ'," +
|
" `mon_vol8` float NOT NULL DEFAULT '0' COMMENT 'µ¥Ìå8µçѹ'," +
|
" `mon_vol9` float NOT NULL DEFAULT '0' COMMENT 'µ¥Ìå9µçѹ'," +
|
" `mon_vol10` float NOT NULL DEFAULT '0' COMMENT 'µ¥Ìå10µçѹ'," +
|
" `mon_vol11` float NOT NULL DEFAULT '0' COMMENT 'µ¥Ìå11µçѹ'," +
|
" `mon_vol12` float NOT NULL DEFAULT '0' COMMENT 'µ¥Ìå12µçѹ'," +
|
" `mon_vol13` float NOT NULL DEFAULT '0' COMMENT 'µ¥Ìå13µçѹ'," +
|
" `mon_vol14` float NOT NULL DEFAULT '0' COMMENT 'µ¥Ìå14µçѹ'," +
|
" `mon_vol15` float NOT NULL DEFAULT '0' COMMENT 'µ¥Ìå15µçѹ'," +
|
" `mon_vol16` float NOT NULL DEFAULT '0' COMMENT 'µ¥Ìå16µçѹ'," +
|
" `tmp_cnt` int(11) NOT NULL DEFAULT '0' COMMENT 'µçоζÈÊýÁ¿'," +
|
" `mon_tmp1` float NOT NULL DEFAULT '0' COMMENT 'µçо1ζÈ'," +
|
" `mon_tmp2` float NOT NULL DEFAULT '0' COMMENT 'µçо2ζÈ'," +
|
" `mon_tmp3` float NOT NULL DEFAULT '0' COMMENT 'µçо3ζÈ'," +
|
" `mon_tmp4` float NOT NULL DEFAULT '0' COMMENT 'µçо4ζÈ'," +
|
" `env_temp` float(11) NOT NULL DEFAULT '0' COMMENT '»·¾³Î¶È'," +
|
" `mos_temp` float(11) NOT NULL DEFAULT '0' COMMENT 'MOS¹ÜζÈ'," +
|
" `current` float(11) NOT NULL DEFAULT '0' COMMENT 'µçÁ÷'," +
|
" `sum_vol` float(11) NOT NULL DEFAULT '0' COMMENT '×Üѹ'," +
|
" `rest_cap` int(11) NOT NULL DEFAULT '0' COMMENT 'Ê£ÓàÈÝÁ¿'," +
|
" `sum_cap` int(11) NOT NULL DEFAULT '0' COMMENT '×ÜÈÝÁ¿'," +
|
" `cycle_times` int(11) NOT NULL DEFAULT '0' COMMENT 'µç³ØÑ»·´ÎÊý'," +
|
" `user_def_cnt` int(11) NOT NULL DEFAULT '0' COMMENT '×Ô¶¨ÒåÒ£²âÊýÁ¿'," +
|
" `group_num` int(11) NOT NULL DEFAULT '0' COMMENT '×éºÅ:0-×é1£»1-×é2'," +
|
" PRIMARY KEY (`num`)," +
|
" KEY `idx_dev_id` (`dev_id`) USING BTREE" +
|
") ENGINE=InnoDB AUTO_INCREMENT=11 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);
|
|
//ÐÞ¸Ä×Ö¶Îenv_temp ÀàÐÍΪfloat
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Tb_li9130_bms_state
|
+ " CHANGE `env_temp` `env_temp` float NOT NULL DEFAULT '0' COMMENT '»·¾³Î¶È';");
|
|
//ÐÞ¸Ä×Ö¶Îmos_temp ÀàÐÍΪfloat
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Tb_li9130_bms_state
|
+ " CHANGE `mos_temp` `mos_temp` float NOT NULL DEFAULT '0' COMMENT 'MOS¹ÜζÈ';");
|
|
//ÐÞ¸Ä×Ö¶Îcurrent ÀàÐÍΪfloat
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Tb_li9130_bms_state
|
+ " CHANGE `current` `current` float NOT NULL DEFAULT '0' COMMENT 'µçÁ÷';");
|
|
//ÐÞ¸Ä×Ö¶Îsum_vol ÀàÐÍΪfloat
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Tb_li9130_bms_state
|
+ " CHANGE `sum_vol` `sum_vol` float NOT NULL DEFAULT '0' COMMENT '×Üѹ';");
|
|
|
//Ìí¼Ó×éºÅ:0-×é1£»1-×é2
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_li9130_bms_state'"
|
+ " AND column_name='group_num'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Tb_li9130_bms_state
|
+ " ADD COLUMN `group_num` int(11) NOT NULL DEFAULT '0' COMMENT '×éºÅ:0-×é1£»1-×é2';");
|
}
|
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
if(null != res) {
|
try {
|
res.close();
|
} catch (SQLException e) {
|
e.printStackTrace();
|
}
|
}
|
sql.close_con();
|
}
|
}
|
|
|
|
|
/**
|
*
|
* @Title: createTb_li9130_dcdc_data
|
* @Description: ´´½¨Ë«ÏòDCDCÄÚ²¿Êý¾Ý±í
|
* @param pool
|
* @param recreate
|
* @author author
|
* @date 2021Äê9ÔÂ14ÈÕ
|
*/
|
private static void createTb_li9130_dcdc_data(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Tb_li9130_dcdc_data;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Tb_li9130_dcdc_data + " (" +
|
" `num` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `op_cmd` int(11) NOT NULL DEFAULT '0' COMMENT 'ÃüÁî¿ØÖÆ'," +
|
" `dev_id` int(11) NOT NULL DEFAULT '0' COMMENT 'É豸id'," +
|
" `dcdc_index` int(11) NOT NULL DEFAULT '0' COMMENT 'dcdecÄ£¿éË÷Òý[ÿÖÖ﮵çBTS´ø4¸ödcdcÄ£¿éÐÅÏ¢]'," +
|
" `powerState` int(11) NOT NULL DEFAULT '0' COMMENT 'µçԴ״̬£º0-Í£Ö¹£»1-Õý³£Êä³ö£»2/3/4/5-Òì³£±£»¤'," +
|
" `imuxian` float NOT NULL DEFAULT '0' COMMENT 'µçÔ´(ĸÏß)¶ËµçÁ÷'," +
|
" `vmuxian` float NOT NULL DEFAULT '0' COMMENT 'µçÔ´(ĸÏß)¶Ëµçѹ'," +
|
" `ibatt` float NOT NULL DEFAULT '0' COMMENT 'µç³Ø¶ËµçÁ÷'," +
|
" `vbatt` float NOT NULL DEFAULT '0' COMMENT 'µçÁ÷¶Ëµçѹ'," +
|
" `currState` int(11) NOT NULL DEFAULT '0' COMMENT 'µçÁ÷״̬£º0-ĸÏ߶Եç³Ø³äµç£»1-µç³Ø¶ÔĸÏ߷ŵç'," +
|
" `version` float NOT NULL DEFAULT '0' COMMENT '°æ±¾ºÅ'," +
|
" `setChgVol` float NOT NULL DEFAULT '0' COMMENT '³äµçµçѹÉèÖÃ'," +
|
" `setChgCurr` float NOT NULL DEFAULT '0' COMMENT '³äµçµçÁ÷ÉèÖÃ'," +
|
" `setChgStopCurr` float NOT NULL DEFAULT '0' COMMENT '³äµç½ØÖ¹µçÁ÷ÉèÖÃ'," +
|
" `setReChgVol` float NOT NULL DEFAULT '0' COMMENT 'µçѹµøÂäÔٴγäµç·§ÖµÉèÖÃ'," +
|
" `setDisStartVol` float NOT NULL DEFAULT '0' COMMENT 'ĸÏ߷ŵçµçѹãÐÖµÉèÖÃ'," +
|
" `setDisVol` float NOT NULL DEFAULT '0' COMMENT '·ÅµçµçѹÉèÖÃ'," +
|
" `setDisCurr` float NOT NULL DEFAULT '0' COMMENT '·ÅµçµçÁ÷ÉèÖÃ'," +
|
" `setChgStartVol` float NOT NULL DEFAULT '0' COMMENT 'µç³Ø³äµçµçѹãÐÖµÉèÖÃ'," +
|
" `commTxCnt` int(11) NOT NULL DEFAULT '0' COMMENT '·¢ËͼÆÊý'," +
|
" `commRxCnt` int(11) NOT NULL DEFAULT '0' COMMENT '½ÓÊÕ¼ÆÊý'," +
|
" PRIMARY KEY (`num`)" +
|
") ENGINE=InnoDB AUTO_INCREMENT=24 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();
|
}
|
}
|
|
|
|
/**
|
*
|
* @Title: createTb_li9130_dcdc_param
|
* @Description: ´´½¨Ë«ÏòDCDC¹¤×÷²ÎÊý±í
|
* @param pool
|
* @param recreate
|
* @author author
|
* @date 2021Äê9ÔÂ14ÈÕ
|
*/
|
private static void createTb_li9130_dcdc_param(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Tb_li9130_dcdc_param;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Tb_li9130_dcdc_param + " (" +
|
" `num` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'Ö÷¼ü'," +
|
" `dev_id` int(11) NOT NULL DEFAULT '0' COMMENT 'É豸id'," +
|
" `op_cmd` int(11) NOT NULL DEFAULT '0' COMMENT 'ÃüÁî±êʶ'," +
|
" `dev_type` int(11) NOT NULL DEFAULT '0' COMMENT 'É豸ÀàÐÍ[0:﮵ç³Ø;1ǦËáµç³Ø]'," +
|
" `setChgVol` float NOT NULL DEFAULT '0' COMMENT '³äµçµçѹÉèÖÃ'," +
|
" `setChgCurr` int(11) NOT NULL DEFAULT '0' COMMENT '³äµçµçÁ÷ÉèÖÃ'," +
|
" `setChgStopCurr` float NOT NULL DEFAULT '0' COMMENT '³äµç½ØÖ¹µçÁ÷ÉèÖÃ'," +
|
" `setReChgVol` float NOT NULL DEFAULT '0' COMMENT 'µçѹµøÂäÔٴγäµç·§ÖµÉèÖÃ'," +
|
" `setDisStartVol` float NOT NULL DEFAULT '0' COMMENT 'ĸÏ߷ŵçµçѹ·§ÖµÉèÖÃ'," +
|
" `setDisVol` float NOT NULL DEFAULT '0' COMMENT '·ÅµçµçѹÉèÖÃ'," +
|
" `setDisCurr` int(11) NOT NULL DEFAULT '0' COMMENT '·ÅµçµçÁ÷ÉèÖÃ'," +
|
" `setChgStartVol` float NOT NULL DEFAULT '0' COMMENT 'µç³Ø³äµçµçѹ·§ÖµÉèÖÃ'," +
|
" `ifSaveToFlash` int(11) NOT NULL DEFAULT '0' COMMENT 'ÊÇ·ñдFlash[0:²»Ð´;1:д]'," +
|
" `setWorkMode` int(11) NOT NULL DEFAULT '0' COMMENT '¹¤×÷ģʽ[ÊÖ¶¯/×Ô¶¯]'," +
|
" PRIMARY KEY (`num`)," +
|
" UNIQUE KEY `idx_dev_id` (`dev_id`) USING BTREE" +
|
") ENGINE=InnoDB AUTO_INCREMENT=5 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();
|
}
|
}
|
|
|
|
|
|
/**
|
* ´´½¨ web_site Êý¾Ý¿â
|
* @param pool
|
*/
|
public static void createDb_Ram_Db(MysqlConnPool pool) {
|
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
|
try {
|
sql.sqlMysqlExecute("CREATE DATABASE IF NOT EXISTS " + Sql_Mysql.DB_RamDB);
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
sql.close_con();
|
}
|
}
|
|
/**
|
* ´´½¨³ýÁò״̬±í
|
* @param pool
|
* @param recreate
|
*/
|
public static void createFBS9100s_fod_state(MysqlConnPool pool, boolean recreate) {
|
String sql_str1 = " DROP TABLE IF EXISTS " + Sql_Mysql.FBS9100s_fod_state;
|
String sql_str2 = "CREATE TABLE IF NOT EXISTS "+ Sql_Mysql.FBS9100s_fod_state +" (" +
|
" num int(11) NOT NULL AUTO_INCREMENT," +
|
" dev_id int(11) NOT NULL DEFAULT '0' COMMENT 'É豸id'," +
|
" BattGroupId int(11) NOT NULL DEFAULT '0' COMMENT 'µç³Ø×éid'," +
|
" record_time datetime NOT NULL DEFAULT '1970-01-01 00:00:00' COMMENT '¼Ç¼ʱ¼ä'," +
|
" RestTime_one int(11) NOT NULL DEFAULT '0' COMMENT 'Ê£ÓàÌìÊý(×é1)'," +
|
" WorkState_one int(11) NOT NULL DEFAULT '0' COMMENT '¹¤×÷ģʽ(×é1)'," +
|
" VGroupVol_one double NOT NULL DEFAULT '0' COMMENT '×é¶Ëµçѹ(×é1)'," +
|
" VpeakVol_one double NOT NULL DEFAULT '0' COMMENT '·åÖµµçѹ(×é1)'," +
|
" RestTime_two int(11) NOT NULL DEFAULT '0' COMMENT 'Ê£ÓàÌìÊý(×é2)'," +
|
" WorkState_two int(11) NOT NULL DEFAULT '0' COMMENT '¹¤×÷ģʽ(×é2)'," +
|
" VGroupVol_two double NOT NULL DEFAULT '0' COMMENT '×é¶Ëµçѹ(×é2)'," +
|
" VpeakVol_two double NOT NULL DEFAULT '0' COMMENT '·åÖµµçѹ(×é2)'," +
|
" RestTime_three int(11) NOT NULL DEFAULT '0' COMMENT 'Ê£ÓàÌìÊý(×é3)'," +
|
" WorkState_three int(11) NOT NULL DEFAULT '0' COMMENT '¹¤×÷ģʽ(×é3)'," +
|
" VGroupVol_three double NOT NULL DEFAULT '0' COMMENT '×é¶Ëµçѹ(×é3)'," +
|
" VpeakVol_three double NOT NULL DEFAULT '0' COMMENT '·åÖµµçѹ(×é3)'," +
|
" RestTime_four int(11) NOT NULL DEFAULT '0' COMMENT 'Ê£ÓàÌìÊý(×é4)'," +
|
" WorkState_four int(11) NOT NULL DEFAULT '0' COMMENT '¹¤×÷ģʽ(×é4)'," +
|
" VGroupVol_four double NOT NULL DEFAULT '0' COMMENT '×é¶Ëµçѹ(×é4)'," +
|
" VpeakVol_four double NOT NULL DEFAULT '0' COMMENT '·åÖµµçѹ(×é4)'," +
|
" RestTime_five int(11) NOT NULL DEFAULT '0' COMMENT 'Ê£Óàʱ¼ä(×é5)'," +
|
" WorkState_five int(11) NOT NULL DEFAULT '0' COMMENT '³ýÁò5״̬(×é5)'," +
|
" VGroupVol_five int(11) NOT NULL DEFAULT '0' COMMENT '×é¶Ëµçѹ(×é5)'," +
|
" VpeakVol_five int(11) NOT NULL DEFAULT '0' COMMENT '·åÖµµçѹ(×é5)'," +
|
" PRIMARY KEY (num)," +
|
" UNIQUE KEY unique_battgroupid (BattGroupId) USING BTREE" +
|
") ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;";
|
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
|
ResultSet res = null;
|
try {
|
if(recreate) {
|
sql.sqlMysqlExecute(sql_str1);
|
}
|
sql.sqlMysqlExecute(sql_str2);
|
|
//Ìí¼ÓÊ£Óàʱ¼ä(×é1)
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_fbs9100s_fod_state'"
|
+ " AND column_name='RestTime_one'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100s_fod_state
|
+ " ADD COLUMN RestTime_one int(11) NOT NULL DEFAULT '0' COMMENT 'Ê£Óàʱ¼ä(×é5)'");
|
}
|
//Ìí¼Ó³ýÁò״̬(×é1)
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_fbs9100s_fod_state'"
|
+ " AND column_name='WorkState_one'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100s_fod_state
|
+ " ADD COLUMN WorkState_one int(11) NOT NULL DEFAULT '0' COMMENT '³ýÁò5״̬(×é5)'");
|
}
|
//Ìí¼Ó×é¶Ëµçѹ(×é1)
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_fbs9100s_fod_state'"
|
+ " AND column_name='VGroupVol_one'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100s_fod_state
|
+ " ADD COLUMN VGroupVol_one int(11) NOT NULL DEFAULT '0' COMMENT '×é¶Ëµçѹ(×é5)'");
|
}
|
//Ìí¼Ó·åÖµµçѹ(×é1)
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_fbs9100s_fod_state'"
|
+ " AND column_name='VpeakVol_one'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100s_fod_state
|
+ " ADD COLUMN VpeakVol_one int(11) NOT NULL DEFAULT '0' COMMENT '·åÖµµçѹ(×é5)'");
|
}
|
|
//Ìí¼ÓÊ£Óàʱ¼ä(×é2)
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_fbs9100s_fod_state'"
|
+ " AND column_name='RestTime_two'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100s_fod_state
|
+ " ADD COLUMN RestTime_two int(11) NOT NULL DEFAULT '0' COMMENT 'Ê£Óàʱ¼ä(×é5)'");
|
}
|
//Ìí¼Ó³ýÁò״̬(×é2)
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_fbs9100s_fod_state'"
|
+ " AND column_name='WorkState_two'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100s_fod_state
|
+ " ADD COLUMN WorkState_two int(11) NOT NULL DEFAULT '0' COMMENT '³ýÁò5״̬(×é5)'");
|
}
|
//Ìí¼Ó×é¶Ëµçѹ(×é2)
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_fbs9100s_fod_state'"
|
+ " AND column_name='VGroupVol_two'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100s_fod_state
|
+ " ADD COLUMN VGroupVol_two int(11) NOT NULL DEFAULT '0' COMMENT '×é¶Ëµçѹ(×é5)'");
|
}
|
//Ìí¼Ó·åÖµµçѹ(×é2)
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_fbs9100s_fod_state'"
|
+ " AND column_name='VpeakVol_two'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100s_fod_state
|
+ " ADD COLUMN VpeakVol_two int(11) NOT NULL DEFAULT '0' COMMENT '·åÖµµçѹ(×é5)'");
|
}
|
|
//Ìí¼ÓÊ£Óàʱ¼ä(×é3)
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_fbs9100s_fod_state'"
|
+ " AND column_name='RestTime_three'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100s_fod_state
|
+ " ADD COLUMN RestTime_three int(11) NOT NULL DEFAULT '0' COMMENT 'Ê£Óàʱ¼ä(×é5)'");
|
}
|
//Ìí¼Ó³ýÁò״̬(×é3)
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_fbs9100s_fod_state'"
|
+ " AND column_name='WorkState_three'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100s_fod_state
|
+ " ADD COLUMN WorkState_three int(11) NOT NULL DEFAULT '0' COMMENT '³ýÁò5״̬(×é5)'");
|
}
|
//Ìí¼Ó×é¶Ëµçѹ(×é3)
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_fbs9100s_fod_state'"
|
+ " AND column_name='VGroupVol_three'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100s_fod_state
|
+ " ADD COLUMN VGroupVol_three int(11) NOT NULL DEFAULT '0' COMMENT '×é¶Ëµçѹ(×é5)'");
|
}
|
//Ìí¼Ó·åÖµµçѹ(×é3)
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_fbs9100s_fod_state'"
|
+ " AND column_name='VpeakVol_three'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100s_fod_state
|
+ " ADD COLUMN VpeakVol_three int(11) NOT NULL DEFAULT '0' COMMENT '·åÖµµçѹ(×é5)'");
|
}
|
|
//Ìí¼ÓÊ£Óàʱ¼ä(×é4)
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_fbs9100s_fod_state'"
|
+ " AND column_name='RestTime_four'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100s_fod_state
|
+ " ADD COLUMN RestTime_four int(11) NOT NULL DEFAULT '0' COMMENT 'Ê£Óàʱ¼ä(×é5)'");
|
}
|
//Ìí¼Ó³ýÁò״̬(×é4)
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_fbs9100s_fod_state'"
|
+ " AND column_name='WorkState_four'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100s_fod_state
|
+ " ADD COLUMN WorkState_four int(11) NOT NULL DEFAULT '0' COMMENT '³ýÁò5״̬(×é5)'");
|
}
|
//Ìí¼Ó×é¶Ëµçѹ(×é4)
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_fbs9100s_fod_state'"
|
+ " AND column_name='VGroupVol_four'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100s_fod_state
|
+ " ADD COLUMN VGroupVol_four int(11) NOT NULL DEFAULT '0' COMMENT '×é¶Ëµçѹ(×é5)'");
|
}
|
//Ìí¼Ó·åÖµµçѹ(×é4)
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_fbs9100s_fod_state'"
|
+ " AND column_name='VpeakVol_four'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100s_fod_state
|
+ " ADD COLUMN VpeakVol_four int(11) NOT NULL DEFAULT '0' COMMENT '·åÖµµçѹ(×é5)'");
|
}
|
|
//Ìí¼ÓÊ£Óàʱ¼ä(×é5)
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_fbs9100s_fod_state'"
|
+ " AND column_name='RestTime_five'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100s_fod_state
|
+ " ADD COLUMN RestTime_five int(11) NOT NULL DEFAULT '0' COMMENT 'Ê£Óàʱ¼ä(×é5)'");
|
}
|
//Ìí¼Ó³ýÁò״̬(×é5)
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_fbs9100s_fod_state'"
|
+ " AND column_name='WorkState_five'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100s_fod_state
|
+ " ADD COLUMN WorkState_five int(11) NOT NULL DEFAULT '0' COMMENT '³ýÁò5״̬(×é5)'");
|
}
|
//Ìí¼Ó×é¶Ëµçѹ(×é5)
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_fbs9100s_fod_state'"
|
+ " AND column_name='VGroupVol_five'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100s_fod_state
|
+ " ADD COLUMN VGroupVol_five int(11) NOT NULL DEFAULT '0' COMMENT '×é¶Ëµçѹ(×é5)'");
|
}
|
//Ìí¼Ó·åÖµµçѹ(×é5)
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_fbs9100s_fod_state'"
|
+ " AND column_name='VpeakVol_five'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100s_fod_state
|
+ " ADD COLUMN VpeakVol_five int(11) NOT NULL DEFAULT '0' COMMENT '·åÖµµçѹ(×é5)'");
|
}
|
//Ìí¼Óµç³Ø×éid×Ö¶Î
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_fbs9100s_fod_state'"
|
+ " AND column_name='BattGroupId'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100s_fod_state
|
+ " ADD COLUMN BattGroupId int(11) NOT NULL DEFAULT '0' COMMENT 'µç³Ø×éid' AFTER dev_id");
|
}
|
//ÒƳý֮ǰµÄÒÔÉ豸id·Ö×éµÄÉ豸idΨһË÷Òý
|
res = sql.sqlMysqlQuery("show INDEX FROM "+Sql_Mysql.FBS9100s_fod_state+" WHERE KEY_name = 'unique_dev_id'");
|
if(res.next()) {
|
sql.sqlMysqlExecute("alter table "+Sql_Mysql.FBS9100s_fod_state+" drop index unique_dev_id;");
|
}
|
//Ìí¼Óµç³Ø×éidΪΨһË÷Òý
|
res = sql.sqlMysqlQuery("show INDEX FROM "+Sql_Mysql.FBS9100s_fod_state+" WHERE KEY_name = 'unique_BattGroupId'");
|
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);");
|
}
|
//ÒƳý֮ǰµÄÒÔÉ豸id·Ö×éµÄÉ豸idΨһË÷Òý
|
/*res = sql.sqlMysqlQuery("show INDEX FROM "+Sql_Mysql.FBS9100s_fod_state+" WHERE KEY_name = 'unique_BattGroupId'");
|
if(res.next()) {
|
sql.sqlMysqlExecute("alter table "+Sql_Mysql.FBS9100s_fod_state+" drop index unique_BattGroupId;");
|
}
|
//Ìí¼ÓÐÞ¸´É豸idΪΨһË÷Òý
|
res = sql.sqlMysqlQuery("show INDEX FROM "+Sql_Mysql.FBS9100s_fod_state+" WHERE KEY_name = 'unique_dev_id'");
|
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_dev_id(dev_id);");
|
}*/
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
if(null != res) {
|
try {
|
res.close();
|
} catch (SQLException e) {
|
e.printStackTrace();
|
}
|
}
|
sql.close_con();
|
}
|
}
|
|
/**
|
* ´´½¨³ýÁò״̬±í
|
* @param pool
|
* @param recreate
|
*/
|
public static void createFBS9100SetDLParam_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str1 = " DROP TABLE IF EXISTS " + Sql_Mysql.FBS9100SetDLParam_Table;
|
String sql_str2 = "CREATE TABLE IF NOT EXISTS "+ Sql_Mysql.FBS9100SetDLParam_Table +" (" +
|
" num int(11) NOT NULL AUTO_INCREMENT," +
|
" dev_id int(11) NOT NULL DEFAULT '0' COMMENT 'É豸id'," +
|
" op_cmd int(11) NOT NULL DEFAULT '0'," +
|
" test_cmd int(11) NOT NULL DEFAULT '0'," +
|
" GroupNum int(11) NOT NULL DEFAULT '0' COMMENT 'Ä£¿é±àºÅ'," +
|
" BattGroupNum int(11) NOT NULL DEFAULT '0' COMMENT 'µç³Ø×éºÅ'," +
|
" STDCap_one int(11) NOT NULL DEFAULT '0' COMMENT '×é1±ê³ÆÈÝÁ¿'," +
|
" FloatVol_one double NOT NULL DEFAULT '0' COMMENT '×é1¸¡³äµçѹ'," +
|
" Strength_one double NOT NULL DEFAULT '0' COMMENT '×é1³ýÁòÇ¿¶È'," +
|
" YHStrength_one double NOT NULL DEFAULT '0' COMMENT '×é1Ñø»¤Ç¿¶È'," +
|
" TimeLong_one int(11) NOT NULL DEFAULT '0' COMMENT '×é1³ýÁòÌìÊý'," +
|
" STDCap_two int(11) NOT NULL DEFAULT '0' COMMENT '×é2±ê³ÆÈÝÁ¿'," +
|
" FloatVol_two double NOT NULL DEFAULT '0' COMMENT '×é2¸¡³äµçѹ'," +
|
" Strength_two double NOT NULL DEFAULT '0' COMMENT '×é2³ýÁòÇ¿¶È'," +
|
" YHStrength_two double NOT NULL DEFAULT '0' COMMENT '×é2Ñø»¤Ç¿¶È'," +
|
" TimeLong_two int(11) NOT NULL DEFAULT '0' COMMENT '×é2³ýÁòÌìÊý'," +
|
" STDCap_three int(11) NOT NULL DEFAULT '0' COMMENT '×é3±ê³ÆÈÝÁ¿'," +
|
" FloatVol_three double NOT NULL DEFAULT '0' COMMENT '×é3¸¡³äµçѹ'," +
|
" Strength_three double NOT NULL DEFAULT '0' COMMENT '×é3³ýÁòÇ¿¶È'," +
|
" YHStrength_three double NOT NULL DEFAULT '0' COMMENT '×é3Ñø»¤Ç¿¶È'," +
|
" TimeLong_three int(11) NOT NULL DEFAULT '0' COMMENT '×é3³ýÁòÌìÊý'," +
|
" STDCap_four int(11) NOT NULL DEFAULT '0' COMMENT '×é4±ê³ÆÈÝÁ¿'," +
|
" FloatVol_four double NOT NULL DEFAULT '0' COMMENT '×é4¸¡³äµçѹ'," +
|
" Strength_four double NOT NULL DEFAULT '0' COMMENT '×é4³ýÁòÇ¿¶È'," +
|
" YHStrength_four double NOT NULL DEFAULT '0' COMMENT '×é4Ñø»¤Ç¿¶È'," +
|
" TimeLong_four int(11) NOT NULL DEFAULT '0' COMMENT '×é4³ýÁòÌìÊý'," +
|
" PRIMARY KEY (num)," +
|
" UNIQUE KEY unique_dev_id (dev_id)" +
|
") ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;";
|
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
|
ResultSet res = null;
|
try {
|
if(recreate) {
|
sql.sqlMysqlExecute(sql_str1);
|
}
|
sql.sqlMysqlExecute(sql_str2);
|
//Ìí¼Óµç³Ø×é±àºÅ×Ö¶Î
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_fbs9100s_fod_param'"
|
+ " AND column_name='BattGroupNum'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SetDLParam_Table
|
+ " ADD COLUMN BattGroupNum int(11) NOT NULL DEFAULT '0' COMMENT 'µç³Ø×é×éºÅ'");
|
}
|
//Ìí¼Ó±ê³ÆÈÝÁ¿(×é5)
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_fbs9100s_fod_param'"
|
+ " AND column_name='STDCap_five'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SetDLParam_Table
|
+ " ADD COLUMN STDCap_five int(11) NOT NULL DEFAULT '0' COMMENT '×é5±ê³ÆÈÝÁ¿'");
|
}
|
//Ìí¼Ó¸¡³äµçѹ(×é5)
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_fbs9100s_fod_param'"
|
+ " AND column_name='FloatVol_five'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SetDLParam_Table
|
+ " ADD COLUMN FloatVol_five double NOT NULL DEFAULT '0' COMMENT '×é5¸¡³äµçѹ'");
|
}
|
//Ìí¼Ó³ýÁòÇ¿¶È(×é5)
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_fbs9100s_fod_param'"
|
+ " AND column_name='Strength_five'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SetDLParam_Table
|
+ " ADD COLUMN Strength_five double NOT NULL DEFAULT '0' COMMENT '×é5³ýÁòÇ¿¶È'");
|
}
|
//Ìí¼ÓÑø»¤Ç¿¶È(×é5)
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_fbs9100s_fod_param'"
|
+ " AND column_name='YHStrength_five'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SetDLParam_Table
|
+ " ADD COLUMN YHStrength_five double NOT NULL DEFAULT '0' COMMENT '×é5Ñø»¤Ç¿¶È'");
|
}
|
//Ìí¼ÓÊ£Óàʱ¼ä(×é5)
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_fbs9100s_fod_param'"
|
+ " AND column_name='TimeLong_five'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SetDLParam_Table
|
+ " ADD COLUMN TimeLong_five int(11) NOT NULL DEFAULT '0' COMMENT '×é5³ýÁòÌìÊý'");
|
}
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
if(null != res) {
|
try {
|
res.close();
|
} catch (SQLException e) {
|
e.printStackTrace();
|
}
|
}
|
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();
|
}
|
}
|
|
/**
|
* ´´½¨ tb_socketclient_state ±í
|
* @param pool
|
* @param recreate
|
*/
|
public static void createSocketClientStateTable(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.SocketClientStateTable;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.SocketClientStateTable + " (" +
|
" num bigint(20) NOT NULL AUTO_INCREMENT," +
|
" uId int(11) NOT NULL DEFAULT '0'," +
|
" client_type int(11) NOT NULL DEFAULT '0'," +
|
" client_id bigint(20) NOT NULL DEFAULT '0'," +
|
" BattGroupId int(11) NOT NULL DEFAULT '0'," +
|
" client_is_connected tinyint(1) NOT NULL DEFAULT '0'," +
|
" client_ip varchar(64) NOT NULL DEFAULT ' '," +
|
" client_conn_time datetime NOT NULL DEFAULT '1980-01-01 00:00:00'," +
|
" client_disconn_time datetime NOT NULL DEFAULT '1980-01-01 00:00:00'," +
|
" PRIMARY KEY (num)," +
|
" KEY index_user_id (uId)," +
|
" KEY index_client_type (client_type)" +
|
") 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();
|
}
|
}
|
|
/**
|
* ´´½¨ tb_server_state ±í
|
* @param pool
|
* @param recreate
|
*/
|
public static void createServerState_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.ServerState_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.ServerState_Table + " (" +
|
" num bigint(20) NOT NULL AUTO_INCREMENT," +
|
" server_version float NOT NULL DEFAULT '0'," +
|
" server_datetime datetime NOT NULL DEFAULT '1982-01-01 00:00:00'," +
|
" max_mem bigint(20) NOT NULL DEFAULT '0'," +
|
" total_mem bigint(20) NOT NULL DEFAULT '0'," +
|
" free_men bigint(20) NOT NULL DEFAULT '0'," +
|
" total_disc_space bigint(20) NOT NULL DEFAULT '0'," +
|
" free_disc_space bigint(20) NOT NULL DEFAULT '0'," +
|
" db_conn_max int(11) NOT NULL DEFAULT '0'," +
|
" db_conn_count int(11) NOT NULL DEFAULT '0'," +
|
" app_conn_max int(11) NOT NULL DEFAULT '0'," +
|
" app_busy_conn_cnt int(11) NOT NULL DEFAULT '0'," +
|
" app_idle_conn_cnt int(11) NOT NULL DEFAULT '0'," +
|
" server_cpu_rate float NOT NULL DEFAULT '0'," +
|
" server_network_rate float NOT NULL DEFAULT '0'," +
|
" PRIMARY KEY (num)" +
|
") ENGINE=InnoDB AUTO_INCREMENT=1 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);
|
|
//Ìí¼Ó×Ö¶Îapp_conn_max
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_server_state'"
|
+ " AND column_name='app_conn_max'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.ServerState_Table
|
+ " ADD COLUMN app_conn_max int(11) NOT NULL DEFAULT '0';");
|
}
|
|
//Ìí¼Ó×Ö¶Îapp_busy_conn_cnt
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_server_state'"
|
+ " AND column_name='app_busy_conn_cnt'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.ServerState_Table
|
+ " ADD COLUMN app_busy_conn_cnt int(11) NOT NULL DEFAULT '0';");
|
}
|
|
//Ìí¼Ó×Ö¶Îapp_idle_conn_cnt
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_server_state'"
|
+ " AND column_name='app_idle_conn_cnt'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.ServerState_Table
|
+ " ADD COLUMN app_idle_conn_cnt int(11) NOT NULL DEFAULT '0';");
|
}
|
|
//Ìí¼Ó×Ö¶Îserver_cpu_rate
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_server_state'"
|
+ " AND column_name='server_cpu_rate'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.ServerState_Table
|
+ " ADD COLUMN server_cpu_rate float NOT NULL DEFAULT '0';");
|
}
|
|
//Ìí¼Ó×ֶΠserver_network_rate
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_server_state'"
|
+ " AND column_name='server_network_rate'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.ServerState_Table
|
+ " ADD COLUMN server_network_rate float NOT NULL DEFAULT '0';");
|
}
|
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
if(null != res) {
|
try {
|
res.close();
|
} catch (SQLException e) {
|
e.printStackTrace();
|
}
|
}
|
sql.close_con();
|
}
|
}
|
|
/**
|
* ´´½¨ tb_ld9_updatestatue ±í
|
* @param pool
|
* @param recreate
|
*/
|
public static void createLd9_Updatestatue_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Ld9_Updatestatue_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Ld9_Updatestatue_Table + " (" +
|
"`num` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `dev_id` bigint(20) NOT NULL DEFAULT '0' COMMENT 'É豸ID'," +
|
" `update_file` varchar(200) NOT NULL DEFAULT '' COMMENT 'Éý¼¶ÎļþÃû³Æ'," +
|
" `update_en` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Éý¼¶Ê¹ÄÜ:0:²»²Ù×÷£»1£º¿ªÊ¼Éý¼¶'," +
|
" `update_type` int(1) NOT NULL DEFAULT '0' COMMENT '0:Éý¼¶LD9;1:Éý¼¶ÏÔʾÆÁ'," +
|
" `send_upfile_ok` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Éý¼¶ÊÇ·ñ³É¹¦'," +
|
" `stopreason` int(11) NOT NULL DEFAULT '0' COMMENT 'Í£Ö¹ÔÒò'," +
|
" `countpackage` int(11) NOT NULL DEFAULT '0' COMMENT '×ÜÊý¾Ý°üÊýÁ¿'," +
|
" `nowpackagenum` int(11) NOT NULL DEFAULT '0' COMMENT 'µ±Ç°Êý¾Ý°ü±àºÅ'," +
|
" `updatetime` datetime NOT NULL DEFAULT '1982-01-01 00:00:00' COMMENT '¸üÐÂʱ¼ä'," +
|
" `starttime` datetime NOT NULL DEFAULT '1982-01-01 00:00:00' COMMENT '¿ªÊ¼Éý¼¶Ê±¼ä'," +
|
" `note` varchar(200) NOT NULL DEFAULT ''," +
|
" PRIMARY KEY (`num`)," +
|
" UNIQUE KEY `index_dev_id_uniq` (`dev_id`)" +
|
") ENGINE=MEMORY AUTO_INCREMENT=7 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);
|
//Ìí¼ÓÔÚÏß³äµçÁÐ
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_ld9_updatestatue'"
|
+ " AND column_name='update_type'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Ld9_Updatestatue_Table
|
+ " ADD COLUMN `update_type` int(1) NOT NULL DEFAULT '0' COMMENT '0:Éý¼¶LD9;1:Éý¼¶ÏÔʾÆÁ' AFTER update_en;");
|
}
|
|
//³õʼ»¯Ä¬ÈÏÊý¾Ý
|
res = sql.sqlMysqlQuery("SELECT COUNT(*) num FROM db_ram_db.tb_ld9_updatestatue;");
|
if(false != res.next()) {
|
int num = res.getInt("num");
|
if(num==0){
|
//³õʼ»¯Êý¾Ý
|
sql.sqlMysqlExecute("INSERT INTO db_ram_db.`tb_ld9_updatestatue` VALUES ('6', '401900002', 'E51_DFU.SM5', '0', '0', '1', '0', '668', '668', '2022-01-07 10:10:02', '2022-01-07 10:07:12', '');");
|
}else{
|
// System.out.println("db_ram_db.tb_ld9_updatestatue ÓÐ Num ÌõÊý¾Ý "+num);
|
}
|
}
|
|
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
sql.close_con();
|
}
|
}
|
|
/**
|
* ´´½¨ tb_ld9_state ±í
|
* @param pool
|
* @param recreate
|
*/
|
public static void createLd9_State_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Ld9_State_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Ld9_State_Table + " (" +
|
" num bigint(20) NOT NULL AUTO_INCREMENT," +
|
" dev_id int(11) NOT NULL DEFAULT '401900001'," +
|
" dev_ip varchar(20) NOT NULL DEFAULT '127.0.0.1'," +
|
" record_datetime datetime NOT NULL DEFAULT '1982-01-01 00:00:00'," +
|
" dev_version varchar(64) NOT NULL DEFAULT 'v1.01.01'," +
|
" sys_state int(11) NOT NULL DEFAULT '0'," +
|
" sys_online_vol float NOT NULL DEFAULT '0.01'," +
|
" sys_group_vol float NOT NULL DEFAULT '0.01'," +
|
" sys_now_battnum int(11) NOT NULL DEFAULT '1'," +
|
" sys_now_battstate int(11) NOT NULL DEFAULT '1'," +
|
" sys_now_battvol float NOT NULL DEFAULT '0.01'," +
|
" sys_now_battcurr float NOT NULL DEFAULT '0.01'," +
|
" sys_now_battcap float NOT NULL DEFAULT '0.01'," +
|
" sys_now_testtime datetime NOT NULL DEFAULT '1982-01-01 00:00:00'," +
|
" sys_next_battnum int(11) NOT NULL DEFAULT '1'," +
|
" sys_next_battstate int(11) NOT NULL DEFAULT '1'," +
|
" sys_next_battvol float NOT NULL DEFAULT '0.01'," +
|
" sys_next_battcurr float NOT NULL DEFAULT '0.01'," +
|
" sys_next_battcap float NOT NULL DEFAULT '0.01'," +
|
" sys_next_testtime datetime NOT NULL DEFAULT '1982-01-01 00:00:00'," +
|
" sys_tmp float NOT NULL DEFAULT '0.1'," +
|
" sys_stop_reason int(11) NOT NULL DEFAULT '1'," +
|
" dev_commcount int(11) NOT NULL DEFAULT '0'," +
|
" dev_errcommcount int(11) NOT NULL DEFAULT '0'," +
|
" timelong int(11) NOT NULL DEFAULT '0'," +
|
" monvol_hightalarm int(11) NOT NULL DEFAULT '0'," +
|
" monvol_loweralarm int(11) NOT NULL DEFAULT '0'," +
|
" moncap_alarm int(11) NOT NULL DEFAULT '0'," +
|
" montmp_alarm int(11) NOT NULL DEFAULT '0'," +
|
" monres_alarm int(11) NOT NULL DEFAULT '0'," +
|
" PRIMARY KEY (num)," +
|
" UNIQUE KEY index_dev_id (dev_id)" +
|
") ENGINE=InnoDB 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();
|
}
|
}
|
|
/**
|
* ´´½¨ tb_ld9_setparam ±í
|
* @param pool
|
* @param recreate
|
*/
|
public static void createLd9_Setparam_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Ld9_Setparam_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Ld9_Setparam_Table + " (" +
|
" num bigint(20) NOT NULL AUTO_INCREMENT," +
|
" dev_id int(11) NOT NULL DEFAULT '401900001'," +
|
" op_cmd int(11) NOT NULL DEFAULT '0'," +
|
" param_teststart_batt_num int(11) NOT NULL DEFAULT '0'," +
|
" param_cap int(11) NOT NULL DEFAULT '1'," +
|
" param_discharge_curr float NOT NULL DEFAULT '0.001'," +
|
" param_mon_curr_high float NOT NULL DEFAULT '0.001'," +
|
" param_charge_curr float NOT NULL DEFAULT '0.001'," +
|
" param_mon_curr_low float NOT NULL DEFAULT '0.001'," +
|
" param_online_vol float NOT NULL DEFAULT '0.01'," +
|
" param_charge_curr_low float NOT NULL DEFAULT '0.001'," +
|
" param_charge_cap_low float NOT NULL DEFAULT '0.1'," +
|
" param_online_vol_recover int(11) NOT NULL DEFAULT '0'," +
|
" param_module_address int(11) NOT NULL DEFAULT '1'," +
|
" param_junheng_model int(11) NOT NULL DEFAULT '0'," +
|
" param_cap_low float NOT NULL DEFAULT '0'," +
|
" param_datasource int(11) NOT NULL DEFAULT '0'," +
|
" param_res_args int(11) NOT NULL DEFAULT '0'," +
|
" param_tmp_high float NOT NULL DEFAULT '0'," +
|
" param_res_high float NOT NULL DEFAULT '0'," +
|
" PRIMARY KEY (num)," +
|
" UNIQUE KEY index_dev_id (dev_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();
|
}
|
}
|
|
/**
|
* ´´½¨ tb_ld9_setparam ±í
|
* @param pool
|
* @param recreate
|
*/
|
public static void createLd9_Concentratestate_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Ld9_Concentratestate_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Ld9_Concentratestate_Table + " (" +
|
" num int(11) NOT NULL AUTO_INCREMENT COMMENT 'Ö÷¼ü'," +
|
" dev_id int(11) NOT NULL DEFAULT '0' COMMENT 'É豸id'," +
|
" record_time datetime NOT NULL DEFAULT '2000-01-01 00:00:00' COMMENT '¼Ç¼ʱ¼ä'," +
|
" systemVersion varchar(255) NOT NULL DEFAULT '' COMMENT 'ϵͳ°æ±¾'," +
|
" systemState int(11) NOT NULL DEFAULT '0' COMMENT 'ϵͳ״̬'," +
|
" groupVol float NOT NULL DEFAULT '0' COMMENT '×é¶Ëµçѹ'," +
|
" groupCurr float NOT NULL DEFAULT '0' COMMENT '×é¶ËµçÁ÷'," +
|
" battState int(11) NOT NULL DEFAULT '0' COMMENT 'µç³Ø״̬'," +
|
" currDirection int(11) NOT NULL DEFAULT '0' COMMENT 'µçÁ÷·½Ïò'," +
|
" rippleCurrAvg float NOT NULL DEFAULT '0' COMMENT 'ÎƲ¨µçÁ÷¾ùÖµ'," +
|
" rippleCurrTop float NOT NULL DEFAULT '0' COMMENT 'ÎƲ¨µçÁ÷·åÖµ'," +
|
" resTestCount int(11) NOT NULL DEFAULT '0' COMMENT 'ÄÚ×è²âÊÔ´ÎÊý'," +
|
" resTestMethod int(11) NOT NULL DEFAULT '0' COMMENT 'ÄÚ×è²âÊÔ·½·¨'," +
|
" PRIMARY KEY (num)," +
|
" UNIQUE KEY unique_dev_id (dev_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();
|
}
|
}
|
|
|
/**
|
* ´´½¨ tb_ld9_concentrateparam ±í
|
* @param pool
|
* @param recreate
|
*/
|
public static void createLd9_Concentrateparam_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Ld9_Concentrateparam_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Ld9_Concentrateparam_Table + " (" +
|
" num int(11) NOT NULL AUTO_INCREMENT," +
|
" dev_id int(11) NOT NULL DEFAULT '0' COMMENT 'É豸id'," +
|
" op_cmd int(11) NOT NULL DEFAULT '0' COMMENT 'ÃüÁî¿ØÖÆ×Ö¶Î'," +
|
" addr int(11) NOT NULL DEFAULT '0' COMMENT '»ã¼¯Æ÷µØÖ·£¨0-2555£©'," +
|
" firthMonCount int(11) NOT NULL DEFAULT '0' COMMENT 'µÚһ·µ¥Ìå¸öÊý'," +
|
" secondMonCount int(11) NOT NULL DEFAULT '0' COMMENT 'µÚ¶þ·µ¥Ìå¸öÊý'," +
|
" thirdMonCount int(11) NOT NULL DEFAULT '0' COMMENT 'µÚÈý·µ¥Ìå¸öÊý'," +
|
" fourthMonCount int(11) NOT NULL DEFAULT '0' COMMENT 'µÚËÄ·µ¥Ìå¸öÊý'," +
|
" fifthMonCount int(11) NOT NULL DEFAULT '0' COMMENT 'µÚÎå·µ¥Ìå¸öÊý'," +
|
" currRange int(11) NOT NULL DEFAULT '0' COMMENT 'µçÁ÷ǯÁ¿³Ì'," +
|
" floatCurrLimit float NOT NULL DEFAULT '0' COMMENT '¸¡³äµçÁ÷ÃÅÏÞ'," +
|
" rippleCurrLimit float NOT NULL DEFAULT '0' COMMENT 'ÎƲ¨µçÁ÷·§Öµ'," +
|
" autoTestCycle int(11) NOT NULL DEFAULT '1' COMMENT '×Ô¶¯²âÊÔÖÜÆÚ'," +
|
" resTestType int(11) NOT NULL DEFAULT '0' COMMENT 'ÄÚ×è²âÊÔ·½·¨'," +
|
" dischargeType int(11) NOT NULL DEFAULT '0' COMMENT '·Åµçģʽ'," +
|
" battCapStd int(11) NOT NULL DEFAULT '0' COMMENT '±ê³ÆÈÝÁ¿'," +
|
" backup1 int(11) NOT NULL DEFAULT '0' COMMENT '±¸ÓÃ1'," +
|
" backup2 int(11) NOT NULL DEFAULT '0' COMMENT '±¸ÓÃ2'," +
|
" backup3 int(11) NOT NULL DEFAULT '0' COMMENT '±¸ÓÃ3'," +
|
" backup4 int(11) NOT NULL DEFAULT '0' COMMENT '±¸ÓÃ4'," +
|
" PRIMARY KEY (num)," +
|
" UNIQUE KEY unique_dev_id (dev_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();
|
}
|
}
|
|
|
/**
|
* ´´½¨ tb_hard_dev_sms_state ±í
|
* @param pool
|
* @param recreate
|
*/
|
public static void createHardDevSmsState_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.HardDevSmsState_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.HardDevSmsState_Table + " (" +
|
" num bigint(20) NOT NULL AUTO_INCREMENT," +
|
" sms_dev_ip varchar(20) NOT NULL DEFAULT '192.168.1.60'," +
|
" sms_ack_type int(11) NOT NULL DEFAULT '0'," +
|
" sms_sincard_ok tinyint(1) NOT NULL DEFAULT '0'," +
|
" sms_mobile_net_ok tinyint(1) NOT NULL DEFAULT '0'," +
|
" sms_sinal_value int(11) NOT NULL DEFAULT '0'," +
|
" sms_is_busy tinyint(1) NOT NULL DEFAULT '0'," +
|
" sms_money_rest float NOT NULL DEFAULT '0'," +
|
" sms_com_count int(11) NOT NULL DEFAULT '0'," +
|
" sms_com_err_count int(11) NOT NULL DEFAULT '0'," +
|
" note varchar(100) NOT NULL DEFAULT ' '," +
|
" PRIMARY KEY (num)" +
|
") ENGINE=MEMORY 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();
|
}
|
}
|
|
/**
|
* ´´½¨ tb_fbs9600_state ±í
|
* @param pool
|
* @param recreate
|
*/
|
public static void createFBS9600State_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.FBS9600State_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.FBS9600State_Table + " (" +
|
" num bigint(20) NOT NULL AUTO_INCREMENT," +
|
" dev_ip varchar(20) NOT NULL DEFAULT '127.0.0.0'," +
|
" dev_id bigint(20) NOT NULL DEFAULT '0'," +
|
" op_cmd int(11) NOT NULL DEFAULT '0'," +
|
" dev_workstate int(11) NOT NULL DEFAULT '0'," +
|
" dev_alarmstate int(11) NOT NULL DEFAULT '0'," +
|
" dev_commcount int(11) NOT NULL DEFAULT '0'," +
|
" dev_errcommcount int(11) NOT NULL DEFAULT '0'," +
|
" PRIMARY KEY (num)," +
|
" UNIQUE KEY index_dev_id_uniq (dev_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();
|
}
|
}
|
|
/**
|
* ´´½¨ tb_fbs9100s_dfu_state ±í
|
* @param pool
|
* @param recreate
|
*/
|
public static void createFBS9100S_DFUState_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.FBS9100S_DFUState_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.FBS9100S_DFUState_Table + " (" +
|
" num bigint(20) NOT NULL AUTO_INCREMENT," +
|
" dev_id bigint(20) NOT NULL DEFAULT '0'," +
|
" sysVersion_new int(11) NOT NULL DEFAULT '0'," +
|
" softVersion_new int(11) NOT NULL DEFAULT '0'," +
|
" sysVersion_dev int(11) NOT NULL DEFAULT '0'," +
|
" softVersion_dev int(11) NOT NULL DEFAULT '0'," +
|
" dfu_file varchar(200) NOT NULL DEFAULT ' '," +
|
" dfu_en tinyint(1) NOT NULL DEFAULT '0'," +
|
" dfu_wr_stat int(11) NOT NULL DEFAULT '0'," +
|
" dfu_data_blocknum int(11) NOT NULL DEFAULT '0'," +
|
" dfu_data_blocklen int(11) NOT NULL DEFAULT '256'," +
|
" dfu_password varchar(100) NOT NULL DEFAULT ' '," +
|
" dfu_file_len int(11) NOT NULL," +
|
" PRIMARY KEY (num)," +
|
" UNIQUE KEY index_dev_id_uniq (dev_id)" +
|
") ENGINE=InnoDB 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);
|
|
//Ìí¼Ó´íÎó´úÂë×Ö¶Î
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_fbs9100s_DFU_state'"
|
+ " AND column_name='error_code'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100S_DFUState_Table
|
+ " ADD COLUMN `error_code` int(11) NOT NULL DEFAULT '0' COMMENT '´íÎó´úÂë[0:ÎÞ£»1:ÎļþδÕÒµ½£»2:²ÎÊý´íÎó£»3:Îļþ·¢Ëͳ¬Ê±;4£ºÔ¶³ÌÍ£Ö¹]'");
|
}
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
if(null != res) {
|
try {
|
res.close();
|
} catch (SQLException e) {
|
e.printStackTrace();
|
}
|
}
|
sql.close_con();
|
}
|
}
|
|
/**
|
* ´´½¨ tb_fbs9100s_dcdc_state ±í
|
* @param pool
|
* @param recreate
|
*/
|
public static void createFBS9100S_DcDcState_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.FBS9100S_DcDcState_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.FBS9100S_DcDcState_Table + " (" +
|
" num bigint(20) NOT NULL AUTO_INCREMENT," +
|
" dev_id bigint(20) NOT NULL DEFAULT '0'," +
|
" dcdc_num bigint(20) NOT NULL DEFAULT '0'," +
|
" dcdc_Vsys float NOT NULL DEFAULT '0'," +
|
" dcdc_Vout float NOT NULL DEFAULT '0'," +
|
" dcdc_Vbat float NOT NULL DEFAULT '0'," +
|
" dcdc_Iout float NOT NULL DEFAULT '0'," +
|
" dcdc_Ibuck float NOT NULL DEFAULT '0'," +
|
" dcdc_Tmp_Dis float NOT NULL DEFAULT '0'," +
|
" dcdc_Tmp_Chr float NOT NULL DEFAULT '0'," +
|
" dcdc_SMR_Alarm1 int(11) NOT NULL DEFAULT '0'," +
|
" dcdc_SMR_Alarm2 int(11) NOT NULL DEFAULT '0'," +
|
" dcdc_version int(11) NOT NULL DEFAULT '0'," +
|
" dcdc_ModeSetComm int(11) NOT NULL DEFAULT '0'," +
|
" dcdc_RunSetComm int(11) NOT NULL DEFAULT '0'," +
|
" dcdc_BuckISet float NOT NULL DEFAULT '0'," +
|
" dcdc_DisVolSet float NOT NULL DEFAULT '0'," +
|
" dcdc_DisCurrSet float NOT NULL DEFAULT '0'," +
|
" dcdc_CommTxCnt int(11) NOT NULL DEFAULT '0'," +
|
" dcdc_CommRxCnt int(11) NOT NULL DEFAULT '0'," +
|
" PRIMARY KEY (num)," +
|
" UNIQUE KEY index_dcdc_num_uniq (dcdc_num)" +
|
") ENGINE=MEMORY 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();
|
}
|
}
|
|
/**
|
* ´´½¨ tb_fbs9100_sysparam ±í
|
* @param pool
|
* @param recreate
|
*/
|
public static void createFBS9100SysParam_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.FBS9100SysParam_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.FBS9100SysParam_Table + " (" +
|
" num bigint(20) NOT NULL AUTO_INCREMENT," +
|
" dev_ip varchar(20) NOT NULL DEFAULT '127.0.0.0'," +
|
" dev_id bigint(20) NOT NULL DEFAULT '0'," +
|
" op_cmd int(11) NOT NULL DEFAULT '0'," +
|
" IPADDR varchar(20) NOT NULL DEFAULT '127.0.0.0'," +
|
" SubIPADDR varchar(20) NOT NULL DEFAULT '127.0.0.0'," +
|
" NetGateADDR varchar(20) NOT NULL DEFAULT '127.0.0.0'," +
|
" GroupVolRange int(11) NOT NULL DEFAULT '0'," +
|
" GroupVolSorce int(11) NOT NULL DEFAULT '0'," +
|
" CurrentRange int(11) NOT NULL DEFAULT '0'," +
|
" CurrentTyte int(11) NOT NULL DEFAULT '0'," +
|
" MonomerOrder int(11) NOT NULL DEFAULT '0'," +
|
" BackLightTime int(11) NOT NULL DEFAULT '0'," +
|
" MACADDR varchar(30) NOT NULL DEFAULT '0.0.0.0.0.0'," +
|
" LoaderCount int(11) NOT NULL DEFAULT '0'," +
|
" DtCardCount int(11) NOT NULL DEFAULT '0'," +
|
" PowerBreakChargeCurr float NOT NULL DEFAULT '0'," +
|
" MajorBattGroupNum int(11) NOT NULL DEFAULT '0'," +
|
" POF_BG_Boost_Cnt int(11) NOT NULL DEFAULT '0'," +
|
" POF_BG_Boost_VolStop float NOT NULL DEFAULT '0'," +
|
" POF_BG_Boost_VolStart float NOT NULL DEFAULT '0'," +
|
|
" `JunHeng_Enabled` float NOT NULL DEFAULT '0' COMMENT '¾ùºâ¹¦ÄÜÆôÓÃ״̬£¨1:ÆôÓã»0:½ûÓã©'," +
|
" `JunHeng_StVol` float NOT NULL DEFAULT '0' COMMENT '¾ùºâÍ£Ö¹µçѹ·§Öµ'," +
|
" `JunHeng_StCurr` float NOT NULL DEFAULT '0' COMMENT '¾ùºâÍ£Ö¹µçÁ÷·§Öµ'," +
|
" PRIMARY KEY (num)," +
|
" UNIQUE KEY index_dev_id_uniq (dev_id)" +
|
") ENGINE=InnoDB 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);
|
|
//Ìí¼Ó×Ö¶ÎJunHeng_Enabled ¾ùºâ¹¦ÄÜÆôÓÃ״̬
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_fbs9100_sysparam'"
|
+ " AND column_name='JunHeng_Enabled'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SysParam_Table
|
+ " ADD COLUMN `JunHeng_Enabled` float NOT NULL DEFAULT '0' COMMENT '¾ùºâ¹¦ÄÜÆôÓÃ״̬£¨1:ÆôÓã»0:½ûÓã©';");
|
}else{
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SysParam_Table
|
+ " CHANGE `JunHeng_Enabled` `JunHeng_Enabled` float NOT NULL DEFAULT '0' COMMENT '¾ùºâ¹¦ÄÜÆôÓÃ״̬£¨1:ÆôÓã»0:½ûÓã©';");
|
}
|
|
//Ìí¼Ó×Ö¶ÎJunHeng_StVol ¾ùºâÍ£Ö¹µçѹ·§Öµ
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_fbs9100_sysparam'"
|
+ " AND column_name='JunHeng_StVol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SysParam_Table
|
+ " ADD COLUMN `JunHeng_StVol` float NOT NULL DEFAULT '0' COMMENT '¾ùºâÍ£Ö¹µçѹ·§Öµ';");
|
}
|
|
//Ìí¼Ó×Ö¶ÎJunHeng_StCurr ¾ùºâÍ£Ö¹µçÁ÷·§Öµ
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_fbs9100_sysparam'"
|
+ " AND column_name='JunHeng_StCurr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SysParam_Table
|
+ " ADD COLUMN `JunHeng_StCurr` float NOT NULL DEFAULT '0' COMMENT '¾ùºâÍ£Ö¹µçÁ÷·§Öµ';");
|
}
|
|
|
//Ìí¼Ó×Ö¶ÎStandyVolt ºó±¸µçѹ£¨V£©
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_fbs9100_sysparam'"
|
+ " AND column_name='StandyVolt'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SysParam_Table
|
+ " ADD COLUMN `StandyVolt` float NOT NULL DEFAULT '0' COMMENT 'ºó±¸µçѹ£¨V£©';");
|
}
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
if(null != res) {
|
try {
|
res.close();
|
} catch (SQLException e) {
|
e.printStackTrace();
|
}
|
}
|
sql.close_con();
|
}
|
}
|
|
/**
|
* ´´½¨ tb_fbs9100_state ±í
|
* @param pool
|
* @param recreate
|
*/
|
public static void createFBS9100State_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.FBS9100State_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.FBS9100State_Table + " (" +
|
" num bigint(20) NOT NULL AUTO_INCREMENT," +
|
" dev_ip varchar(20) NOT NULL DEFAULT '127.0.0.0'," +
|
" dev_version varchar(64) NOT NULL DEFAULT ''," +
|
" dev_id bigint(20) NOT NULL DEFAULT '0'," +
|
" op_cmd int(11) NOT NULL DEFAULT '0'," +
|
" record_datetime varchar(20) NOT NULL DEFAULT '2015-12-02 12:10:00'," +
|
" dev_datetime varchar(20) NOT NULL DEFAULT '2015-12-02 12:10:00'," +
|
" dev_testtype int(11) NOT NULL DEFAULT '0'," +
|
" dev_testgroupnum int(11) NOT NULL DEFAULT '0'," +
|
" dev_workstate int(11) NOT NULL DEFAULT '0'," +
|
" dev_alarmstate int(11) NOT NULL DEFAULT '0'," +
|
" dev_onlinevollow tinyint(1) NOT NULL DEFAULT '0'," +
|
" dev_eachgroup_battsum int(11) NOT NULL DEFAULT '0'," +
|
" dev_captest_onlinevol float NOT NULL DEFAULT '0'," +
|
" dev_captest_groupvol float NOT NULL DEFAULT '0'," +
|
" dev_captest_curr float NOT NULL DEFAULT '0'," +
|
" dev_captest_cap float NOT NULL DEFAULT '0'," +
|
" dev_captest_timelong int(11) NOT NULL DEFAULT '0'," +
|
" dev_restest_moncount int(11) NOT NULL DEFAULT '0'," +
|
" dev_restest_monindex int(11) NOT NULL DEFAULT '0'," +
|
" dev_commcount int(11) NOT NULL DEFAULT '0'," +
|
" dev_errcommcount int(11) NOT NULL DEFAULT '0'," +
|
" dev_rxnullerrcount int(11) NOT NULL DEFAULT '0'," +
|
" dev_temp float NOT NULL DEFAULT '0'," +
|
" dev_res_test_state int(11) NOT NULL DEFAULT '0'," +
|
" dev_restest_count int(11) NOT NULL DEFAULT '0'," +
|
" dev_last_captest_stop_type int(11) NOT NULL DEFAULT '0'," +
|
" dev_condvoldp float NOT NULL DEFAULT '0'," +
|
" dev_conresist float NOT NULL DEFAULT '0'," +
|
" dev_conresist1 float NOT NULL DEFAULT '0'," +
|
" dev_condcurr float NOT NULL DEFAULT '0'," +
|
" dev_61850alarms varchar(64) NOT NULL DEFAULT ''," +
|
" dev_batt_xuhang_tlong int(11) NOT NULL DEFAULT '0'," +
|
" dev_station_poff_tlong int(11) NOT NULL DEFAULT '0'," +
|
" dev_station_poff_cnt int(11) NOT NULL DEFAULT '0'," +
|
" dev_data_flowsum bigint(20) NOT NULL DEFAULT '0'," +
|
" batt_online_state int(11) NOT NULL DEFAULT '0'," +
|
" dev_concurr float NOT NULL DEFAULT '0'," +
|
" `a059_group_vol1` float NOT NULL DEFAULT '0' COMMENT '³ä·ÅµçÒ»Ìå»ú×é1×é¶Ëµçѹ'," +
|
" `a059_group_vol2` float NOT NULL DEFAULT '0' COMMENT '³ä·ÅµçÒ»Ìå»ú×é2×é¶Ëµçѹ'," +
|
" `a059_group_curr1` float NOT NULL DEFAULT '0' COMMENT '³ä·ÅµçÒ»Ìå»ú×é1×é¶ËµçÁ÷'," +
|
" `a059_group_curr2` float NOT NULL DEFAULT '0' COMMENT '³ä·ÅµçÒ»Ìå»ú×é2×é¶ËµçÁ÷',"+
|
" PRIMARY KEY (num)," +
|
" UNIQUE KEY index_dev_id_uniq (dev_id)" +
|
") ENGINE=InnoDB AUTO_INCREMENT=1 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);
|
|
//Ìí¼Ó×Ö¶Îa059_group_vol1
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_fbs9100_state'"
|
+ " AND column_name='a059_group_vol1'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100State_Table
|
+ " ADD COLUMN `a059_group_vol1` float NOT NULL DEFAULT '0' COMMENT '³ä·ÅµçÒ»Ìå»ú×é1×é¶Ëµçѹ';");
|
}
|
|
//Ìí¼Ó×Ö¶Îa059_group_vol2
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_fbs9100_state'"
|
+ " AND column_name='a059_group_vol2'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100State_Table
|
+ " ADD COLUMN `a059_group_vol2` float NOT NULL DEFAULT '0' COMMENT '³ä·ÅµçÒ»Ìå»ú×é2×é¶Ëµçѹ';");
|
}
|
|
//Ìí¼Ó×Ö¶Îa059_group_curr1
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_fbs9100_state'"
|
+ " AND column_name='a059_group_curr1'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100State_Table
|
+ " ADD COLUMN `a059_group_curr1` float NOT NULL DEFAULT '0' COMMENT '³ä·ÅµçÒ»Ìå»ú×é1×é¶ËµçÁ÷';");
|
}
|
|
//Ìí¼Ó×Ö¶Îa059_group_curr2
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_fbs9100_state'"
|
+ " AND column_name='a059_group_curr2'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100State_Table
|
+ " ADD COLUMN `a059_group_curr2` float NOT NULL DEFAULT '0' COMMENT '³ä·ÅµçÒ»Ìå»ú×é2×é¶ËµçÁ÷';");
|
}
|
|
//Ìí¼Ó×Ö¶Îdev_pos_states
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_fbs9100_state'"
|
+ " AND column_name='dev_pos_states'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100State_Table
|
+ " ADD COLUMN `dev_pos_states` varchar(30) NOT NULL DEFAULT '0,0,0,0' COMMENT 'Çл»Ïä½Ó´¥Æ÷Õý¼«¿ª¹Ø״̬[0ûͨÐÅÉÏ£»1£»Õý³££»2£»Òì³£]';");
|
}
|
//Ìí¼Ó×Ö¶Îdev_neg_states
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_fbs9100_state'"
|
+ " AND column_name='dev_neg_states'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100State_Table
|
+ " ADD COLUMN `dev_neg_states` varchar(30) NOT NULL DEFAULT '0,0,0,0' COMMENT 'Çл»Ïä½Ó´¥Æ÷¸º¼«¿ª¹Ø״̬[0ûͨÐÅÉÏ£»1£»Õý³££»2£»Òì³£]';");
|
}
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
sql.close_con();
|
}
|
}
|
|
|
/**
|
* ´´½¨ tb_fbs9100_setparam ±í
|
* @param pool
|
* @param recreate
|
*/
|
public static void createFBS9100SetParam_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.FBS9100SetParam_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.FBS9100SetParam_Table + " (" +
|
" num bigint(20) NOT NULL AUTO_INCREMENT," +
|
" dev_ip varchar(20) NOT NULL DEFAULT '127.0.0.0'," +
|
" dev_id bigint(20) NOT NULL DEFAULT '0'," +
|
" op_cmd int(11) NOT NULL DEFAULT '0'," +
|
" TestCmd int(11) NOT NULL DEFAULT '0'," +
|
" HourRate int(11) NOT NULL DEFAULT '0'," +
|
" DisCurr float NOT NULL DEFAULT '0'," +
|
" DisCap float NOT NULL DEFAULT '0'," +
|
" DisTime int(11) NOT NULL DEFAULT '0'," +
|
" GroupVol_LOW float NOT NULL DEFAULT '0'," +
|
" MonomerVol_LOW float NOT NULL DEFAULT '0'," +
|
" MonomerLowCount int(11) NOT NULL DEFAULT '0'," +
|
" BattGroupNum int(11) NOT NULL DEFAULT '0'," +
|
" OnlineVolLowAction int(11) NOT NULL DEFAULT '0'," +
|
" DCVolHighLimit float NOT NULL DEFAULT '0'," +
|
" ChargeCurrSet float NOT NULL DEFAULT '0'," +
|
" MonomerTmp_High float NOT NULL DEFAULT '0'," +
|
" AutoTestStartVol float NOT NULL DEFAULT '0'," +
|
" OnLineVol_Low float NOT NULL DEFAULT '0'," +
|
" OffLineYH_Cycle int(11) NOT NULL DEFAULT '0'," +
|
" OffLineYHstarttime datetime NOT NULL DEFAULT '2000-01-01 00:00:00'," +
|
" OffLineYHTimes int(11) NOT NULL DEFAULT '1'," +
|
" OffLineYHOnceCycle int(11) NOT NULL DEFAULT '1'," +
|
" PRIMARY KEY (num)," +
|
" UNIQUE KEY index_dev_id_uniq (dev_id)" +
|
") ENGINE=MEMORY 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();
|
}
|
}
|
|
/**
|
* ´´½¨ tb_fbs9100_offlineyhplan ±í
|
* @param pool
|
* @param recreate
|
*/
|
public static void createFBS9100_offlineyhplan_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.FBS9100_offlineyhplan;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.FBS9100_offlineyhplan + " (" +
|
" num bigint(20) NOT NULL AUTO_INCREMENT," +
|
" dev_id int(11) NOT NULL DEFAULT '1'," +
|
" OffLineYH_Cycle int(11) NOT NULL DEFAULT '1'," +
|
" OffLineYHstarttime datetime NOT NULL DEFAULT '2000-01-01 00:00:00'," +
|
" OffLineYHTimes int(11) NOT NULL DEFAULT '0'," +
|
" OffLineYHOnceCycle int(11) NOT NULL DEFAULT '0'," +
|
" note varchar(255) NOT NULL DEFAULT ''," +
|
" PRIMARY KEY (num)" +
|
") ENGINE=InnoDB 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();
|
}
|
}
|
/**
|
* ´´½¨ tb_fbs9100_battparam ±í
|
* @param pool
|
* @param recreate
|
*/
|
public static void createFBS9100BattParam_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.FBS9100BattParam_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.FBS9100BattParam_Table + " (" +
|
" num bigint(20) NOT NULL AUTO_INCREMENT," +
|
" dev_ip varchar(20) NOT NULL DEFAULT '127.0.0.0'," +
|
" dev_id bigint(20) NOT NULL DEFAULT '0'," +
|
" op_cmd int(11) NOT NULL DEFAULT '0'," +
|
" STD_CAP int(11) NOT NULL DEFAULT '0'," +
|
" STD_RES int(11) NOT NULL DEFAULT '0'," +
|
" BattGroupCount int(11) NOT NULL DEFAULT '0'," +
|
" EachGroupBattCount int(11) NOT NULL DEFAULT '0'," +
|
" MonomerVol float NOT NULL DEFAULT '0'," +
|
" GroupVol float NOT NULL DEFAULT '0'," +
|
" BattTemp float NOT NULL DEFAULT '0'," +
|
" FloatChargeVol float NOT NULL DEFAULT '0'," +
|
" FloatChargeCurr float NOT NULL DEFAULT '0'," +
|
" OnlineVolLow float NOT NULL DEFAULT '0'," +
|
" GroupConnType int(11) NOT NULL DEFAULT '0'," +
|
" BattGroupCountSum int(11) NOT NULL DEFAULT '0'," +
|
" LiBattGroupCount int(11) NOT NULL DEFAULT '0'," +
|
" LiEachGroupBattCount int(11) NOT NULL DEFAULT '0'," +
|
" PRIMARY KEY (num)," +
|
" UNIQUE KEY index_dev_id_uniq (dev_id)" +
|
") ENGINE=MEMORY 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);
|
|
|
//Ìí¼Ó×Ö¶ÎBattGroupCountSum
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_fbs9100_battparam'"
|
+ " AND column_name='BattGroupCountSum'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100BattParam_Table
|
+ " ADD COLUMN `BattGroupCountSum` int(11) NOT NULL DEFAULT '0' COMMENT 'µç³Ø×é×ÜÊý(ǦËá+﮵磬ֻ¶Á)';");
|
}
|
|
//Ìí¼Ó×Ö¶ÎLiBattGroupCount
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_fbs9100_battparam'"
|
+ " AND column_name='LiBattGroupCount'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100BattParam_Table
|
+ " ADD COLUMN `LiBattGroupCount` int(11) NOT NULL DEFAULT '0' COMMENT '﮵ç×éÊý';");
|
}
|
|
//Ìí¼Ó×Ö¶ÎLiEachGroupBattCount
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_fbs9100_battparam'"
|
+ " AND column_name='LiEachGroupBattCount'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100BattParam_Table
|
+ " ADD COLUMN `LiEachGroupBattCount` int(11) NOT NULL DEFAULT '0' COMMENT '﮵ç½ÚÊý';");
|
}
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
sql.close_con();
|
}
|
}
|
/**
|
* ´´½¨ tb_bts_station_state ±í
|
* @param pool
|
* @param recreate
|
*/
|
public static void createBTSStationState_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.BTSStationState_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.BTSStationState_Table + " (" +
|
" num bigint(20) NOT NULL AUTO_INCREMENT," +
|
" station_id bigint(20) NOT NULL DEFAULT '0'," +
|
" dev_id bigint(20) NOT NULL DEFAULT '0'," +
|
" record_datetime varchar(20) NOT NULL DEFAULT '2015-12-02 12:10:00'," +
|
" station_stat int(11) NOT NULL DEFAULT '0'," +
|
" station_poff_start_time varchar(20) NOT NULL DEFAULT '2015-12-02 12:10:00'," +
|
" station_fadian_start_time varchar(20) NOT NULL DEFAULT '2015-12-02 12:10:00'," +
|
" station_diaozhan_start_time varchar(20) NOT NULL DEFAULT '2015-12-02 12:10:00'," +
|
" station_temp float NOT NULL DEFAULT '0'," +
|
" station_damp float NOT NULL DEFAULT '0'," +
|
" station_dooropen_start_time varchar(20) NOT NULL DEFAULT '2015-12-02 12:10:00'," +
|
" station_xuhang_start_time varchar(20) NOT NULL DEFAULT '2015-12-02 12:10:00'," +
|
" station_xuhang_end_time varchar(20) NOT NULL DEFAULT '2015-12-02 12:10:00'," +
|
" PRIMARY KEY (num)," +
|
" UNIQUE KEY index_station_id_uniq (station_id)" +
|
") ENGINE=InnoDB AUTO_INCREMENT=11 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();
|
}
|
}
|
/**
|
* ´´½¨ tb_bts_gprs_state ±í
|
* @param pool
|
* @param recreate
|
*/
|
public static void createBTSGPRSState_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.BTSGPRSState_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.BTSGPRSState_Table + " (" +
|
" `num` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `dev_id` bigint(20) NOT NULL DEFAULT '0'," +
|
" `op_cmd` int(11) NOT NULL DEFAULT '0'," +
|
" `AT_cmd` varchar(20) NOT NULL DEFAULT ''," +
|
" `ack_inf` varchar(50) NOT NULL DEFAULT ''," +
|
" `bts_task_inf` varchar(1024) NOT NULL DEFAULT ''," +
|
" PRIMARY KEY (`num`)," +
|
" UNIQUE KEY `index_dev_id_uniq` (`dev_id`)" +
|
") ENGINE=InnoDB AUTO_INCREMENT=5 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);
|
|
|
//Ìí¼Ó×Ö¶Îop_cmd
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_bts_gprs_state'"
|
+ " AND column_name='op_cmd'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BTSGPRSState_Table
|
+ " ADD COLUMN `op_cmd` int(11) NOT NULL DEFAULT '0';");
|
}
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
if(null != res) {
|
try {
|
res.close();
|
} catch (SQLException e) {
|
e.printStackTrace();
|
}
|
}
|
sql.close_con();
|
}
|
}
|
/**
|
* ´´½¨ tb_bpm7100_state ±í
|
* @param pool
|
* @param recreate
|
*/
|
public static void createBMP7100State_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.BMP7100State_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.BMP7100State_Table + " (" +
|
" num bigint(20) NOT NULL AUTO_INCREMENT," +
|
" dev_ip varchar(20) NOT NULL DEFAULT '127.0.0.0'," +
|
" dev_id int(11) NOT NULL DEFAULT '0'," +
|
" op_cmd int(11) NOT NULL DEFAULT '0'," +
|
" dev_workstate int(11) NOT NULL DEFAULT '0'," +
|
" dev_worktime bigint(20) NOT NULL DEFAULT '0'," +
|
" dev_commcount int(11) NOT NULL DEFAULT '0'," +
|
" dev_errcommcount int(11) NOT NULL DEFAULT '0'," +
|
" PRIMARY KEY (num)" +
|
") ENGINE=MEMORY 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();
|
}
|
}
|
|
/**
|
* ´´½¨ tb_batt_rtstate ±í
|
* @param pool
|
* @param recreate
|
*/
|
public static void createBattRtState_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.BattRtState_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.BattRtState_Table + " (" +
|
" num bigint(20) NOT NULL AUTO_INCREMENT," +
|
" BattGroupId int(11) NOT NULL DEFAULT '0'," +
|
" batt_count int(11) NOT NULL DEFAULT '0'," +
|
" rec_datetime datetime NOT NULL DEFAULT '1982-01-01 00:00:00'," +
|
" online_vol float NOT NULL DEFAULT '0'," +
|
" group_vol float NOT NULL DEFAULT '0'," +
|
" group_tmp float NOT NULL DEFAULT '0'," +
|
" group_curr float NOT NULL DEFAULT '0'," +
|
" batt_state int(11) NOT NULL DEFAULT '0'," +
|
" batt_test_type int(11) NOT NULL DEFAULT '0'," +
|
" batt_test_starttime datetime NOT NULL DEFAULT '1982-01-01 00:00:00'," +
|
" batt_test_recordtime datetime NOT NULL DEFAULT '1982-01-01 00:00:00'," +
|
" batt_test_tlong int(11) NOT NULL DEFAULT '0'," +
|
" batt_test_cap float NOT NULL DEFAULT '0'," +
|
" batt_real_cap float NOT NULL DEFAULT '0'," +
|
" batt_rest_cap float NOT NULL DEFAULT '0'," +
|
" batt_rest_power1_time int(11) NOT NULL DEFAULT '0'," +
|
" batt_rest_power2_time int(11) NOT NULL DEFAULT '0'," +
|
" test_loadertype int(11) NOT NULL DEFAULT '0'," +
|
" test_recordnum int(11) NOT NULL DEFAULT '0'," +
|
" `dev_temperature` float NOT NULL DEFAULT '0' COMMENT 'ζȴ«¸ÐÆ÷ζÈ'," +
|
" `dev_humidity` float NOT NULL DEFAULT '0' COMMENT 'ζȴ«¸ÐÆ÷ʪ¶È'," +
|
" PRIMARY KEY (num)," +
|
" KEY index_BattGroupId (BattGroupId)" +
|
") ENGINE=InnoDB AUTO_INCREMENT=8 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);
|
|
//ζȴ«¸ÐÆ÷ζÈ
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_batt_rtstate'"
|
+ " AND column_name='dev_temperature'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattRtState_Table
|
+ " ADD COLUMN `dev_temperature` float NOT NULL DEFAULT '0' COMMENT 'ζȴ«¸ÐÆ÷ζÈ'");
|
}
|
|
//ζȴ«¸ÐÆ÷ʪ¶È
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_batt_rtstate'"
|
+ " AND column_name='dev_humidity'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattRtState_Table
|
+ " ADD COLUMN `dev_humidity` float NOT NULL DEFAULT '0' COMMENT 'ζȴ«¸ÐÆ÷ʪ¶È'");
|
}
|
|
//a059É豸µ±Ç°µ¥ÌåÊý¾ÝÀ´Ô´µç³Ø×éºÅ
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_batt_rtstate'"
|
+ " AND column_name='a059_num'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattRtState_Table
|
+ " ADD COLUMN `a059_num` int(11) NOT NULL DEFAULT '0' COMMENT 'a059É豸µ±Ç°µç³Ø×é±àºÅ'");
|
}
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
sql.close_con();
|
}
|
}
|
/**
|
* ´´½¨ tb_batt_rtdata ±í
|
* @param pool
|
* @param recreate
|
*/
|
public static void createBattRtData_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.BattRtData_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.BattRtData_Table + " (" +
|
" num bigint(20) NOT NULL AUTO_INCREMENT," +
|
" BattGroupId int(11) NOT NULL DEFAULT '0'," +
|
" rec_datetime datetime NOT NULL DEFAULT '1982-01-01 00:00:00'," +
|
" mon_num int(11) NOT NULL DEFAULT '0'," +
|
" mon_vol float NOT NULL DEFAULT '0'," +
|
" mon_tmp float NOT NULL DEFAULT '0'," +
|
" mon_res float NOT NULL DEFAULT '0'," +
|
" mon_ser float NOT NULL DEFAULT '0'," +
|
" mon_conn_res float NOT NULL DEFAULT '0'," +
|
" mon_cap float NOT NULL DEFAULT '0'," +
|
" mon_JH_curr float NOT NULL DEFAULT '0'," +
|
" mon_LY_vol float NOT NULL DEFAULT '0'," +
|
" PRIMARY KEY (num)," +
|
" KEY index_BattGroupId (BattGroupId)" +
|
") ENGINE=InnoDB AUTO_INCREMENT=347 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);
|
//Ìí¼Ó×Ö¶Îmon_JH_curr
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_batt_rtdata'"
|
+ " AND column_name='mon_JH_curr'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattRtData_Table
|
+ " ADD COLUMN mon_JH_curr float NOT NULL DEFAULT '0';");
|
}
|
//Ìí¼Ó×Ö¶Îmon_LY_vol
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_batt_rtdata'"
|
+ " AND column_name='mon_LY_vol'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattRtData_Table
|
+ " ADD COLUMN mon_LY_vol float NOT NULL DEFAULT '0';");
|
}
|
|
//Ìí¼Ó×Ö¶Îmon_test_cap
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_batt_rtdata'"
|
+ " AND column_name='mon_test_cap'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattRtData_Table
|
+ " ADD COLUMN `mon_test_cap` float NOT NULL DEFAULT '0' COMMENT 'µ¥Ìå²âÊÔÈÝÁ¿';");
|
}
|
|
//Ìí¼Ó×Ö¶Îmon_dis_timelong
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_batt_rtdata'"
|
+ " AND column_name='mon_dis_timelong'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattRtData_Table
|
+ " ADD COLUMN `mon_dis_timelong` int(11) NOT NULL DEFAULT '0' COMMENT '·Åµç¿É³ÖÐøʱ³¤';");
|
}
|
|
//Ìí¼Ó×Ö¶Îmon_rest_cap--µ¥ÌåÊ£ÓàÈÝÁ¿
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_batt_rtdata'"
|
+ " AND column_name='mon_rest_cap'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattRtData_Table
|
+ " ADD COLUMN `mon_rest_cap` float NOT NULL DEFAULT '0' COMMENT 'µ¥ÌåÊ£ÓàÈÝÁ¿';");
|
}
|
|
//Ìí¼Ó×Ö¶Îmon_state--µ¥Ìå״̬
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_batt_rtdata'"
|
+ " AND column_name='mon_state'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattRtData_Table
|
+ " ADD COLUMN `mon_state` int(11) NOT NULL DEFAULT '0' COMMENT 'µ¥Ìå״̬';");
|
}
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
sql.close_con();
|
}
|
}
|
/**
|
* ´´½¨ tb_61850_jhstate ±í
|
* @param pool
|
* @param recreate
|
*/
|
public static void create61850_JHState_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.TB_61850_JHState_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.TB_61850_JHState_Table + " (" +
|
" num bigint(20) NOT NULL AUTO_INCREMENT," +
|
" dev_id int(11) NOT NULL DEFAULT '0'," +
|
" dev_version varchar(255) NOT NULL DEFAULT ''," +
|
" input_vol_total double NOT NULL DEFAULT '0'," +
|
" output_vol_total double NOT NULL DEFAULT '0'," +
|
" input_curr_total double NOT NULL DEFAULT '0'," +
|
" output_curr_total double NOT NULL DEFAULT '0'," +
|
" output_vol_one double NOT NULL DEFAULT '0'," +
|
" output_vol_two double NOT NULL DEFAULT '0'," +
|
" output_vol_three double NOT NULL DEFAULT '0'," +
|
" output_vol_four double NOT NULL DEFAULT '0'," +
|
" output_vol_five double NOT NULL DEFAULT '0'," +
|
" output_vol_six double NOT NULL DEFAULT '0'," +
|
" output_vol_seven double NOT NULL DEFAULT '0'," +
|
" output_vol_eight double NOT NULL DEFAULT '0'," +
|
" output_vol_nine double NOT NULL DEFAULT '0'," +
|
" output_vol_ten double NOT NULL DEFAULT '0'," +
|
" dev_temp double NOT NULL DEFAULT '0'," +
|
" PRIMARY KEY (num)," +
|
" UNIQUE KEY index_dev_id_unique (dev_id) USING BTREE" +
|
") ENGINE=InnoDB AUTO_INCREMENT=9046 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();
|
}
|
}
|
/**
|
* ´´½¨ cmcc_power_data ±í
|
* @param pool
|
* @param recreate
|
*/
|
public static void createRamDB_CMCC_POWER_Data_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.RamDB_CMCC_POWER_Data;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.RamDB_CMCC_POWER_Data + " (" +
|
" num bigint(20) NOT NULL AUTO_INCREMENT," +
|
" dev_id bigint(20) NOT NULL DEFAULT '0'," +
|
" vol1 float NOT NULL DEFAULT '0'," +
|
" vol2 float NOT NULL DEFAULT '0'," +
|
" vol3 float NOT NULL DEFAULT '0'," +
|
" vol4 float NOT NULL DEFAULT '0'," +
|
" vol5 float NOT NULL DEFAULT '0'," +
|
" curr1 float NOT NULL DEFAULT '0'," +
|
" curr2 float NOT NULL DEFAULT '0'," +
|
" curr3 float NOT NULL DEFAULT '0'," +
|
" curr4 float NOT NULL DEFAULT '0'," +
|
" curr5 float NOT NULL DEFAULT '0'," +
|
" PRIMARY KEY (num)," +
|
" UNIQUE KEY index_dev_id_uniq (dev_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();
|
}
|
}
|
|
/**
|
* ´´½¨ tb_fbs9100_insulatstate ±í
|
* @param pool
|
* @param recreate
|
*/
|
public static void createFBS9100_InsulatstateTable(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.FBS9100_InsulatstateTable;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.FBS9100_InsulatstateTable + " (" +
|
" `num` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'Ö÷¼ü'," +
|
" `PowerDeviceId` int(11) NOT NULL DEFAULT '1' COMMENT 'µçÔ´id'," +
|
" `BattGroupId` int(11) NOT NULL DEFAULT '0' COMMENT 'µç³Ø×éid'," +
|
" `record_time` datetime NOT NULL DEFAULT '2000-01-01 00:00:00' COMMENT '¼Ç¼ʱ¼ä'," +
|
" `dev_version` varchar(64) NOT NULL DEFAULT '' COMMENT 'Ðת°æ±¾ºÅ'," +
|
" `insulat_system_vol` float NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿éϵͳµçѹ'," +
|
" `insulat_ground_vol` float NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿éÕý¶ÔµØµçѹ'," +
|
" `insulat_negative_vol` float NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿é¸º¶ÔµØµçѹ'," +
|
" `insulat_ground_res` float NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿éÕý¶ÔµØµç×è'," +
|
" `insulat_negative_res` float NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿é¸º¶ÔµØµç×è'," +
|
" `insulat_batt_res` float NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿éµç³Ø¶ÔµØµç×è'," +
|
" `insulat_fault_num` int(11) NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿é¹ÊÕϵç³Ø½ÚÊý'," +
|
" `insulat_ac_vol` float NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿é½»Á÷µçѹ'," +
|
" `insulat_system_state` int(11) NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿éϵͳ״̬'," +
|
" `insulat_record_state` int(11) NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿é˲ʱ¼Ç¼״̬'," +
|
" `insulat_state` int(11) NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿é×°ÖÃ״̬'," +
|
" `insulat_branch_num_1` int(11) NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿é½ÓµØ֧·ºÅ(Ä£¿é1)'," +
|
" `insulat_branch_res_is_1` float NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿é֧·Õý¶ÔµØµç×è(Ä£¿é1)'," +
|
" `insulat_branch_res_ne_1` float NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿é֧·¸º¶ÔµØµç×è(Ä£¿é1)'," +
|
" `insulat_branch_num_2` int(11) NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿é½ÓµØ֧·ºÅ(Ä£¿é2)'," +
|
" `insulat_branch_res_is_2` float NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿é֧·Õý¶ÔµØµç×è(Ä£¿é2)'," +
|
" `insulat_branch_res_ne_2` float NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿é֧·¸º¶ÔµØµç×è(Ä£¿é2)'," +
|
" `insulat_branch_num_3` int(11) NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿é½ÓµØ֧·ºÅ(Ä£¿é3)'," +
|
" `insulat_branch_res_is_3` float NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿é֧·Õý¶ÔµØµç×è(Ä£¿é3)'," +
|
" `insulat_branch_res_ne_3` float NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿é֧·¸º¶ÔµØµç×è(Ä£¿é3)'," +
|
" `insulat_branch_num_4` int(11) NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿é½ÓµØ֧·ºÅ(Ä£¿é4)'," +
|
" `insulat_branch_res_is_4` float NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿é֧·Õý¶ÔµØµç×è(Ä£¿é4)'," +
|
" `insulat_branch_res_ne_4` float NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿é֧·¸º¶ÔµØµç×è(Ä£¿é4)'," +
|
" `insulat_branch_num_5` int(11) NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿é½ÓµØ֧·ºÅ(Ä£¿é5)'," +
|
" `insulat_branch_res_is_5` float NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿é֧·Õý¶ÔµØµç×è(Ä£¿é5)'," +
|
" `insulat_branch_res_ne_5` float NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿é֧·¸º¶ÔµØµç×è(Ä£¿é5)'," +
|
" `insulat_branch_num_6` int(11) NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿é½ÓµØ֧·ºÅ(Ä£¿é6)'," +
|
" `insulat_branch_res_is_6` float NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿é֧·Õý¶ÔµØµç×è(Ä£¿é6)'," +
|
" `insulat_branch_res_ne_6` float NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿é֧·¸º¶ÔµØµç×è(Ä£¿é6)'," +
|
" `insulat_branch_num_7` int(11) NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿é½ÓµØ֧·ºÅ(Ä£¿é7)'," +
|
" `insulat_branch_res_is_7` float NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿é֧·Õý¶ÔµØµç×è(Ä£¿é7)'," +
|
" `insulat_branch_res_ne_7` float NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿é֧·¸º¶ÔµØµç×è(Ä£¿é7)'," +
|
" `insulat_branch_num_8` int(11) NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿é½ÓµØ֧·ºÅ(Ä£¿é8)'," +
|
" `insulat_branch_res_is_8` float NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿é֧·Õý¶ÔµØµç×è(Ä£¿é8)'," +
|
" `insulat_branch_res_ne_8` float NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿é֧·¸º¶ÔµØµç×è(Ä£¿é8)'," +
|
" `insulat_branch_num_9` int(11) NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿é½ÓµØ֧·ºÅ(Ä£¿é9)'," +
|
" `insulat_branch_res_is_9` float NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿é֧·Õý¶ÔµØµç×è(Ä£¿é9)'," +
|
" `insulat_branch_res_ne_9` float NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿é֧·¸º¶ÔµØµç×è(Ä£¿é9)'," +
|
" `insulat_branch_num_10` int(11) NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿é½ÓµØ֧·ºÅ(Ä£¿é10)'," +
|
" `insulat_branch_res_is_10` float NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿é֧·Õý¶ÔµØµç×è(Ä£¿é10)'," +
|
" `insulat_branch_res_ne_10` float NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿é֧·¸º¶ÔµØµç×è(Ä£¿é10)'," +
|
" `insulat_branch_num_11` int(11) NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿é½ÓµØ֧·ºÅ(Ä£¿é11)'," +
|
" `insulat_branch_res_is_11` float NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿é֧·Õý¶ÔµØµç×è(Ä£¿é11)'," +
|
" `insulat_branch_res_ne_11` float NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿é֧·¸º¶ÔµØµç×è(Ä£¿é11)'," +
|
" `insulat_branch_num_12` int(11) NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿é½ÓµØ֧·ºÅ(Ä£¿é12)'," +
|
" `insulat_branch_res_is_12` float NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿é֧·Õý¶ÔµØµç×è(Ä£¿é12)'," +
|
" `insulat_branch_res_ne_12` float NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿é֧·¸º¶ÔµØµç×è(Ä£¿é12)'," +
|
" `insulat_branch_num_13` int(11) NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿é½ÓµØ֧·ºÅ(Ä£¿é13)'," +
|
" `insulat_branch_res_is_13` float NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿é֧·Õý¶ÔµØµç×è(Ä£¿é13)'," +
|
" `insulat_branch_res_ne_13` float NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿é֧·¸º¶ÔµØµç×è(Ä£¿é13)'," +
|
" `insulat_branch_num_14` int(11) NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿é½ÓµØ֧·ºÅ(Ä£¿é14)'," +
|
" `insulat_branch_res_is_14` float NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿é֧·Õý¶ÔµØµç×è(Ä£¿é14)'," +
|
" `insulat_branch_res_ne_14` float NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿é֧·¸º¶ÔµØµç×è(Ä£¿é14)'," +
|
" `insulat_branch_num_15` int(11) NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿é½ÓµØ֧·ºÅ(Ä£¿é15)'," +
|
" `insulat_branch_res_is_15` float NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿é֧·Õý¶ÔµØµç×è(Ä£¿é15)'," +
|
" `insulat_branch_res_ne_15` float NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿é֧·¸º¶ÔµØµç×è(Ä£¿é15)'," +
|
" `insulat_branch_num_16` int(11) NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿é½ÓµØ֧·ºÅ(Ä£¿é12)'," +
|
" `insulat_branch_res_is_16` float NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿é֧·Õý¶ÔµØµç×è(Ä£¿é12)'," +
|
" `insulat_branch_res_ne_16` float NOT NULL DEFAULT '0' COMMENT '¾øÔµ¼à²âÄ£¿é֧·¸º¶ÔµØµç×è(Ä£¿é12)'," +
|
" `note` varchar(32) NOT NULL DEFAULT '' COMMENT '±¸ÓÃ'," +
|
" PRIMARY KEY (`num`,`PowerDeviceId`)," +
|
" KEY `index_PowerDeviceId` (`PowerDeviceId`) USING BTREE," +
|
" KEY `index_battgroupid` (`BattGroupId`) USING BTREE" +
|
") ENGINE=InnoDB AUTO_INCREMENT=4 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);
|
//ÒƳý֮ǰµÄÒÔµç³Ø×éidÉèÖõÄΨһË÷Òý
|
res = sql.sqlMysqlQuery("show INDEX FROM "+Sql_Mysql.FBS9100_InsulatstateTable+" WHERE KEY_name = 'unique_battgroupid'");
|
if(res.next()) {
|
sql.sqlMysqlExecute("alter table "+Sql_Mysql.FBS9100_InsulatstateTable+" drop index unique_battgroupid;");
|
}
|
//Ìí¼Ó×Ö¶ÎPowerDeviceId
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_fbs9100_insulatstate'"
|
+ " AND column_name='PowerDeviceId'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100_InsulatstateTable
|
+ " ADD COLUMN `PowerDeviceId` int(11) NOT NULL DEFAULT '1' COMMENT 'µçÔ´id'");
|
}
|
//Ìí¼Ó×Ö¶Îdev_version
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_fbs9100_insulatstate'"
|
+ " AND column_name='dev_version'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100_InsulatstateTable
|
+ " ADD COLUMN `dev_version` varchar(64) NOT NULL DEFAULT '' COMMENT 'Ðת°æ±¾ºÅ';");
|
}
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
if(null != res) {
|
try {
|
res.close();
|
} catch (SQLException e) {
|
e.printStackTrace();
|
}
|
}
|
sql.close_con();
|
}
|
}
|
|
/**
|
* ´´½¨ tb_fbs9100_collectionstate ±í
|
* @param pool
|
* @param recreate
|
*/
|
public static void createFBS9100_CollectionstateTable(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.FBS9100_CollectionstateTable;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.FBS9100_CollectionstateTable + " (" +
|
" `num` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'Ö÷¼ü'," +
|
" `BattGroupId` int(11) NOT NULL DEFAULT '0' COMMENT 'µç³Ø×éID'," +
|
" `record_time` datetime NOT NULL DEFAULT '2000-01-01 00:00:00' COMMENT '¼Ç¼ʱ¼ä'," +
|
" `col_version` float NOT NULL DEFAULT '0' COMMENT '»ã¼¯Æ÷°æ±¾'," +
|
" `col_state` int(11) NOT NULL DEFAULT '0' COMMENT '»ã¼¯Æ÷״̬'," +
|
" `col_vol` float NOT NULL DEFAULT '0' COMMENT '»ã¼¯Æ÷×éµçѹ'," +
|
" `col_curr` float NOT NULL DEFAULT '0' COMMENT '»ã¼¯Æ÷×éµçÁ÷'," +
|
" `col_batt_state` int(11) NOT NULL DEFAULT '0' COMMENT '»ã¼¯Æ÷µç³Ø״̬'," +
|
" `col_curr_dir` float NOT NULL DEFAULT '0' COMMENT '»ã¼¯Æ÷µçÁ÷·½Ïò'," +
|
" `col_mean_rip_curr` float NOT NULL DEFAULT '0' COMMENT '»ã¼¯Æ÷ÎƲ¨µçÁ÷¾ùÖµ'," +
|
" `col_peak_rip_curr` float NOT NULL DEFAULT '0' COMMENT '»ã¼¯Æ÷ÎƲ¨µçÁ÷·åÖµ'," +
|
" `col_restest_count` int(11) NOT NULL DEFAULT '0' COMMENT '»ã¼¯Æ÷ÄÚ×è²âÊÔ´ÎÊý'," +
|
" `col_restest_type` int(11) NOT NULL DEFAULT '0' COMMENT '»ã¼¯Æ÷ÄÚ×è²âÊÔ·½·¨'," +
|
" `note` varchar(255) NOT NULL DEFAULT '' COMMENT '±¸ÓÃ'," +
|
" PRIMARY KEY (`num`)," +
|
" UNIQUE KEY `unique_battgroupid` (`BattGroupId`) USING BTREE" +
|
") ENGINE=InnoDB AUTO_INCREMENT=4 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();
|
}
|
}
|
|
/**
|
* ´´½¨ tb_lithium_data ±í
|
* @param pool
|
* @param recreate
|
*/
|
public static void createTb_Lithium_DataTable(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Tb_Lithium_DataTable;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Tb_Lithium_DataTable + " (" +
|
" `num` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `BattGroupId` int(11) NOT NULL DEFAULT '1000001' COMMENT 'µç³Ø×éID'," +
|
" `record_time` datetime NOT NULL DEFAULT '2000-01-01 00:00:00' COMMENT '¼Ç¼ʱ¼ä'," +
|
" `envir_tmp` float NOT NULL DEFAULT '0' COMMENT '»·¾³Î¶È'," +
|
" `power_tmp` float NOT NULL DEFAULT '0' COMMENT '¹¦ÂÊζÈ'," +
|
" `rest_cap` float NOT NULL DEFAULT '0' COMMENT 'Ê£ÓàÈÝÁ¿'," +
|
" `remote_control_count` int(11) NOT NULL DEFAULT '0' COMMENT '×Ô¶¨ÒåÒ£¿ØÊýÁ¿'," +
|
" `batt_total_cap` float NOT NULL DEFAULT '0' COMMENT 'µç³Ø×ÜÈÝÁ¿'," +
|
" `batt_cycles` int(11) NOT NULL DEFAULT '0' COMMENT 'µç³ØÑ»·´ÎÊý'," +
|
" `evir_tmp_alm_state` int(11) NOT NULL DEFAULT '0' COMMENT '»·¾³Î¶ȸ澯״̬'," +
|
" `power_tmp_alm_state` int(11) NOT NULL DEFAULT '0' COMMENT '¹¦ÂÊζȸ澯״̬'," +
|
" `discharge_curr_alm_state` int(11) NOT NULL DEFAULT '0' COMMENT '³ä·ÅµçµçÁ÷¸æ¾¯×´Ì¬'," +
|
" `batt_totalvol_alm_state` int(11) NOT NULL DEFAULT '0' COMMENT 'µç³Ø×ܵçѹ¸æ¾¯×´Ì¬'," +
|
" `custom_alm_count` int(11) NOT NULL DEFAULT '0' COMMENT '×Ô¶¨Òå¸æ¾¯Á¿ÊýÁ¿'," +
|
" `junheng_event_code` int(11) NOT NULL DEFAULT '0' COMMENT '¾ùºâʼþ´úÂë'," +
|
" `vol_event_code` int(11) NOT NULL DEFAULT '0' COMMENT 'µçѹʼþ´úÂë'," +
|
" `tmp_event_code` int(11) NOT NULL DEFAULT '0' COMMENT 'ζÈʼþ´úÂë'," +
|
" `curr_event_code` int(11) NOT NULL DEFAULT '0' COMMENT 'µçÁ÷ʼþ´úÂë'," +
|
" `fet_state_code` int(11) NOT NULL DEFAULT '0' COMMENT 'FET״̬´úÂë'," +
|
" `junheng_state_code` int(11) NOT NULL DEFAULT '0' COMMENT '¾ùºâ״̬´úÂë'," +
|
" `sys_state_code` int(11) NOT NULL DEFAULT '0' COMMENT 'ϵͳ״̬´úÂë'," +
|
" `note` varchar(255) NOT NULL DEFAULT '' COMMENT '±¸ÓÃ'," +
|
" PRIMARY KEY (`num`)" +
|
") ENGINE=InnoDB 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();
|
}
|
}
|
|
/**
|
* ´´½¨×é¶ËÐÅÏ¢¸æ¾¯¼Ç¼±í
|
* @param pool
|
* @param recreate
|
*/
|
public static void createTb_Batt_RSAlarm_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Tb_Batt_RSAlarm_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Tb_Batt_RSAlarm_Table + " (" +
|
" `num` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `BattGroupId` int(11) NOT NULL DEFAULT '1000001' COMMENT 'µç³Ø×éID'," +
|
" `record_time` datetime NOT NULL DEFAULT '2000-01-01 00:00:00' COMMENT '¼Ç¼ʱ¼ä'," +
|
" `groupvol_alm` tinyint(4) NOT NULL DEFAULT '0' COMMENT '×éµçѹ¸æ¾¯'," +
|
" `test_end_vol` float NOT NULL DEFAULT '0' COMMENT '²âÊÔÖÕÖ¹µçѹ'," +
|
" `test_end_cap` float NOT NULL DEFAULT '0' COMMENT '²âÊÔÖÕֹʣÓàÈÝÁ¿'," +
|
" `test_timelong` int(11) NOT NULL DEFAULT '0' COMMENT '²âÊÔÖÕֹʱ¼ä(Ãë)'," +
|
" PRIMARY KEY (`num`)," +
|
" KEY `index_BattGroupId` (`BattGroupId`) USING BTREE," +
|
" KEY `index_record_time` (`record_time`) USING BTREE" +
|
") ENGINE=InnoDB DEFAULT CHARSET=utf8;";
|
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
|
|
try {
|
if(true == recreate) {
|
sql.sqlMysqlExecute(sql_str01);
|
}
|
//System.out.println(sql_str02);
|
sql.sqlMysqlExecute(sql_str02);
|
//Ìí¼Óδ¼Èëµç³Ø×éµÄ×é¶ËÐÅÏ¢
|
String sql_str03 = "INSERT INTO " + Sql_Mysql.Tb_Batt_RSAlarm_Table + " (BattGroupId)" +
|
" SELECT BattGroupId FROM " + Sql_Mysql.BattInf_Table +
|
" WHERE BattGroupId NOT IN (SELECT BattGroupId FROM " + Sql_Mysql.Tb_Batt_RSAlarm_Table + ")";
|
//System.out.println(sql_str03);
|
sql.sqlMysqlExecute(sql_str03);
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
sql.close_con();
|
}
|
}
|
|
/**
|
* ´´½¨µ¥ÌåÐÅÏ¢¸æ¾¯¼Ç¼±í
|
* @param pool
|
* @param recreate
|
*/
|
public static void createTb_Batt_RTAlarm_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Tb_Batt_RTAlarm_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Tb_Batt_RTAlarm_Table + " (" +
|
" `num` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `BattGroupId` int(11) NOT NULL DEFAULT '1000001' COMMENT 'µç³Ø×éid'," +
|
" `record_time` datetime NOT NULL DEFAULT '2000-01-01 00:00:00' COMMENT '¼Ç¼ʱ¼ä'," +
|
" `mon_num` int(11) NOT NULL DEFAULT '0' COMMENT 'µ¥Ìå±àºÅ'," +
|
" `monvol_alm` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'µ¥Ìåµçѹ¸æ¾¯'," +
|
" `montmp_alm` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'µ¥Ìåζȸ澯'," +
|
" `monres_alm` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'µ¥ÌåÄÚ×è¸æ¾¯'," +
|
" `monrestcap_alm` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'µ¥ÌåÊ£ÓàÈÝÁ¿¸æ¾¯'," +
|
" PRIMARY KEY (`num`)," +
|
" KEY `index_BattGroupId` (`BattGroupId`) USING BTREE," +
|
" KEY `index_record_time` (`record_time`) USING BTREE" +
|
") 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);
|
|
ResultSet res_t = sql.sqlMysqlQuery("SELECT BattGroupId,MonCount,FBSDeviceId,PackCount FROM " + Sql_Mysql.BattInf_Table);
|
while(res_t.next()) {
|
int bg_id = res_t.getInt("BattGroupId");
|
int mon_cnt = res_t.getInt("MonCount");
|
int packCount = res_t.getInt("PackCount");
|
int dev_id = res_t.getInt("FBSDeviceId");
|
if(checkLiBTSDevType(dev_id) && packCount > 0) {
|
mon_cnt = mon_cnt * packCount;
|
}
|
if(mon_cnt > 0){
|
|
int max_monnum = BattData_RT_RamDB_Thread_SQL.seachBattRTAlarmMaxMonNum(pool,bg_id); //µ±Ç°µç³Ø×éÔÚ tb_batt_rtdata ±íÖеÄ×î´óµ¥Ìå¸öÊý
|
if(mon_cnt > max_monnum){
|
//ÐèÒª´Ómax_monnum¿ªÊ¼Ìí¼Óµ¥Ìå¼Ç¼
|
String sql_str2 = "INSERT INTO " + Sql_Mysql.Tb_Batt_RTAlarm_Table + "(BattGroupId, mon_num)" + " VALUES ";
|
boolean isStart = true;
|
for(int mc = max_monnum; mc < mon_cnt; mc++) {
|
if(isStart) {
|
isStart = false;
|
}else{
|
sql_str2 += ",";
|
}
|
sql_str2 += "(" + bg_id + "," + (mc+1) + ")";
|
}
|
System.out.println("µç³Ø×é"+bg_id+"´Óµ¥Ìå"+(max_monnum+1)+"¿ªÊ¼ÔÚtb_batt_rtdata±íÖÐÌí¼Óµ¥ÌåÊý¾Ý at " + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms));
|
sql.sqlMysqlExecute(sql_str2);
|
}else if(mon_cnt < max_monnum){
|
//ɾ³ýµ±Ç°µç³Ø×éÖг¬¹ýµ¥Ìå¸öÊýµÄÊý¾Ý
|
String sql_str2 = " DELETE FROM " + Sql_Mysql.Tb_Batt_RTAlarm_Table + " WHERE BattGroupId = " +bg_id+ " AND mon_num > "+mon_cnt;
|
sql.sqlMysqlExecute(sql_str2);
|
System.out.println("µç³Ø×é"+bg_id+"´Óµ¥Ìå"+(mon_cnt+1)+"¿ªÊ¼É¾³ýtb_batt_rtdataµ¥ÌåÊý¾Ý at "+Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms));
|
}
|
}
|
}
|
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
sql.close_con();
|
}
|
}
|
|
|
/**
|
* ´´½¨ tb_fbs9100_chargerstate ±í
|
* @param pool
|
* @param recreate
|
*/
|
public static void createFBS9100_ChargerstateTable(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.FBS9100_ChargerstateTable;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.FBS9100_ChargerstateTable + " (" +
|
" `num` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'Ö÷¼ü'," +
|
" `PowerDeviceId` int(11) NOT NULL DEFAULT '1' COMMENT 'µçÔ´id'," +
|
" `BattGroupId` int(11) NOT NULL DEFAULT '0' COMMENT 'µç³Ø×éID'," +
|
" `record_time` datetime NOT NULL DEFAULT '2000-01-01 00:00:00' COMMENT '¼Ç¼ʱ¼ä'," +
|
" `dev_version` varchar(64) NOT NULL DEFAULT '' COMMENT 'Ðת°æ±¾ºÅ'," +
|
" `char_output_vol` float NOT NULL DEFAULT '0' COMMENT '³äµç»úÊä³öµçѹ'," +
|
" `char_output_curr` float NOT NULL DEFAULT '0' COMMENT '³äµç»úÊä³öµçÁ÷'," +
|
" `char_peak_rip_vol` float NOT NULL DEFAULT '0' COMMENT 'ÎƲ¨·åÖµ'," +
|
" `char_peak_rip_param` float NOT NULL DEFAULT '0' COMMENT 'ÎƲ¨·åֵϵÊý'," +
|
" `char_Uan` float NOT NULL DEFAULT '0' COMMENT 'Uan'," +
|
" `char_Ian` float NOT NULL DEFAULT '0' COMMENT 'Ian'," +
|
" `char_Ubn` float NOT NULL DEFAULT '0' COMMENT 'Ubn'," +
|
" `char_Ibn` float NOT NULL DEFAULT '0' COMMENT 'Ibn'," +
|
" `char_Ucn` float NOT NULL DEFAULT '0' COMMENT 'Ucn'," +
|
" `char_Icn` float NOT NULL DEFAULT '0' COMMENT 'Icn'," +
|
" `char_system_state` int(11) NOT NULL DEFAULT '0' COMMENT 'ϵͳ״̬'," +
|
" `note` varchar(255) NOT NULL DEFAULT '' COMMENT '±¸ÓÃ'," +
|
" PRIMARY KEY (`num`)," +
|
" KEY `index_battgroupid` (`BattGroupId`) USING BTREE," +
|
" KEY `index_PowerDeviceId` (`PowerDeviceId`) USING BTREE" +
|
") ENGINE=InnoDB AUTO_INCREMENT=4 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);
|
//ÒƳý֮ǰµÄÒÔµç³Ø×éidÉèÖõÄΨһË÷Òý
|
res = sql.sqlMysqlQuery("show INDEX FROM "+Sql_Mysql.FBS9100_ChargerstateTable+" WHERE KEY_name = 'unique_battgroupid'");
|
if(res.next()) {
|
sql.sqlMysqlExecute("alter table "+Sql_Mysql.FBS9100_ChargerstateTable+" drop index unique_battgroupid;");
|
}
|
//Ìí¼Ó×Ö¶ÎPowerDeviceId
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_fbs9100_chargerstate'"
|
+ " AND column_name='PowerDeviceId'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100_ChargerstateTable
|
+ " ADD COLUMN `PowerDeviceId` int(11) NOT NULL DEFAULT '1' COMMENT 'µçÔ´id';");
|
}
|
//Ìí¼Ó×Ö¶Îdev_version
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_ram_db'"
|
+ " AND table_name='tb_fbs9100_chargerstate'"
|
+ " AND column_name='dev_version'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100_ChargerstateTable
|
+ " ADD COLUMN `dev_version` varchar(64) NOT NULL DEFAULT '' COMMENT 'Ðת°æ±¾ºÅ';");
|
}
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
if(null != res) {
|
try {
|
res.close();
|
} catch (SQLException e) {
|
e.printStackTrace();
|
}
|
}
|
sql.close_con();
|
}
|
}
|
|
/**
|
* ´´½¨¸É½Óµã״̬±í
|
* @param pool
|
* @param recreate
|
*/
|
private static void createFBS9100s_stemnode_state_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.FBS9100s_stemnode_state_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.FBS9100s_stemnode_state_Table + " (" +
|
" `num` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `dev_id` int(11) NOT NULL," +
|
" `record_time` datetime NOT NULL DEFAULT '2000-01-01 00:00:00' COMMENT '¼Ç¼ʱ¼ä'," +
|
" `dryInputState` int(11) NOT NULL DEFAULT '0' COMMENT '¸É½ÚµãÊäÈë״̬'," +
|
" `dryOutputState` int(11) NOT NULL DEFAULT '0' COMMENT '¸É½ÚµãÊä³ö״̬'," +
|
" `volOutputState` int(11) NOT NULL DEFAULT '0' COMMENT '¸É½ÚµãµçѹÊä³ö״̬'," +
|
" `sumOutputVolt` float NOT NULL DEFAULT '0' COMMENT '×ÜÊä³öµçѹ'," +
|
" `sumOutputCur` float NOT NULL DEFAULT '0' COMMENT '×ÜÊä³öµçÁ÷'," +
|
" `outputVolt1` float NOT NULL DEFAULT '0' COMMENT 'Êä³öµçѹ1'," +
|
" `outputVolt2` float NOT NULL DEFAULT '0' COMMENT 'Êä³öµçѹ2'," +
|
" `outputVolt3` float NOT NULL DEFAULT '0' COMMENT 'Êä³öµçѹ3'," +
|
" `outputVolt4` float NOT NULL DEFAULT '0' COMMENT 'Êä³öµçѹ4'," +
|
" PRIMARY KEY (`num`)," +
|
" UNIQUE KEY `index_dev_id` (`dev_id`) USING BTREE" +
|
") ENGINE=InnoDB 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();
|
}
|
|
}
|
|
/**
|
* ´´½¨Ä¸Áª×´Ì¬±í
|
* @param pool
|
* @param recreate
|
*/
|
private static void createFBS9100s_buscouple_state_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.FBS9100s_buscouple_state_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.FBS9100s_buscouple_state_Table + " (" +
|
" `num` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `dev_id` int(11) NOT NULL DEFAULT '912000001' COMMENT 'É豸id'," +
|
" `record_time` datetime NOT NULL DEFAULT '2000-01-01 00:00:00' COMMENT '¼Ç¼ʱ¼ä'," +
|
" `fanglei_state` int(11) NOT NULL DEFAULT '0' COMMENT '·ÀÀ×״̬:0:δÁ¬½Ó;1:Õý³£¹¤×÷;2ÐèÒª¸ü»»·ÀÀ×É豸'," +
|
" `workstate` int(11) NOT NULL DEFAULT '0' COMMENT '¹¤×÷״̬'," +
|
" `rlayworkmode` int(11) NOT NULL DEFAULT '0' COMMENT '¿Õ¿ª²Ù×÷״̬'," +
|
" `rlyAstate` int(11) NOT NULL DEFAULT '0' COMMENT '¿ª¹ØÊäÈëON״̬'," +
|
" `rlyBstate` int(11) NOT NULL DEFAULT '0' COMMENT '¿ª¹ØÊäÈëOFF״̬'," +
|
" `stopreson` int(11) NOT NULL DEFAULT '0' COMMENT 'Í£Ö¹ÔÒò'," +
|
" `volt_m1` float NOT NULL DEFAULT '0' COMMENT 'µçѹ1'," +
|
" `volt_m2` float NOT NULL DEFAULT '0' COMMENT 'µçѹ2'," +
|
" `iout` float NOT NULL DEFAULT '0' COMMENT 'µçÁ÷'," +
|
" `curdir` int(11) NOT NULL DEFAULT '0' COMMENT 'µçÁ÷·½Ïò'," +
|
" `commustate` int(11) NOT NULL DEFAULT '0' COMMENT 'ͨÐÅ״̬'," +
|
" PRIMARY KEY (`num`)," +
|
" UNIQUE KEY `index_dev_id` (`dev_id`) USING BTREE" +
|
") ENGINE=InnoDB AUTO_INCREMENT=3 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();
|
}
|
|
}
|
|
/**
|
* ´´½¨³ä·ÅµçÒ»Ìå»úÏÂÔØ¿ØÖƱí
|
* @param pool
|
* @param recreate
|
*/
|
private static void createFgcd_filedownload_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Fgcd_filedownload_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Fgcd_filedownload_Table + " (" +
|
" `num` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `dev_id` int(11) NOT NULL DEFAULT '0' COMMENT 'É豸id'," +
|
" `BattGroupId` int(11) NOT NULL DEFAULT '0' COMMENT 'µç³Ø×éID'," +
|
" `op_cmd` int(11) NOT NULL DEFAULT '0' COMMENT 'ÃüÁî'," +
|
" `file_total` int(11) NOT NULL DEFAULT '0' COMMENT '×ܵÄÎļþÊýÄ¿'," +
|
" `file_count` int(11) NOT NULL DEFAULT '0' COMMENT 'µ±Ç°Ò³Êý¾ÝÎļþÊý'," +
|
" `file_index` int(11) NOT NULL DEFAULT '0' COMMENT 'ÐèÒªÏÂÔØÎļþË÷Òý'," +
|
" `file_name1` varchar(255) NOT NULL DEFAULT '' COMMENT 'ÎļþÃû1'," +
|
" `file_index1` int(11) NOT NULL DEFAULT '0' COMMENT 'ÎļþË÷Òý1'," +
|
" `test_timelong1` int(11) NOT NULL DEFAULT '0' COMMENT '²âÊÔʱ³¤1'," +
|
" `data_type1` int(11) NOT NULL DEFAULT '0' COMMENT 'Êý¾ÝÀàÐÍ1'," +
|
" `test_curr1` float NOT NULL DEFAULT '0' COMMENT '²âÊÔµçÁ÷1'," +
|
" `test_cap1` float NOT NULL DEFAULT '0' COMMENT '²âÊÔÈÝÁ¿1'," +
|
" `cap_std1` int(11) NOT NULL DEFAULT '0' COMMENT '±ê³ÆÈÝÁ¿1'," +
|
" `mon_count1` int(11) NOT NULL DEFAULT '0' COMMENT 'µ¥ÌåÊýÁ¿1'," +
|
" `mon_vol1` float NOT NULL DEFAULT '0' COMMENT 'µ¥ÌåµçѹÀàÐÍ1'," +
|
" `stop_type1` int(11) NOT NULL DEFAULT '0' COMMENT 'Í£Ö¹ÔÒò1'," +
|
" `download_flag1` int(11) NOT NULL DEFAULT '0' COMMENT 'ÏÂÔرêʶ1'," +
|
" `download_state1` int(11) NOT NULL DEFAULT '0' COMMENT 'ÏÂÔØ״̬1'," +
|
" `file_name2` varchar(255) NOT NULL DEFAULT '' COMMENT 'ÎļþÃû2'," +
|
" `file_index2` int(11) NOT NULL DEFAULT '0' COMMENT 'ÎļþË÷Òý2'," +
|
" `test_timelong2` int(11) NOT NULL DEFAULT '0' COMMENT '²âÊÔʱ³¤2'," +
|
" `data_type2` int(11) NOT NULL DEFAULT '0' COMMENT 'Êý¾ÝÀàÐÍ2'," +
|
" `test_curr2` float NOT NULL DEFAULT '0' COMMENT '²âÊÔµçÁ÷2'," +
|
" `test_cap2` float NOT NULL DEFAULT '0' COMMENT '²âÊÔÈÝÁ¿2'," +
|
" `cap_std2` int(11) NOT NULL DEFAULT '0' COMMENT '±ê³ÆÈÝÁ¿2'," +
|
" `mon_count2` int(11) NOT NULL DEFAULT '0' COMMENT 'µ¥ÌåÊýÁ¿2'," +
|
" `mon_vol2` float NOT NULL DEFAULT '0' COMMENT 'µ¥ÌåµçѹÀàÐÍ2'," +
|
" `stop_type2` int(11) NOT NULL DEFAULT '0' COMMENT 'Í£Ö¹ÔÒò2'," +
|
" `download_flag2` int(11) NOT NULL DEFAULT '0' COMMENT 'ÏÂÔرêʶ2'," +
|
" `download_state2` int(11) NOT NULL DEFAULT '0' COMMENT 'ÏÂÔØ״̬2'," +
|
" `file_name3` varchar(255) NOT NULL DEFAULT '' COMMENT 'ÎļþÃû3'," +
|
" `file_index3` int(11) NOT NULL DEFAULT '0' COMMENT 'ÎļþË÷Òý3'," +
|
" `test_timelong3` int(11) NOT NULL DEFAULT '0' COMMENT '²âÊÔʱ³¤3'," +
|
" `data_type3` int(11) NOT NULL DEFAULT '0' COMMENT 'Êý¾ÝÀàÐÍ3'," +
|
" `test_curr3` float NOT NULL DEFAULT '0' COMMENT '²âÊÔµçÁ÷3'," +
|
" `test_cap3` float NOT NULL DEFAULT '0' COMMENT '²âÊÔÈÝÁ¿3'," +
|
" `cap_std3` int(11) NOT NULL DEFAULT '0' COMMENT '±ê³ÆÈÝÁ¿3'," +
|
" `mon_count3` int(11) NOT NULL DEFAULT '0' COMMENT 'µ¥ÌåÊýÁ¿3'," +
|
" `mon_vol3` float NOT NULL DEFAULT '0' COMMENT 'µ¥ÌåµçѹÀàÐÍ3'," +
|
" `stop_type3` int(11) NOT NULL DEFAULT '0' COMMENT 'Í£Ö¹ÔÒò3'," +
|
" `download_flag3` int(11) NOT NULL DEFAULT '0' COMMENT 'ÏÂÔرêʶ3'," +
|
" `download_state3` int(11) NOT NULL DEFAULT '0' COMMENT 'ÏÂÔØ״̬3'," +
|
" `file_name4` varchar(255) NOT NULL DEFAULT '' COMMENT 'ÎļþÃû4'," +
|
" `file_index4` int(11) NOT NULL DEFAULT '0' COMMENT 'ÎļþË÷Òý4'," +
|
" `test_timelong4` int(11) NOT NULL DEFAULT '0' COMMENT '²âÊÔʱ³¤4'," +
|
" `data_type4` int(11) NOT NULL DEFAULT '0' COMMENT 'Êý¾ÝÀàÐÍ4'," +
|
" `test_curr4` float NOT NULL DEFAULT '0' COMMENT '²âÊÔµçÁ÷4'," +
|
" `test_cap4` float NOT NULL DEFAULT '0' COMMENT '²âÊÔÈÝÁ¿4'," +
|
" `cap_std4` int(11) NOT NULL DEFAULT '0' COMMENT '±ê³ÆÈÝÁ¿4'," +
|
" `mon_count4` int(11) NOT NULL DEFAULT '0' COMMENT 'µ¥ÌåÊýÁ¿4'," +
|
" `mon_vol4` float NOT NULL DEFAULT '0' COMMENT 'µ¥ÌåµçѹÀàÐÍ4'," +
|
" `download_flag4` int(11) NOT NULL DEFAULT '0' COMMENT 'ÏÂÔرêʶ4'," +
|
" `download_state4` int(11) NOT NULL DEFAULT '0' COMMENT 'ÏÂÔØ״̬4'," +
|
" `stop_type4` int(11) NOT NULL DEFAULT '0' COMMENT 'Í£Ö¹ÔÒò4'," +
|
" `file_name5` varchar(255) NOT NULL DEFAULT '' COMMENT 'ÎļþÃû5'," +
|
" `file_index5` int(11) NOT NULL DEFAULT '0' COMMENT 'ÎļþË÷Òý5'," +
|
" `test_timelong5` int(11) NOT NULL DEFAULT '0' COMMENT '²âÊÔʱ³¤5'," +
|
" `data_type5` int(11) NOT NULL DEFAULT '0' COMMENT 'Êý¾ÝÀàÐÍ5'," +
|
" `test_curr5` float NOT NULL DEFAULT '0' COMMENT '²âÊÔµçÁ÷5'," +
|
" `test_cap5` float NOT NULL DEFAULT '0' COMMENT '²âÊÔÈÝÁ¿5'," +
|
" `cap_std5` int(11) NOT NULL DEFAULT '0' COMMENT '±ê³ÆÈÝÁ¿5'," +
|
" `mon_count5` int(11) NOT NULL DEFAULT '0' COMMENT 'µ¥ÌåÊýÁ¿5'," +
|
" `mon_vol5` float NOT NULL DEFAULT '0' COMMENT 'µ¥ÌåµçѹÀàÐÍ5'," +
|
" `stop_type5` int(11) NOT NULL DEFAULT '0' COMMENT 'Í£Ö¹ÔÒò5'," +
|
" `download_flag5` int(11) NOT NULL DEFAULT '0' COMMENT 'ÏÂÔرêʶ5'," +
|
" `download_state5` int(11) NOT NULL DEFAULT '0' COMMENT 'ÏÂÔØ״̬5'," +
|
" `file_name6` varchar(255) NOT NULL DEFAULT '' COMMENT 'ÎļþÃû6'," +
|
" `file_index6` int(11) NOT NULL DEFAULT '0' COMMENT 'ÎļþË÷Òý6'," +
|
" `test_timelong6` int(11) NOT NULL DEFAULT '0' COMMENT '²âÊÔʱ³¤6'," +
|
" `data_type6` int(11) NOT NULL DEFAULT '0' COMMENT 'Êý¾ÝÀàÐÍ6'," +
|
" `test_curr6` float NOT NULL DEFAULT '0' COMMENT '²âÊÔµçÁ÷6'," +
|
" `test_cap6` float NOT NULL DEFAULT '0' COMMENT '²âÊÔÈÝÁ¿6'," +
|
" `cap_std6` int(11) NOT NULL DEFAULT '0' COMMENT '±ê³ÆÈÝÁ¿6'," +
|
" `mon_count6` int(11) NOT NULL DEFAULT '0' COMMENT 'µ¥ÌåÊýÁ¿6'," +
|
" `mon_vol6` float NOT NULL DEFAULT '0' COMMENT 'µ¥ÌåµçѹÀàÐÍ6'," +
|
" `stop_type6` int(11) NOT NULL DEFAULT '0' COMMENT 'Í£Ö¹ÔÒò6'," +
|
" `download_flag6` int(11) NOT NULL DEFAULT '0' COMMENT 'ÏÂÔرêʶ6'," +
|
" `download_state6` int(11) NOT NULL DEFAULT '0' COMMENT 'ÏÂÔØ״̬6'," +
|
" `file_name7` varchar(255) NOT NULL DEFAULT '' COMMENT 'ÎļþÃû7'," +
|
" `file_index7` int(11) NOT NULL DEFAULT '0' COMMENT 'ÎļþË÷Òý7'," +
|
" `test_timelong7` int(11) NOT NULL DEFAULT '0' COMMENT '²âÊÔʱ³¤7'," +
|
" `data_type7` int(11) NOT NULL DEFAULT '0' COMMENT 'Êý¾ÝÀàÐÍ7'," +
|
" `test_curr7` float NOT NULL DEFAULT '0' COMMENT '²âÊÔµçÁ÷7'," +
|
" `test_cap7` float NOT NULL DEFAULT '0' COMMENT '²âÊÔÈÝÁ¿7'," +
|
" `cap_std7` int(11) NOT NULL DEFAULT '0' COMMENT '±ê³ÆÈÝÁ¿7'," +
|
" `mon_count7` int(11) NOT NULL DEFAULT '0' COMMENT 'µ¥ÌåÊýÁ¿7'," +
|
" `mon_vol7` float NOT NULL DEFAULT '0' COMMENT 'µ¥ÌåµçѹÀàÐÍ7'," +
|
" `stop_type7` int(11) NOT NULL DEFAULT '0' COMMENT 'Í£Ö¹ÔÒò7'," +
|
" `download_flag7` int(11) NOT NULL DEFAULT '0' COMMENT 'ÏÂÔØ״̬7'," +
|
" `download_state7` int(11) NOT NULL DEFAULT '0' COMMENT 'ÏÂÔØ״̬7'," +
|
" `file_name8` varchar(255) NOT NULL DEFAULT '' COMMENT 'ÎļþÃû8'," +
|
" `file_index8` int(11) NOT NULL DEFAULT '0' COMMENT 'ÎļþË÷Òý8'," +
|
" `test_timelong8` int(11) NOT NULL DEFAULT '0' COMMENT '²âÊÔʱ³¤8'," +
|
" `data_type8` int(11) NOT NULL DEFAULT '0' COMMENT 'Êý¾ÝÀàÐÍ8'," +
|
" `test_curr8` float NOT NULL DEFAULT '0' COMMENT '²âÊÔµçÁ÷8'," +
|
" `test_cap8` float NOT NULL DEFAULT '0' COMMENT '²âÊÔÈÝÁ¿8'," +
|
" `cap_std8` int(11) NOT NULL DEFAULT '0' COMMENT '±ê³ÆÈÝÁ¿8'," +
|
" `mon_count8` int(11) NOT NULL DEFAULT '0' COMMENT 'µ¥ÌåÊýÁ¿8'," +
|
" `mon_vol8` float NOT NULL DEFAULT '0' COMMENT 'µ¥ÌåµçѹÀàÐÍ8'," +
|
" `stop_type8` int(11) NOT NULL DEFAULT '0' COMMENT 'Í£Ö¹ÔÒò8'," +
|
" `download_flag8` int(11) NOT NULL DEFAULT '0' COMMENT 'ÏÂÔرêʶ8'," +
|
" `download_state8` int(11) NOT NULL DEFAULT '0' COMMENT 'ÏÂÔØ״̬8'," +
|
" `stop_reason` int(11) NOT NULL DEFAULT '0' COMMENT 'Ò쳣ֹͣÔÒò'," +
|
" `download_state` int(11) NOT NULL DEFAULT '0' COMMENT 'ÏÂÔØ״̬[1:ÏÂÔØÎļþ;2:Éú³ÉÎļþ;3:½âÎöÊý¾Ý;4:µ¼ÈëÍê³É]'," +
|
" `now_data_block` int(11) NOT NULL DEFAULT '0' COMMENT 'µ±Ç°ÏÂÔؽø¶È'," +
|
" `total_data_block` int(11) NOT NULL DEFAULT '0' COMMENT '×ܵÄÊý¾Ý¿éÊý'," +
|
" PRIMARY KEY (`num`)," +
|
" UNIQUE KEY `index_dev_id` (`dev_id`) USING BTREE" +
|
") 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();
|
}
|
|
}
|
/**
|
* УÑ鵱ǰÉ豸ÊÇ·ñÊÇ﮵çBTS
|
* @param dev_id
|
* @return
|
*/
|
public static boolean checkLiBTSDevType(int dev_id) {
|
if(dev_id/100000 == 9131) {
|
return true;
|
}
|
return false;
|
}
|
}
|
