package com.database_util;
|
|
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;
|
|
public class DB_db_user {
|
|
|
public static void init(MysqlConnPool pool, boolean recreate) {
|
System.out.println(" db_db_user init start at " + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms));
|
|
createDB_UserDB(pool); //´´½¨db_userÊý¾Ý¿â
|
|
createTb_user_infTable(pool, recreate); //´´½¨Óû§±í
|
|
createUser_Permitgroup_Table(pool,recreate); //´´½¨È¨ÏÞ±í
|
|
createUser_Permitgroup_Data_Table(pool,recreate); //´´½¨Óû§È¨ÏÞ±í
|
|
createUser_Task_User_List_Table(pool,recreate);
|
|
createUser_Task_Template_Table(pool,recreate);
|
|
createUser_Task_Param_Table(pool,recreate);
|
|
createUser_Task_Change_Table(pool,recreate);
|
|
createUser_Task_Batt_Test_Table(pool,recreate);
|
|
createUser_Task_Batt_Template_Table(pool,recreate);
|
|
createUser_Task_Batt_Check_Table(pool,recreate);
|
|
createUser_Task_Table(pool, recreate);
|
|
createUser_Sms_Format_Table(pool, recreate);
|
|
createUser_Sms_Table(pool, recreate);
|
|
createUser_Paixiu_Table(pool, recreate);
|
|
createUser_Jiejiari_Table(pool, recreate);
|
|
createUser_Face_Table(pool, recreate);
|
|
createUser_Battmaint_Check_Process_Table(pool, recreate);
|
|
createUser_Battmaint_Check_Table(pool, recreate);
|
|
createUser_Battgroup_Baojigroup_Usr_Table(pool, recreate);
|
|
createUser_Battgroup_Baojigroup_Battgroup_Table(pool, recreate);
|
|
createUser_Battgroup_Baojigroup_Table(pool, recreate);
|
|
createUser_Limit_Table(pool, recreate);
|
|
createUser_Log_Table(pool, recreate);
|
|
createTb_User_Work(pool, recreate);
|
|
createTb_Work_Alarm(pool, recreate);
|
|
|
System.out.println(" db_db_user init end at " + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms));
|
}
|
|
/**
|
*
|
*/
|
public static void createUser_Task_Batt_Test_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.User_Task_Batt_Test_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.User_Task_Batt_Test_Table + " (" +
|
" `num` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `task_id` int(11) NOT NULL DEFAULT '0'," +
|
" `task_usr_ids` varchar(200) NOT NULL DEFAULT '0'," +
|
" `BattGroupId` int(11) NOT NULL DEFAULT '0'," +
|
" `task_enabled` tinyint(1) NOT NULL DEFAULT '1'," +
|
" `task_exe_date` datetime NOT NULL DEFAULT '2015-09-01 00:00:00'," +
|
" `task_close_date` datetime NOT NULL DEFAULT '2015-09-01 00:00:00'," +
|
" `task_notice_starttime` datetime NOT NULL DEFAULT '2015-09-01 00:00:00'," +
|
" `task_notice_endtime` datetime NOT NULL DEFAULT '2015-09-01 00:00:00'," +
|
" `task_notice_count` int(11) NOT NULL DEFAULT '0'," +
|
" `task_notice_latesttime` datetime NOT NULL DEFAULT '2015-09-01 00:00:00'," +
|
" `task_notice_master` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `test_complete` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `test_completetime` datetime NOT NULL DEFAULT '2015-09-01 00:00:00'," +
|
" `test_starttime` datetime NOT NULL DEFAULT '2015-09-01 00:00:00'," +
|
" `test_record_count_id` int(11) NOT NULL DEFAULT '0'," +
|
" `note` varchar(200) NOT NULL DEFAULT ' '," +
|
" PRIMARY KEY (`num`)," +
|
" KEY `index_task_id` (`task_id`)," +
|
" KEY `index_battgroup_id` (`BattGroupId`)" +
|
") ENGINE=InnoDB AUTO_INCREMENT=13923 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();
|
}
|
}
|
/**
|
*
|
*/
|
public static void createUser_Task_Batt_Template_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.User_Task_Batt_Template_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.User_Task_Batt_Template_Table + " (" +
|
" `template_id` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `template_name` varchar(200) NOT NULL DEFAULT ' '," +
|
" `task_batt_check_en` tinyint(1) NOT NULL DEFAULT '1'," +
|
" `task_batt_lazha_test_en` tinyint(1) NOT NULL DEFAULT '1'," +
|
" `task_batt_cap40_test_en` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `task_batt_cap80_test_en` tinyint(1) NOT NULL DEFAULT '1'," +
|
" `task_param_id` int(11) NOT NULL DEFAULT '0'," +
|
" `task_battgroup_quyu_index` int(11) NOT NULL DEFAULT '0'," +
|
" `task_exe_usr_selmode` int(11) NOT NULL DEFAULT '0'," +
|
" `task_exe_usrlunliu_count` int(11) NOT NULL DEFAULT '0'," +
|
" `task_create_mode` int(11) NOT NULL DEFAULT '0'," +
|
" PRIMARY KEY (`template_id`)" +
|
") ENGINE=InnoDB AUTO_INCREMENT=100008 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();
|
}
|
}
|
/**
|
*
|
*/
|
public static void createUser_Task_Batt_Check_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.User_Task_Batt_Check_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.User_Task_Batt_Check_Table + " (" +
|
" `num` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `task_id` int(11) NOT NULL DEFAULT '0'," +
|
" `task_usr_ids` varchar(200) NOT NULL DEFAULT '0'," +
|
" `BattGroupId` int(11) NOT NULL DEFAULT '0'," +
|
" `task_enabled` tinyint(1) NOT NULL DEFAULT '1'," +
|
" `task_exe_date` datetime NOT NULL DEFAULT '2015-09-01 00:00:00'," +
|
" `task_close_date` datetime NOT NULL DEFAULT '2015-09-01 00:00:00'," +
|
" `test_complete` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `test_completetime` datetime NOT NULL DEFAULT '2015-09-01 00:00:00'," +
|
" `batt_clean_done` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `batt_clean_done_result` varchar(200) NOT NULL DEFAULT ' '," +
|
" `batt_clean_done_recheck` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `batt_clean_done_recheck_result` varchar(200) NOT NULL DEFAULT ' '," +
|
" `batt_clean_done_recheck_check` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `batt_clean_done_recheck_check_result` varchar(200) NOT NULL DEFAULT ' '," +
|
" `battvol_tempe_done` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `battvol_tempe_done_result` varchar(200) NOT NULL DEFAULT ' '," +
|
" `battvol_tempe_done_recheck` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `battvol_tempe_done_recheck_result` varchar(200) NOT NULL DEFAULT ' '," +
|
" `battvol_tempe_done_recheck_check` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `battvol_tempe_done_recheck_check_result` varchar(200) NOT NULL DEFAULT ' '," +
|
" `battfault_check_done` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `battfault_check_done_result` varchar(200) NOT NULL DEFAULT ' '," +
|
" `battfault_check_done_recheck` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `battfault_check_done_recheck_result` varchar(200) NOT NULL DEFAULT ' '," +
|
" `battfault_check_done_recheck_check` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `battfault_check_done_recheck_check_result` varchar(200) NOT NULL DEFAULT ' '," +
|
" PRIMARY KEY (`num`)," +
|
" KEY `index_task_id` (`task_id`)," +
|
" KEY `index_battgroup_id` (`BattGroupId`)" +
|
") ENGINE=InnoDB AUTO_INCREMENT=9940 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();
|
}
|
}
|
/**
|
*
|
*/
|
public static void createUser_Task_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.User_Task_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.User_Task_Table + " (" +
|
" `num` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `task_id` int(11) NOT NULL DEFAULT '0'," +
|
" `task_id_ex` int(11) NOT NULL DEFAULT '0'," +
|
" `task_name` varchar(200) NOT NULL DEFAULT ' '," +
|
" `task_type` int(11) NOT NULL DEFAULT '0'," +
|
" `task_enabled` tinyint(1) NOT NULL DEFAULT '1'," +
|
" `task_create_date` datetime NOT NULL DEFAULT '2015-09-01 00:00:00'," +
|
" `task_start_date` datetime NOT NULL DEFAULT '2015-10-01 00:00:00'," +
|
" `task_close_date` datetime NOT NULL DEFAULT '2015-10-01 00:00:00'," +
|
" `subtask_count` int(11) NOT NULL DEFAULT '0'," +
|
" `task_notice_sum` int(11) NOT NULL DEFAULT '0'," +
|
" `task_notice_starttime` datetime NOT NULL DEFAULT '2015-09-01 00:00:00'," +
|
" `task_notice_endtime` datetime NOT NULL DEFAULT '2015-09-01 00:00:00'," +
|
" `task_notice_timeinterval` int(11) NOT NULL DEFAULT '1'," +
|
" `task_notice_count` int(11) NOT NULL DEFAULT '0'," +
|
" `task_notice_latesttime` datetime NOT NULL DEFAULT '2015-09-01 00:00:00'," +
|
" `task_autoinc_day_count` int(11) NOT NULL DEFAULT '0'," +
|
" `task_delay_day_count` int(11) NOT NULL DEFAULT '0'," +
|
" `task_pass_saturday` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `task_pass_sunday` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `task_pass_jiejiari` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `task_confirm` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `task_confirm_date` datetime NOT NULL DEFAULT '2015-09-01 00:00:00'," +
|
" `task_complete` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `task_complete_date` datetime NOT NULL DEFAULT '2015-09-01 00:00:00'," +
|
" `task_complete_confirm` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `task_complete_confirm_date` datetime NOT NULL DEFAULT '2015-09-01 00:00:00'," +
|
" `notice_master_enabled` tinyint(1) NOT NULL DEFAULT '1'," +
|
" `notice_master` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `note` varchar(200) NOT NULL DEFAULT ' '," +
|
" PRIMARY KEY (`num`)," +
|
" KEY `index_task_id` (`task_id`)" +
|
") ENGINE=InnoDB AUTO_INCREMENT=96 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();
|
}
|
}
|
/**
|
*
|
*/
|
public static void createUser_Sms_Format_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.User_Sms_Format_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.User_Sms_Format_Table + " (" +
|
" `num` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `format_type` varchar(64) NOT NULL DEFAULT ' '," +
|
" `format_str` varchar(1024) NOT NULL DEFAULT ' '," +
|
" PRIMARY KEY (`num`)" +
|
") ENGINE=InnoDB AUTO_INCREMENT=5 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();
|
}
|
}
|
/**
|
*
|
*/
|
public static void createUser_Sms_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.User_Sms_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.User_Sms_Table + " (" +
|
" `num` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `task_id` int(11) NOT NULL DEFAULT '0'," +
|
" `priority_level` int(11) NOT NULL DEFAULT '0'," +
|
" `uId` int(11) NOT NULL DEFAULT '0'," +
|
" `phone_num` varchar(15) NOT NULL DEFAULT ' '," +
|
" `sms` varchar(1024) NOT NULL DEFAULT ' '," +
|
" `sms_add_date` datetime NOT NULL DEFAULT '2015-09-01 00:00:00'," +
|
" `sms_send_date` datetime NOT NULL DEFAULT '2015-09-01 00:00:00'," +
|
" `sms_send_err_count` int(11) NOT NULL DEFAULT '0'," +
|
" `sms_state` int(11) NOT NULL DEFAULT '0'," +
|
" PRIMARY KEY (`num`)," +
|
" KEY `index_task_id` (`task_id`)" +
|
") ENGINE=InnoDB AUTO_INCREMENT=10279 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();
|
}
|
}
|
|
/**
|
*
|
*/
|
public static void createUser_Paixiu_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.User_Paixiu_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.User_Paixiu_Table + " (" +
|
" `id` bigint(20) NOT NULL DEFAULT '0'," +
|
" `uId` int(11) NOT NULL DEFAULT '0'," +
|
" `uMasterId` int(11) NOT NULL DEFAULT '0'," +
|
" `create_time` datetime NOT NULL DEFAULT '1980-01-01 00:00:00'," +
|
" `start_date` datetime NOT NULL DEFAULT '1980-01-01 00:00:00'," +
|
" `end_date` datetime NOT NULL DEFAULT '1980-01-01 00:00:00'," +
|
" `task_id` int(11) NOT NULL DEFAULT '0'," +
|
" `event_type` int(11) NOT NULL DEFAULT '0'," +
|
" `event` varchar(250) NOT NULL DEFAULT ' '," +
|
" `result` int(11) NOT NULL DEFAULT '0'," +
|
" `result_caption` varchar(250) NOT NULL DEFAULT ' '," +
|
" `result_check` int(11) NOT NULL DEFAULT '0'," +
|
" `result_check_caption` varchar(250) NOT NULL DEFAULT ' '," +
|
" PRIMARY KEY (`id`)," +
|
" KEY `user_id` (`uId`)" +
|
") ENGINE=InnoDB 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();
|
}
|
}
|
/**
|
*
|
*/
|
public static void createUser_Jiejiari_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.User_Jiejiari_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.User_Jiejiari_Table + " (" +
|
" `num` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `jiejiari_type` int(11) NOT NULL DEFAULT '0'," +
|
" `jiejiari_date` datetime NOT NULL DEFAULT '2015-09-01 00:00:00'," +
|
" `note` varchar(50) NOT NULL DEFAULT ' '," +
|
" PRIMARY KEY (`num`)" +
|
") ENGINE=InnoDB AUTO_INCREMENT=12 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();
|
}
|
}
|
/**
|
*
|
*/
|
public static void createUser_Face_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.User_Face_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.User_Face_Table + " (" +
|
" `id` int(5) NOT NULL AUTO_INCREMENT COMMENT 'face_id'," +
|
" `url` varchar(150) DEFAULT NULL COMMENT 'ÈËÁ³Í¼Æ¬url'," +
|
" PRIMARY KEY (`id`) USING BTREE" +
|
") ENGINE=InnoDB AUTO_INCREMENT=29 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();
|
}
|
}
|
/**
|
*
|
*/
|
public static void createUser_Battmaint_Check_Process_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.User_Battmaint_Check_Process_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.User_Battmaint_Check_Process_Table + " (" +
|
" `num` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `task_rec_id` bigint(20) NOT NULL DEFAULT '0'," +
|
" `usr_id` int(11) NOT NULL DEFAULT '0'," +
|
" `work_caption` varchar(200) NOT NULL DEFAULT ' '," +
|
" `work_caption_time` datetime DEFAULT '2005-01-01 00:00:00'," +
|
" PRIMARY KEY (`num`)," +
|
" KEY `index_task_rec_id` (`task_rec_id`)" +
|
") ENGINE=InnoDB AUTO_INCREMENT=70 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();
|
}
|
}
|
/**
|
*
|
*/
|
public static void createUser_Battmaint_Check_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.User_Battmaint_Check_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.User_Battmaint_Check_Table + " (" +
|
" `num` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `StationId` int(11) NOT NULL DEFAULT '0'," +
|
" `usr_id` int(11) NOT NULL DEFAULT '0'," +
|
" `master_id` int(11) NOT NULL DEFAULT '0'," +
|
" `appoint_uid` int(11) NOT NULL DEFAULT '0'," +
|
" `copy_uids` varchar(200) NOT NULL DEFAULT ' '," +
|
" `task_type_id` int(11) NOT NULL DEFAULT '0'," +
|
" `task_level` int(11) NOT NULL DEFAULT '0'," +
|
" `task_caption` varchar(200) NOT NULL DEFAULT ' '," +
|
" `task_time_start` datetime NOT NULL DEFAULT '2005-01-01 00:00:00'," +
|
" `task_time_end` datetime NOT NULL DEFAULT '2005-01-01 00:00:00'," +
|
" `task_process` varchar(200) NOT NULL DEFAULT ' '," +
|
" `task_done` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `task_done_time` datetime DEFAULT '2005-01-01 00:00:00'," +
|
" `origin_usr_work_mark` int(11) NOT NULL DEFAULT '0'," +
|
" `task_done_confirm` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `master_audit` int(11) NOT NULL DEFAULT '0'," +
|
" `remark` varchar(200) NOT NULL DEFAULT ' '," +
|
" PRIMARY KEY (`num`)," +
|
" KEY `index_station_id` (`StationId`)," +
|
" KEY `index_user_id` (`usr_id`)," +
|
" KEY `index_task_type_id` (`task_type_id`)" +
|
") ENGINE=InnoDB AUTO_INCREMENT=29 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();
|
}
|
}
|
/**
|
*
|
*/
|
public static void createUser_Battgroup_Baojigroup_Usr_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.User_Battgroup_Baojigroup_Usr_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.User_Battgroup_Baojigroup_Usr_Table + " (" +
|
" `num` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `baoji_group_id` int(11) NOT NULL DEFAULT '0'," +
|
" `uId` int(11) NOT NULL DEFAULT '0'," +
|
" PRIMARY KEY (`num`)," +
|
" KEY `index_group_id` (`baoji_group_id`)" +
|
") ENGINE=InnoDB AUTO_INCREMENT=93 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();
|
}
|
}
|
/**
|
*
|
*/
|
public static void createUser_Battgroup_Baojigroup_Battgroup_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.User_Battgroup_Baojigroup_Battgroup_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.User_Battgroup_Baojigroup_Battgroup_Table + " (" +
|
" `num` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `baoji_group_id` int(11) NOT NULL DEFAULT '0'," +
|
" `StationId` int(11) NOT NULL DEFAULT '0'," +
|
" `BattGroupId` int(11) NOT NULL DEFAULT '0'," +
|
" PRIMARY KEY (`num`)," +
|
" KEY `index_group_id` (`baoji_group_id`)" +
|
") ENGINE=InnoDB AUTO_INCREMENT=1845 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();
|
}
|
}
|
/**
|
*
|
*/
|
public static void createUser_Battgroup_Baojigroup_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.User_Battgroup_Baojigroup_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.User_Battgroup_Baojigroup_Table + " (" +
|
" `baoji_group_id` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `baoji_group_name` varchar(200) NOT NULL DEFAULT '0'," +
|
" PRIMARY KEY (`baoji_group_id`)" +
|
") ENGINE=InnoDB AUTO_INCREMENT=100015 DEFAULT CHARSET=utf8;";
|
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
|
ResultSet res = null;
|
try {
|
if(true == recreate) {
|
sql.sqlMysqlExecute(sql_str01);
|
}
|
sql.sqlMysqlExecute(sql_str02);
|
|
|
|
//Ìí¼Ó·Åµç¼Æ»®±êʶ discharge_plan_flag
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_user'"
|
+ " AND table_name='tb_user_battgroup_baojigroup'"
|
+ " AND column_name='discharge_plan_flag'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.User_Battgroup_Baojigroup_Table
|
+ " ADD COLUMN `discharge_plan_flag` tinyint(1) unsigned DEFAULT '0' COMMENT '·Åµç¼Æ»®±êʶ:0²»²ÎÓë·Åµç¼Æ»®,1²ÎÓë·Åµç¼Æ»®';");
|
}
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
sql.close_con();
|
}
|
}
|
|
/**
|
*
|
*/
|
public static void createUser_Task_Change_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.User_Task_Change_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.User_Task_Change_Table + " (" +
|
" `num` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `usr_id` int(11) NOT NULL DEFAULT '0'," +
|
" `master_id` int(11) NOT NULL DEFAULT '0'," +
|
" `appoint_uid` int(11) NOT NULL DEFAULT '0'," +
|
" `copy_uids` varchar(200) NOT NULL DEFAULT ' '," +
|
" `change_type_id` int(11) NOT NULL DEFAULT '0'," +
|
" `task_type_id` int(11) NOT NULL DEFAULT '0'," +
|
" `task_rc_num` int(11) NOT NULL DEFAULT '0'," +
|
" `BattGroupId` int(11) NOT NULL DEFAULT '0'," +
|
" `change_reason` varchar(200) NOT NULL DEFAULT ' '," +
|
" `old_executor_ids` varchar(200) NOT NULL DEFAULT ' '," +
|
" `old_task_exe_time` datetime NOT NULL DEFAULT '2005-01-01 00:00:00'," +
|
" `new_executor_ids` varchar(200) NOT NULL DEFAULT ' '," +
|
" `new_task_exe_time` datetime DEFAULT '2005-01-01 00:00:00'," +
|
" `change_ask_time` datetime NOT NULL DEFAULT '2005-01-01 00:00:00'," +
|
" `change_ask_time_limit` datetime NOT NULL DEFAULT '2005-01-01 00:00:00'," +
|
" `task_change_approve_res` int(11) NOT NULL DEFAULT '0'," +
|
" `task_change_approve_time` datetime NOT NULL DEFAULT '2005-01-01 00:00:00'," +
|
" `remark` varchar(200) NOT NULL DEFAULT ' '," +
|
" PRIMARY KEY (`num`)," +
|
" KEY `index_battgroup_id` (`BattGroupId`)," +
|
" KEY `index_user_id` (`usr_id`)," +
|
" KEY `index_change_type_id` (`change_type_id`)," +
|
" KEY `index_task_type_id` (`task_type_id`)" +
|
") ENGINE=InnoDB AUTO_INCREMENT=10 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();
|
}
|
}
|
|
|
/**
|
*
|
*/
|
public static void createUser_Task_Param_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.User_Task_Param_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.User_Task_Param_Table + " (" +
|
" `tp_num` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `tp_name` varchar(50) NOT NULL DEFAULT ' '," +
|
" `tp_taskname` varchar(100) NOT NULL DEFAULT ' '," +
|
" `tp_tasktype` int(11) NOT NULL DEFAULT '0'," +
|
" `tp_autoinc_daycount` int(11) NOT NULL DEFAULT '1'," +
|
" `tp_taskdelay_daycount` int(11) NOT NULL DEFAULT '0'," +
|
" `tp_pass_saturday` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `tp_pass_sunday` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `tp_pass_jiejiari` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `tp_task_notice_count` int(11) NOT NULL DEFAULT '3'," +
|
" `tp_task_notice_time_interval` int(11) NOT NULL DEFAULT '30'," +
|
" `tp_task_notice_starttime` datetime NOT NULL DEFAULT '2015-09-01 09:00:00'," +
|
" `tp_task_notice_endtime` datetime NOT NULL DEFAULT '2015-09-01 17:00:00'," +
|
" `tp_task_enabled` tinyint(1) NOT NULL DEFAULT '1'," +
|
" `tp_master_id` varchar(100) NOT NULL DEFAULT ' '," +
|
" `tp_notice_master_enabled` tinyint(1) NOT NULL DEFAULT '1'," +
|
" `tp_task_battlife_var` int(11) NOT NULL DEFAULT '3'," +
|
" `tp_task_battyong_test80_month` int(11) NOT NULL DEFAULT '36'," +
|
" `tp_task_battold_test80_month` int(11) NOT NULL DEFAULT '12'," +
|
" `tp_task_battyong_test40_month` int(11) NOT NULL DEFAULT '12'," +
|
" `tp_task_battold_test40_month` int(11) NOT NULL DEFAULT '12'," +
|
" `tp_task_batt_checkcircle_month` int(11) NOT NULL DEFAULT '1'," +
|
" `tp_task_batt_checklimit_month` int(11) NOT NULL DEFAULT '1'," +
|
" `tp_task_batt_lazhacircle_month` int(11) NOT NULL DEFAULT '1'," +
|
" `tp_task_batt_lazhalimit_month` int(11) NOT NULL DEFAULT '1'," +
|
" PRIMARY KEY (`tp_num`)" +
|
") ENGINE=InnoDB AUTO_INCREMENT=100004 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();
|
}
|
}
|
/**
|
*
|
*/
|
public static void createUser_Task_Template_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.User_Task_Template_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.User_Task_Template_Table + " (" +
|
" `template_id` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `template_name` varchar(200) NOT NULL DEFAULT ' '," +
|
" `task_batt_check` tinyint(1) NOT NULL DEFAULT '1'," +
|
" `task_batt_cap40_test` tinyint(1) NOT NULL DEFAULT '0'," +
|
" `task_batt_cap80_test` tinyint(1) NOT NULL DEFAULT '1'," +
|
" `task_param_id` tinyint(1) NOT NULL DEFAULT '1'," +
|
" `task_battgroup_table_id` int(11) NOT NULL DEFAULT '0'," +
|
" `task_exe_circal_daycount` int(11) NOT NULL DEFAULT '0'," +
|
" `task_exe_usr_selmode` int(11) NOT NULL DEFAULT '0'," +
|
" PRIMARY KEY (`template_id`)" +
|
") ENGINE=InnoDB 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();
|
}
|
}
|
/**
|
*
|
*/
|
public static void createUser_Task_User_List_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.User_Task_User_List_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.User_Task_User_List_Table + " (" +
|
" `num` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `task_id` int(11) NOT NULL DEFAULT '0'," +
|
" `uId` int(11) NOT NULL DEFAULT '0'," +
|
" `usr_type` int(11) NOT NULL DEFAULT '0'," +
|
" PRIMARY KEY (`num`)," +
|
" KEY `index_task_id` (`task_id`)" +
|
") ENGINE=InnoDB AUTO_INCREMENT=165 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();
|
}
|
}
|
|
|
|
|
|
/**
|
* ´´½¨È¨Ï޼Ǽ±í
|
* @param pool
|
* @param recreate
|
*/
|
public static void createUser_Permitgroup_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str_del = " DROP TABLE IF EXISTS "+Sql_Mysql.User_Permitgroup_Table;
|
String sql_str = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.User_Permitgroup_Table + " (" +
|
" `num` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `permit_group_id` int(11) NOT NULL DEFAULT '0'," +
|
" `permit_group_name` varchar(100) NOT NULL DEFAULT '0'," +
|
" `permit_item_name` varchar(100) NOT NULL DEFAULT '0'," +
|
" `permit_item_value` tinyint(1) NOT NULL DEFAULT '0'," +
|
" PRIMARY KEY (`num`)" +
|
") ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;";
|
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
|
String sql_str_sel = " SELECT COUNT(*) as sum_count FROM "+Sql_Mysql.User_Permitgroup_Table;
|
ResultSet res = null;
|
try {
|
if(recreate) {
|
//sql.sqlMysqlExecute(sql_str_del);
|
}
|
sql.sqlMysqlExecute(sql_str);
|
//Ìí¼ÓÉÏÒ»´ÎÖØÆôʱ¼ä×Ö¶Î
|
res = sql.sqlMysqlQuery(sql_str_sel);
|
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(100001,'¹ÜÀíÔ±×é','battinf_report_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(100001,'¹ÜÀíÔ±×é','battgroup_report_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(100001,'¹ÜÀíÔ±×é','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(100001,'¹ÜÀíÔ±×é','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(100001,'¹ÜÀíÔ±×é','monomer_report_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(100001,'¹ÜÀíÔ±×é','batttest_data_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(100001,'¹ÜÀíÔ±×é','batttest_data_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(100001,'¹ÜÀíÔ±×é','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(100001,'¹ÜÀíÔ±×é','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(100001,'¹ÜÀíÔ±×é','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(100001,'¹ÜÀíÔ±×é','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(100001,'¹ÜÀíÔ±×é','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(100001,'¹ÜÀíÔ±×é','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(100001,'¹ÜÀíÔ±×é','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(100001,'¹ÜÀíÔ±×é','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(100001,'¹ÜÀíÔ±×é','server_param_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(100001,'¹ÜÀíÔ±×é','server_param_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(100001,'¹ÜÀíÔ±×é','analog_loader_op_permit',1);");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES(100001,'¹ÜÀíÔ±×é','batt_test_op_permit',1);");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES(100001,'¹ÜÀíÔ±×é','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(100001,'¹ÜÀíÔ±×é','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(100001,'¹ÜÀíÔ±×é','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(100001,'¹ÜÀíÔ±×é','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(100001,'¹ÜÀíÔ±×é','batt_alm_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(100001,'¹ÜÀíÔ±×é','batt_alm_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(100001,'¹ÜÀíÔ±×é','batt_alm_clear_permit',1);");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES(100001,'¹ÜÀíÔ±×é','batt_alm_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(100001,'¹ÜÀíÔ±×é','batt_alm_param_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(100001,'¹ÜÀíÔ±×é','batt_alm_param_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(100001,'¹ÜÀíÔ±×é','dev_alm_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(100001,'¹ÜÀíÔ±×é','dev_alm_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(100001,'¹ÜÀíÔ±×é','dev_alm_clear_permit',1);");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES(100001,'¹ÜÀíÔ±×é','dev_alm_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(100001,'¹ÜÀíÔ±×é','battfault_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(100001,'¹ÜÀíÔ±×é','battfault_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(100001,'¹ÜÀíÔ±×é','battfault_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(100001,'¹ÜÀíÔ±×é','battfault_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(100001,'¹ÜÀíÔ±×é','battmaint_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(100001,'¹ÜÀíÔ±×é','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(100001,'¹ÜÀíÔ±×é','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(100001,'¹ÜÀíÔ±×é','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(100001,'¹ÜÀíÔ±×é','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(100001,'¹ÜÀíÔ±×é','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(100001,'¹ÜÀíÔ±×é','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(100001,'¹ÜÀíÔ±×é','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(100001,'¹ÜÀíÔ±×é','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(100001,'¹ÜÀíÔ±×é','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(100001,'¹ÜÀíÔ±×é','batt_map_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(100001,'¹ÜÀíÔ±×é','batt_map_delete_permit',1);");
|
|
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('1736', '100002', '³¬¼¶¹ÜÀíÔ±×é', 'battinf_report_query_permit', '1');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('1737', '100002', '³¬¼¶¹ÜÀíÔ±×é', 'battgroup_report_query_permit', '1');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('1738', '100002', '³¬¼¶¹ÜÀíÔ±×é', 'battmant_report_query_permit', '1');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('1739', '100002', '³¬¼¶¹ÜÀíÔ±×é', 'battlarm_report_query_permit', '1');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('1740', '100002', '³¬¼¶¹ÜÀíÔ±×é', 'monomer_report_query_permit', '1');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('1741', '100002', '³¬¼¶¹ÜÀíÔ±×é', 'batttest_data_query_permit', '1');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('1742', '100002', '³¬¼¶¹ÜÀíÔ±×é', 'batttest_data_edit_permit', '1');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('1743', '100002', '³¬¼¶¹ÜÀíÔ±×é', 'task_query_permit', '1');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('1744', '100002', '³¬¼¶¹ÜÀíÔ±×é', 'task_edit_permit', '1');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('1745', '100002', '³¬¼¶¹ÜÀíÔ±×é', 'task_check_permit', '1');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('1746', '100002', '³¬¼¶¹ÜÀíÔ±×é', 'task_recheck_permit', '1');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('1747', '100002', '³¬¼¶¹ÜÀíÔ±×é', 'usr_query_permit', '1');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('1748', '100002', '³¬¼¶¹ÜÀíÔ±×é', 'usr_edit_permit', '1');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('1749', '100002', '³¬¼¶¹ÜÀíÔ±×é', 'permit_query_permit', '1');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('1750', '100002', '³¬¼¶¹ÜÀíÔ±×é', 'permit_edit_permit', '1');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('1751', '100002', '³¬¼¶¹ÜÀíÔ±×é', 'server_param_query_permit', '1');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('1752', '100002', '³¬¼¶¹ÜÀíÔ±×é', 'server_param_edit_permit', '1');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('1753', '100002', '³¬¼¶¹ÜÀíÔ±×é', 'analog_loader_op_permit', '1');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('1754', '100002', '³¬¼¶¹ÜÀíÔ±×é', 'batt_test_op_permit', '1');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('1755', '100002', '³¬¼¶¹ÜÀíÔ±×é', 'battcfg_query_permit', '1');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('1756', '100002', '³¬¼¶¹ÜÀíÔ±×é', 'battcfg_add_permit', '1');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('1757', '100002', '³¬¼¶¹ÜÀíÔ±×é', 'battcfg_modify_permit', '1');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('1758', '100002', '³¬¼¶¹ÜÀíÔ±×é', 'battcfg_del_permit', '1');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('1759', '100002', '³¬¼¶¹ÜÀíÔ±×é', 'batt_alm_query_permit', '1');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('1760', '100002', '³¬¼¶¹ÜÀíÔ±×é', 'batt_alm_confirm_permit', '1');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('1761', '100002', '³¬¼¶¹ÜÀíÔ±×é', 'batt_alm_clear_permit', '1');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('1762', '100002', '³¬¼¶¹ÜÀíÔ±×é', 'batt_alm_delete_permit', '1');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('1763', '100002', '³¬¼¶¹ÜÀíÔ±×é', 'batt_alm_param_query_permit', '1');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('1764', '100002', '³¬¼¶¹ÜÀíÔ±×é', 'batt_alm_param_edit_permit', '1');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('1765', '100002', '³¬¼¶¹ÜÀíÔ±×é', 'dev_alm_query_permit', '1');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('1766', '100002', '³¬¼¶¹ÜÀíÔ±×é', 'dev_alm_confirm_permit', '1');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('1767', '100002', '³¬¼¶¹ÜÀíÔ±×é', 'dev_alm_clear_permit', '1');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('1768', '100002', '³¬¼¶¹ÜÀíÔ±×é', 'dev_alm_delete_permit', '1');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('1769', '100002', '³¬¼¶¹ÜÀíÔ±×é', 'battfault_query_permit', '1');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('1770', '100002', '³¬¼¶¹ÜÀíÔ±×é', 'battfault_add_permit', '1');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('1771', '100002', '³¬¼¶¹ÜÀíÔ±×é', 'battfault_edit_permit', '1');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('1772', '100002', '³¬¼¶¹ÜÀíÔ±×é', 'battfault_delete_permit', '1');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('1773', '100002', '³¬¼¶¹ÜÀíÔ±×é', 'battmaint_confirm_permit', '1');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('1774', '100002', '³¬¼¶¹ÜÀíÔ±×é', 'usrtaskcheck_query_permit', '1');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('1775', '100002', '³¬¼¶¹ÜÀíÔ±×é', 'usrtaskcheck_add_permit', '1');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('1776', '100002', '³¬¼¶¹ÜÀíÔ±×é', 'usrtaskcheck_edit_permit', '1');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('1777', '100002', '³¬¼¶¹ÜÀíÔ±×é', 'usrtaskcheck_delete_permit', '1');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('1778', '100002', '³¬¼¶¹ÜÀíÔ±×é', 'usrtaskcheck_confirm_permit', '1');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('1779', '100002', '³¬¼¶¹ÜÀíÔ±×é', 'taskchange_query_permit', '1');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('1780', '100002', '³¬¼¶¹ÜÀíÔ±×é', 'taskchange_add_permit', '1');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('1781', '100002', '³¬¼¶¹ÜÀíÔ±×é', 'taskchange_delete_permit', '1');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('1782', '100002', '³¬¼¶¹ÜÀíÔ±×é', 'taskchange_shenpi_permit', '1');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('3475', '100003', 'ÆÕͨÓû§×é', 'battinf_report_query_permit', '0');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('3476', '100003', 'ÆÕͨÓû§×é', 'battgroup_report_query_permit', '0');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('3477', '100003', 'ÆÕͨÓû§×é', 'battmant_report_query_permit', '0');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('3478', '100003', 'ÆÕͨÓû§×é', 'battlarm_report_query_permit', '0');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('3479', '100003', 'ÆÕͨÓû§×é', 'monomer_report_query_permit', '0');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('3480', '100003', 'ÆÕͨÓû§×é', 'batttest_data_query_permit', '0');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('3481', '100003', 'ÆÕͨÓû§×é', 'batttest_data_edit_permit', '0');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('3482', '100003', 'ÆÕͨÓû§×é', 'task_query_permit', '0');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('3483', '100003', 'ÆÕͨÓû§×é', 'task_edit_permit', '0');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('3484', '100003', 'ÆÕͨÓû§×é', 'task_check_permit', '0');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('3485', '100003', 'ÆÕͨÓû§×é', 'task_recheck_permit', '0');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('3486', '100003', 'ÆÕͨÓû§×é', 'usr_query_permit', '0');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('3487', '100003', 'ÆÕͨÓû§×é', 'usr_edit_permit', '0');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('3488', '100003', 'ÆÕͨÓû§×é', 'permit_query_permit', '0');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('3489', '100003', 'ÆÕͨÓû§×é', 'permit_edit_permit', '0');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('3490', '100003', 'ÆÕͨÓû§×é', 'server_param_query_permit', '0');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('3491', '100003', 'ÆÕͨÓû§×é', 'server_param_edit_permit', '0');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('3492', '100003', 'ÆÕͨÓû§×é', 'analog_loader_op_permit', '0');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('3493', '100003', 'ÆÕͨÓû§×é', 'batt_test_op_permit', '0');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('3494', '100003', 'ÆÕͨÓû§×é', 'battcfg_query_permit', '0');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('3495', '100003', 'ÆÕͨÓû§×é', 'battcfg_add_permit', '0');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('3496', '100003', 'ÆÕͨÓû§×é', 'battcfg_modify_permit', '0');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('3497', '100003', 'ÆÕͨÓû§×é', 'battcfg_del_permit', '0');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('3498', '100003', 'ÆÕͨÓû§×é', 'batt_alm_query_permit', '0');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('3499', '100003', 'ÆÕͨÓû§×é', 'batt_alm_confirm_permit', '0');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('3500', '100003', 'ÆÕͨÓû§×é', 'batt_alm_clear_permit', '0');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('3501', '100003', 'ÆÕͨÓû§×é', 'batt_alm_delete_permit', '0');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('3502', '100003', 'ÆÕͨÓû§×é', 'batt_alm_param_query_permit', '0');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('3503', '100003', 'ÆÕͨÓû§×é', 'batt_alm_param_edit_permit', '0');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('3504', '100003', 'ÆÕͨÓû§×é', 'dev_alm_query_permit', '0');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('3505', '100003', 'ÆÕͨÓû§×é', 'dev_alm_confirm_permit', '0');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('3506', '100003', 'ÆÕͨÓû§×é', 'dev_alm_clear_permit', '0');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('3507', '100003', 'ÆÕͨÓû§×é', 'dev_alm_delete_permit', '0');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('3508', '100003', 'ÆÕͨÓû§×é', 'battfault_query_permit', '0');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('3509', '100003', 'ÆÕͨÓû§×é', 'battfault_add_permit', '0');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + " VALUES ('3510', '100003', 'ÆÕͨÓû§×é', 'battfault_edit_permit', '0');");
|
}
|
}
|
//" SELECT COUNT(*) as sum_count FROM "+Sql_Mysql.User_Permitgroup_Table;
|
res = sql.sqlMysqlQuery("SELECT COUNT(*) as sum_count FROM " + Sql_Mysql.User_Permitgroup_Table + " WHERE permit_group_id = 1");
|
//²åÈëĬÈϵÄϵͳ¹ÜÀíԱȨÏÞ×é
|
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 ('1', 'ϵͳ¹ÜÀíÔ±', 'battinf_report_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 ('1', 'ϵͳ¹ÜÀíÔ±', 'battgroup_report_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 ('1', 'ϵͳ¹ÜÀíÔ±', '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 ('1', 'ϵͳ¹ÜÀíÔ±', '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 ('1', 'ϵͳ¹ÜÀíÔ±', 'monomer_report_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 ('1', 'ϵͳ¹ÜÀíÔ±', 'batttest_data_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 ('1', 'ϵͳ¹ÜÀíÔ±', 'batttest_data_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 ('1', 'ϵͳ¹ÜÀíÔ±', '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 ('1', 'ϵͳ¹ÜÀíÔ±', '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 ('1', 'ϵͳ¹ÜÀíÔ±', '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 ('1', 'ϵͳ¹ÜÀíÔ±', '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 ('1', 'ϵͳ¹ÜÀíÔ±', '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 ('1', 'ϵͳ¹ÜÀíÔ±', '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 ('1', 'ϵͳ¹ÜÀíÔ±', '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 ('1', 'ϵͳ¹ÜÀíÔ±', '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 ('1', 'ϵͳ¹ÜÀíÔ±', 'server_param_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 ('1', 'ϵͳ¹ÜÀíÔ±', 'server_param_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 ('1', 'ϵͳ¹ÜÀíÔ±', 'analog_loader_op_permit', '1');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('1', 'ϵͳ¹ÜÀíÔ±', 'batt_test_op_permit', '1');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('1', 'ϵͳ¹ÜÀíÔ±', '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 ('1', 'ϵͳ¹ÜÀíÔ±', '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 ('1', 'ϵͳ¹ÜÀíÔ±', '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 ('1', 'ϵͳ¹ÜÀíÔ±', '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 ('1', 'ϵͳ¹ÜÀíÔ±', 'batt_alm_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 ('1', 'ϵͳ¹ÜÀíÔ±', 'batt_alm_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 ('1', 'ϵͳ¹ÜÀíÔ±', 'batt_alm_clear_permit', '1');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('1', 'ϵͳ¹ÜÀíÔ±', 'batt_alm_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 ('1', 'ϵͳ¹ÜÀíÔ±', 'batt_alm_param_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 ('1', 'ϵͳ¹ÜÀíÔ±', 'batt_alm_param_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 ('1', 'ϵͳ¹ÜÀíÔ±', 'dev_alm_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 ('1', 'ϵͳ¹ÜÀíÔ±', 'dev_alm_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 ('1', 'ϵͳ¹ÜÀíÔ±', 'dev_alm_clear_permit', '1');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.User_Permitgroup_Table + "(permit_group_id,permit_group_name,permit_item_name,permit_item_value) VALUES ('1', 'ϵͳ¹ÜÀíÔ±', 'dev_alm_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 ('1', 'ϵͳ¹ÜÀíÔ±', 'battfault_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 ('1', 'ϵͳ¹ÜÀíÔ±', 'battfault_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 ('1', 'ϵͳ¹ÜÀíÔ±', 'battfault_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 ('1', 'ϵͳ¹ÜÀíÔ±', 'battfault_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 ('1', 'ϵͳ¹ÜÀíÔ±', 'battmaint_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 ('1', 'ϵͳ¹ÜÀíÔ±', '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 ('1', 'ϵͳ¹ÜÀíÔ±', '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 ('1', 'ϵͳ¹ÜÀíÔ±', '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 ('1', 'ϵͳ¹ÜÀíÔ±', '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 ('1', 'ϵͳ¹ÜÀíÔ±', '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 ('1', 'ϵͳ¹ÜÀíÔ±', '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 ('1', 'ϵͳ¹ÜÀíÔ±', '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 ('1', 'ϵͳ¹ÜÀíÔ±', '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 ('1', 'ϵͳ¹ÜÀíÔ±', '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 ('1', 'ϵͳ¹ÜÀíÔ±', 'batt_map_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 ('1', 'ϵͳ¹ÜÀíÔ±', 'batt_map_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 ('1', 'ϵͳ¹ÜÀíÔ±', 'batt_discharge_model_permit', '0');");
|
}
|
}
|
|
res = sql.sqlMysqlQuery("SELECT COUNT(*) as sum_count FROM " + Sql_Mysql.User_Permitgroup_Table + " WHERE permit_group_id = 2");
|
//²åÈëĬÈϵÄÉó¼Æ¹ÜÀíԱȨÏÞ×é
|
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 ('2', 'Éó¼Æ¹ÜÀíÔ±', 'battinf_report_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 ('2', 'Éó¼Æ¹ÜÀíÔ±', 'battgroup_report_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 ('2', 'Éó¼Æ¹ÜÀíÔ±', '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 ('2', 'Éó¼Æ¹ÜÀíÔ±', '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 ('2', 'Éó¼Æ¹ÜÀíÔ±', 'monomer_report_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 ('2', 'Éó¼Æ¹ÜÀíÔ±', '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 ('2', 'Éó¼Æ¹ÜÀíÔ±', '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 ('2', 'Éó¼Æ¹ÜÀíÔ±', '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 ('2', 'Éó¼Æ¹ÜÀíÔ±', '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 ('2', 'Éó¼Æ¹ÜÀíÔ±', '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 ('2', 'Éó¼Æ¹ÜÀíÔ±', '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 ('2', 'Éó¼Æ¹ÜÀíÔ±', '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 ('2', 'Éó¼Æ¹ÜÀíÔ±', '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 ('2', 'Éó¼Æ¹ÜÀíÔ±', '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 ('2', 'Éó¼Æ¹ÜÀíÔ±', '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 ('2', 'Éó¼Æ¹ÜÀíÔ±', 'server_param_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 ('2', 'Éó¼Æ¹ÜÀíÔ±', '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 ('2', 'Éó¼Æ¹ÜÀíÔ±', '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 ('2', 'Éó¼Æ¹ÜÀíÔ±', '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 ('2', 'Éó¼Æ¹ÜÀíÔ±', '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 ('2', 'Éó¼Æ¹ÜÀíÔ±', '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 ('2', 'Éó¼Æ¹ÜÀíÔ±', '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 ('2', 'Éó¼Æ¹ÜÀíÔ±', '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 ('2', 'Éó¼Æ¹ÜÀíÔ±', 'batt_alm_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 ('2', 'Éó¼Æ¹ÜÀíÔ±', '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 ('2', 'Éó¼Æ¹ÜÀíÔ±', '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 ('2', 'Éó¼Æ¹ÜÀíÔ±', '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 ('2', 'Éó¼Æ¹ÜÀíÔ±', 'batt_alm_param_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 ('2', 'Éó¼Æ¹ÜÀíÔ±', '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 ('2', 'Éó¼Æ¹ÜÀíÔ±', 'dev_alm_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 ('2', 'Éó¼Æ¹ÜÀíÔ±', '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 ('2', 'Éó¼Æ¹ÜÀíÔ±', '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 ('2', 'Éó¼Æ¹ÜÀíÔ±', '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 ('2', 'Éó¼Æ¹ÜÀíÔ±', 'battfault_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 ('2', 'Éó¼Æ¹ÜÀíÔ±', '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 ('2', 'Éó¼Æ¹ÜÀíÔ±', '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 ('2', 'Éó¼Æ¹ÜÀíÔ±', '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 ('2', 'Éó¼Æ¹ÜÀíÔ±', '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 ('2', 'Éó¼Æ¹ÜÀíÔ±', '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 ('2', 'Éó¼Æ¹ÜÀíÔ±', '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 ('2', 'Éó¼Æ¹ÜÀíÔ±', '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 ('2', 'Éó¼Æ¹ÜÀíÔ±', '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 ('2', 'Éó¼Æ¹ÜÀíÔ±', '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 ('2', 'Éó¼Æ¹ÜÀíÔ±', '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 ('2', 'Éó¼Æ¹ÜÀíÔ±', '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 ('2', 'Éó¼Æ¹ÜÀíÔ±', '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 ('2', 'Éó¼Æ¹ÜÀíÔ±', '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 ('2', 'Éó¼Æ¹ÜÀíÔ±', 'batt_map_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 ('2', 'Éó¼Æ¹ÜÀíÔ±', '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 ('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 {
|
if(res != null) {
|
try {
|
res.close();
|
} catch (SQLException e) {
|
e.printStackTrace();
|
}
|
}
|
sql.close_con();
|
}
|
}
|
|
/**
|
* ´´½¨È¨ÏÞÓû§¼Ç¼±í
|
* @param pool
|
* @param recreate
|
*/
|
public static void createUser_Permitgroup_Data_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str_del = " DROP TABLE IF EXISTS "+Sql_Mysql.User_Permitgroup_Data_Table;
|
String sql_str = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.User_Permitgroup_Data_Table + " (" +
|
" `num` int(11) NOT NULL AUTO_INCREMENT," +
|
" `permit_group_id` int(11) NOT NULL DEFAULT '0'," +
|
" `uId` int(11) NOT NULL DEFAULT '0'," +
|
" PRIMARY KEY (`num`)" +
|
") ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8;";
|
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
|
String sql_str_sel = " SELECT COUNT(*) as sum_count FROM "+Sql_Mysql.User_Permitgroup_Data_Table;
|
ResultSet res = null;
|
try {
|
if(recreate) {
|
sql.sqlMysqlExecute(sql_str_del);
|
}
|
sql.sqlMysqlExecute(sql_str);
|
//Ìí¼ÓÉÏÒ»´ÎÖØÆôʱ¼ä×Ö¶Î
|
res = sql.sqlMysqlQuery(sql_str_sel);
|
if(res.next()) {
|
int count = res.getInt("sum_count");
|
if(count<1) {
|
sql.sqlMysqlExecute("INSERT INTO "+Sql_Mysql.User_Permitgroup_Data_Table+" VALUES ('1', '100001', '1001');");
|
sql.sqlMysqlExecute("INSERT INTO "+Sql_Mysql.User_Permitgroup_Data_Table+" VALUES ('2', '100002', '1002');");
|
}
|
}
|
//¸øϵͳ¹ÜÀíÔ±·ÖÅäϵͳ¹ÜÀíԱȨÏÞ
|
res = sql.sqlMysqlQuery("SELECT COUNT(*) as sum_count FROM " + Sql_Mysql.User_Permitgroup_Data_Table + " WHERE permit_group_id = 1 AND uId = 1");
|
if(res.next()) {
|
int count = res.getInt("sum_count");
|
if(count<1) {
|
sql.sqlMysqlExecute("INSERT INTO "+Sql_Mysql.User_Permitgroup_Data_Table+"(permit_group_id,uId) VALUES ('1', '1');");
|
}
|
}
|
|
//¸øÉó¼Æ¹ÜÀíÔ±·ÖÅäÉó¼Æ¹ÜÀíԱȨÏÞ
|
res = sql.sqlMysqlQuery("SELECT COUNT(*) as sum_count FROM " + Sql_Mysql.User_Permitgroup_Data_Table + " WHERE permit_group_id = 2 AND uId = 2");
|
if(res.next()) {
|
int count = res.getInt("sum_count");
|
if(count<1) {
|
sql.sqlMysqlExecute("INSERT INTO "+Sql_Mysql.User_Permitgroup_Data_Table+"(permit_group_id,uId) VALUES ('2', '2');");
|
}
|
}
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
if(res != null) {
|
try {
|
res.close();
|
} catch (SQLException e) {
|
e.printStackTrace();
|
}
|
}
|
sql.close_con();
|
}
|
}
|
|
/**
|
* ´´½¨ db_user Êý¾Ý¿â
|
* @param pool
|
*/
|
public static void createDB_UserDB(MysqlConnPool pool) {
|
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
|
try {
|
sql.sqlMysqlExecute("CREATE DATABASE IF NOT EXISTS " + Sql_Mysql.DB_USER);
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
sql.close_con();
|
}
|
}
|
|
|
/**
|
*
|
*/
|
public static void createUser_Limit_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.User_Limit_Table;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.User_Limit_Table + " (" +
|
" `id` int(11) NOT NULL AUTO_INCREMENT," +
|
" `userId` int(11) DEFAULT NULL," +
|
" `limitDuration` int(3) DEFAULT NULL COMMENT 'ÏÞÖÆʱ¼ä,µ¥Î»:Ãë'," +
|
" `loginTime` datetime DEFAULT NULL COMMENT 'µÇ¼ʱ¼ä'," +
|
" PRIMARY KEY (`id`)" +
|
") ENGINE=InnoDB AUTO_INCREMENT=36 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();
|
}
|
}
|
|
/**
|
* ´´½¨Ïß³ÌÊÖ¶¯Æô¶¯¹¤¾ß±í
|
*/
|
public static void createTb_user_infTable(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.UserInfTable;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.UserInfTable + " (" +
|
" `uId` bigint(20) NOT NULL AUTO_INCREMENT," +
|
" `uSnId` varchar(50) NOT NULL DEFAULT '123456'," +
|
" `uName` varchar(50) NOT NULL DEFAULT ' '," +
|
" `uShenFenId` varchar(50) NOT NULL DEFAULT ' '," +
|
" `uEmployeeId` varchar(50) NOT NULL DEFAULT ' '," +
|
" `uTelephone` varchar(20) NOT NULL DEFAULT '0'," +
|
" `uMobilephone` varchar(20) NOT NULL DEFAULT '0'," +
|
" `uEmail` varchar(100) NOT NULL DEFAULT '0'," +
|
" `uAddr` varchar(200) NOT NULL DEFAULT ' '," +
|
" `uBirthDay` date NOT NULL DEFAULT '1980-01-01'," +
|
" `uAccessionDay` date NOT NULL DEFAULT '2001-01-01'," +
|
" `uSex` varchar(10) NOT NULL DEFAULT 'u'," +
|
" `uDepartment` varchar(50) NOT NULL DEFAULT ' '," +
|
" `uProTitle` varchar(50) NOT NULL DEFAULT ' '," +
|
" `uAuthority` varchar(50) NOT NULL DEFAULT ' '," +
|
" `uJobGroup` varchar(50) NOT NULL DEFAULT ' '," +
|
" `uDuties` varchar(50) NOT NULL DEFAULT ' '," +
|
" `uTasks` varchar(50) NOT NULL DEFAULT ' '," +
|
" `uBaojiUsr` tinyint(1) NOT NULL DEFAULT '1'," +
|
" `uNote` varchar(200) NOT NULL DEFAULT ' '," +
|
" `upassword` varchar(64) NOT NULL DEFAULT ''," +
|
" `uPubKeyX` varchar(200) NOT NULL DEFAULT ''," +
|
" `uPubKeyY` varchar(200) NOT NULL DEFAULT ''," +
|
" `uKey_ID` varchar(200) NOT NULL DEFAULT ''," +
|
" `face_id` int(5) DEFAULT NULL," +
|
" `license` text DEFAULT NULL," +
|
" PRIMARY KEY (`uId`)," +
|
" UNIQUE KEY `user_id` (`uId`)" +
|
") ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;";
|
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
|
ResultSet rs = null;
|
try {
|
// if(true == recreate) {
|
// sql.sqlMysqlExecute(sql_str01);
|
// }
|
sql.sqlMysqlUseDB(Sql_Mysql.DB_USER);
|
|
sql.sqlMysqlExecute(sql_str02);
|
|
//Ìí¼Ó¼ÓÃܸ澯upassword
|
ResultSet res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_user'"
|
+ " AND table_name='tb_user_inf'"
|
+ " AND column_name='upassword'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.UserInfTable
|
+ " ADD COLUMN `upassword` varchar(200) NOT NULL DEFAULT ''");
|
}else{
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.UserInfTable
|
+ " MODIFY COLUMN `upassword` varchar(1000) NOT NULL DEFAULT '';");
|
}
|
|
//Ìí¼Ó¹«Ô¿X
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_user'"
|
+ " AND table_name='tb_user_inf'"
|
+ " AND column_name='uPubKeyX'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.UserInfTable
|
+ " ADD COLUMN `uPubKeyX` varchar(200) NOT NULL DEFAULT ''");
|
}
|
|
|
//Ìí¼Ó¹«Ô¿Y
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_user'"
|
+ " AND table_name='tb_user_inf'"
|
+ " AND column_name='uPubKeyY'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.UserInfTable
|
+ " ADD COLUMN `uPubKeyY` varchar(200) NOT NULL DEFAULT ''");
|
}
|
|
//Ìí¼ÓuKey_ID
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_user'"
|
+ " AND table_name='tb_user_inf'"
|
+ " AND column_name='uKey_ID'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.TB_UserInf
|
+ " ADD COLUMN `uKey_ID` varchar(200) NOT NULL DEFAULT ''");
|
}
|
|
//Ìí¼Óface_id
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_user'"
|
+ " AND table_name='tb_user_inf'"
|
+ " AND column_name='face_id'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.TB_UserInf
|
+ " ADD COLUMN `face_id` int(5) DEFAULT NULL;");
|
}
|
//Ìí¼Ólicense
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_user'"
|
+ " AND table_name='tb_user_inf'"
|
+ " AND column_name='license'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.TB_UserInf
|
+ " ADD COLUMN `license` text DEFAULT NULL;");
|
}
|
//Ìí¼Ólogin_type[µÇ½״̬]
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_user'"
|
+ " AND table_name='tb_user_inf'"
|
+ " AND column_name='login_type'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.TB_UserInf
|
+ " ADD COLUMN `login_type` tinyint(1) DEFAULT '1' COMMENT 'µÇ¼ÀàÐÍ:1-ÃÜÂë,2-ÈËÁ³';");
|
}
|
//`uRole` tinyint(1) DEFAULT NULL COMMENT '¸æ¾¯½ÇÉ«£º0-¹ÜÀíÔ±¡¢1-ά»¤×鳤¡¢2-ά»¤×éÔ±'
|
//Ìí¼ÓuRole['¸æ¾¯½ÇÉ«£º0-¹ÜÀíÔ±¡¢1-ά»¤×鳤¡¢2-ά»¤×éÔ±']
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_user'"
|
+ " AND table_name='tb_user_inf'"
|
+ " AND column_name='uRole'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.TB_UserInf
|
+ " ADD COLUMN `uRole` tinyint(1) DEFAULT NULL COMMENT '¸æ¾¯½ÇÉ«£º0-¹ÜÀíÔ±¡¢1-ά»¤×鳤¡¢2-ά»¤×éÔ±';");
|
}
|
|
|
//ÐÞ¸ÄusnidµÄ³¤¶È¸Ä³Évarchar(1000)
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_user'"
|
+ " AND table_name='tb_user_inf'"
|
+ " AND column_name='uSnId'");
|
if(res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.TB_UserInf
|
+ " CHANGE COLUMN `uSnId` `uSnId` VARCHAR(1000) NOT NULL DEFAULT '123456';");
|
}
|
//ÐÞ¸ÄpasswordµÄ³¤¶È¸Ä³Évarchar(1000)
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_user'"
|
+ " AND table_name='tb_user_inf'"
|
+ " AND column_name='upassword'");
|
if(res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.TB_UserInf
|
+ " CHANGE COLUMN `upassword` `upassword` VARCHAR(1000) NOT NULL DEFAULT '';");
|
}
|
|
|
//Ìí¼Ótype
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_user'"
|
+ " AND table_name='tb_user_inf'"
|
+ " AND column_name='type'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.TB_UserInf
|
+ " ADD COLUMN `type` tinyint(1) DEFAULT '1' COMMENT 'Õ˺ÅÀàÐÍ 1:³¤ÆÚ,2:ÁÙʱ ';");
|
}
|
//Ìí¼Óstatus
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_user'"
|
+ " AND table_name='tb_user_inf'"
|
+ " AND column_name='status'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.TB_UserInf
|
+ " ADD COLUMN `status` tinyint(1) DEFAULT '1' COMMENT 'Õ˺Å״̬ 1:¼¤»î,2:ÐÝÃß,3:Ëø¶¨,0:×¢Ïú';");
|
}
|
//Ìí¼Óexpiration_time
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_user'"
|
+ " AND table_name='tb_user_inf'"
|
+ " AND column_name='expiration_time'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.TB_UserInf
|
+ " ADD COLUMN `expiration_time` datetime DEFAULT NULL COMMENT 'ÁÙʱÕ˺ŵĵ½ÆÚʱ¼ä';");
|
}
|
//Ìí¼Ólast_login_time
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_user'"
|
+ " AND table_name='tb_user_inf'"
|
+ " AND column_name='last_login_time'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.TB_UserInf
|
+ " ADD COLUMN `last_login_time` datetime DEFAULT NULL COMMENT '×îºóµÇ¼ʱ¼ä';");
|
}
|
//Ìí¼Ópassword_update_time
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_user'"
|
+ " AND table_name='tb_user_inf'"
|
+ " AND column_name='password_update_time'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.TB_UserInf
|
+ " ADD COLUMN `password_update_time` datetime DEFAULT NULL COMMENT 'ÃÜÂë¸üÐÂʱ¼ä,ÖÁÉÙ3¸öÔÂÒ»´Î';");
|
}
|
|
//Ìí¼Ócreate_time
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_user'"
|
+ " AND table_name='tb_user_inf'"
|
+ " AND column_name='create_time'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.TB_UserInf
|
+ " ADD COLUMN `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '´´½¨Ê±¼ä';");
|
}
|
|
//Ìí¼Ólock_time
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_user'"
|
+ " AND table_name='tb_user_inf'"
|
+ " AND column_name='lock_time'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.TB_UserInf
|
+ " ADD COLUMN `lock_time` datetime DEFAULT NULL COMMENT 'Õ˺ÅËø¶¨Ê±¼ä';");
|
}
|
//Ìí¼Óvisit_time
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_user'"
|
+ " AND table_name='tb_user_inf'"
|
+ " AND column_name='visit_time'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.TB_UserInf
|
+ " ADD COLUMN `visit_time` VARCHAR(17) NULL DEFAULT '00:00:01~23:59:59' COMMENT 'ÔÊÐí·ÃÎÊʱ¼äÇø¼ä' AFTER `lock_time`;");
|
}
|
//Ìí¼Óvisit_ip
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_user'"
|
+ " AND table_name='tb_user_inf'"
|
+ " AND column_name='visit_ip'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.TB_UserInf
|
+ " ADD COLUMN `visit_ip` VARCHAR(255) NULL DEFAULT '*' COMMENT 'ÔÊÐí·ÃÎÊip' AFTER `visit_time`;");
|
}
|
|
|
//123456--------
|
//String upstr = "jFr3/n7JBhwxVE+uiMzC9LapSjDb97x1P7s8npTTLepabMucHcgVPwU/rkiG4tLlEICjYJKINQzoZQ0bqGxhwASe9vT2KukOOHJAEmBjs1uWkJoK0GLMZtNt7oiRoQzVSzPCfmtlc64gplUCSH6UTqqkMu//pEn/67W4sTLzUzg=";
|
//String upstr = "X9rYw0Za1T7vgFO9cEMghH8f+Uo1Dhc3jAnMPpaKnCXL8nJ5xqueQ7Pldp0GmOr3imulIqxIQjdwZ43trz6s9YDi9lpEDNGVHQAx6hazHQmSnQ04HrPRn6xn9hvYo6BaJQYf+Jw5SmYwRgBWHbIA6atl/czRcDnXV9p7TCtcE8YsrgFYyT07D7/AmjPl1taiJmYnrojmqrQbOY/WE7nvHftjRkJoQcywYOfLY4zy4VOwhD6//Kpzo6klsLTuZgWMP1Wr4BzNB41EyjN68lzRiPhTQN0E8MuXwNSUS2sOODr96r6m9Z15Gg0iuzs60pz3HNXXoreRDjb5qZODprnEau0i94A9vuGaDS+Lr0QFV95ZAnCQ0t0j11QgxnuiBL0UIBNLYexCyTn3T5+cPDPMBC9bsMkCLzWvrapIFcGqrboxzx9g6KUh9jH24Eeckwndqqz5S+I0GeZbEZEAjHqgNSCPMDX0L8+CBvm6atT5kXpy1gls5YDsEDds0bTl9baf";
|
//fg001@hdw --- ×îÐÂĬÈÏÓû§ÃÜÂë
|
String upstr = "b27LZm0jrenKa++WUmKOpsoACZi/lwXs1sLAD+f6KqPGD53Ru5V8vHCM0b7HwoGx5f7ieCzxt8M3CNb+vtQdDd1nNr22K9eR5BfLdKojzt1lDpfwLfqBOozkl6q5nlF4hqQnIjaOdUT0llIVDESc94WEXKzvVYAx5BybNBcub4ihEbgDWHFp2fQNOTZc/L8nZIHBWJe163a0u2A+pR5XIxbrDcHK2wnkULDs2kiiZhXX7O970VCYL97m11IbYyPQFiV25oN1aM2GJZrpg4wsmcIPj/q6aNxhivuhohGH36KBP8zrzNPRKEQ6jeRVue7rI7uG4sqsDCwE3D94/GhQfdHwD7ApPQwPqUjbyPJ/+pPoGYC1ATM//Ed6a7+eqcbZ0JovLIjaiLBgqF1JjUNFrwV2g50kFvTlI9y6c8dqRy4zS+tQPd3KPPQuHuAd80pttiLwB4mvcdHER4cjrDn4m7eMu1UgKJ+5+N2Tajqu4ASjWlaPD+cXA+/8qka0nYze";
|
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', '" + 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','1','1',null,'"+Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms)+"','2022-05-19 14:53:44','2022-05-19 14:53:44',null,'00:00:01~23:59:59','*');");
|
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','1','1',null,'"+Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms)+"','2022-05-19 14:53:44','2022-05-19 14:53:44',null,'00:00:01~23:59:59','*');");
|
}
|
}*/
|
|
//ĬÈÏÐÂÔöϵͳĬÈϵÄÕ˺Åsuperuser,admin
|
{
|
//Ìí¼Óadmin
|
res = sql.sqlMysqlQuery("SELECT COUNT(*) as num_count FROM " + Sql_Mysql.TB_UserInf + " WHERE uName = 'admin';");
|
if(res.next()) {
|
int count = res.getInt("num_count");
|
if(count<1) {
|
//ĬÈÏûÓÐÌí¼ÓÓû§ÐÅϢʱÌí¼Ó'admin'
|
//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', NULL, '0','0','0','1','1',null,'"+Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms)+"','2022-05-19 14:53:44','2022-05-19 14:53:44',null,'00:00:01~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(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'");
|
}
|
}
|
//Ìí¼Ósuperuser
|
res = sql.sqlMysqlQuery("SELECT COUNT(*) as num_count FROM " + Sql_Mysql.TB_UserInf + " WHERE uName = 'superuser';");
|
if(res.next()) {
|
int count = res.getInt("num_count");
|
if(count<1) {
|
//ĬÈÏûÓÐÌí¼ÓÓû§ÐÅϢʱÌí¼Ó'superuser'
|
//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', NULL, '0','0','0','1','1',null,'"+Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms)+"','2022-05-19 14:53:44','2022-05-19 14:53:44',null,'00:00:01~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(1002,'" + upstr + "', 'superuser','','ĬÈÏ°à×é','" + 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 = 'superuser'");
|
}
|
|
}
|
}
|
|
|
//ĬÈÏÐÂÔöÖ¸¶¨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 = 'δµÇ¼µÄÓû§Õ˺Å'");
|
}
|
|
//Ìí¼ÓĬÈÏÕ˺Å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,'"+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");
|
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','*');");
|
}
|
}
|
|
//ÐÞ¸ÄÕ˺ŵÄËø¶¨×´Ì¬
|
sql.sqlMysqlExecute("UPDATE db_user.tb_user_inf SET status = 1,last_login_time = NOW();");
|
|
}
|
|
//½«Óû§ÐÔ±ðÊÇ·ÇÅ®µÄÕ˺ÅÐÔ±ð¸Ä³É0-ÄÐ 1-Å®
|
sql.sqlMysqlExecute("UPDATE " + Sql_Mysql.TB_UserInf + " SET uSex = '0' WHERE uSex != 'Å®' AND uSex != '1'");
|
//½«Óû§Å®¸üÐÂΪ1
|
sql.sqlMysqlExecute("UPDATE " + Sql_Mysql.TB_UserInf + " SET uSex = '1' WHERE uSex = 'Å®'");
|
|
//½«Óû§±íÖÐÉÏ´ÎÃÜÂë¸üÐÂʱ¼äΪ'Null'µÄ¼Ç¼¸üÐÂΪµ±Ç°Ê±¼ä
|
sql.sqlMysqlExecute("UPDATE " + Sql_Mysql.TB_UserInf + " SET password_update_time = NOW() WHERE password_update_time IS NULL;");
|
|
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
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 ' '," +
|
" `operation_detail` text COMMENT '²Ù×÷µÄ¾ßÌåÊý¾Ý'," +
|
" `read_flag` tinyint(1) DEFAULT '1' COMMENT 'ÊÇ·ñÒÑÔĶÁ,´Ë¹¦ÄÜÕë¶ÔÒì³£ÐÅÏ¢'," +
|
" `uOprateMsgEnUs` text," +
|
" `operation_detail_enUs` text," +
|
" PRIMARY KEY (`num`)," +
|
" KEY `user_id` (`uId`)" +
|
") ENGINE=InnoDB AUTO_INCREMENT=7293 DEFAULT CHARSET=utf8;";
|
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
|
ResultSet res = null;
|
try {
|
if(true == recreate) {
|
sql.sqlMysqlExecute(sql_str01);
|
}
|
sql.sqlMysqlExecute(sql_str02);
|
|
//Ìí¼Óoperation_detail
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_user'"
|
+ " AND table_name='tb_user_log'"
|
+ " AND column_name='operation_detail'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.User_Log_Table
|
+ " ADD COLUMN `operation_detail` text COMMENT '²Ù×÷µÄ¾ßÌåÊý¾Ý';");
|
}else{
|
//Ð޸ĵ±Ç°×ֶεÄÀàÐÍ
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.User_Log_Table
|
+ " CHANGE `operation_detail` `operation_detail` text COMMENT '²Ù×÷µÄ¾ßÌåÊý¾Ý';");
|
}
|
|
//ÐÞ¸ÄuOprateMsg¸ñʽΪtext
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_user'"
|
+ " AND table_name='tb_user_log'"
|
+ " AND column_name='uOprateMsg'");
|
if(res.next()) {
|
//Ð޸ĵ±Ç°×ֶεÄÀàÐÍΪtext
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.User_Log_Table
|
+ " CHANGE `uOprateMsg` `uOprateMsg` text;");
|
}
|
|
|
//Ìí¼Óread_flag
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_user'"
|
+ " AND table_name='tb_user_log'"
|
+ " AND column_name='read_flag'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.User_Log_Table
|
+ " ADD COLUMN `read_flag` tinyint(1) DEFAULT '1' COMMENT 'ÊÇ·ñÒÑÔĶÁ,´Ë¹¦ÄÜÕë¶ÔÒì³£ÐÅÏ¢'");
|
}
|
|
sql.sqlMysqlExecute("DELETE FROM " + Sql_Mysql.User_Log_Table + " where DATE_SUB(CURDATE(), INTERVAL 30 DAY) > date(uOprateDay)");
|
|
res = null;
|
//Ìí¼ÓuOprateMsgEnUs
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_user'"
|
+ " AND table_name='tb_user_log'"
|
+ " AND column_name='uOprateMsgEnUs'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.User_Log_Table
|
+ " ADD COLUMN `uOprateMsgEnUs` text");
|
}
|
res = null;
|
//Ìí¼Óoperation_detail_enUs
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_user'"
|
+ " AND table_name='tb_user_log'"
|
+ " AND column_name='operation_detail_enUs'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.User_Log_Table
|
+ " ADD COLUMN `operation_detail_enUs` text");
|
}
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
if(res != null) {
|
try {
|
res.close();
|
} catch (SQLException e) {
|
e.printStackTrace();
|
}
|
}
|
sql.close_con();
|
}
|
}
|
|
public static void createTb_User_Work(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Tb_User_Work;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Tb_User_Work + " (" +
|
" `id` int(11) NOT NULL AUTO_INCREMENT," +
|
" `workId` int(11) NULL DEFAULT NULL," +
|
" `userId` int(11) NULL DEFAULT NULL COMMENT 'ά»¤Ô±id'," +
|
" `imageBefore` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '´¦ÀíÇ°ÕÕƬ'," +
|
" `imageAfter` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '´¦ÀíºóÕÕƬ'," +
|
" `workWay` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '´¦Àí°ì·¨'," +
|
" `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '¸æ¾¯ÃèÊö'," +
|
" `workSuggest` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '½¨Òé'," +
|
" `managerId` int(11) NULL DEFAULT NULL COMMENT '¹ÜÀíÔ±ÉóºË'," +
|
" `note` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'ÉóºËÒâ¼û'," +
|
" `createTime` datetime NULL DEFAULT NULL COMMENT '´´½¨Ê±¼ä-½Óµ¥Ê±¼ä'," +
|
" `endTime` datetime NULL DEFAULT NULL COMMENT '½áÊøʱ¼ä'," +
|
" `checkStatus` tinyint(4) NULL DEFAULT NULL COMMENT 'ÉóºË״̬'," +
|
" `checkedTime` datetime NULL DEFAULT NULL COMMENT 'ÉóºËʱ¼ä'," +
|
" PRIMARY KEY (`id`) USING BTREE" +
|
") ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 ROW_FORMAT = Dynamic;";
|
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();
|
}
|
}
|
|
public static void createTb_Work_Alarm(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Tb_Work_Alarm;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Tb_Work_Alarm + " (" +
|
" `id` int(11) NOT NULL AUTO_INCREMENT," +
|
" `alarmRecId` int(11) NULL DEFAULT NULL COMMENT 'tb_battalarm_dataµÄnum'," +
|
" `alarmRecordId` bigint(20) NULL DEFAULT NULL COMMENT 'battalarmºÍdevalarmµÄrecord_id'," +
|
" `stationId` int(11) NULL DEFAULT NULL COMMENT 'Õ¾µã»ú·¿id'," +
|
" `battGroupId` int(11) NULL DEFAULT NULL COMMENT 'tb_battalarm_dataµÄBattGroupId'," +
|
" `deviceId` int(11) NULL DEFAULT NULL," +
|
" `managerId` int(11) NULL DEFAULT NULL COMMENT '¹ÜÀíÔ±id'," +
|
" `userId` int(11) NULL DEFAULT NULL COMMENT 'ά»¤Ô±id'," +
|
" `status` tinyint(4) NULL DEFAULT NULL COMMENT '״̬'," +
|
" `dispatchTime` datetime NULL DEFAULT NULL COMMENT 'Åɵ¥Ê±¼ä'," +
|
" `alarmLevel` tinyint(4) NULL DEFAULT NULL COMMENT '¸æ¾¯µÈ¼¶'," +
|
" `alarmName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '¸æ¾¯Ãû³Æ'," +
|
" `alarmTime` datetime NULL DEFAULT NULL," +
|
" `createTime` datetime NULL DEFAULT NULL," +
|
" PRIMARY KEY (`id`) USING BTREE," +
|
" INDEX `idx_device_id`(`deviceId`) USING BTREE" +
|
") ENGINE=InnoDB AUTO_INCREMENT=1447 DEFAULT CHARSET=utf8 ROW_FORMAT = Dynamic;";
|
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();
|
}
|
}
|
|
|
|
public static void main(String[] args) {
|
String upstr = "jFr3/n7JBhwxVE+uiMzC9LapSjDb97x1P7s8npTTLepabMucHcgVPwU/rkiG4tLlEICjYJKINQzoZQ0bqGxhwASe9vT2KukOOHJAEmBjs1uWkJoK0GLMZtNt7oiRoQzVSzPCfmtlc64gplUCSH6UTqqkMu//pEn/67W4sTLzUzg=";
|
String phone = "153745192";
|
for(int i =1;i<=30;i++ ) {
|
System.out.println("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("+(2007+i)+",'" + upstr + "', '"+("test"+(i))+"','"+(phone + (i+10))+"','ĬÈÏ°à×é','" + upstr + "',1,0,1,1,null,'2021-12-14 16:18:44','2021-12-14 16:18:44','00:00:00~23:59:59','*');");
|
}
|
}
|
}
|
