From db4dbe5b723289678e54521c3d1152cece34f14c Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期二, 25 七月 2023 13:40:03 +0800
Subject: [PATCH] 2.'db_pwrdev_alarm.tb_pwrdev_alarm_param_forsx'表新增上上限告警等级和下下限告警等级 `alarm_limitL_lower_level` int(11) NOT NULL DEFAULT '1' COMMENT '下下限告警等级', `alarm_limitH_upper_level` int(11) NOT NULL DEFAULT '1' COMMENT '上上限告警等级', `alarm_limitL_level` int(11) NOT NULL DEFAULT '1' COMMENT '下限告警等级', `alarm_limitH_level` int(11) NOT NULL DEFAULT '1' COMMENT '上限告警等级',
---
BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java | 12 ++++++++++++
1 files changed, 12 insertions(+), 0 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java b/BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java
index e227a41..3843a40 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java
@@ -651,14 +651,26 @@
" `stationLongitude` double NOT NULL DEFAULT '0' COMMENT '经度'," +
" `stationLatitude` double NOT NULL DEFAULT '0' COMMENT '纬度'," +
" `stationAddr` varchar(255) NOT NULL DEFAULT '' COMMENT '机房详细地址'," +
+ " `together_flag` int(11) NOT NULL DEFAULT '0'," +
" PRIMARY KEY (`num`)" +
") ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='机房总站表 = 电池信息表 + 电源信息表 ';";
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
+ ResultSet res = null;
try {
if(true == recreate) {
//sql.sqlMysqlExecute(sql_str01);
}
sql.sqlMysqlExecute(sql_str02);
+ //添加 together_flag - 标识同一机房
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_battinf'"
+ + " AND table_name='tb_station_inf'"
+ + " AND column_name='together_flag'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Station_Inf_Table
+ + " ADD COLUMN `together_flag` int(11) NOT NULL DEFAULT '0';");
+ }
+
//录入已存在的蓄电池机房信息
initBattStationInfoData(pool);
--
Gitblit v1.9.1