From 351bbd8738c89c0302465360c1ca0c92abd18eba Mon Sep 17 00:00:00 2001 From: DELL <1525436766@qq.com> Date: 星期五, 07 二月 2025 13:34:35 +0800 Subject: [PATCH] 新增统计月份，季度，年度统计开锁次数 --- ElectLock_Monitor/src/com/sql/Sql_Mysql.java | 14 ++++++++++++-- 1 files changed, 12 insertions(+), 2 deletions(-) diff --git a/ElectLock_Monitor/src/com/sql/Sql_Mysql.java b/ElectLock_Monitor/src/com/sql/Sql_Mysql.java index c9fbd33..4f8f18d 100644 --- a/ElectLock_Monitor/src/com/sql/Sql_Mysql.java +++ b/ElectLock_Monitor/src/com/sql/Sql_Mysql.java @@ -13,17 +13,27 @@ 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 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"; //閿佸叿寮�閿佹鏁扮粺璁¤〃 /*********************************************************/ - /*************** ******************************************/ + /*************** ************ 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_Table = DB_AREA + ".tb_auth_idcard"; //鎵归噺娣诲姞鎺堟潈鍜屽彇娑堟巿鏉冭〃 public static final String Auth_Idcard_His_Table = DB_AREA + ".tb_auth_idcard_his"; //鎵归噺娣诲姞鎺堟潈鍜屽彇娑堟巿鏉冨巻鍙茶〃 /*********************************************************/ + /***************************** db_lock_his ****************************/ + public static final String Lock_His_Table = DB_LOCK_HIS + ".tb_lock_his_"; //閿佸叿寮�閿佹鏁扮粺璁¤〃 + + /*********************************************************/ + /***************************** db_user ****************************/ + public static final String Process_Survey_Table = DB_USER + ".tb_process_survey"; //绾跨▼绠＄悊琛� + + /*********************************************************/ public Logger logger; public Connection mysql_con; -- Gitblit v1.9.1