From c50da3449ee8c5793e7fbf4ba924a51c7f2e96d7 Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期四, 27 十月 2022 14:02:12 +0800
Subject: [PATCH] 1.新增三方接口配置表'web_site.tb_interface'
---
BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java | 30 ++++++++++++++++++++++++++++++
1 files changed, 30 insertions(+), 0 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java b/BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java
index 548cdc5..1b91ed7 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java
@@ -75,6 +75,8 @@
createTB_3D_STATION_Table(pool, recreate); //创建3D机房信息表
createTB_Map_Outline_Table(pool, recreate); //创建首页轮廓图表
+
+ createTB_Interface_Table(pool, recreate); //创建首页轮廓图表
System.out.println(" DB_web_site init end at " + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms));
}
@@ -176,6 +178,34 @@
sql.close_con();
}
}
+
+ /**
+ *
+ * @param pool
+ * @param recreate
+ */
+ private static void createTB_Interface_Table(MysqlConnPool pool, boolean recreate) {
+ String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.TB_Interface_Table;
+ String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.TB_Interface_Table+ " (" +
+ " `num` int(11) NOT NULL AUTO_INCREMENT," +
+ " `interface_number` varchar(255) NOT NULL DEFAULT ''," +
+ " `interface_name` varchar(255) NOT NULL DEFAULT ''," +
+ " `enable`int NOT NULL DEFAULT '1'," +
+ " PRIMARY KEY (`num`) " +
+ ") 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();
+ }
+ }
private static void createTb_Weather_City2_Table(MysqlConnPool pool, boolean recreate) {
--
Gitblit v1.9.1