From faa8d63e2944d84f4ef477394d9ffee53c79e56b Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期六, 29 七月 2023 08:53:44 +0800
Subject: [PATCH] 电源信息表新增电源型号字段
---
BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Inf.java | 11 +++++++++++
1 files changed, 11 insertions(+), 0 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Inf.java b/BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Inf.java
index 5e469a4..bf99468 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Inf.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Inf.java
@@ -73,6 +73,7 @@
" `ProtocolName` varchar(100) NOT NULL DEFAULT '0'," +
" `DeviceId` varchar(20) DEFAULT '0'," +
" `DeviceName` varchar(100) DEFAULT '0'," +
+ " `model` varchar(45) DEFAULT NULL COMMENT '型号'," +
" `PowerProducer` varchar(45) NOT NULL DEFAULT '0'," +
" `PowerProductDate` date NOT NULL DEFAULT '2006-07-06'," +
" `PowerInUseDate` date NOT NULL DEFAULT '2006-07-06'," +
@@ -176,6 +177,16 @@
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Inf_Table
+ " ADD COLUMN `dcoutvol_low_limit` float NOT NULL DEFAULT '43.2' COMMENT '直流输出电压下限阈值';");
}
+ res = null;
+ //添加字段model ----- 电源型号
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_pwrdev_inf'"
+ + " AND table_name='tb_pwrdev_inf'"
+ + " AND column_name='model'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Inf_Table
+ + " ADD COLUMN `model` varchar(45) DEFAULT NULL COMMENT '型号' AFTER `DeviceName`;");
+ }
} catch (SQLException e) {
e.printStackTrace();
} finally {
--
Gitblit v1.9.1