From 449830e0d0a1de25a6b3fa6ba0a1fb6565f6330f Mon Sep 17 00:00:00 2001
From: DELL <DELL@WIN-3EOIPEE9ML1>
Date: 星期六, 13 一月 2024 13:48:38 +0800
Subject: [PATCH] V1.93 edit at date 2024-01-13 1.数据库'db_battinf.tb_battinf'新增字段 `sign_type` int(11) NOT NULL DEFAULT '0' COMMENT '验签格式0-常规 1-正常1拖2[61850设备有效]' 2.数据库'db_battinf.tb_battinf_update_record'新增字段 `sign_type` int(11) NOT NULL DEFAULT '0' COMMENT '验签格式0-常规 1-正常1拖2[61850设备有效]'
---
BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java | 29 +++++++++++++++++++++++++++++
1 files changed, 29 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 f76591f..5b1824f 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java
@@ -793,15 +793,34 @@
" PRIMARY KEY (`num`)" +
") ENGINE=InnoDB AUTO_INCREMENT=5 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);
+
+ res = null;
+ //添加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_update_record'"
+ + " AND column_name='sign_type'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Battinf_Update_Record_Table
+ + " ADD COLUMN `sign_type` int(11) NOT NULL DEFAULT '0' COMMENT '验签格式0-常规 1-正常1拖2[61850设备有效]';");
+ }
} catch (SQLException e) {
e.printStackTrace();
} finally {
+ if(null != res) {
+ try {
+ res.close();
+ } catch (SQLException e) {
+ e.printStackTrace();
+ }
+ }
sql.close_con();
}
}
@@ -1434,6 +1453,16 @@
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattInf_Table
+ " ADD COLUMN `StationType` varchar(255) DEFAULT NULL COMMENT '站点类型[例如110V/22V]';");
}
+ res = null;
+ //添加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'"
+ + " AND column_name='sign_type'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattInf_Table
+ + " ADD COLUMN `sign_type` int(11) NOT NULL DEFAULT '0' COMMENT '验签格式0-常规 1-正常1拖2[61850设备有效]';");
+ }
--
Gitblit v1.9.1