From 4c834e36ff6d26fc76b4d591d1e5076f58f08ab2 Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期日, 24 四月 2022 16:20:44 +0800
Subject: [PATCH] V2.22 edit at date 2022-04-24 1.默认创建`db_ram_db`.`tb_batt_gtstate`----山西储能设备信息表
---
BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java | 39 ++++++++++++++++++++++++---------------
1 files changed, 24 insertions(+), 15 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 f32ba0a..4e66522 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
@@ -68,26 +68,28 @@
createTb_Weather_City2_Table(pool, recreate); //创建消峰填谷计划统计表
- createTB_3D_STATION_Table(pool, recreate);
+ createTB_3D_STATION_Table(pool, recreate); //创建3D机房信息表
+
}
-
+
+
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";
+ " `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());
ResultSet res = null;
try {
@@ -104,7 +106,7 @@
res = sql.sqlMysqlQuery(sql_str03);
if(false == res.next()) {
sql.sqlMysqlExecute(" ALTER TABLE " + Sql_Mysql.TB_3D_STATION_Table
- + " ADD COLUMN `stationName` varchar(255) DEFAULT NULL;");
+ + " ADD COLUMN `stationName` varchar(255) DEFAULT NULL;");
}
//添加battGroupName
@@ -131,6 +133,13 @@
} catch (SQLException e) {
e.printStackTrace();
} finally {
+ if(null != res) {
+ try {
+ res.close();
+ } catch (SQLException e) {
+ e.printStackTrace();
+ }
+ }
sql.close_con();
}
}
--
Gitblit v1.9.1