From eb746715527db9b42740db84bb576735185e21cd Mon Sep 17 00:00:00 2001
From: DELL <1525436766@qq.com>
Date: 星期一, 28 四月 2025 15:30:27 +0800
Subject: [PATCH] 11111
---
ElectLock_Monitor/src/com/sql/Sql_Mysql.java | 45 +++++++++++++++++++++++++++++++++++----------
1 files changed, 35 insertions(+), 10 deletions(-)
diff --git a/ElectLock_Monitor/src/com/sql/Sql_Mysql.java b/ElectLock_Monitor/src/com/sql/Sql_Mysql.java
index c9fbd33..ddba2b0 100644
--- a/ElectLock_Monitor/src/com/sql/Sql_Mysql.java
+++ b/ElectLock_Monitor/src/com/sql/Sql_Mysql.java
@@ -10,19 +10,44 @@
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 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_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"; //閿佸叿宸叉巿鏉僆D鍗�
/*********************************************************/
- /*************** ******************************************/
- 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"; //鎵归噺娣诲姞鎺堟潈鍜屽彇娑堟巿鏉冨巻鍙茶〃
+ /*************** ************ db_area ******************************/
+ 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 = PLUS_LOCK_HIS + ".tb_lock_his_"; //閿佸叿寮�閿佹鏁扮粺璁¤〃
+
+ /*********************************************************/
+ /***************************** db_user ****************************/
+ 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_"; //鍘嗗彶鍛婅琛�
+
/*********************************************************/
public Logger logger;
--
Gitblit v1.9.1