package com.database_util;
|
|
import java.sql.ResultSet;
|
import java.sql.SQLException;
|
import java.util.ArrayList;
|
import java.util.Arrays;
|
import java.util.Date;
|
import java.util.List;
|
|
import com.base.Com;
|
import com.sql.MysqlConnPool;
|
import com.sql.Sql_Mysql;
|
|
public class DB_App_Sys {
|
|
public static void init(MysqlConnPool pool, boolean recreate) {
|
System.out.println(" db_app_sys init start at " + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms));
|
|
createDB_AppSys(pool);
|
|
createPage_Param_Table(pool, recreate);
|
|
createFbsdev_Statechange_Inf_Table(pool, recreate);
|
|
createDashboard_Module_Chart_Table(pool, recreate);
|
|
createDashboard_Module_Table(pool, recreate);
|
|
createDashboard_Chart_Type_Table(pool, recreate);
|
|
createApp_Sys_Table(pool, recreate);
|
|
createApp_Bts_Comm_Task_Table(pool, recreate);
|
|
createApp_Bts_Battgroup_Table(pool, recreate);
|
|
createMenu_Table(pool, recreate);
|
|
//3.5大屏
|
createTb_application_Table(pool, recreate);
|
createTb_application_config_Table(pool, recreate);
|
createTb_dashboard_chart_type_Table(pool, recreate);
|
createTb_dashboard_module_Table(pool, recreate);
|
createTb_dashboard_module_chart_Table(pool, recreate);
|
|
createTb_Page_Param_User_Table(pool, recreate);
|
|
createTb_Page_Param2_Table(pool, recreate);//创建表并初始化值
|
|
createTb_Menu_Approve_Table(pool, recreate);//创建表tb_menu_approve
|
|
createTb_Menu_User_Table(pool, recreate);//创建表tb_menu_approve
|
|
System.out.println(" db_app_sys init end at " + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms));
|
}
|
|
/**
|
*
|
* @Title: createTb_Menu_Approve_Table
|
* @Description: 建表tb_menu_approve
|
* @param pool
|
* @param recreate
|
* @author author
|
* @date 2021年12月13日
|
*/
|
private static void createTb_Menu_Approve_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Tb_Menu_Approve_Table;
|
String sql_str02 = " CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Tb_Menu_Approve_Table + " (" +
|
" `id` int(11) NOT NULL," +
|
" `label` varchar(255) DEFAULT NULL COMMENT '中文名称'," +
|
" `name` varchar(255) DEFAULT NULL COMMENT '名称'," +
|
" `src` varchar(255) DEFAULT NULL COMMENT '路径'," +
|
" `icon` varchar(100) DEFAULT NULL COMMENT '图标'," +
|
" `closable` tinyint(4) DEFAULT NULL COMMENT '是否可关闭'," +
|
" `enableduse` tinyint(4) DEFAULT NULL COMMENT '是否启用'," +
|
" `permitName` varchar(255) DEFAULT NULL COMMENT '权限'," +
|
" `level` tinyint(4) DEFAULT NULL COMMENT '菜单等级'," +
|
" `ord` tinyint(4) DEFAULT NULL COMMENT '排序'," +
|
" `menuId` int(11) DEFAULT NULL COMMENT '上级菜单id'," +
|
" `createTime` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '申请时间'," +
|
" `approveTime` datetime DEFAULT NULL COMMENT '审批时间'," +
|
" `userId` int(11) DEFAULT NULL COMMENT '申请用户'," +
|
" `status` tinyint(1) DEFAULT '0' COMMENT '审批状态 0:未审批,1:已审批-通过,2:已审批-拒绝'," +
|
" KEY `idx_id` (`id`)," +
|
" KEY `idx_userId` (`userId`)" +
|
") ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;";
|
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();
|
}
|
}
|
/**
|
*
|
* @Title: createTb_Menu_User_Table
|
* @Description: 建表tb_menu_user
|
* @param pool
|
* @param recreate
|
* @author author
|
* @date 2021年12月13日
|
*/
|
private static void createTb_Menu_User_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Tb_Menu_User_Table;
|
String sql_str02 = " CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Tb_Menu_User_Table + " (" +
|
" `num` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增长主键'," +
|
" `id` int(11) DEFAULT NULL COMMENT '菜单id'," +
|
" `label` varchar(255) DEFAULT NULL COMMENT '中文名称'," +
|
" `name` varchar(255) DEFAULT NULL COMMENT '名称'," +
|
" `src` varchar(255) DEFAULT NULL COMMENT '路径'," +
|
" `icon` varchar(100) DEFAULT NULL COMMENT '图标'," +
|
" `closable` tinyint(4) DEFAULT NULL COMMENT '是否可关闭'," +
|
" `enableduse` tinyint(4) DEFAULT NULL COMMENT '是否启用'," +
|
" `permitName` varchar(255) DEFAULT NULL COMMENT '权限'," +
|
" `level` tinyint(4) DEFAULT NULL COMMENT '菜单等级'," +
|
" `ord` tinyint(4) DEFAULT NULL COMMENT '排序'," +
|
" `menuId` int(11) DEFAULT NULL COMMENT '上级菜单id'," +
|
" `userId` int(11) DEFAULT NULL COMMENT '用户id'," +
|
" PRIMARY KEY (`num`)" +
|
") 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();
|
}
|
}
|
|
private static void createTb_Page_Param2_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Tb_Page_Param2_Table;
|
String sql_str02 = " CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Tb_Page_Param2_Table + " (" +
|
" `id` int(11) NOT NULL AUTO_INCREMENT," +
|
" `param` varchar(45) DEFAULT NULL COMMENT '参数'," +
|
" `label` varchar(45) DEFAULT NULL COMMENT '标签'," +
|
" `value` varchar(45) DEFAULT NULL COMMENT '参数的值'," +
|
" `category` int(11) DEFAULT NULL COMMENT '分类'," +
|
" PRIMARY KEY (`id`)" +
|
") ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='页面参数配置,配置非状态量参数';";
|
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
|
ResultSet res = null;
|
try {
|
if(true == recreate) {
|
sql.sqlMysqlExecute(sql_str01);
|
}
|
sql.sqlMysqlExecute(sql_str02);
|
|
//添加lableEnUs
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_app_sys'"
|
+ " AND table_name='tb_page_param2'"
|
+ " AND column_name='lableEnUs'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Tb_Page_Param2_Table
|
+ " ADD COLUMN `lableEnUs` varchar(255) DEFAULT '' COMMENT '标签国际化英文名';");
|
}
|
|
//修改category改为categoryId
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_app_sys'"
|
+ " AND table_name='tb_page_param2'"
|
+ " AND column_name='category'");
|
if(true == res.next()) {
|
// System.out.println("true");
|
sql.sqlMysqlExecute("ALTER TABLE `db_app_sys`.`tb_page_param2` CHANGE `category` `categoryId` int(11) DEFAULT NULL COMMENT '分类';");
|
}else{
|
|
}
|
|
//初始化默认数据
|
res = sql.sqlMysqlQuery("SELECT COUNT(*) num FROM db_app_sys.tb_page_param2;");
|
if(false != res.next()) {
|
int num = res.getInt("num");
|
if(num>0){
|
//根据唯一id检测默认三条数据是否存在
|
res = sql.sqlMysqlQuery("SELECT id FROM db_app_sys.tb_page_param2;");
|
List<Integer> ids= new ArrayList<Integer>();
|
while(res.next()){
|
int id = res.getInt("id");
|
ids.add(id);
|
}
|
// System.out.println("db_app_sys.tb_page_param2 ids:"+ids);
|
List<Integer> idsDefault2 = SqlsUtils.idsDefault2;
|
for (int i = 0; i < idsDefault2.size(); i++) {
|
if (!ids.contains(idsDefault2.get(i))) {
|
sql.sqlMysqlExecute(SqlsUtils.sqlstb_page_param2.get(i));
|
System.out.println("insert id = "+SqlsUtils.sqlstb_page_param2.get(i));
|
}
|
}
|
|
}else{
|
//不存在添加
|
sql.sqlMysqlExecute("INSERT INTO `db_app_sys`.`tb_page_param2` (`id`, `param`, `label`, `value`, `categoryId`) "
|
+ "VALUES ('1', 'visit_time_first', '用户登录访问控制-访问时间最早', '00:00:01', '1'),"
|
+ "('2', 'visit_time_last', '用户登录访问控制-访问时间最晚', '23:59:59', '1'),"
|
+ "('3', 'visit_ip', '用户登录访问控制-访问客户端ip-允许', '*', '1'),"
|
+ "('4', 'audit_cap', '审计数据记录容量', '5000', '2');");
|
}
|
|
}
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
sql.close_con();
|
}
|
}
|
|
/**
|
*
|
* @Title: createTb_Page_Param_User_Table
|
* @Description: 创建表db_app_sys.tb_page_param_user
|
* @param pool
|
* @param recreate
|
*/
|
private static void createTb_Page_Param_User_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Tb_Page_Param_User_Table;
|
String sql_str02 = " CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Tb_Page_Param_User_Table + " (" +
|
" `id` int(11) NOT NULL AUTO_INCREMENT," +
|
" `lableEnUs` varchar(255) DEFAULT NULL COMMENT '标签国际化英文'," +
|
" `key` varchar(45) CHARACTER SET utf8 DEFAULT NULL," +
|
" `label` varchar(45) CHARACTER SET utf8 DEFAULT NULL," +
|
" `show` tinyint(4) DEFAULT NULL," +
|
" `user_id` int(11) DEFAULT NULL," +
|
" `type` int(11) DEFAULT NULL COMMENT '分类'," +
|
" PRIMARY KEY (`id`)" +
|
") ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='页面可配置,关联用户id';";
|
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
|
ResultSet res = null;
|
try {
|
if(true == recreate) {
|
sql.sqlMysqlExecute(sql_str01);
|
}
|
sql.sqlMysqlExecute(sql_str02);
|
|
//添加price_factor
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_app_sys'"
|
+ " AND table_name='tb_page_param_user'"
|
+ " AND column_name='type'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Tb_Page_Param_User_Table
|
+ " ADD COLUMN `type` int(11) COMMENT '电价系数';");
|
}
|
//添加lableEnUs
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_app_sys'"
|
+ " AND table_name='tb_page_param_user'"
|
+ " AND column_name='lableEnUs'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Tb_Page_Param_User_Table
|
+ " ADD COLUMN `lableEnUs` varchar(255) DEFAULT NULL COMMENT '标签国际化英文';");
|
}
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
sql.close_con();
|
}
|
}
|
|
private static void createTb_dashboard_module_chart_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Tb_dashboard_module_chart_Table;
|
String sql_str02 = " CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Tb_dashboard_module_chart_Table + " (" +
|
" id int(11) NOT NULL AUTO_INCREMENT," +
|
" param varchar(30) DEFAULT NULL COMMENT '具体参数'," +
|
" status int(1) DEFAULT NULL COMMENT '参数是否页面显示'," +
|
" categoryId int(1) DEFAULT NULL COMMENT '参数分类,类目1,类目2'," +
|
" PRIMARY KEY (id) USING BTREE" +
|
") ENGINE=InnoDB AUTO_INCREMENT=21 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();
|
}
|
}
|
|
private static void createTb_dashboard_module_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Tb_dashboard_module_Table;
|
String sql_str02 = " CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Tb_dashboard_module_Table + " (" +
|
"`id` int(11) NOT NULL AUTO_INCREMENT," +
|
" `x` int(11) DEFAULT NULL COMMENT 'x坐标'," +
|
" `y` int(11) DEFAULT NULL COMMENT 'y坐标'," +
|
" `w` int(11) DEFAULT NULL COMMENT '宽度'," +
|
" `h` int(11) DEFAULT NULL COMMENT '高度'," +
|
" `module_id` int(11) DEFAULT NULL COMMENT '模块Id'," +
|
" `title` varchar(255) DEFAULT NULL COMMENT '模块标题'," +
|
" `label` varchar(255) DEFAULT NULL COMMENT '英文'," +
|
" `type` varchar(20) DEFAULT NULL COMMENT '图标类型:1.横向柱状图;2.竖向柱状图;3.折线图;4.饼图'," +
|
" `page_id` int(11) DEFAULT NULL COMMENT '页面Id'," +
|
" `user_id` int(11) DEFAULT NULL COMMENT '所属用户'," +
|
" PRIMARY KEY (`id`) USING BTREE" +
|
") 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();
|
}
|
}
|
|
private static void createTb_dashboard_chart_type_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Tb_dashboard_chart_type_Table;
|
String sql_str02 = " CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Tb_dashboard_chart_type_Table + " (" +
|
"`id` int(11) NOT NULL AUTO_INCREMENT," +
|
" `type_id` int(11) DEFAULT NULL," +
|
" `type_name` varchar(20) DEFAULT NULL," +
|
" PRIMARY KEY (`id`) USING BTREE" +
|
") ENGINE=InnoDB AUTO_INCREMENT=11 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();
|
}
|
}
|
|
private static void createTb_application_config_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Tb_application_config_Table;
|
String sql_str02 = " CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Tb_application_config_Table + " (" +
|
"`num` int(11) NOT NULL AUTO_INCREMENT," +
|
" `id` int(11) NOT NULL COMMENT '配置模块对应id'," +
|
" `app_id` int(11) DEFAULT NULL COMMENT '所属应用id'," +
|
" `name` varchar(255) DEFAULT NULL COMMENT '应用中的模块配置名称'," +
|
" `w` double DEFAULT NULL COMMENT '宽度'," +
|
" `h` double DEFAULT NULL COMMENT '高度'," +
|
" `x` double DEFAULT NULL COMMENT 'X轴坐标'," +
|
" `y` double DEFAULT NULL COMMENT 'Y轴坐标'," +
|
" `type` varchar(255) DEFAULT NULL COMMENT '图标类型'," +
|
" PRIMARY KEY (`num`) USING BTREE" +
|
") ENGINE=InnoDB AUTO_INCREMENT=404 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;";
|
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();
|
}
|
}
|
|
private static void createTb_application_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Tb_application_Table;
|
String sql_str02 = " CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Tb_application_Table + " (" +
|
"`id` int(11) NOT NULL AUTO_INCREMENT," +
|
" `name` varchar(255) DEFAULT NULL," +
|
" `screenshot` varchar(255) DEFAULT NULL COMMENT '缩略图'," +
|
" `bg_pic` varchar(255) DEFAULT NULL COMMENT '背景图片'," +
|
" `head_pic` varchar(255) DEFAULT NULL COMMENT '头部图片'," +
|
" `user_id` int(11) DEFAULT NULL COMMENT '应用所属的用户'," +
|
" `active_status` tinyint(1) DEFAULT NULL," +
|
" PRIMARY KEY (`id`) USING BTREE" +
|
") ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;";
|
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();
|
}
|
}
|
|
/**
|
* 创建 db_app_sys 数据库
|
* @param pool
|
*/
|
public static void createDB_AppSys(MysqlConnPool pool) {
|
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
|
try {
|
sql.sqlMysqlExecute("CREATE DATABASE IF NOT EXISTS " + Sql_Mysql.DB_AppSys);
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
sql.close_con();
|
}
|
}
|
|
/**
|
* 创建 tb_page_param 表
|
* @param pool
|
* @param recreate
|
*/
|
public static void createPage_Param_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Page_Param_Table;
|
String sql_str02 = " CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Page_Param_Table + " (" +
|
" id int(11) NOT NULL AUTO_INCREMENT," +
|
" param varchar(255) DEFAULT NULL COMMENT '具体参数'," +
|
" status int(1) DEFAULT NULL COMMENT '参数是否页面显示'," +
|
" categoryId int(1) DEFAULT NULL COMMENT '参数分类,类目1,类目2'," +
|
" paramEnUs varchar(255) DEFAULT '' COMMENT '具体参数国际化英文'," +
|
" PRIMARY KEY (id) USING BTREE" +
|
") ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4;";
|
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
|
ResultSet res = null;
|
try {
|
if(true == recreate) {
|
sql.sqlMysqlExecute(sql_str01);
|
}
|
sql.sqlMysqlExecute(sql_str02);
|
|
|
//添加paramEnUs
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_app_sys'"
|
+ " AND table_name='tb_page_param'"
|
+ " AND column_name='paramEnUs'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Page_Param_Table
|
+ " ADD COLUMN `paramEnUs` varchar(255) DEFAULT '' COMMENT '具体参数国际化英文';");
|
}
|
//修改param 表的长度
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_app_sys'"
|
+ " AND table_name='tb_page_param'"
|
+ " AND column_name='param'");
|
if(res.next()) {
|
System.out.println("修改字段长度");
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Page_Param_Table
|
+ " MODIFY COLUMN param varchar(255);");
|
}
|
|
//添加初始化数据
|
res = sql.sqlMysqlQuery("SELECT COUNT(*) num FROM db_app_sys.tb_page_param;");
|
if(false != res.next()) {
|
int num = res.getInt("num");
|
if(num>0){
|
//根据唯一id检测是否需要添加默认数据
|
res = sql.sqlMysqlQuery("SELECT id FROM db_app_sys.tb_page_param;");
|
List<Integer> ids= new ArrayList<Integer>();
|
while(res.next()){
|
int id = res.getInt("id");
|
ids.add(id);
|
}
|
List<Integer> idsDefault = SqlsUtils.idsDefault;
|
for (int i = 0; i < idsDefault.size(); i++) {
|
if (!ids.contains(idsDefault.get(i))) {
|
sql.sqlMysqlExecute(SqlsUtils.sqlstb_page_param.get(i));
|
System.out.println("insert id = "+SqlsUtils.sqlstb_page_param.get(i));
|
}
|
}
|
// System.out.println("db_app_sys.tb_page_param ids:"+ids);
|
|
}else{
|
sql.sqlMysqlExecute("INSERT INTO `db_app_sys`.`tb_page_param` (`id`, `param`, `status`, `categoryId`,paramEnUs)"+
|
"VALUES ('1', '设备工作状态', '0', '1','Device Status')," +
|
"('2', '设备通讯', '1', '1','Device Communication')," +
|
"('3', '设备温度', '1', '1','Temperature(°C)')," +
|
"('4', '干接点', '1', '1','Dry Contact')," +
|
"('5', '核容终止原因', '1', '1','Reason for capacity check termination')," +
|
"('6', '操作失败原因', '1', '1','Operate Failure Reason')," +
|
"('7', '剩余天数', '1', '1','Remaining Day(s)')," +
|
"('8', '工作模式', '1', '1','Working Mode')," +
|
"('9', '组端电压', '1', '1','String Voltage')," +
|
"('10', '峰值电压', '1', '1','Peak Voltage')," +
|
"('11', '启动核容测试', '1', '2','Initiate capacity check testing')," +
|
"('12', '停止测试', '1', '2','Stop testing')," +
|
"('13', '系统参数设置', '0', '2','System Parms Setting')," +
|
"('14', '清除告警', '1', '2','Clear Alarm')," +
|
"('15', '启动养护/除硫', '1', '2','Start Maintenance/Desulfation')," +
|
"('16', '停止养护/除硫', '1', '2','Stop Maintenance/Desulfation')," +
|
"('17', '启动离线养护', '1', '2','Start Offline Maintenance')," +
|
"('18', '停止离线养护', '1', '2','Stop Offline Maintenance')," +
|
"('19', '定期启动设备', '1', '2','Periodically Ratart')," +
|
"('20', '重启设备', '1', '2','Restart')," +
|
"('31', '蓄电池远程运维管理系统', '1', '5','Intelligent System for Battery Uninterruptible Power Supply')," +
|
"('32', 'V1.0.5', '1', '6','V1.0.5')," +
|
"('33', '平台logo', '1', '7','Platform logo')," +
|
"('34', 'uKey', '1', '7','uKey')," +
|
"('35', '人脸识别', '1', '7','Face recognition')," +
|
"('36', '签名', '1', '7','signature')," +
|
"('37', '远程修改ip', '1', '7','Remote modification of IP')," +
|
"('38', '启动放电添加人脸识别', '1', '7','Start discharging and add facial recognition')," +
|
"('39', '账号扫描策略', '1', '8','Account scanning strategy')," +
|
"('40', '账号登录失败限制次数', '7', '9','Account login failure limit number of times')," +
|
"('41', '账号登录失败锁定解锁策略', '1', '9','Account login failure lock unlock strategy')," +
|
|
"('42', '密码设置规则-位数', '8', '10','Password setting rules - number of digits')," +
|
"('43', '密码设置规则-符号类型', '4', '10','Password Setting Rules - Symbol Types')," +
|
"('44', '历史数据的驼峰锅底功能开启', '1', '11','Enabling the Hump Pot Bottom Function of Historical Data')," +
|
"('45', '历史数据的数据显示粒度', '5', '11','Data display granularity of historical data')" +
|
";");
|
}
|
}
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
sql.close_con();
|
}
|
}
|
|
/**
|
* 创建 tb_fbsdev_statechange_inf 表
|
* @param pool
|
* @param recreate
|
*/
|
public static void createFbsdev_Statechange_Inf_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Fbsdev_Statechange_Inf_Table;
|
String sql_str02 = " CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Fbsdev_Statechange_Inf_Table + " (" +
|
" num bigint(20) NOT NULL AUTO_INCREMENT," +
|
" dev_id int(11) NOT NULL DEFAULT '0'," +
|
" rec_time datetime NOT NULL DEFAULT '1980-01-01 00:00:00'," +
|
" last_stat int(11) NOT NULL DEFAULT '0'," +
|
" now_stat int(11) NOT NULL DEFAULT '0'," +
|
" state_change_reason int(11) NOT NULL DEFAULT '0'," +
|
" dev_alarm int(11) NOT NULL DEFAULT '0'," +
|
" eve_type int(11) NOT NULL DEFAULT '0'," +
|
" module_num int(11) NOT NULL DEFAULT '0'," +
|
" PRIMARY KEY (num)," +
|
" KEY index_dev_id (dev_id)" +
|
") ENGINE=InnoDB AUTO_INCREMENT=1 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();
|
}
|
}
|
|
|
/**
|
* 创建 tb_dashboard_module_chart 表
|
* @param pool
|
* @param recreate
|
*/
|
public static void createDashboard_Module_Chart_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Dashboard_Module_Chart_Table;
|
String sql_str02 = " CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Dashboard_Module_Chart_Table + " (" +
|
" id int(11) NOT NULL AUTO_INCREMENT," +
|
" module_id int(11) NOT NULL DEFAULT '0' COMMENT '模块id'," +
|
" title varchar(255) NOT NULL DEFAULT ''," +
|
" label varchar(20) NOT NULL DEFAULT ''," +
|
" type_id int(11) NOT NULL DEFAULT '1' COMMENT '图标类型:1.横向柱状图;2.竖向柱状图;3.折线图;4.饼图'," +
|
" page_id int(11) NOT NULL DEFAULT '1' COMMENT '页面id'," +
|
" PRIMARY KEY (id) USING BTREE" +
|
") ENGINE=InnoDB AUTO_INCREMENT=24 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();
|
}
|
}
|
|
/**
|
* 创建 tb_dashboard_module 表
|
* @param pool
|
* @param recreate
|
*/
|
public static void createDashboard_Module_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Dashboard_Module_Table;
|
String sql_str02 = " CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Dashboard_Module_Table + " (" +
|
" id int(11) NOT NULL AUTO_INCREMENT," +
|
" x int(11) DEFAULT NULL DEFAULT '1' COMMENT 'x坐标'," +
|
" y int(11) DEFAULT NULL DEFAULT '0' COMMENT 'y坐标'," +
|
" w int(11) DEFAULT NULL DEFAULT '0' COMMENT '宽度'," +
|
" h int(11) DEFAULT NULL DEFAULT '0' COMMENT '高度'," +
|
" module_id int(11) DEFAULT '0' COMMENT '模块Id'," +
|
" title varchar(255) DEFAULT '' COMMENT '模块标题'," +
|
" label varchar(255) DEFAULT '' COMMENT '英文'," +
|
" type varchar(20) DEFAULT '' COMMENT '图标类型:1.横向柱状图;2.竖向柱状图;3.折线图;4.饼图'," +
|
" page_id int(11) DEFAULT '0' COMMENT '页面Id'," +
|
" user_id int(11) DEFAULT '0' COMMENT '所属用户'," +
|
" PRIMARY KEY (id) USING BTREE" +
|
") 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();
|
}
|
}
|
|
/**
|
* 创建 tb_dashboard_chart_type 表
|
* @param pool
|
* @param recreate
|
*/
|
public static void createDashboard_Chart_Type_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Dashboard_Chart_Type_Table;
|
String sql_str02 = " CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Dashboard_Chart_Type_Table + " (" +
|
" id int(11) NOT NULL AUTO_INCREMENT," +
|
" type_id int(11) DEFAULT '1'," +
|
" type_name varchar(20) DEFAULT ''," +
|
" PRIMARY KEY (id) USING BTREE" +
|
") ENGINE=InnoDB AUTO_INCREMENT=6 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();
|
}
|
}
|
|
/**
|
* 创建 tb_app_sys 表
|
* @param pool
|
* @param recreate
|
*/
|
public static void createApp_Sys_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.App_Sys_Table;
|
String sql_str02 = " CREATE TABLE IF NOT EXISTS " + Sql_Mysql.App_Sys_Table + " (" +
|
" num int(11) NOT NULL AUTO_INCREMENT," +
|
" SqlDB_Version float NOT NULL DEFAULT '1'," +
|
" SqlDB_BackUpTime datetime NOT NULL DEFAULT '2000-01-01 00:00:00'," +
|
" SqlDB_BackUpManual_EN tinyint(1) NOT NULL DEFAULT '0'," +
|
" AppServer_Reinit_BattGroupData_EN tinyint(1) NOT NULL DEFAULT '0'," +
|
" AppServer_Reinit_BattGroupData_LD9_EN tinyint(1) NOT NULL DEFAULT '0'," +
|
" AppServer_Reinit_BattGroupData_A059_EN tinyint(1) NOT NULL DEFAULT '0'," +
|
" AppServer_Reinit_Config_EN tinyint(1) NOT NULL DEFAULT '0'," +
|
" AppServer_Version float NOT NULL DEFAULT '1'," +
|
" AppClient_Version float NOT NULL DEFAULT '1'," +
|
" AppName varchar(50) NOT NULL DEFAULT '0'," +
|
" PRIMARY KEY (num)" +
|
") ENGINE=InnoDB AUTO_INCREMENT=2 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);
|
//添加充放电一体机蓄电池组录入状态
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_app_sys'"
|
+ " AND table_name='tb_app_sys'"
|
+ " AND column_name='AppServer_Reinit_BattGroupData_A059_EN'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.App_Sys_Table
|
+ " ADD COLUMN AppServer_Reinit_BattGroupData_A059_EN tinyint(1) NOT NULL DEFAULT '0';");
|
}
|
//添加远程重启装置重载数据
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_app_sys'"
|
+ " AND table_name='tb_app_sys'"
|
+ " AND column_name='AppServer_Reinit_BattGroupData_61851_EN'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.App_Sys_Table
|
+ " ADD COLUMN `AppServer_Reinit_BattGroupData_61851_EN` tinyint(1) NOT NULL DEFAULT '0' COMMENT '远程重启装置重新加载机房信息';");
|
}
|
//添加电操核容线程重载数据
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_app_sys'"
|
+ " AND table_name='tb_app_sys'"
|
+ " AND column_name='AppServer_Reinit_BattGroupData_60870_EN'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.App_Sys_Table
|
+ " ADD COLUMN `AppServer_Reinit_BattGroupData_60870_EN` tinyint(1) NOT NULL DEFAULT '0' COMMENT '电操核容重新加载机房信息';");
|
}
|
//添加fbo4815重载数据
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_app_sys'"
|
+ " AND table_name='tb_app_sys'"
|
+ " AND column_name='AppServer_Reinit_BattGroupData_FBO4815_EN'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.App_Sys_Table
|
+ " ADD COLUMN `AppServer_Reinit_BattGroupData_FBO4815_EN` tinyint(1) NOT NULL DEFAULT '0' COMMENT '重新FBO4815线程加载机房信息';");
|
}
|
//添加fbo4831重载数据
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_app_sys'"
|
+ " AND table_name='tb_app_sys'"
|
+ " AND column_name='AppServer_Reinit_BattGroupData_FBO4831_EN'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.App_Sys_Table
|
+ " ADD COLUMN `AppServer_Reinit_BattGroupData_FBO4831_EN` tinyint(1) NOT NULL DEFAULT '0' COMMENT '重新FBO4831线程加载机房信息';");
|
}
|
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
sql.close_con();
|
}
|
}
|
|
/**
|
* 创建 tb_app_bts_comm_task 表
|
* @param pool
|
* @param recreate
|
*/
|
public static void createApp_Bts_Comm_Task_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.App_Bts_Comm_Task_Table;
|
String sql_str02 = " CREATE TABLE IF NOT EXISTS " + Sql_Mysql.App_Bts_Comm_Task_Table + " (" +
|
" num bigint(20) NOT NULL AUTO_INCREMENT," +
|
" thread_id bigint(20) NOT NULL DEFAULT '0'," +
|
" dev_id bigint(20) NOT NULL DEFAULT '0'," +
|
" dev_mcu_uid varchar(48) NOT NULL DEFAULT 'null'," +
|
" battgroup_cnt int(11) NOT NULL DEFAULT '0'," +
|
" battgroup_id1 int(11) NOT NULL DEFAULT '0'," +
|
" battgroup_index1 int(11) NOT NULL DEFAULT '0'," +
|
" battgroup_id2 int(11) NOT NULL DEFAULT '0'," +
|
" battgroup_index2 int(11) NOT NULL DEFAULT '0'," +
|
" battgroup_id3 int(11) NOT NULL DEFAULT '0'," +
|
" battgroup_index3 int(11) NOT NULL DEFAULT '0'," +
|
" battgroup_id4 int(11) NOT NULL DEFAULT '0'," +
|
" battgroup_index4 int(11) NOT NULL DEFAULT '0'," +
|
" connet_time varchar(20) NOT NULL DEFAULT '1980-01-01 01:01:00'," +
|
" dev_comm_runtime varchar(20) NOT NULL DEFAULT '1980-01-01 01:01:00'," +
|
" break_type int(11) NOT NULL DEFAULT '0'," +
|
" PRIMARY KEY (num)," +
|
" KEY index_dev_id_uniq (dev_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();
|
}
|
}
|
|
/**
|
* 创建 tb_app_bts_battgroup 表
|
* @param pool
|
* @param recreate
|
*/
|
public static void createApp_Bts_Battgroup_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.App_Bts_Battgroup_Table;
|
String sql_str02 = " CREATE TABLE IF NOT EXISTS " + Sql_Mysql.App_Bts_Battgroup_Table + " (" +
|
" num bigint(20) NOT NULL AUTO_INCREMENT," +
|
" dev_id bigint(20) NOT NULL DEFAULT '0'," +
|
" battgroup_id int(11) NOT NULL DEFAULT '0'," +
|
" battgroup_index int(11) NOT NULL DEFAULT '-1'," +
|
" battgroup_mon_cnt int(11) NOT NULL DEFAULT '0'," +
|
" battgroup_float_vol float NOT NULL DEFAULT '0'," +
|
" battgroup_float_curr float NOT NULL DEFAULT '0'," +
|
" battgroup_register_code varchar(48) NOT NULL DEFAULT 'null'," +
|
" PRIMARY KEY (num)" +
|
") ENGINE=InnoDB AUTO_INCREMENT=2 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();
|
}
|
}
|
|
/**
|
* 创建 tb_menu 表
|
* @param pool
|
* @param recreate
|
*/
|
public static void createMenu_Table(MysqlConnPool pool, boolean recreate) {
|
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Menu_Table;
|
String sql_str02 = " CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Menu_Table + "(" +
|
" `id` int(11) NOT NULL," +
|
" `lableEnUs` varchar(255) DEFAULT '' COMMENT '国际化英文列'," +
|
" `label` varchar(50) DEFAULT NULL COMMENT '中文名称'," +
|
" `name` varchar(100) DEFAULT NULL COMMENT '名称'," +
|
" `src` varchar(100) DEFAULT NULL COMMENT '路径'," +
|
" `icon` varchar(100) DEFAULT NULL COMMENT '图标'," +
|
" `closable` tinyint(4) DEFAULT NULL COMMENT '是否可关闭'," +
|
" `enableduse` tinyint(4) DEFAULT NULL COMMENT '是否启用'," +
|
" `permitName` varchar(100) DEFAULT NULL COMMENT '权限'," +
|
" `level` tinyint(4) DEFAULT NULL COMMENT '菜单等级'," +
|
" `ord` tinyint(4) DEFAULT NULL COMMENT '排序'," +
|
" `menuId` int(11) DEFAULT NULL COMMENT '上级菜单id'," +
|
" PRIMARY KEY (`id`)" +
|
") ENGINE=InnoDB 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);
|
|
//添加lableEnUs- 国际化英文列
|
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
|
+ " WHERE table_schema='db_app_sys'"
|
+ " AND table_name='tb_menu'"
|
+ " AND column_name='lableEnUs'");
|
if(false == res.next()) {
|
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Menu_Table
|
+ " ADD COLUMN `lableEnUs` varchar(255) DEFAULT '' COMMENT '国际化英文列';");
|
}
|
|
|
//添加初始化数据
|
res = sql.sqlMysqlQuery("SELECT COUNT(*) num FROM " + Sql_Mysql.Menu_Table);
|
if(false != res.next()) {
|
int num = res.getInt("num");
|
if(num>0){
|
|
//根据唯一id检测是否需要添加默认数据
|
res = sql.sqlMysqlQuery("SELECT id FROM " + Sql_Mysql.Menu_Table);
|
List<Integer> ids= new ArrayList<Integer>();
|
while(res.next()){
|
int id = res.getInt("id");
|
ids.add(id);
|
}
|
List<Integer> idsDefault = SqlsUtils.idsDefault_tb_menu;
|
for (int i = 0; i < idsDefault.size(); i++) {
|
if (!ids.contains(idsDefault.get(i))) {
|
sql.sqlMysqlExecute(SqlsUtils.sqlstb_tb_menu.get(i));
|
System.out.println("insert id = "+SqlsUtils.sqlstb_tb_menu.get(i));
|
}
|
}
|
} else {
|
//插入所有默认数据
|
sql.makeManualCommit(SqlsUtils.sqlstb_tb_menu);
|
}
|
|
}
|
|
/*
|
res = sql.sqlMysqlQuery("SELECT * FROM db_app_sys.tb_menu WHERE label = '首页'");
|
if(!res.next()) {
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) VALUES ('首页', 'index', '#/index', 'el-icon-s-home', '0', '1', null, '1', '1', '0');");
|
}
|
res = sql.sqlMysqlQuery("SELECT * FROM db_app_sys.tb_menu WHERE label = '在线监测'");
|
if(!res.next()) {
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) VALUES ('在线监测', 'testData', '', 'el-icon-s-data', '0', '1', null, '1', '2', '2');");
|
}
|
res = sql.sqlMysqlQuery("SELECT * FROM db_app_sys.tb_menu WHERE label = '数据管理'");
|
if(!res.next()) {
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) VALUES ('数据管理', 'dataMager', '', 'el-icon-s-help', '0', '1', null, '1', '3', '3');");
|
}
|
|
res = sql.sqlMysqlQuery("SELECT * FROM db_app_sys.tb_menu WHERE label = '告警管理'");
|
if(!res.next()) {
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) VALUES ('告警管理', 'alarmMager', '', 'el-icon-message-solid', '0', '1', null, '1', '4', '4');");
|
}
|
|
res = sql.sqlMysqlQuery("SELECT * FROM db_app_sys.tb_menu WHERE label = '报表统计'");
|
if(!res.next()) {
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) VALUES ('报表统计', 'reportStatistics', '', 'el-icon-tickets', '0', '1', null, '1', '5', '5');");
|
}
|
|
|
res = sql.sqlMysqlQuery("SELECT * FROM db_app_sys.tb_menu WHERE label = '作业管理'");
|
if(!res.next()) {
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) VALUES ('作业管理', 'jobManage', '', 'el-icon-s-cooperation', '0', '1', null, '1', '6', '6');");
|
}
|
|
res = sql.sqlMysqlQuery("SELECT * FROM db_app_sys.tb_menu WHERE label = '用户管理'");
|
if(!res.next()) {
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) VALUES ('用户管理', 'userMager', '', 'el-icon-user-solid', '0', '1', null, '1', '7', '7');");
|
}
|
|
res = sql.sqlMysqlQuery("SELECT * FROM db_app_sys.tb_menu WHERE label = '系统设置'");
|
if(!res.next()) {
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) VALUES ('系统设置', 'systemPageSetting', '', 'el-icon-s-management', '0', '1', null, '1', '8', '8');");
|
}
|
|
res = sql.sqlMysqlQuery("SELECT * FROM db_app_sys.tb_menu WHERE label = '实时监控'");
|
if(!res.next()) {
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) VALUES ('实时监控', 'movingRingSysteRrealTime', '#/moving-ring-system', null, '1', '1', null, '2', '1', '2');");
|
}
|
|
res = sql.sqlMysqlQuery("SELECT * FROM db_app_sys.tb_menu WHERE label = '历史数据'");
|
if(!res.next()) {
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) VALUES ('历史数据', 'history', '#/history', null, '1', '1', null, '2', '2', '2');");
|
}
|
|
res = sql.sqlMysqlQuery("SELECT * FROM db_app_sys.tb_menu WHERE label = '历史数据管理'");
|
if(!res.next()) {
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) VALUES ('历史数据管理', 'historyDataMager', '#/dataMager/historyInfo', null, '1', '1', null, '2', '3', '2');");
|
}
|
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) VALUES ('标准曲线', 'standardLine', '#/dataTest/standardLine', null, '1', '1', null, '2', '4', '2');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) VALUES ('设备状态查询', 'btsStatusTest', '#/dataMager/btsStatus', null, '1', '1', null, '2', '5', '2');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) VALUES ('一体机导入记录', 'historyAio', '#/history-aio', null, '1', '0', null, '2', '6', '2');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) VALUES ('高频开关配电柜遥测量', 'hfSwitch', '#/hfSwitch', null, '1', '0', null, '2', '7', '2');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) VALUES ('交流配电柜遥测量 ', 'GGDmeasure', '#/GGDmeasure', null, '1', '0', null, '2', '8', '2');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) VALUES ('电源信息配置', 'SupplyPowerMager', '#/dataMager/powerMager', null, '1', '1', null, '2', '1', '3');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) VALUES ('电池信息管理', 'battGroupMager', '#/dataMager/battGroupMager', null, '1', '1', 'batttest_data_query_permit', '2', '2', '3');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) VALUES ('机房定位信息管理', 'homeAddressInfoManage', '#/dataMager/homeAddressInfoManage', null, '1', '1', 'batt_map_edit_permit', '2', '3', '3');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) VALUES ('电池信息统计分析', 'produceTotal', '#/dataMager/produceTotal', null, '1', '1', null, '2', '4', '3');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) VALUES ('后台线程管理', 'threadMager', '#/dataMager/threadMager', null, '1', '1', 'batttest_data_query_permit', '2', '5', '3');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) VALUES ('机房状态查询', 'powercutMager', '#/dataMager/powercut', null, '1', '1', 'batttest_data_query_permit', '2', '6', '3');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) VALUES ('电池关注管理', 'batteryMager', '#/batteryMager', null, '1', '1', 'batttest_data_query_permit', '2', '7', '3');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) VALUES ('设备工作状态', 'deviceWorkState', '#/device-work-state', null, '1', '1', null, '2', '8', '3');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) VALUES ('报废电池信息管理', 'scrapBattery', '#/scrap-battery', null, '1', '0', null, '2', '9', '3');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) VALUES ('备件电池信息管理', 'repairBattery', '#/repair-battery', null, '1', '0', null, '2', '10', '3');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) VALUES ('电价分布模板管理', 'electricityPriceDistributionTemplate', '#/dataMager/elePriceDistributionTpl', null, '1', '1', null, '2', '11', '3');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) VALUES ('电源实时告警', 'powerRealtimeInfo', '#/powerRealtimeInfo', null, '1', '1', null, '2', '1', '4');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) VALUES ('电源历史告警', 'powerHistoryInfo', '#/powerHistoryInfo', null, '1', '1', null, '2', '2', '4');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) VALUES ('电池告警实时查询', 'batteryrTimequery', '#/batteryrTimequery', null, '1', '1', 'batt_alm_query_permit', '2', '3', '4');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) VALUES ('电池告警历史查询', 'batteryrHistoryquery', '#/batteryrHistoryquery', null, '1', '1', 'batt_alm_query_permit', '2', '4', '4');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) VALUES ('设备告警实时查询', 'deviceTimequery', '#/deviceTimequery', null, '1', '1', 'dev_alm_query_permit', '2', '5', '4');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) VALUES ('设备告警历史查询', 'deviceHistoryquery', '#/deviceHistoryquery', null, '1', '1', 'dev_alm_query_permit', '2', '6', '4');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) VALUES ('通信电源实时告警', 'powerBoxAlarm', '#/powerBoxAlarm', null, '1', '0', null, '2', '7', '4');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) VALUES ('通信电源历史告警', 'powerBoxHistoryAlarm', '#/powerBoxHistoryAlarm', null, '1', '0', null, '2', '8', '4');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) VALUES ('通信电源超时告警', 'powerAlarmTimeout', '#/powerAlarmTimeout', null, '1', '0', null, '2', '9', '4');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) VALUES ('通信电源告警规则', 'powerCabinetSetting', '#/powerCabinetSetting', null, '1', '0', null, '2', '10', '4');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) VALUES ('电池告警参数设置', 'devicepaSetting', '#/devicepaSetting', null, '1', '1', 'batt_alm_param_query_permit', '2', '11', '4');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) VALUES ('告警派单管理', 'alarmDispatch', '#/alarmDispatch', null, '1', '1', null, '2', '12', '4');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) VALUES ('电池组统计分析查询', 'eleAnalyse', '#/reportStatistics/eleAnalyse', null, '1', '1', null, '2', '1', '5');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) VALUES ('电池单体统计分析查询', 'eleMonomer', '#/reportStatistics/eleMonomer', null, '1', '1', null, '2', '2', '5');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) VALUES ('蓄电池组后评估', 'eleAssess', '#/reportStatistics/eleAssess', null, '1', '1', null, '2', '3', '5');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) VALUES ('落后单体查询', 'taskplan', '#/reportStatistics/taskplan', null, '1', '1', null, '2', '4', '5');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) VALUES ('电池实时状态查询', 'elestatus', '#/reportStatistics/elestatus', null, '1', '1', null, '2', '5', '5');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) VALUES ('电池续航能力历史查询', 'endure', '#/reportStatistics/endure', null, '1', '1', null, '2', '6', '5');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) VALUES ('通信电源报表', 'powerReport', '#/reportStatistics/powerReport', null, '1', '0', null, '2', '7', '5');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) VALUES ('事件总表', 'eventTotalPage', '#/dataMager/eventTotalPage', null, '1', '1', null, '2', '8', '5');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) VALUES ('BTS设备升级', 'btsUpgrade', '#/jobManage/btsUpgrade', null, '1', '0', null, '2', '1', '6');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) VALUES ('放电计划管理', 'planManage', '#/jobManage/planManage', null, '1', '0', null, '2', '2', '6');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) VALUES ('用户信息管理', 'userInfoMager', '#/userMager/userInfo', null, '1', '1', 'usr_query_permit', '2', '1', '7');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) VALUES ('用户人脸管理', 'userFaceManager', '#/faceManager/userFaceManager', null, '1', '0', null, '2', '2', '7');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) VALUES ('权限管理', 'powerMager', '#/userMager/powerMager', null, '1', '1', 'permit_query_permit', '2', '3', '7');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) VALUES ('包机组管理', 'baojiMager', '#/userMager/baojiMager', null, '1', '1', 'usr_query_permit', '2', '4', '7');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) VALUES ('操作事件管理', 'operationRecordMager', '#/userMager/operationRecord', null, '1', '1', null, '2', '5', '7');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) VALUES ('系统配置', 'realTimeSetting', '#/pageSetting/realTime', null, '1', '1', 'batt_test_op_permit', '2', '1', '8');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) VALUES ('3D机房配置', 'threeHomeSetting', '#/pageSetting/threeHomeSetting', null, '1', '0', null, '2', '2', '8');");
|
sql.sqlMysqlExecute("INSERT INTO " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) VALUES ('地图配置', 'chartMapSetting', '#/pageSetting/chartMapSetting', null, '1', '1', null, '2', '3', '8');");
|
|
*/
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} finally {
|
sql.close_con();
|
}
|
}
|
}
|
