From 42cd07fa9ef7d14db0f0e759a3a121b8d71843f5 Mon Sep 17 00:00:00 2001
From: whyclj <1525436766@qq.com>
Date: 星期二, 15 一月 2019 09:38:29 +0800
Subject: [PATCH] 给指定的列添加新增加的字段
---
BattMonitor_DB_Builder/src/com/dev/fbs9100/FBS9100_Task_Thread_SQL.java | 12 ++++++------
1 files changed, 6 insertions(+), 6 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/dev/fbs9100/FBS9100_Task_Thread_SQL.java b/BattMonitor_DB_Builder/src/com/dev/fbs9100/FBS9100_Task_Thread_SQL.java
index a9ffcc5..29e6fd6 100644
--- a/BattMonitor_DB_Builder/src/com/dev/fbs9100/FBS9100_Task_Thread_SQL.java
+++ b/BattMonitor_DB_Builder/src/com/dev/fbs9100/FBS9100_Task_Thread_SQL.java
@@ -168,7 +168,7 @@
+ " AND table_name='tb_fbs9100_setparam'"
+ " AND column_name='BattGroupNum'");
if(false == res.next()) {
- sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattRtState_Table
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SetParam_Table
+ " ADD COLUMN `BattGroupNum` INT NOT NULL DEFAULT 0;");
}
//添加指定的OnlineVolLowAction列
@@ -177,7 +177,7 @@
+ " AND table_name='tb_fbs9100_setparam'"
+ " AND column_name='OnlineVolLowAction'");
if(false == res.next()) {
- sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattRtState_Table
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SetParam_Table
+ " ADD COLUMN `OnlineVolLowAction` INT NOT NULL DEFAULT 0;");
}
//添加指定的 DCVolHighLimit 列
@@ -186,7 +186,7 @@
+ " AND table_name='tb_fbs9100_setparam'"
+ " AND column_name='DCVolHighLimit'");
if(false == res.next()) {
- sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattRtState_Table
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SetParam_Table
+ " ADD COLUMN `DCVolHighLimit` FLOAT NOT NULL DEFAULT 0;");
}
//添加指定的 ChargeCurrSet 列
@@ -195,7 +195,7 @@
+ " AND table_name='tb_fbs9100_setparam'"
+ " AND column_name='ChargeCurrSet'");
if(false == res.next()) {
- sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattRtState_Table
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SetParam_Table
+ " ADD COLUMN `ChargeCurrSet` FLOAT NOT NULL DEFAULT 0;");
}
//添加指定的 MonomerTmp_High 列
@@ -204,7 +204,7 @@
+ " AND table_name='tb_fbs9100_setparam'"
+ " AND column_name='MonomerTmp_High'");
if(false == res.next()) {
- sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattRtState_Table
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SetParam_Table
+ " ADD COLUMN `MonomerTmp_High` FLOAT NOT NULL DEFAULT 0;");
}
//添加指定的 AutoTestStartVol 列
@@ -213,7 +213,7 @@
+ " AND table_name='tb_fbs9100_setparam'"
+ " AND column_name='AutoTestStartVol'");
if(false == res.next()) {
- sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattRtState_Table
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SetParam_Table
+ " ADD COLUMN `AutoTestStartVol` float NOT NULL DEFAULT 0;");
}
} catch (SQLException e) {
--
Gitblit v1.9.1