From a0fe090adf6622c72df70225881add061ab3a5d1 Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期五, 02 七月 2021 09:43:58 +0800
Subject: [PATCH] 11修改
---
BattMonitor_DB_Builder/src/com/database_util/DB_App_Sys.java | 36 ++++++++++++++++++++++++++++++++++++
1 files changed, 36 insertions(+), 0 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 adb1fc3..0851d03 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
@@ -26,6 +26,8 @@
createApp_Bts_Battgroup_Table(pool, recreate);
+ createMenu_Table(pool, recreate);
+
}
/**
@@ -296,4 +298,38 @@
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," +
+ " `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());
+ try {
+ if(true == recreate) {
+ sql.sqlMysqlExecute(sql_str01);
+ }
+ sql.sqlMysqlExecute(sql_str02);
+ } catch (SQLException e) {
+ e.printStackTrace();
+ } finally {
+ sql.close_con();
+ }
+ }
}
--
Gitblit v1.9.1