From 09777726e5206e78eadd1869e73d7e10679317a7 Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期二, 15 三月 2022 13:39:50 +0800
Subject: [PATCH] V2.14 edit at date 2022-03-15 1.默认创建业务配置员,业务管理员和业务审计员权限组
---
BattMonitor_DB_Builder/src/com/database_util/DB_db_user.java | 261 ++++++++++++++++++++++++++++++++++++++++++++--------
1 files changed, 220 insertions(+), 41 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 701f795..4b0e309 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
@@ -887,6 +887,181 @@
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('2', '审计管理员', 'batt_discharge_model_permit', '0');");
}
}
+
+ res = sql.sqlMysqlQuery("SELECT COUNT(*) as sum_count FROM " + Sql_Mysql.User_Permitgroup_Table + " WHERE permit_group_id = 3");
+ //插入默认的业务配置员权限组 permit_group_id = 3
+ if(res.next()) {
+ int count = res.getInt("sum_count");
+ if(count<10) {
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('3', '业务配置员', 'battinf_report_query_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('3', '业务配置员', 'battgroup_report_query_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('3', '业务配置员', 'battmant_report_query_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('3', '业务配置员', 'battlarm_report_query_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('3', '业务配置员', 'monomer_report_query_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('3', '业务配置员', 'batttest_data_query_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('3', '业务配置员', 'batttest_data_edit_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('3', '业务配置员', 'task_query_permit', '1');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('3', '业务配置员', 'task_edit_permit', '1');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('3', '业务配置员', 'task_check_permit', '1');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('3', '业务配置员', 'task_recheck_permit', '1');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('3', '业务配置员', 'usr_query_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('3', '业务配置员', 'usr_edit_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('3', '业务配置员', 'permit_query_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('3', '业务配置员', 'permit_edit_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('3', '业务配置员', 'server_param_query_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('3', '业务配置员', 'server_param_edit_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('3', '业务配置员', 'analog_loader_op_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('3', '业务配置员', 'batt_test_op_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('3', '业务配置员', 'battcfg_query_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('3', '业务配置员', 'battcfg_add_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('3', '业务配置员', 'battcfg_modify_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('3', '业务配置员', 'battcfg_del_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('3', '业务配置员', 'batt_alm_query_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('3', '业务配置员', 'batt_alm_confirm_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('3', '业务配置员', 'batt_alm_clear_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('3', '业务配置员', 'batt_alm_delete_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('3', '业务配置员', 'batt_alm_param_query_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('3', '业务配置员', 'batt_alm_param_edit_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('3', '业务配置员', 'dev_alm_query_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('3', '业务配置员', 'dev_alm_confirm_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('3', '业务配置员', 'dev_alm_clear_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('3', '业务配置员', 'dev_alm_delete_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('3', '业务配置员', 'battfault_query_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('3', '业务配置员', 'battfault_add_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('3', '业务配置员', 'battfault_edit_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('3', '业务配置员', 'battfault_delete_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('3', '业务配置员', 'battmaint_confirm_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('3', '业务配置员', 'usrtaskcheck_query_permit', '1');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('3', '业务配置员', 'usrtaskcheck_add_permit', '1');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('3', '业务配置员', 'usrtaskcheck_edit_permit', '1');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('3', '业务配置员', 'usrtaskcheck_delete_permit', '1');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('3', '业务配置员', 'usrtaskcheck_confirm_permit', '1');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('3', '业务配置员', 'taskchange_query_permit', '1');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('3', '业务配置员', 'taskchange_add_permit', '1');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('3', '业务配置员', 'taskchange_delete_permit', '1');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('3', '业务配置员', 'taskchange_shenpi_permit', '1');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('3', '业务配置员', 'batt_map_edit_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('3', '业务配置员', 'batt_map_delete_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('3', '业务配置员', 'batt_discharge_model_permit', '0');");
+
+ }
+ }
+
+ res = sql.sqlMysqlQuery("SELECT COUNT(*) as sum_count FROM " + Sql_Mysql.User_Permitgroup_Table + " WHERE permit_group_id = 4");
+ //插入默认的业务管理员权限组 permit_group_id = 4
+ if(res.next()) {
+ int count = res.getInt("sum_count");
+ if(count<10) {
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('4', '业务管理员', 'battinf_report_query_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('4', '业务管理员', 'battgroup_report_query_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('4', '业务管理员', 'battmant_report_query_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('4', '业务管理员', 'battlarm_report_query_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('4', '业务管理员', 'monomer_report_query_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('4', '业务管理员', 'batttest_data_query_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('4', '业务管理员', 'batttest_data_edit_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('4', '业务管理员', 'task_query_permit', '1');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('4', '业务管理员', 'task_edit_permit', '1');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('4', '业务管理员', 'task_check_permit', '1');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('4', '业务管理员', 'task_recheck_permit', '1');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('4', '业务管理员', 'usr_query_permit', '1');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('4', '业务管理员', 'usr_edit_permit', '1');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('4', '业务管理员', 'permit_query_permit', '1');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('4', '业务管理员', 'permit_edit_permit', '1');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('4', '业务管理员', 'server_param_query_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('4', '业务管理员', 'server_param_edit_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('4', '业务管理员', 'analog_loader_op_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('4', '业务管理员', 'batt_test_op_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('4', '业务管理员', 'battcfg_query_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('4', '业务管理员', 'battcfg_add_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('4', '业务管理员', 'battcfg_modify_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('4', '业务管理员', 'battcfg_del_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('4', '业务管理员', 'batt_alm_query_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('4', '业务管理员', 'batt_alm_confirm_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('4', '业务管理员', 'batt_alm_clear_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('4', '业务管理员', 'batt_alm_delete_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('4', '业务管理员', 'batt_alm_param_query_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('4', '业务管理员', 'batt_alm_param_edit_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('4', '业务管理员', 'dev_alm_query_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('4', '业务管理员', 'dev_alm_confirm_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('4', '业务管理员', 'dev_alm_clear_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('4', '业务管理员', 'dev_alm_delete_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('4', '业务管理员', 'battfault_query_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('4', '业务管理员', 'battfault_add_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('4', '业务管理员', 'battfault_edit_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('4', '业务管理员', 'battfault_delete_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('4', '业务管理员', 'battmaint_confirm_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('4', '业务管理员', 'usrtaskcheck_query_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('4', '业务管理员', 'usrtaskcheck_add_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('4', '业务管理员', 'usrtaskcheck_edit_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('4', '业务管理员', 'usrtaskcheck_delete_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('4', '业务管理员', 'usrtaskcheck_confirm_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('4', '业务管理员', 'taskchange_query_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('4', '业务管理员', 'taskchange_add_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('4', '业务管理员', 'taskchange_delete_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('4', '业务管理员', 'taskchange_shenpi_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('4', '业务管理员', 'batt_map_edit_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('4', '业务管理员', 'batt_map_delete_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('4', '业务管理员', 'batt_discharge_model_permit', '0');");
+ }
+ }
+
+ res = sql.sqlMysqlQuery("SELECT COUNT(*) as sum_count FROM " + Sql_Mysql.User_Permitgroup_Table + " WHERE permit_group_id = 5");
+ //插入默认的业务管理员权限组 permit_group_id = 5
+ if(res.next()) {
+ int count = res.getInt("sum_count");
+ if(count<10) {
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('5', '业务审计员', 'battinf_report_query_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('5', '业务审计员', 'battgroup_report_query_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('5', '业务审计员', 'battmant_report_query_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('5', '业务审计员', 'battlarm_report_query_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('5', '业务审计员', 'monomer_report_query_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('5', '业务审计员', 'batttest_data_query_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('5', '业务审计员', 'batttest_data_edit_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('5', '业务审计员', 'task_query_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('5', '业务审计员', 'task_edit_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('5', '业务审计员', 'task_check_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('5', '业务审计员', 'task_recheck_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('5', '业务审计员', 'usr_query_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('5', '业务审计员', 'usr_edit_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('5', '业务审计员', 'permit_query_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('5', '业务审计员', 'permit_edit_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('5', '业务审计员', 'server_param_query_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('5', '业务审计员', 'server_param_edit_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('5', '业务审计员', 'analog_loader_op_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('5', '业务审计员', 'batt_test_op_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('5', '业务审计员', 'battcfg_query_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('5', '业务审计员', 'battcfg_add_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('5', '业务审计员', 'battcfg_modify_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('5', '业务审计员', 'battcfg_del_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('5', '业务审计员', 'batt_alm_query_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('5', '业务审计员', 'batt_alm_confirm_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('5', '业务审计员', 'batt_alm_clear_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('5', '业务审计员', 'batt_alm_delete_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('5', '业务审计员', 'batt_alm_param_query_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('5', '业务审计员', 'batt_alm_param_edit_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('5', '业务审计员', 'dev_alm_query_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('5', '业务审计员', 'dev_alm_confirm_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('5', '业务审计员', 'dev_alm_clear_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('5', '业务审计员', 'dev_alm_delete_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('5', '业务审计员', 'battfault_query_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('5', '业务审计员', 'battfault_add_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('5', '业务审计员', 'battfault_edit_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('5', '业务审计员', 'battfault_delete_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('5', '业务审计员', 'battmaint_confirm_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('5', '业务审计员', 'usrtaskcheck_query_permit', '1');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('5', '业务审计员', 'usrtaskcheck_add_permit', '1');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('5', '业务审计员', 'usrtaskcheck_edit_permit', '1');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('5', '业务审计员', 'usrtaskcheck_delete_permit', '1');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('5', '业务审计员', 'usrtaskcheck_confirm_permit', '1');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('5', '业务审计员', 'taskchange_query_permit', '1');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('5', '业务审计员', 'taskchange_add_permit', '1');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('5', '业务审计员', 'taskchange_delete_permit', '1');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('5', '业务审计员', 'taskchange_shenpi_permit', '1');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('5', '业务审计员', 'batt_map_edit_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('5', '业务审计员', 'batt_map_delete_permit', '0');");
+ sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('5', '业务审计员', 'batt_discharge_model_permit', '0');");
+ }
+ }
} catch (SQLException e) {
e.printStackTrace();
} finally {
@@ -1127,48 +1302,7 @@
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.TB_UserInf
+ " ADD COLUMN `uRole` tinyint(1) DEFAULT NULL COMMENT '告警角色：0-管理员、1-维护组长、2-维护组员';");
}
- res = sql.sqlMysqlQuery("SELECT COUNT(*) as num_count FROM " + Sql_Mysql.TB_UserInf);
- if(res.next()) {
- 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', '','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');");
- }
- }
- //默认新增指定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,'9bjUYyd3End5Hof9HqNmDQ==', 'sys_admin','','默认班组','dd75ac527808a04efadb9de25871effc',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,'Y2YIthHwIvAA3e8M4vofnA==', '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','*');");
- }
- }
-
- }
@@ -1265,6 +1399,51 @@
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.TB_UserInf
+ " MODIFY COLUMN `uSnId` VARCHAR(200) NOT NULL DEFAULT '123456';");
}
+
+
+ String upstr = "jFr3/n7JBhwxVE+uiMzC9LapSjDb97x1P7s8npTTLepabMucHcgVPwU/rkiG4tLlEICjYJKINQzoZQ0bqGxhwASe9vT2KukOOHJAEmBjs1uWkJoK0GLMZtNt7oiRoQzVSzPCfmtlc64gplUCSH6UTqqkMu//pEn/67W4sTLzUzg=";
+ res = sql.sqlMysqlQuery("SELECT COUNT(*) as num_count FROM " + Sql_Mysql.TB_UserInf);
+ if(res.next()) {
+ 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', '','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');");
+ }
+ }
+
+ //默认新增指定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,'" + 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','*');");
+ }
+ }
+
+ 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,'" + upstr + "', 'audit_admin','','默认班组','" + upstr + "',1,0,1,1,null,'2021-12-14 16:18:44','2021-12-14 16:18:44','00:00:00~23:59:59','*');");
+ }
+ }
+
+ }
} catch (SQLException e) {
e.printStackTrace();
} finally {
--
Gitblit v1.9.1