From cbe11e1b664acc48cc55639eabbdd194c810af5a Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期二, 19 一月 2021 12:03:18 +0800
Subject: [PATCH] 修改
---
BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Inf.java | 22 +++++++++++++++++++++-
1 files changed, 21 insertions(+), 1 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Inf.java b/BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Inf.java
index 0be8917..ee2745c 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Inf.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Inf.java
@@ -1,5 +1,6 @@
package com.database_util;
+import java.sql.ResultSet;
import java.sql.SQLException;
import com.sql.MysqlConnPool;
@@ -91,6 +92,7 @@
" `SqlDB_BackUpTime` datetime NOT NULL DEFAULT '2000-01-01 00:00:00'," +
" `SqlDB_BackUpManual_EN` tinyint(1) NOT NULL DEFAULT '0'," +
" `AppServer_Reinit_PowerData_EN` tinyint(1) NOT NULL DEFAULT '0'," +
+ " `AppServer_Reinit_BattGroupData_EN` tinyint(1) NOT NULL DEFAULT '0'," +
" `AppServer_Reinit_Config_EN` tinyint(1) NOT NULL DEFAULT '0'," +
" `AppServer_Version` float NOT NULL DEFAULT '1'," +
" `AppClient_Version` float NOT NULL DEFAULT '1'," +
@@ -98,14 +100,32 @@
" PRIMARY KEY (`num`)" +
") 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);
+ sql.sqlMysqlExecute(sql_str02);
+
+ //添加字段AppServer_Reinit_PowerData_Charger_EN
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_pwrdev_inf'"
+ + " AND table_name='tb_pwrapp_sys'"
+ + " AND column_name='AppServer_Reinit_BattGroupData_EN'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Pwrapp_Sys_Table
+ + " ADD COLUMN `AppServer_Reinit_BattGroupData_EN` tinyint(1) NOT NULL DEFAULT '0';");
+ }
} catch (SQLException e) {
e.printStackTrace();
} finally {
+ if(null != res) {
+ try {
+ res.close();
+ } catch (SQLException e) {
+ e.printStackTrace();
+ }
+ }
sql.close_con();
}
}
--
Gitblit v1.9.1