From 02c3f341fd8b1d4f7806d7cc240a1cb2d7b63f15 Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期四, 16 六月 2022 17:12:33 +0800
Subject: [PATCH] V1.31 edit at date 2022-06-16 1.新增初始化创建表`web_site`.`tb_map_outline`"表[首页轮廓图表] 2.新增初始化创建表`db_battinf`.`tb_battmon_standardcurve`表[标准曲线表]
---
BattMonitor_DB_Builder/src/com/database_util/DB_Ram_db.java | 26 +++++++++++++++++++++++++-
1 files changed, 25 insertions(+), 1 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 9d032ad..0a79c71 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
@@ -3027,13 +3027,37 @@
" UNIQUE KEY `index_dev_id` (`dev_id`) USING BTREE" +
") ENGINE=InnoDB AUTO_INCREMENT=2 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);
+ for(int i=0;i<8;i++) {
+ //添加字段LiBattGroupCount
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_ram_db'"
+ + " AND table_name='tb_fgcd_filedownload'"
+ + " AND column_name='now_data_block"+(i+1)+"'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Fgcd_filedownload_Table
+ + " ADD COLUMN `now_data_block"+(i+1)+"` int(11) NOT NULL DEFAULT '0' COMMENT '文件"+(i+1)+"当前下载进度';");
+ }
+
+ //添加字段LiBattGroupCount
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_ram_db'"
+ + " AND table_name='tb_fgcd_filedownload'"
+ + " AND column_name='total_data_block"+(i+1)+"'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Fgcd_filedownload_Table
+ + " ADD COLUMN `total_data_block"+(i+1)+"` int(11) NOT NULL DEFAULT '0' COMMENT '文件"+(i+1)+"总的数据块数';");
+ }
+ }
+
+
+
} catch (SQLException e) {
e.printStackTrace();
} finally {
--
Gitblit v1.9.1