From ee50ac899bd7b9ad587d79ff9edb4191a478c937 Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期六, 23 四月 2022 16:12:28 +0800
Subject: [PATCH] V2.21 edit at date 2022-04-23 1.检测表'web_site'.'tb_3d_station'中新增字段，没有就创建,修复早期表中缺失字段 `stationName` varchar(255) DEFAULT NULL, `battGroupName` varchar(255) DEFAULT NULL, `pictureUrl` varchar(255) DEFAULT NULL,
---
BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java | 36 +++++++++++++++++++++++++++++++++++-
1 files changed, 35 insertions(+), 1 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 ce0e1ed..f32ba0a 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
@@ -89,11 +89,45 @@
" PRIMARY KEY (`id`) USING BTREE" +
") ENGINE=InnoDB DEFAULT CHARSET=utf8mb4";
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
+ ResultSet res = null;
try {
if(true == recreate) {
sql.sqlMysqlExecute(sql_str01);
}
- sql.sqlMysqlExecute(sql_str02);
+ sql.sqlMysqlExecute(sql_str02);
+
+ //添加stationName
+ String sql_str03 = " SELECT * FROM information_schema.columns "
+ + " WHERE table_schema= 'web_site' "
+ + " AND table_name='tb_3d_station' "
+ + " AND column_name='stationName'";
+ 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;");
+ }
+
+ //添加battGroupName
+ sql_str03 = " SELECT * FROM information_schema.columns "
+ + " WHERE table_schema= 'web_site' "
+ + " AND table_name='tb_3d_station' "
+ + " AND column_name='battGroupName'";
+ res = sql.sqlMysqlQuery(sql_str03);
+ if(false == res.next()) {
+ sql.sqlMysqlExecute(" ALTER TABLE " + Sql_Mysql.TB_3D_STATION_Table
+ + " ADD COLUMN `battGroupName` varchar(255) DEFAULT NULL;");
+ }
+
+ //添加pictureUrl
+ sql_str03 = " SELECT * FROM information_schema.columns "
+ + " WHERE table_schema= 'web_site' "
+ + " AND table_name='tb_3d_station' "
+ + " AND column_name='pictureUrl'";
+ res = sql.sqlMysqlQuery(sql_str03);
+ if(false == res.next()) {
+ sql.sqlMysqlExecute(" ALTER TABLE " + Sql_Mysql.TB_3D_STATION_Table
+ + " ADD COLUMN `pictureUrl` varchar(255) DEFAULT NULL;");
+ }
} catch (SQLException e) {
e.printStackTrace();
} finally {
--
Gitblit v1.9.1