package com.database_util;
|
|
import java.sql.ResultSet;
|
import java.sql.SQLException;
|
|
import com.sql.MysqlConnPool;
|
import com.sql.Sql_Mysql;
|
|
public class DB_db_user {
|
|
|
public static void init(MysqlConnPool pool, boolean recreate) {
|
|
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);
|
|
}
|
|
/**
|
*
|
*/
|
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());
|
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_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 + " 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');");
|
}
|
}
|
} 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');");
|
}
|
}
|
} 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.TB_UserInf;
|
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.TB_UserInf + " (" +
|
" `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) NOT NULL DEFAULT '1'," +
|
" `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.TB_UserInf
|
+ " ADD COLUMN `upassword` varchar(64) 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.TB_UserInf
|
+ " 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.TB_UserInf
|
+ " 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) NOT NULL DEFAULT '1'");
|
}
|
//Ìí¼Ó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-ÈËÁ³';");
|
}
|
res = sql.sqlMysqlQuery("SELECT COUNT(*) as num_count FROM " + Sql_Mysql.TB_UserInf);
|
if(res.next()) {
|
int count = res.getInt("num_count");
|
if(count<1) {
|
//ĬÈÏûÓÐÌí¼ÓÓû§ÐÅϢʱÌí¼Ósuperuser
|
sql.sqlMysqlExecute("INSERT INTO "+Sql_Mysql.TB_UserInf+" VALUES ('1001', 'admin', 'admin', 'admin', 'employeeid', '12345678912', '12345678912', 'abcde@mail.com', '', '1980-01-01', '2015-12-09', 'ÄÐ', '¹ã¶«Ê¡', 'protitle', 'authority', 'ĬÈÏ°à×é', 'duties', 'tasks', '1', 'note', '21232f297a57a5a743894a0e4a801fc3', '', '', '48505834353130373639353153594E4F', '28', '','0');");
|
sql.sqlMysqlExecute("INSERT INTO "+Sql_Mysql.TB_UserInf+" VALUES ('1002', '1', 'superuser', '1234567', '100010000', '12345678', '15346259512', '123456789@qq.com', '', '1990-04-20', '2016-03-28', 'ÄÐ', 'ºþ±±Ê¡', 'Èí¼þ¹¤³Ìʦ', 'authority111', 'ĬÈÏ°à×é', 'dutie', 'Íê³ÉÈí¼þµÄÑз¢¹¤×÷', '0', 'note', 'c4ca4238a0b923820dcc509a6f75849b', '', '', '14031C0F0136063E', '27', '','0');");
|
}
|
}
|
} 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 ' '," +
|
" PRIMARY KEY (`num`)," +
|
" KEY `user_id` (`uId`)" +
|
") ENGINE=InnoDB AUTO_INCREMENT=7293 DEFAULT CHARSET=utf8;";
|
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
|
try {
|
if(true == recreate) {
|
sql.sqlMysqlExecute(sql_str01);
|
}
|
sql.sqlMysqlExecute(sql_str02);
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
sql.close_con();
|
}
|
}
|
}
|
