From 02c3f341fd8b1d4f7806d7cc240a1cb2d7b63f15 Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期四, 16 六月 2022 17:12:33 +0800
Subject: [PATCH] V1.31 edit at date 2022-06-16 1.新增初始化创建表`web_site`.`tb_map_outline`"表[首页轮廓图表] 2.新增初始化创建表`db_battinf`.`tb_battmon_standardcurve`表[标准曲线表]
---
BattMonitor_DB_Builder/src/com/database_util/DB_db_user.java | 18 +++++++++++++-----
1 files changed, 13 insertions(+), 5 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 8c60812..2438ea9 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
@@ -2,7 +2,9 @@
import java.sql.ResultSet;
import java.sql.SQLException;
+import java.util.Date;
+import com.base.Com;
import com.sql.MysqlConnPool;
import com.sql.Sql_Mysql;
@@ -1271,6 +1273,7 @@
// sql.sqlMysqlExecute(sql_str01);
// }
sql.sqlMysqlUseDB(Sql_Mysql.DB_USER);
+
sql.sqlMysqlExecute(sql_str02);
//添加加密告警upassword
@@ -1355,7 +1358,7 @@
}
- //修改usnid的长度
+ //修改usnid的长度改成varchar(200)
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ " WHERE table_schema='db_user'"
+ " AND table_name='tb_user_inf'"
@@ -1364,7 +1367,7 @@
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.TB_UserInf
+ " CHANGE COLUMN `uSnId` `uSnId` VARCHAR(200) NOT NULL DEFAULT '123456';");
}
- //修改password的长度
+ //修改password的长度改成varchar(200)
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ " WHERE table_schema='db_user'"
+ " AND table_name='tb_user_inf'"
@@ -1476,8 +1479,8 @@
int count = res.getInt("num_count");
if(count<1) {
//默认没有添加用户信息时添加superuser
- sql.sqlMysqlExecute("INSERT INTO "+Sql_Mysql.TB_UserInf+" VALUES ('1001', '" + upstr + "', 'admin', 'admin', 'employeeid', '12345678912', '12345678912', 'abcde@mail.com', '', '1980-01-01', '2015-12-09', '男', '广东省', 'protitle', 'authority', '默认班组', 'duties', 'tasks', '1', 'note', '"+upstr+"', '', '', '48505834353130373639353153594E4F', '28', '0','0','0','0','0','2022-05-19 14:53:44','2022-05-19 14:53:44','2022-05-19 14:53:44','2022-05-19 14:53:44','2022-05-19 14:53:44','0','0');");
- sql.sqlMysqlExecute("INSERT INTO "+Sql_Mysql.TB_UserInf+" VALUES ('1002', '" + upstr + "', 'superuser', '1234567', '100010000', '12345678', '15346259512', '123456789@qq.com', '', '1990-04-20', '2016-03-28', '男', '湖北省', '软件工程师', 'authority111', '默认班组', 'dutie', '完成软件的研发工作', '0', 'note', '"+upstr+"', '', '', '14031C0F0136063E', '27', '0','0','0','0','0','2022-05-19 14:53:44','2022-05-19 14:53:44','2022-05-19 14:53:44','2022-05-19 14:53:44','2022-05-19 14:53:44','0','0');");
+ sql.sqlMysqlExecute("INSERT INTO "+Sql_Mysql.TB_UserInf+" VALUES ('1001', '" + upstr + "', 'admin', 'admin', 'employeeid', '12345678912', '12345678912', 'abcde@mail.com', '', '1980-01-01', '2015-12-09', '男', '广东省', 'protitle', 'authority', '默认班组', 'duties', 'tasks', '1', 'note', '"+upstr+"', '', '', '48505834353130373639353153594E4F', '28', '0','0','0','0','1','" + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms) + "','2022-05-19 14:53:44','2022-05-19 14:53:44','2022-05-19 14:53:44','2022-05-19 14:53:44','0','0');");
+ sql.sqlMysqlExecute("INSERT INTO "+Sql_Mysql.TB_UserInf+" VALUES ('1002', '" + upstr + "', 'superuser', '1234567', '100010000', '12345678', '15346259512', '123456789@qq.com', '', '1990-04-20', '2016-03-28', '男', '湖北省', '软件工程师', 'authority111', '默认班组', 'dutie', '完成软件的研发工作', '0', 'note', '"+upstr+"', '', '', '14031C0F0136063E', '27', '0','0','0','0','1','" + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms) + "','2022-05-19 14:53:44','2022-05-19 14:53:44','2022-05-19 14:53:44','2022-05-19 14:53:44','0','0');");
}
}
@@ -1494,15 +1497,17 @@
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';");
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,'" + upstr + "', 'sys_admin','','默认班组','" + upstr + "',1,0,1,1,'2022-02-14 16:02:01',null,'2021-12-14 16:16:04','00:00:00~23:59:59','*');");
+ 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,'" + upstr + "', 'sys_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','*');");
}
}
+ //添加默认账号audit_admin
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");
@@ -1512,6 +1517,9 @@
}
}
+ //
+ //sql.sqlMysqlExecute("UPDATE db_user.tb_user_inf SET status = 1,last_login_time = NOW();");
+
}
} catch (SQLException e) {
e.printStackTrace();
--
Gitblit v1.9.1