From 90c0fe3cc6fae4fd252c6ad1cbf5a30a3f557b70 Mon Sep 17 00:00:00 2001
From: whyclj <1525436766@qq.com>
Date: 星期一, 02 十二月 2019 09:28:07 +0800
Subject: [PATCH] 紫晶中的tb_battmap_information表中添加stationName3字段
---
BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java | 13 +++++++++++++
1 files changed, 13 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 ebd7532..3c00573 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
@@ -854,6 +854,7 @@
" `num` int(11) NOT NULL AUTO_INCREMENT," +
" `stationId` varchar(128) NOT NULL," +
" `stationName` varchar(128) NOT NULL," +
+ " `stationName3` varchar(128) DEFAULT ''," +
" `address` varchar(128) NOT NULL," +
" `longitude` double(11,8) NOT NULL DEFAULT '0.00000000'," +
" `latitude` double(11,8) NOT NULL DEFAULT '0.00000000'," +
@@ -863,6 +864,7 @@
" KEY `index_num` (`num`)" +
") ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;";
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
+ ResultSet rs = null;
try {
if(true == recreate) {
//sql.sqlMysqlExecute(sql_str01);
@@ -870,6 +872,16 @@
}else {
}
sql.sqlMysqlExecute(sql_str02); //创建基站定位表
+ /************************** 添加 stationName3 字段 **************************************/
+ String sql_str03 = " SELECT * FROM information_schema.columns "
+ + " WHERE table_schema= 'web_site' "
+ + " AND table_name='tb_battmap_information' "
+ + " AND column_name='stationName3'";
+ rs = sql.sqlMysqlQuery(sql_str03);
+ if(false == rs.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattMapInformation_Table
+ + " ADD COLUMN `stationName3` varchar(128) NOT NULL DEFAULT '';");
+ }
} catch (SQLException e) {
e.printStackTrace();
} finally {
@@ -898,6 +910,7 @@
//sql.sqlMysqlExecute(sql_str02);
}
sql.sqlMysqlExecute(sql_str02); //创建基站故障表
+
} catch (SQLException e) {
e.printStackTrace();
} finally {
--
Gitblit v1.9.1