| | |
|---|
| | | import org.apache.logging.log4j.Logger;
|
|---|
| | |
|
|---|
| | | public class Sql_Mysql {
|
|---|
| | | public static final String DB_AREA = "`db_area`";
|
|---|
| | | public static final String DB_LOCK_RAM = "`db_lock_ram`";
|
|---|
| | | public static final String DB_USER = "`db_user`";
|
|---|
| | | public static final String DB_LOCK_HIS = "`db_lock_his`"; //锁具历史状态库
|
|---|
| | | public static final String PLUS_INF = "`plus_inf`";
|
|---|
| | | public static final String PLUS_LOCK_RAM = "`plus_lock_ram`";
|
|---|
| | | public static final String PLUS_USER = "`plus_user`";
|
|---|
| | | public static final String PLUS_LOCK_HIS = "`plus_lock_his`"; //锁具历史状态库
|
|---|
| | | public static final String PLUS_LOCK_ALARM = "`plus_lock_alarm`"; //锁具告警库
|
|---|
| | | // public static final String DB_AREA = "`db_area`";
|
|---|
| | | // public static final String DB_LOCK_RAM = "`db_lock_ram`";
|
|---|
| | | // public static final String DB_USER = "`db_user`";
|
|---|
| | | // public static final String DB_LOCK_HIS = "`db_lock_his`"; //锁具历史状态库
|
|---|
| | | // public static final String DB_LOCK_ALARM = "`db_lock_alarm`"; //锁具告警库
|
|---|
| | |
|
|---|
| | | /*********************************************************/
|
|---|
| | | public static final String Lock_Rt_Table = DB_LOCK_RAM + ".tb_lock_rt";
|
|---|
| | | public static final String Lock_Ctl_Log_Table = DB_LOCK_RAM + ".tb_lock_ctl_log";
|
|---|
| | | public static final String Lock_Report_Table = DB_LOCK_RAM + ".tb_lock_report"; //锁具开锁次数统计表
|
|---|
| | | public static final String Lock_Rt_Table = PLUS_LOCK_RAM + ".tb_lock_rt";
|
|---|
| | | public static final String Lock_Ctl_Log_Table = PLUS_LOCK_RAM + ".tb_lock_ctl_log";
|
|---|
| | | public static final String Lock_Report_Table = PLUS_LOCK_RAM + ".tb_lock_report"; //锁具开锁次数统计表
|
|---|
| | | public static final String Plate_Info_Table = PLUS_LOCK_RAM + ".tb_plate_info"; //平台锁具模式设定表
|
|---|
| | | public static final String Lock_IdCard_Table = PLUS_LOCK_RAM + ".tb_lock_idcard"; //锁具已授权ID卡
|
|---|
| | | /*********************************************************/
|
|---|
| | | /*************** ************ db_area ******************************/
|
|---|
| | | public static final String Lock_Inf_Table = DB_AREA + ".tb_lock_inf";
|
|---|
| | | public static final String Key_Inf_Table = DB_AREA + ".tb_key_inf";
|
|---|
| | | public static final String Auth_Idcard_Table = DB_AREA + ".tb_auth_idcard"; //批量添加授权和取消授权表
|
|---|
| | | public static final String Auth_Idcard_His_Table = DB_AREA + ".tb_auth_idcard_his"; //批量添加授权和取消授权历史表
|
|---|
| | | public static final String Lock_Inf_Table = PLUS_INF + ".tb_lock_inf";
|
|---|
| | | public static final String Key_Inf_Table = PLUS_INF + ".tb_key_inf";
|
|---|
| | | public static final String Auth_Idcard_Table = PLUS_INF + ".tb_auth_idcard"; //批量添加授权和取消授权表
|
|---|
| | | public static final String Auth_Idcard_His_Table = PLUS_INF + ".tb_auth_idcard_his"; //批量添加授权和取消授权历史表
|
|---|
| | | public static final String Lock_BL_Table = PLUS_INF + ".tb_lock_bl"; //蓝牙定时开启计划
|
|---|
| | | /*********************************************************/
|
|---|
| | | /***************************** db_lock_his ****************************/
|
|---|
| | | public static final String Lock_His_Table = DB_LOCK_HIS + ".tb_lock_his_"; //锁具开锁次数统计表
|
|---|
| | | public static final String Lock_His_Table = PLUS_LOCK_HIS + ".tb_lock_his_"; //锁具开锁次数统计表
|
|---|
| | |
|
|---|
| | | /*********************************************************/
|
|---|
| | | /***************************** db_user ****************************/
|
|---|
| | | public static final String Process_Survey_Table = DB_USER + ".tb_process_survey"; //线程管理表
|
|---|
| | | public static final String Process_Survey_Table = PLUS_USER + ".tb_process_survey"; //线程管理表
|
|---|
| | | |
|---|
| | | /***************************** db_lock_alarm ****************************/
|
|---|
| | |
|
|---|
| | | public static final String Lock_Alarm_Table = PLUS_LOCK_ALARM + ".tb_lock_alarm"; //实时告警
|
|---|
| | | public static final String Lock_Alm_Temp_Table = PLUS_LOCK_ALARM + ".tb_lock_alm_temp"; //告警临时表
|
|---|
| | | public static final String Lock_Alarm_His_Table = PLUS_LOCK_ALARM + ".tb_lock_alarm_"; //历史告警表
|
|---|
| | |
|
|---|
| | | /*********************************************************/
|
|---|
| | |
|
|---|
