From 6a598cfca96b698d7018789fa1837d24818f8de5 Mon Sep 17 00:00:00 2001
From: DELL <1525436766@qq.com>
Date: 星期一, 28 十月 2024 10:13:06 +0800
Subject: [PATCH] V2.07 edit at date 2024-10-28 1.表'db_app_sys.tb_page_param'表中默认新增用户密码时效配置，默认插入值'-1'-永不失效 INSERT INTO `db_app_sys`.`tb_page_param`(`id`, `param`, `status`, `categoryId`,paramEnUs) VALUES ('57', '用户密码时效', '-1', '15',''); 2.表'db_user.tb_user_inf'更新字段'password_update_time'中密码为'Null'的记录为当前时间 UPDATE db_user.tb_user_inf SET password_update_time = NOW() WHERE password_update_time IS NULL;
---
BattMonitor_DB_Builder/src/com/database_util/DB_db_user.java | 3 +++
1 files changed, 3 insertions(+), 0 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/database_util/DB_db_user.java b/BattMonitor_DB_Builder/src/com/database_util/DB_db_user.java
index 22fa606..b045d60 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_db_user.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/DB_db_user.java
@@ -1569,6 +1569,9 @@
sql.sqlMysqlExecute("UPDATE " + Sql_Mysql.TB_UserInf + " SET uSex = '0' WHERE uSex != '女' AND uSex != '1'");
//将用户女更新为1
sql.sqlMysqlExecute("UPDATE " + Sql_Mysql.TB_UserInf + " SET uSex = '1' WHERE uSex = '女'");
+
+ //将用户表中上次密码更新时间为'Null'的记录更新为当前时间
+ sql.sqlMysqlExecute("UPDATE " + Sql_Mysql.TB_UserInf + " SET password_update_time = NOW() WHERE password_update_time IS NULL;");
} catch (SQLException e) {
--
Gitblit v1.9.1