package com.database_util;
|
|
import java.sql.SQLException;
|
|
import com.sql.MysqlConnPool;
|
import com.sql.Sql_Mysql;
|
|
public class DB_Pwrdev_Data_Rt {
|
public static void init(MysqlConnPool pool, boolean recreate) {
|
createDB_PWRDEV_DATA_RT (pool);
|
|
createPwrdev_Acdata_Table(pool, recreate);
|
|
createPwrdev_Acdcdata_Table(pool, recreate);
|
|
createPwrdev_Dcdata_Table(pool, recreate);
|
}
|
|
/**
|
* ´´½¨ db_pwrdev_data_rt Êý¾Ý¿â
|
* @param pool
|
*/
|
private static void createDB_PWRDEV_DATA_RT(MysqlConnPool pool) {
|
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
|
try {
|
sql.sqlMysqlExecute("CREATE DATABASE IF NOT EXISTS " + Sql_Mysql.DB_PWRDEV_DATA_RT);
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
sql.close_con();
|
}
|
}
|
|
/**
|
* ´´½¨ tb_pwrdev_acdcdata ±í
|
* @param pool
|
* @param recreate
|
*/
|
public static void createPwrdev_Acdcdata_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Pwrdev_Acdcdata_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Pwrdev_Acdcdata_Table + " (" +
|
" `num` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `PowerDeviceId` bigint(20) NOT NULL DEFAULT '0'," +
|
" `record_datetime` datetime NOT NULL DEFAULT '2005-01-01 00:00:00'," +
|
" `acIn1_volA` float NOT NULL DEFAULT '0'," +
|
" `acIn1_volB` float NOT NULL DEFAULT '0'," +
|
" `acIn1_volC` float NOT NULL DEFAULT '0'," +
|
" `acIn2_volA` float NOT NULL DEFAULT '0'," +
|
" `acIn2_volB` float NOT NULL DEFAULT '0'," +
|
" `acIn2_volC` float NOT NULL DEFAULT '0'," +
|
" `acOut_volA` float NOT NULL DEFAULT '0'," +
|
" `acOut_volB` float NOT NULL DEFAULT '0'," +
|
" `acOut_volC` float NOT NULL DEFAULT '0'," +
|
" `acOut_currA` float NOT NULL DEFAULT '0'," +
|
" `acOut_currB` float NOT NULL DEFAULT '0'," +
|
" `acOut_currC` float NOT NULL DEFAULT '0'," +
|
" `dcOut_vol` float NOT NULL DEFAULT '0'," +
|
" `dcOut_curr` float NOT NULL DEFAULT '0'," +
|
" `battgroup1_vol` float NOT NULL DEFAULT '0'," +
|
" `battgroup1_curr` float NOT NULL DEFAULT '0'," +
|
" `battgroup2_vol` float NOT NULL DEFAULT '0'," +
|
" `battgroup2_curr` float NOT NULL DEFAULT '0'," +
|
" `temprature` float NOT NULL DEFAULT '0'," +
|
" `m_outputvol` float NOT NULL DEFAULT '0'," +
|
" `m1_outCurr` float NOT NULL DEFAULT '0'," +
|
" `m2_outCurr` float NOT NULL DEFAULT '0'," +
|
" `m3_outCurr` float NOT NULL DEFAULT '0'," +
|
" `m4_outCurr` float NOT NULL DEFAULT '0'," +
|
" `m5_outCurr` float NOT NULL DEFAULT '0'," +
|
" `m6_outCurr` float NOT NULL DEFAULT '0'," +
|
" `m7_outCurr` float NOT NULL DEFAULT '0'," +
|
" `m8_outCurr` float NOT NULL DEFAULT '0'," +
|
" `m9_outCurr` float NOT NULL DEFAULT '0'," +
|
" `m10_outCurr` float NOT NULL DEFAULT '0'," +
|
" `m11_outCurr` float NOT NULL DEFAULT '0'," +
|
" `m12_outCurr` float NOT NULL DEFAULT '0'," +
|
" `m13_outCurr` float NOT NULL DEFAULT '0'," +
|
" `m14_outCurr` float NOT NULL DEFAULT '0'," +
|
" `m15_outCurr` float NOT NULL DEFAULT '0'," +
|
" `m16_outCurr` float NOT NULL DEFAULT '0'," +
|
" `is_acIn1_over_volA` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_under_volA` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_less_A` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_over_volB` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_under_volB` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_less_B` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_over_volC` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_under_volC` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_less_C` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_thunder_err` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_powerdown` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_over_volA` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_under_volA` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_less_A` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_over_volB` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_under_volB` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_less_B` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_over_volC` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_under_volC` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_less_C` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_thunder_err` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_powerdown` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn_monitorerr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_dcOut_over_vol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_dcOut_under_vol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_battgroup_down` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_jun_charge` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acdcMod1_err` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod1_off` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod2_err` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod2_off` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod3_err` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod3_off` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod4_err` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod4_off` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod5_err` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod5_off` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod6_err` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod6_off` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod7_err` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod7_off` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod8_err` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod8_off` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod9_err` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod9_off` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod10_err` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod10_off` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod11_err` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod11_off` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod12_err` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod12_off` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod13_err` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod13_off` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod14_err` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod14_off` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod15_err` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod15_off` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod16_err` float NOT NULL DEFAULT '0'," +
|
" `is_acdcMod16_off` float NOT NULL DEFAULT '0'," +
|
" `is_acIn1_trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_loader_fuse` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_battgroup1_fuse` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_battgroup2_fuse` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_total_alarm` tinyint(1) NOT NULL DEFAULT '0'," +
|
" PRIMARY KEY (`num`)," +
|
" KEY `index_powerdev_id` (`PowerDeviceId`)" +
|
") 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();
|
}
|
}
|
|
/**
|
* ´´½¨ tb_pwrdev_dcdata ±í
|
* @param pool
|
* @param recreate
|
*/
|
public static void createPwrdev_Dcdata_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Pwrdev_Dcdata_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Pwrdev_Dcdata_Table + " (" +
|
" `num` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `PowerDeviceId` bigint(20) NOT NULL DEFAULT '0'," +
|
" `record_datetime` datetime NOT NULL DEFAULT '2005-01-01 00:00:00'," +
|
" `dcIn1_vol` float NOT NULL DEFAULT '0'," +
|
" `dcIn2_vol` float NOT NULL DEFAULT '0'," +
|
" `dcOut1_vol` float NOT NULL DEFAULT '0'," +
|
" `dcOut1_curr` float NOT NULL DEFAULT '0'," +
|
" `dcOut2_vol` float NOT NULL DEFAULT '0'," +
|
" `dcOut2_curr` float NOT NULL DEFAULT '0'," +
|
" `temprature` float NOT NULL DEFAULT '0'," +
|
" `is_dc1_over_vol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_dc1_under_vol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_dc2_over_vol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_dc2_under_vol` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_dc_monitorerr` tinyint(1) NOT NULL," +
|
" `is_tempalarm` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw1_sw1trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw1_sw2trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw1_sw3trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw1_sw4trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw1_sw5trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw1_sw6trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw1_sw7trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw1_sw8trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw1_sw9trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw2_sw1trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw2_sw2trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw2_sw3trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw2_sw4trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw2_sw5trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw2_sw6trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw2_sw7trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw2_sw8trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw2_sw9trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_total_alarm` tinyint(1) NOT NULL DEFAULT '0'," +
|
" PRIMARY KEY (`num`)," +
|
" KEY `index_powerdev_id` (`PowerDeviceId`)" +
|
") 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_pwrdev_acdata ±í
|
* @param pool
|
* @param recreate
|
*/
|
public static void createPwrdev_Acdata_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Pwrdev_Acdata_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Pwrdev_Acdata_Table + " (" +
|
" `num` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `PowerDeviceId` bigint(20) NOT NULL DEFAULT '0'," +
|
" `record_datetime` datetime NOT NULL DEFAULT '2005-01-01 00:00:00'," +
|
" `acIn1_volA` float NOT NULL DEFAULT '0'," +
|
" `acIn1_volB` float NOT NULL DEFAULT '0'," +
|
" `acIn1_volC` float NOT NULL DEFAULT '0'," +
|
" `acIn1_currA` float NOT NULL DEFAULT '0'," +
|
" `acIn1_currB` float NOT NULL DEFAULT '0'," +
|
" `acIn1_currC` float NOT NULL DEFAULT '0'," +
|
" `acIn2_volA` float NOT NULL DEFAULT '0'," +
|
" `acIn2_volB` float NOT NULL DEFAULT '0'," +
|
" `acIn2_volC` float NOT NULL DEFAULT '0'," +
|
" `acIn2_currA` float NOT NULL DEFAULT '0'," +
|
" `acIn2_currB` float NOT NULL DEFAULT '0'," +
|
" `acIn2_currC` float NOT NULL DEFAULT '0'," +
|
" `temprature` float NOT NULL DEFAULT '0'," +
|
" `is_acIn1_over_volA` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_under_volA` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_less_A` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_over_volB` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_under_volB` tinyint(1) NOT NULL," +
|
" `is_acIn1_less_B` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_over_volC` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_under_volC` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_less_C` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_thunder_err` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_over_volA` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_under_volA` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_less_A` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_over_volB` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_under_volB` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_less_B` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_over_volC` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_under_volC` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_less_C` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_thunder_err` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_powerdown` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_monitorerr` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_powerdown` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn1_trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_acIn2_trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw1_sw1trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw1_sw2trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw1_sw3trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw1_sw4trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw1_sw5trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw1_sw6trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw1_sw7trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw1_sw8trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw1_sw9trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw2_sw1trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw2_sw2trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw2_sw3trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw2_sw4trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw2_sw5trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw2_sw6trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw2_sw7trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw2_sw8trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_fsw2_sw9trip` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `is_total_alarm` tinyint(1) NOT NULL DEFAULT '0'," +
|
" PRIMARY KEY (`num`)," +
|
" KEY `index_powerdev_id` (`PowerDeviceId`)" +
|
") 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();
|
}
|
}
|
}
|
