From 9aebb4866e8bd2a3680d3117c7b8c6086ba30151 Mon Sep 17 00:00:00 2001
From: DELL <1525436766@qq.com>
Date: 星期三, 30 十月 2024 09:39:46 +0800
Subject: [PATCH] 3.插入默认账号逻辑为根据用户id识别，山西太原需频闭admin字眼账号名称
---
BattMonitor_DB_Builder/src/com/database_util/DB_db_user.java | 14 ++++++++------
1 files changed, 8 insertions(+), 6 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 b045d60..58efaa5 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
@@ -1498,7 +1498,7 @@
//默认新增系统默认的账号superuser,admin
{
//添加admin
- res = sql.sqlMysqlQuery("SELECT COUNT(*) as num_count FROM " + Sql_Mysql.TB_UserInf + " WHERE uName = 'admin';");
+ res = sql.sqlMysqlQuery("SELECT COUNT(*) as num_count FROM " + Sql_Mysql.TB_UserInf + " WHERE uId = 1001;");
if(res.next()) {
int count = res.getInt("num_count");
if(count<1) {
@@ -1507,7 +1507,7 @@
sql.sqlMysqlExecute("INSERT INTO "+Sql_Mysql.TB_UserInf+"(uId,uSnId,uName,uMobilephone,uJobGroup,upassword,login_type,uRole,type,status,last_login_time,password_update_time,create_time,visit_time,visit_ip) VALUES(1001,'" + upstr + "', 'admin','','默认班组','" + upstr + "',1,0,1,1,'"+Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms)+"',null,'2021-12-14 16:16:04','00:00:00~23:59:59','*');");
}else {
//修复前期添加默认账号时添加成了临时账号
- sql.sqlMysqlExecute("UPDATE " + Sql_Mysql.UserInfTable + " SET type = 1,expiration_time = null,lock_time = null,visit_time='00:00:00~23:59:59',visit_ip = '*' WHERE uName = 'admin'");
+ sql.sqlMysqlExecute("UPDATE " + Sql_Mysql.UserInfTable + " SET type = 1,expiration_time = null,lock_time = null,visit_time='00:00:00~23:59:59',visit_ip = '*' WHERE uId = 1001");
}
}
//添加superuser
@@ -1529,7 +1529,7 @@
//默认新增指定UID = 0;1;2的 账号
{
- res = sql.sqlMysqlQuery("SELECT COUNT(*) as num_count FROM " + Sql_Mysql.TB_UserInf + " WHERE uName = '未登录的用户账号';");
+ res = sql.sqlMysqlQuery("SELECT COUNT(*) as num_count FROM " + Sql_Mysql.TB_UserInf + " WHERE uId = 0;");
if(res.next()) {
int count = res.getInt("num_count");
if(count<1) {
@@ -1537,11 +1537,12 @@
sql.sqlMysqlExecute("INSERT INTO "+Sql_Mysql.TB_UserInf+"(uId,uSnId,uName,uMobilephone,uJobGroup,upassword,login_type,uRole,type,status,last_login_time,password_update_time,create_time,visit_time,visit_ip) VALUES('0','未登录的用户账号','未登录的用户账号','','','',1,0,1,1,null,'2021-12-14 16:18:44','2021-12-14 16:18:44','00:00:00~23:59:59','*');");
}
- sql.sqlMysqlExecute("UPDATE " + Sql_Mysql.TB_UserInf + " SET uId = 0 WHERE uName = '未登录的用户账号'");
+ //sql.sqlMysqlExecute("UPDATE " + Sql_Mysql.TB_UserInf + " SET uId = 0 WHERE uName = '未登录的用户账号'");
}
//添加默认账号sys_admin
- res = sql.sqlMysqlQuery("SELECT COUNT(*) as num_count FROM " + Sql_Mysql.TB_UserInf + " WHERE uName = 'sys_admin';");
+// res = sql.sqlMysqlQuery("SELECT COUNT(*) as num_count FROM " + Sql_Mysql.TB_UserInf + " WHERE uName = 'sys_admin';");
+ res = sql.sqlMysqlQuery("SELECT COUNT(*) as num_count FROM " + Sql_Mysql.TB_UserInf + " WHERE uId = 1;");
if(res.next()) {
int count = res.getInt("num_count");
if(count<1) {
@@ -1551,7 +1552,8 @@
}
//添加默认账号audit_admin
- res = sql.sqlMysqlQuery("SELECT COUNT(*) as num_count FROM " + Sql_Mysql.TB_UserInf + " WHERE uName = 'audit_admin';");
+ res = sql.sqlMysqlQuery("SELECT COUNT(*) as num_count FROM " + Sql_Mysql.TB_UserInf + " WHERE uId = 2;");
+// res = sql.sqlMysqlQuery("SELECT COUNT(*) as num_count FROM " + Sql_Mysql.TB_UserInf + " WHERE uName = 'audit_admin';");
if(res.next()) {
int count = res.getInt("num_count");
if(count<1) {
--
Gitblit v1.9.1