From e8af6b013b057f7fc96e8cd0b55ed9ded2a190ed Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期五, 10 六月 2022 14:42:36 +0800
Subject: [PATCH] V1.28 edit at date 2022-06-10 ------ 并联BTS需要新增参数 1.'db_ram_db.tb_fbs9100_setparam'表新增字段 `ChargeVolt` float NOT NULL DEFAULT '0' COMMENT '充电电压(V)',
---
BattMonitor_DB_Builder/src/com/database_util/DB_App_Sys.java | 378 ++++++++++++++++++++++++++++++++++-------------------
1 files changed, 241 insertions(+), 137 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/database_util/DB_App_Sys.java b/BattMonitor_DB_Builder/src/com/database_util/DB_App_Sys.java
index 184f338..40a9114 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_App_Sys.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/DB_App_Sys.java
@@ -32,7 +32,7 @@
createMenu_Table(pool, recreate);
- //3.5大屏
+ //3.5澶у睆
createTb_application_Table(pool, recreate);
createTb_application_config_Table(pool, recreate);
createTb_dashboard_chart_type_Table(pool, recreate);
@@ -41,9 +41,9 @@
createTb_Page_Param_User_Table(pool, recreate);
- createTb_Page_Param2_Table(pool, recreate);//创建表并初始化值
+ createTb_Page_Param2_Table(pool, recreate);//鍒涘缓琛ㄥ苟鍒濆鍖栧��
- createTb_Menu_Approve_Table(pool, recreate);//创建表tb_menu_approve
+ createTb_Menu_Approve_Table(pool, recreate);//鍒涘缓琛╰b_menu_approve
}
@@ -51,30 +51,30 @@
/**
*
* @Title: createTb_Menu_Approve_Table
- * @Description: 建表tb_menu_approve
+ * @Description: 寤鸿〃tb_menu_approve
* @param pool
* @param recreate
* @author author
- * @date 2021年12月13日
+ * @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:已审批-拒绝'," +
+ " `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;";
@@ -95,12 +95,12 @@
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 '分类'," +
+ " `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='页面参数配置,配置非状态量参数';";
+ ") ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='椤甸潰鍙傛暟閰嶇疆,閰嶇疆闈炵姸鎬侀噺鍙傛暟';";
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
ResultSet res = null;
try {
@@ -109,24 +109,24 @@
}
sql.sqlMysqlExecute(sql_str02);
- //修改category改为categoryId
+ //淇敼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 '分类';");
+ 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检测默认三条数据是否存在
+ //鏍规嵁鍞竴id妫�娴嬮粯璁や笁鏉℃暟鎹槸鍚﹀瓨鍦�
res = sql.sqlMysqlQuery("SELECT id FROM db_app_sys.tb_page_param2;");
List<Integer> ids= new ArrayList<Integer>();
while(res.next()){
@@ -143,12 +143,12 @@
}
}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');");
+ + "VALUES ('1', 'visit_time_first', '鐢ㄦ埛鐧诲綍璁块棶鎺у埗-璁块棶鏃堕棿鏈�鏃�', '00:00:01', '1'),"
+ + "('2', 'visit_time_last', '鐢ㄦ埛鐧诲綍璁块棶鎺у埗-璁块棶鏃堕棿鏈�鏅�', '23:59:59', '1'),"
+ + "('3', 'visit_ip', '鐢ㄦ埛鐧诲綍璁块棶鎺у埗-璁块棶瀹㈡埛绔痠p-鍏佽', '*', '1'),"
+ + "('4', 'audit_cap', '瀹¤鏁版嵁璁板綍瀹归噺', '5000', '2');");
}
}
@@ -162,7 +162,7 @@
/**
*
* @Title: createTb_Page_Param_User_Table
- * @Description: 创建表db_app_sys.tb_page_param_user
+ * @Description: 鍒涘缓琛╠b_app_sys.tb_page_param_user
* @param pool
* @param recreate
*/
@@ -174,9 +174,9 @@
" `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 '分类'," +
+ " `type` int(11) DEFAULT NULL COMMENT '鍒嗙被'," +
" PRIMARY KEY (`id`)" +
- ") ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='页面可配置,关联用户id';";
+ ") ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='椤甸潰鍙厤缃�,鍏宠仈鐢ㄦ埛id';";
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
ResultSet res = null;
try {
@@ -185,14 +185,14 @@
}
sql.sqlMysqlExecute(sql_str02);
- //添加price_factor
+ //娣诲姞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 '电价系数';");
+ + " ADD COLUMN `type` int(11) COMMENT '鐢典环绯绘暟';");
}
} catch (SQLException e) {
e.printStackTrace();
@@ -205,9 +205,9 @@
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'," +
+ " 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());
@@ -227,16 +227,16 @@
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 '所属用户'," +
+ " `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());
@@ -277,14 +277,14 @@
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 '图标类型'," +
+ " `id` int(11) NOT NULL COMMENT '閰嶇疆妯″潡瀵瑰簲id'," +
+ " `app_id` int(11) DEFAULT NULL COMMENT '鎵�灞炲簲鐢╥d'," +
+ " `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());
@@ -305,10 +305,10 @@
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 '应用所属的用户'," +
+ " `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;";
@@ -326,7 +326,7 @@
}
/**
- * 创建 db_app_sys 数据库
+ * 鍒涘缓 db_app_sys 鏁版嵁搴�
* @param pool
*/
public static void createDB_AppSys(MysqlConnPool pool) {
@@ -341,7 +341,7 @@
}
/**
- * 创建 tb_page_param 表
+ * 鍒涘缓 tb_page_param 琛�
* @param pool
* @param recreate
*/
@@ -349,9 +349,9 @@
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(30) DEFAULT NULL COMMENT '具体参数'," +
- " status int(1) DEFAULT NULL COMMENT '参数是否页面显示'," +
- " categoryId int(1) DEFAULT NULL COMMENT '参数分类,类目1,类目2'," +
+ " 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=utf8mb4;";
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
@@ -362,12 +362,12 @@
}
sql.sqlMysqlExecute(sql_str02);
- //添加初始化数据
+ //娣诲姞鍒濆鍖栨暟鎹�
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检测是否需要添加默认数据
+ //鏍规嵁鍞竴id妫�娴嬫槸鍚﹂渶瑕佹坊鍔犻粯璁ゆ暟鎹�
res = sql.sqlMysqlQuery("SELECT id FROM db_app_sys.tb_page_param;");
List<Integer> ids= new ArrayList<Integer>();
while(res.next()){
@@ -385,42 +385,42 @@
}else{
sql.sqlMysqlExecute("INSERT INTO `db_app_sys`.`tb_page_param` (`id`, `param`, `status`, `categoryId`)"+
- "VALUES ('1', '设备工作状态', '0', '1')," +
- "('2', '设备通讯', '1', '1')," +
- "('3', '设备温度', '1', '1')," +
- "('4', '干接点', '1', '1')," +
- "('5', '核容终止原因', '1', '1')," +
- "('6', '操作失败原因', '1', '1')," +
- "('7', '剩余天数', '1', '1')," +
- "('8', '工作模式', '1', '1')," +
- "('9', '组端电压', '1', '1')," +
- "('10', '峰值电压', '1', '1')," +
- "('11', '启动核容测试', '1', '2')," +
- "('12', '停止测试', '1', '2')," +
- "('13', '系统参数设置', '0', '2')," +
- "('14', '清除告警', '1', '2')," +
- "('15', '启动养护/除硫', '1', '2')," +
- "('16', '停止养护/除硫', '1', '2')," +
- "('17', '启动离线养护', '1', '2')," +
- "('18', '停止离线养护', '1', '2')," +
- "('19', '定期启动设备', '1', '2')," +
- "('20', '重启设备', '1', '2')," +
- "('31', '蓄电池远程运维管理系统', '1', '5')," +
+ "VALUES ('1', '璁惧宸ヤ綔鐘舵��', '0', '1')," +
+ "('2', '璁惧閫氳', '1', '1')," +
+ "('3', '璁惧娓╁害', '1', '1')," +
+ "('4', '骞叉帴鐐�', '1', '1')," +
+ "('5', '鏍稿缁堟鍘熷洜', '1', '1')," +
+ "('6', '鎿嶄綔澶辫触鍘熷洜', '1', '1')," +
+ "('7', '鍓╀綑澶╂暟', '1', '1')," +
+ "('8', '宸ヤ綔妯″紡', '1', '1')," +
+ "('9', '缁勭鐢靛帇', '1', '1')," +
+ "('10', '宄板�肩數鍘�', '1', '1')," +
+ "('11', '鍚姩鏍稿娴嬭瘯', '1', '2')," +
+ "('12', '鍋滄娴嬭瘯', '1', '2')," +
+ "('13', '绯荤粺鍙傛暟璁剧疆', '0', '2')," +
+ "('14', '娓呴櫎鍛婅', '1', '2')," +
+ "('15', '鍚姩鍏绘姢/闄ょ～', '1', '2')," +
+ "('16', '鍋滄鍏绘姢/闄ょ～', '1', '2')," +
+ "('17', '鍚姩绂荤嚎鍏绘姢', '1', '2')," +
+ "('18', '鍋滄绂荤嚎鍏绘姢', '1', '2')," +
+ "('19', '瀹氭湡鍚姩璁惧', '1', '2')," +
+ "('20', '閲嶅惎璁惧', '1', '2')," +
+ "('31', '钃勭數姹犺繙绋嬭繍缁寸鐞嗙郴缁�', '1', '5')," +
"('32', 'V1.0.5', '1', '6')," +
- "('33', '平台logo', '1', '7')," +
+ "('33', '骞冲彴logo', '1', '7')," +
"('34', 'uKey', '1', '7')," +
- "('35', '人脸识别', '1', '7')," +
- "('36', '签名', '1', '7')," +
- "('37', '远程修改ip', '1', '7')," +
- "('38', '启动放电添加人脸识别', '1', '7')," +
- "('39', '账号扫描策略', '1', '8')," +
- "('40', '账号登录失败限制次数', '7', '9')," +
- "('41', '账号登录失败锁定解锁策略', '1', '9')," +
+ "('35', '浜鸿劯璇嗗埆', '1', '7')," +
+ "('36', '绛惧悕', '1', '7')," +
+ "('37', '杩滅▼淇敼ip', '1', '7')," +
+ "('38', '鍚姩鏀剧數娣诲姞浜鸿劯璇嗗埆', '1', '7')," +
+ "('39', '璐﹀彿鎵弿绛栫暐', '1', '8')," +
+ "('40', '璐﹀彿鐧诲綍澶辫触闄愬埗娆℃暟', '7', '9')," +
+ "('41', '璐﹀彿鐧诲綍澶辫触閿佸畾瑙ｉ攣绛栫暐', '1', '9')," +
- "('42', '密码设置规则-位数', '8', '10')," +
- "('43', '密码设置规则-符号类型', '4', '10')," +
- "('44', '历史数据的驼峰锅底功能开启', '1', '11')," +
- "('45', '历史数据的数据显示粒度', '5', '11')" +
+ "('42', '瀵嗙爜璁剧疆瑙勫垯-浣嶆暟', '8', '10')," +
+ "('43', '瀵嗙爜璁剧疆瑙勫垯-绗﹀彿绫诲瀷', '4', '10')," +
+ "('44', '鍘嗗彶鏁版嵁鐨勯┘宄伴攨搴曞姛鑳藉紑鍚�', '1', '11')," +
+ "('45', '鍘嗗彶鏁版嵁鐨勬暟鎹樉绀虹矑搴�', '5', '11')" +
";");
}
}
@@ -432,7 +432,7 @@
}
/**
- * 创建 tb_fbsdev_statechange_inf 表
+ * 鍒涘缓 tb_fbsdev_statechange_inf 琛�
* @param pool
* @param recreate
*/
@@ -466,7 +466,7 @@
/**
- * 创建 tb_dashboard_module_chart 表
+ * 鍒涘缓 tb_dashboard_module_chart 琛�
* @param pool
* @param recreate
*/
@@ -474,11 +474,11 @@
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'," +
+ " 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'," +
+ " 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());
@@ -495,7 +495,7 @@
}
/**
- * 创建 tb_dashboard_module 表
+ * 鍒涘缓 tb_dashboard_module 琛�
* @param pool
* @param recreate
*/
@@ -503,16 +503,16 @@
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 '所属用户'," +
+ " 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());
@@ -529,7 +529,7 @@
}
/**
- * 创建 tb_dashboard_chart_type 表
+ * 鍒涘缓 tb_dashboard_chart_type 琛�
* @param pool
* @param recreate
*/
@@ -555,7 +555,7 @@
}
/**
- * 创建 tb_app_sys 表
+ * 鍒涘缓 tb_app_sys 琛�
* @param pool
* @param recreate
*/
@@ -582,7 +582,7 @@
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'"
@@ -600,7 +600,7 @@
}
/**
- * 创建 tb_app_bts_comm_task 表
+ * 鍒涘缓 tb_app_bts_comm_task 琛�
* @param pool
* @param recreate
*/
@@ -640,7 +640,7 @@
}
/**
- * 创建 tb_app_bts_battgroup 表
+ * 鍒涘缓 tb_app_bts_battgroup 琛�
* @param pool
* @param recreate
*/
@@ -671,32 +671,136 @@
}
/**
- * 创建 tb_menu 表
+ * 鍒涘缓 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 + " (" +
+ String sql_str02 = " CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Menu_Table + "(label,name,src,icon,closable,permitName,level,ord,menuI) (" +
" `id` int(11) NOT NULL," +
- " `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'," +
+ " `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);
+ sql.sqlMysqlExecute(sql_str02);
+ /*
+ 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 {
--
Gitblit v1.9.1