From a0fe090adf6622c72df70225881add061ab3a5d1 Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期五, 02 七月 2021 09:43:58 +0800
Subject: [PATCH] 11修改
---
BattMonitor_DB_Builder/src/com/database_util/DB_db_user.java | 36 +++++++++++++++++++++++++++++++++---
1 files changed, 33 insertions(+), 3 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 acfe8e2..aa70975 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
@@ -57,7 +57,7 @@
createUser_Limit_Table(pool, recreate);
-
+ createUser_Log_Table(pool, recreate);
}
@@ -982,8 +982,8 @@
int count = res.getInt("num_count");
if(count<1) {
//默认没有添加用户信息时添加superuser
- sql.sqlMysqlExecute("INSERT INTO "+Sql_Mysql.TB_UserInf+" VALUES ('1001', 'admin', 'admin', 'admin', 'employeeid', '12345678912', '12345678912', 'abcde@mail.com', '', '1980-01-01', '2015-12-09', '男', '广东省', 'protitle', 'authority', '默认班组', 'duties', 'tasks', '1', 'note', '21232f297a57a5a743894a0e4a801fc3', '', '', '48505834353130373639353153594E4F', '28', '');");
- sql.sqlMysqlExecute("INSERT INTO "+Sql_Mysql.TB_UserInf+" VALUES ('1002', '1', 'superuser', '1234567', '100010000', '12345678', '15346259512', '123456789@qq.com', '', '1990-04-20', '2016-03-28', '男', '湖北省', '软件工程师', 'authority111', '默认班组', 'dutie', '完成软件的研发工作', '0', 'note', 'c4ca4238a0b923820dcc509a6f75849b', '', '', '14031C0F0136063E', '27', '');");
+ sql.sqlMysqlExecute("INSERT INTO "+Sql_Mysql.TB_UserInf+" VALUES ('1001', 'admin', 'admin', 'admin', 'employeeid', '12345678912', '12345678912', 'abcde@mail.com', '', '1980-01-01', '2015-12-09', '男', '广东省', 'protitle', 'authority', '默认班组', 'duties', 'tasks', '1', 'note', '21232f297a57a5a743894a0e4a801fc3', '', '', '48505834353130373639353153594E4F', '28', '','0');");
+ sql.sqlMysqlExecute("INSERT INTO "+Sql_Mysql.TB_UserInf+" VALUES ('1002', '1', 'superuser', '1234567', '100010000', '12345678', '15346259512', '123456789@qq.com', '', '1990-04-20', '2016-03-28', '男', '湖北省', '软件工程师', 'authority111', '默认班组', 'dutie', '完成软件的研发工作', '0', 'note', 'c4ca4238a0b923820dcc509a6f75849b', '', '', '14031C0F0136063E', '27', '','0');");
}
}
} catch (SQLException e) {
@@ -992,4 +992,34 @@
sql.close_con();
}
}
+
+ /**
+ * 创建用户操作日志表
+ * @param pool
+ * @param recreate
+ */
+ public static void createUser_Log_Table(MysqlConnPool pool, boolean recreate) {
+ String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.User_Log_Table;
+ String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.User_Log_Table + " (" +
+ " `num` bigint(20) NOT NULL AUTO_INCREMENT," +
+ " `uId` int(11) NOT NULL DEFAULT '0'," +
+ " `uOprateType` int(11) NOT NULL DEFAULT '0'," +
+ " `uOprateDay` datetime NOT NULL DEFAULT '1980-01-01 00:00:00'," +
+ " `uTerminalIp` varchar(20) NOT NULL DEFAULT ' '," +
+ " `uOprateMsg` varchar(250) NOT NULL DEFAULT ' '," +
+ " PRIMARY KEY (`num`)," +
+ " KEY `user_id` (`uId`)" +
+ ") ENGINE=InnoDB AUTO_INCREMENT=7293 DEFAULT CHARSET=utf8;";
+ Sql_Mysql sql = new Sql_Mysql(pool.getConn());
+ try {
+ if(true == recreate) {
+ sql.sqlMysqlExecute(sql_str01);
+ }
+ sql.sqlMysqlExecute(sql_str02);
+ } catch (SQLException e) {
+ e.printStackTrace();
+ } finally {
+ sql.close_con();
+ }
+ }
}
--
Gitblit v1.9.1