From 6ef2fa8148eacf52aa320d1c5a61ebbacf31e6d6 Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期三, 23 二月 2022 11:52:41 +0800
Subject: [PATCH] V2.09 edit at date 2022-2-18 1：修改`db_ram_db`.`tb_batt_rtdata`表新增字段 `mon_test_cap` float NOT NULL DEFAULT '0' COMMENT '单体测试容量', `mon_dis_timelong` int(11) NOT NULL DEFAULT '0' COMMENT '放电可持续时长', `mon_rest_cap` float NOT NULL DEFAULT '0' COMMENT '单体剩余容量',
---
BattMonitor_DB_Builder/src/com/database_util/DB_Ram_db.java | 40 ++++++++++++++++++++++++++++++++++++++++
1 files changed, 40 insertions(+), 0 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/database_util/DB_Ram_db.java b/BattMonitor_DB_Builder/src/com/database_util/DB_Ram_db.java
index fd8ba92..ca4bee9 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_Ram_db.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/DB_Ram_db.java
@@ -2180,6 +2180,46 @@
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattRtData_Table
+ " ADD COLUMN mon_LY_vol float NOT NULL DEFAULT '0';");
}
+
+ //添加字段mon_test_cap
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_ram_db'"
+ + " AND table_name='tb_batt_rtdata'"
+ + " AND column_name='mon_test_cap'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattRtData_Table
+ + " ADD COLUMN `mon_test_cap` float NOT NULL DEFAULT '0' COMMENT '单体测试容量';");
+ }
+
+ //添加字段mon_dis_timelong
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_ram_db'"
+ + " AND table_name='tb_batt_rtdata'"
+ + " AND column_name='mon_dis_timelong'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattRtData_Table
+ + " ADD COLUMN `mon_dis_timelong` int(11) NOT NULL DEFAULT '0' COMMENT '放电可持续时长';");
+ }
+
+ //添加字段mon_rest_cap--单体剩余容量
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_ram_db'"
+ + " AND table_name='tb_batt_rtdata'"
+ + " AND column_name='mon_rest_cap'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattRtData_Table
+ + " ADD COLUMN `mon_rest_cap` float NOT NULL DEFAULT '0' COMMENT '单体剩余容量';");
+ }
+
+ //添加字段mon_state--单体状态
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_ram_db'"
+ + " AND table_name='tb_batt_rtdata'"
+ + " AND column_name='mon_state'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattRtData_Table
+ + " ADD COLUMN `mon_state` int(11) NOT NULL DEFAULT '0' COMMENT '单体状态';");
+ }
} catch (SQLException e) {
e.printStackTrace();
} finally {
--
Gitblit v1.9.1