From c1e4eef7dbd0e5f1e20ed9e1e0b4b77d2ee35435 Mon Sep 17 00:00:00 2001
From: whycrzg <ruanzhigang@whycst.com>
Date: 星期六, 27 十一月 2021 10:37:05 +0800
Subject: [PATCH] V1.94 edit at date 2021-11-27 1：新增`web_site`.`tb_3d_station` 模板表创建
---
BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java | 32 ++++++++++++++++++++++++++++++++
1 files changed, 32 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 826d5ff..ce0e1ed 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
@@ -67,9 +67,41 @@
createTb_Peak_Statistics_Table(pool, recreate); //创建消峰填谷计划统计表
createTb_Weather_City2_Table(pool, recreate); //创建消峰填谷计划统计表
+
+ createTB_3D_STATION_Table(pool, recreate);
}
+ private static void createTB_3D_STATION_Table(MysqlConnPool pool, boolean recreate) {
+ String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.TB_3D_STATION_Table;
+ String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.TB_3D_STATION_Table + " (" +
+ " `id` int(11) NOT NULL AUTO_INCREMENT," +
+ " `deviceId` int(11) DEFAULT NULL," +
+ " `battGroupId` int(11) DEFAULT NULL," +
+ " `stationName` varchar(255) DEFAULT NULL," +
+ " `battGroupName` varchar(255) DEFAULT NULL," +
+ " `pictureName` varchar(255) DEFAULT NULL," +
+ " `pictureUrl` varchar(255) DEFAULT NULL," +
+ " `positionX` double DEFAULT NULL," +
+ " `positionY` double DEFAULT NULL," +
+ " `length` double DEFAULT NULL," +
+ " `width` double DEFAULT NULL," +
+ " PRIMARY KEY (`id`) USING BTREE" +
+ ") 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();
+ }
+ }
+
+
private static void createTb_Weather_City2_Table(MysqlConnPool pool, boolean recreate) {
String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Weather_City2_Table;
String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Weather_City2_Table + " (" +
--
Gitblit v1.9.1