From 092e21b19d06cb9c2a79c2444670860c3479272a Mon Sep 17 00:00:00 2001
From: DELL <DELL@WIN-3EOIPEE9ML1>
Date: 星期三, 03 四月 2024 10:42:02 +0800
Subject: [PATCH] 2.表'db_ckpwrdev_inf.tb_ckpwrdev_inf'新增字段用于测控平台通过61850连接紫晶电源 `pwr_dev_ip` varchar(64) NOT NULL DEFAULT '127.0.0.1' COMMENT '紫晶61850协转IP地址', `zjdy_record__time` datetime NOT NULL DEFAULT '2000-01-01 00:00:00' COMMENT '紫晶电源协转数据更新时间',
---
BattMonitor_DB_Builder/src/com/database_util/DB_Ckpwrdev_Inf.java | 26 +++++++++++++++++++++++++-
1 files changed, 25 insertions(+), 1 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/database_util/DB_Ckpwrdev_Inf.java b/BattMonitor_DB_Builder/src/com/database_util/DB_Ckpwrdev_Inf.java
index ab68072..8bbf267 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_Ckpwrdev_Inf.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/DB_Ckpwrdev_Inf.java
@@ -1,5 +1,6 @@
package com.database_util;
+import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Date;
@@ -97,11 +98,34 @@
" UNIQUE KEY `idx_power_device_id` (`power_device_id`) USING BTREE" +
") ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='测控电源信息表';";
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);
+
+ //新增字段pwr_dev_ip
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_ckpwrdev_inf'"
+ + " AND table_name='tb_ckpwrdev_inf'"
+ + " AND column_name='pwr_dev_ip'");
+ if(!res.next()) {
+ //修改字段st
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Ckpwrdev_Inf_Table
+ + " ADD column `pwr_dev_ip` varchar(64) NOT NULL DEFAULT '127.0.0.1' COMMENT '紫晶61850协转IP地址';");
+ }
+
+ //新增字段zjdy_record__time
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_ckpwrdev_inf'"
+ + " AND table_name='tb_ckpwrdev_inf'"
+ + " AND column_name='zjdy_record__time'");
+ if(!res.next()) {
+ //修改字段st
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Ckpwrdev_Inf_Table
+ + " ADD column `zjdy_record__time` datetime NOT NULL DEFAULT '2000-01-01 00:00:00' COMMENT '紫晶电源协转数据更新时间';");
+ }
} catch (SQLException e) {
e.printStackTrace();
} finally {
--
Gitblit v1.9.1