From 02c3f341fd8b1d4f7806d7cc240a1cb2d7b63f15 Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期四, 16 六月 2022 17:12:33 +0800
Subject: [PATCH] V1.31 edit at date 2022-06-16 1.新增初始化创建表`web_site`.`tb_map_outline`"表[首页轮廓图表] 2.新增初始化创建表`db_battinf`.`tb_battmon_standardcurve`表[标准曲线表]
---
BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java | 28 ++++++++++++++++++++++++++++
1 files changed, 28 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 4e66522..adc7292 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
@@ -70,6 +70,8 @@
createTB_3D_STATION_Table(pool, recreate); //创建3D机房信息表
+ createTB_Map_Outline_Table(pool, recreate); //创建首页轮廓图表
+
}
@@ -143,6 +145,32 @@
sql.close_con();
}
}
+
+
+ private static void createTB_Map_Outline_Table(MysqlConnPool pool, boolean recreate) {
+ String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.TB_Map_Outline_Table;
+ String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.TB_Map_Outline_Table+ " (" +
+ " `id` int(11) NOT NULL AUTO_INCREMENT," +
+ " `province` varchar(15) DEFAULT NULL," +
+ " `city` varchar(255) DEFAULT NULL," +
+ " `distinct` varchar(255) DEFAULT NULL," +
+ " `name` varchar(255) DEFAULT NULL," +
+ " `status` tinyint(1) DEFAULT NULL," +
+ " PRIMARY KEY (`id`) USING BTREE" +
+ ") ENGINE=InnoDB AUTO_INCREMENT=33 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