From 7528e3b7d9a883b89b97f6c671ef229e93b370fb Mon Sep 17 00:00:00 2001
From: whyclj <1525436766@qq.com>
Date: 星期三, 02 一月 2019 09:55:52 +0800
Subject: [PATCH] 执行完重新建表程序后，修改指定字段（逻辑中添加事务修改）
---
BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java | 58 +++++++++++++++++++++++++++++++++++++++++-----------------
1 files changed, 41 insertions(+), 17 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java b/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java
index e8e6cc1..420b6f8 100644
--- a/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java
+++ b/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java
@@ -33,7 +33,7 @@
public final static String TB_BattTestDataInf = "tb_batttestdata_inf";
public final static String TB_BattRtState = "tb_batt_rtstate";
- public final static String TB_BattRtData = "tb_server_state";
+ public final static String TB_BattRtData = "tb_batt_rtdata";
public final static String TB_UserInf = "tb_user_inf";
public final static String TB_UserLog = "tb_user_log";
@@ -174,6 +174,7 @@
+ "`SqlDB_BackUpTime` DATETIME NOT NULL DEFAULT '2000-1-1 00:00:00',"
+ "`SqlDB_BackUpManual_EN` BOOLEAN NOT NULL DEFAULT false, "
+ "`AppServer_Reinit_BattGroupData_EN` BOOLEAN NOT NULL DEFAULT false, "
+ + "`AppServer_Reinit_Config_EN` BOOLEAN NOT NULL DEFAULT false, "
+ "`AppServer_Version` FLOAT NOT NULL DEFAULT '1.0',"
+ "`AppClient_Version` FLOAT NOT NULL DEFAULT '1.0',"
+ "`AppName` VARCHAR(50) NOT NULL DEFAULT '0',"
@@ -477,26 +478,49 @@
}
}
//---------------------------------------------------------------------------------------------//
- ResultSet res0 = sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ ResultSet res0 = sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_app_sys'"
+ + " AND table_name='tb_app_sys'"
+ + " AND column_name='SqlDB_BackUpTime'");
+ if(false == res0.next()) {
+ sqlMysqlExecute("ALTER TABLE " + AppSys_Table
+ + " ADD COLUMN `SqlDB_BackUpTime` DATETIME NOT NULL DEFAULT '2000-1-1 00:00:00'"
+ + " AFTER `SqlDB_Version`,"
+ + " ADD COLUMN `SqlDB_BackUpManual_EN` BOOLEAN NOT NULL DEFAULT false"
+ + " AFTER `SqlDB_BackUpTime`");
+ }
+ res0 = sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ " WHERE table_schema='db_app_sys'"
+ " AND table_name='tb_app_sys'"
- + " AND column_name='SqlDB_BackUpTime'");
- if(false == res0.next()) {
+ + " AND column_name='SqlDB_BackUpManual_EN'");
+ if(false == res0.next()) {
+ sqlMysqlExecute("ALTER TABLE " + AppSys_Table
+ + " ADD COLUMN `SqlDB_BackUpManual_EN` BOOLEAN NOT NULL DEFAULT false"
+ + " AFTER `SqlDB_BackUpTime`");
+ }
+
+ /**************************** db_app_sys 表中添加 AppServer_Reinit_BattGroupData_EN列(重新载入电池组信息) *******************************************/
+ res0 = sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_app_sys'"
+ + " AND table_name='tb_app_sys'"
+ + " AND column_name='AppServer_Reinit_BattGroupData_EN'");
+ if(false == res0.next()) {
sqlMysqlExecute("ALTER TABLE " + AppSys_Table
- + " ADD COLUMN `SqlDB_BackUpTime` DATETIME NOT NULL DEFAULT '2000-1-1 00:00:00'"
- + " AFTER `SqlDB_Version`,"
- + " ADD COLUMN `SqlDB_BackUpManual_EN` BOOLEAN NOT NULL DEFAULT false"
- + " AFTER `SqlDB_BackUpTime`");
- }
- res0 = sqlMysqlQuery("SELECT * FROM information_schema.columns"
- + " WHERE table_schema='db_app_sys'"
- + " AND table_name='tb_app_sys'"
- + " AND column_name='SqlDB_BackUpManual_EN'");
- if(false == res0.next()) {
+ + " ADD COLUMN `AppServer_Reinit_BattGroupData_EN` BOOLEAN NOT NULL DEFAULT false"
+ + " AFTER `SqlDB_BackUpManual_EN`");
+ }
+
+
+ /**************************** db_app_sys 表中添加 AppServer_Reinit_BattGroupData_EN 列(用于主程序动态调整运行参数) *******************************************/
+ res0 = sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_app_sys'"
+ + " AND table_name='tb_app_sys'"
+ + " AND column_name='AppServer_Reinit_Config_EN'");
+ if(false == res0.next()) {
sqlMysqlExecute("ALTER TABLE " + AppSys_Table
- + " ADD COLUMN `SqlDB_BackUpManual_EN` BOOLEAN NOT NULL DEFAULT false"
- + " AFTER `SqlDB_BackUpTime`");
- }
+ + " ADD COLUMN `AppServer_Reinit_Config_EN` BOOLEAN NOT NULL DEFAULT false"
+ + " AFTER `AppServer_Reinit_BattGroupData_EN`");
+ }
//---------------------------------------------------------------------------------------------//
sqlMysqlExecute(table_1);
--
Gitblit v1.9.1