From f7e3bdab2bfe045ce3d0e68ecdddd54ce358a9c5 Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期二, 01 三月 2022 16:05:40 +0800
Subject: [PATCH] 2.表 `db_user`.`tb_user_inf` 默认插入默认账号 ['未登录的用户账号','sys_admin','audit_admin']
---
BattMonitor_DB_Builder/src/com/database_util/DB_db_user.java | 35 +++++++++++++++++++++++++++++++++++
1 files changed, 35 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 214f8bd..5ec5095 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
@@ -1001,6 +1001,41 @@
}
}
+ //默认新增指定UID = 0;1;2的 账号
+ {
+ res = sql.sqlMysqlQuery("SELECT COUNT(*) as num_count FROM " + Sql_Mysql.TB_UserInf + " WHERE uName = '未登录的用户账号';");
+ if(res.next()) {
+ int count = res.getInt("num_count");
+ if(count<1) {
+ //默认没有添加用户信息时添加'未登录的用户账号'
+ 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 = '未登录的用户账号'");
+ }
+
+ res = sql.sqlMysqlQuery("SELECT COUNT(*) as num_count FROM " + Sql_Mysql.TB_UserInf + " WHERE uName = 'sys_admin';");
+ if(res.next()) {
+ int count = res.getInt("num_count");
+ if(count<1) {
+ //默认没有添加用户信息时添加'未登录的用户账号'
+ 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(1,'sys123456', 'sys_admin','','默认班组','61b3151941bb43fad57005524d1a967c',1,0,1,1,'2022-02-14 16:02:01',null,'2021-12-14 16:16:04','00:00:00~23:59:59','*');");
+ }
+ }
+
+ 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) {
+ //默认没有添加用户信息时添加'未登录的用户账号'
+ 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(2,'audit123456', 'audit_admin','','默认班组','2abdaafa43d93077a514146476ed59db',1,0,1,1,null,'2021-12-14 16:18:44','2021-12-14 16:18:44','00:00:00~23:59:59','*');");
+ }
+ }
+
+ }
+
+
+
//添加type
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ " WHERE table_schema='db_user'"
--
Gitblit v1.9.1