From 219b17f8f5628dcb66da72ed0a70a0baca9a60d4 Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期四, 16 三月 2023 10:12:45 +0800
Subject: [PATCH] V1.60 edit at date 2023-03-16 1.'db_user.tb_user_battgroup_baojigroup'新增字段'discharge_plan_flag' -- 用于标识放电计划是否启用 ALTER TABLE `db_user`.`tb_user_battgroup_baojigroup` ADD COLUMN `discharge_plan_flag` TINYINT(1) UNSIGNED NULL DEFAULT 0 COMMENT '放电计划标识:0不参与放电计划,1参与放电计划' AFTER `baoji_group_name`; 2.'db_ram_db.tb_li9130_bms_state' 新增字段 'reserved1' - 预留[博强-无；拓邦-均衡温度] ALTER TABLE `db_ram_db`.`tb_li9130_bms_state` ADD COLUMN `reserved1` float NOT NULL DEFAULT '0' COMMENT '预留[博强-无；拓邦-均衡温度]';
---
BattMonitor_DB_Builder/src/com/database_util/DB_db_user.java | 13 +++++++++++++
1 files changed, 13 insertions(+), 0 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/database_util/DB_db_user.java b/BattMonitor_DB_Builder/src/com/database_util/DB_db_user.java
index 0d0b458..a012104 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_db_user.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/DB_db_user.java
@@ -502,11 +502,24 @@
" PRIMARY KEY (`baoji_group_id`)" +
") ENGINE=InnoDB AUTO_INCREMENT=100015 DEFAULT CHARSET=utf8;";
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
+ ResultSet res = null;
try {
if(true == recreate) {
sql.sqlMysqlExecute(sql_str01);
}
sql.sqlMysqlExecute(sql_str02);
+
+
+
+ //添加放电计划标识 discharge_plan_flag
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_user'"
+ + " AND table_name='tb_user_battgroup_baojigroup'"
+ + " AND column_name='discharge_plan_flag'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.User_Battgroup_Baojigroup_Table
+ + " ADD COLUMN `discharge_plan_flag` tinyint(1) unsigned DEFAULT '0' COMMENT '放电计划标识:0不参与放电计划,1参与放电计划';");
+ }
} catch (SQLException e) {
e.printStackTrace();
} finally {
--
Gitblit v1.9.1