From a112f4592a4644bf7c3643e7cf6f366c36155301 Mon Sep 17 00:00:00 2001
From: DELL <DELL@WIN-3EOIPEE9ML1>
Date: 星期六, 27 一月 2024 16:45:23 +0800
Subject: [PATCH] 2.修复'db_param.tb_app_param'表中无初始化参数bug
---
BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java | 12 ++++++++++++
1 files changed, 12 insertions(+), 0 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java b/BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java
index 5b1824f..11e77cc 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java
@@ -532,6 +532,18 @@
//sql.sqlMysqlExecute(sql_str01);
}
sql.sqlMysqlExecute(sql_str02);
+
+
+ //添加sign_type - 验签格式0-常规 1-正常1拖2[61850设备有效]
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_battinf'"
+ + " AND table_name='tb_battinf_rebuild'"
+ + " AND column_name='sign_type'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattinfRebuild_TABLE
+ + " ADD COLUMN `sign_type` int(11) NOT NULL DEFAULT '0' COMMENT '验签格式0-常规 1-正常1拖2[61850设备有效]';");
+ }
+
} catch (SQLException e) {
e.printStackTrace();
} finally {
--
Gitblit v1.9.1