From 36deaf5ab0fc4390aba3a9407ff82984a0feee11 Mon Sep 17 00:00:00 2001
From: DELL <1525436766@qq.com>
Date: 星期三, 25 九月 2024 15:31:15 +0800
Subject: [PATCH] 2.表'db_pwrdev_data_rt.tb_pwrdev_acdcdata'新增字段 `m17_out_vol` float NOT NULL DEFAULT '0' COMMENT '模块17输出电压', `m18_out_vol` float NOT NULL DEFAULT '0' COMMENT '模块18输出电压', `m19_out_vol` float NOT NULL DEFAULT '0' COMMENT '模块19输出电压', `m20_out_vol` float NOT NULL DEFAULT '0' COMMENT '模块20输出电压',
---
BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Data_Rt.java | 36 ++++++++++++++++++++++++++++++++++++
1 files changed, 36 insertions(+), 0 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Data_Rt.java b/BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Data_Rt.java
index 6ab103d..769a7c4 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Data_Rt.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Data_Rt.java
@@ -589,6 +589,42 @@
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
+ " ADD COLUMN `m16_out_vol` float NOT NULL DEFAULT '0' COMMENT '整流器16输出电压';");
}
+ //添加m17_out_vol
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_pwrdev_data_rt'"
+ + " AND table_name='tb_pwrdev_acdcdata'"
+ + " AND column_name='m17_out_vol'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
+ + " ADD COLUMN `m17_out_vol` float NOT NULL DEFAULT '0' COMMENT '整流器17输出电压';");
+ }
+ //添加m18_out_vol
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_pwrdev_data_rt'"
+ + " AND table_name='tb_pwrdev_acdcdata'"
+ + " AND column_name='m18_out_vol'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
+ + " ADD COLUMN `m18_out_vol` float NOT NULL DEFAULT '0' COMMENT '整流器18输出电压';");
+ }
+ //添加m19_out_vol
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_pwrdev_data_rt'"
+ + " AND table_name='tb_pwrdev_acdcdata'"
+ + " AND column_name='m19_out_vol'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
+ + " ADD COLUMN `m19_out_vol` float NOT NULL DEFAULT '0' COMMENT '整流器19输出电压';");
+ }
+ //添加m20_out_vol
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_pwrdev_data_rt'"
+ + " AND table_name='tb_pwrdev_acdcdata'"
+ + " AND column_name='m20_out_vol'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrdev_Acdcdata_Table
+ + " ADD COLUMN `m20_out_vol` float NOT NULL DEFAULT '0' COMMENT '整流器20输出电压';");
+ }
//添加is_acb1_over_currA
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
--
Gitblit v1.9.1