From ade57fcc639e316087f8598d87f1ef90277f33f4 Mon Sep 17 00:00:00 2001
From: whyclj <1525436766@qq.com>
Date: 星期日, 11 十月 2020 15:34:23 +0800
Subject: [PATCH] 添加备用加载电机绕组温度字段
---
Motor_MonitorServer/src/com/motor/conn/Motor_Task_SQL.java | 34 ++++++++++++++++++++++++++++++++++
1 files changed, 34 insertions(+), 0 deletions(-)
diff --git a/Motor_MonitorServer/src/com/motor/conn/Motor_Task_SQL.java b/Motor_MonitorServer/src/com/motor/conn/Motor_Task_SQL.java
index 9ffb2a5..1908395 100644
--- a/Motor_MonitorServer/src/com/motor/conn/Motor_Task_SQL.java
+++ b/Motor_MonitorServer/src/com/motor/conn/Motor_Task_SQL.java
@@ -101,6 +101,9 @@
" load_motor_wind_tmp1 float NOT NULL DEFAULT '0' COMMENT '加载电机绕组温度1'," +
" load_motor_wind_tmp2 float NOT NULL DEFAULT '0' COMMENT '加载电机绕组温度2'," +
" load_motor_wind_tmp3 float NOT NULL DEFAULT '0' COMMENT '加载电机绕组温度3'," +
+ " load_motor_wind_tmp1_bp float NOT NULL DEFAULT '0' COMMENT '备用加载电机绕组温度1'," +
+ " load_motor_wind_tmp2_bp float NOT NULL DEFAULT '0' COMMENT '备用加载电机绕组温度2'," +
+ " load_motor_wind_tmp3_bp float NOT NULL DEFAULT '0' COMMENT '备用加载电机绕组温度3'," +
" load_motor_bear_tmp1 float NOT NULL DEFAULT '0' COMMENT '加载电机轴承温度1'," +
" load_motor_bear_tmp2 float NOT NULL DEFAULT '0' COMMENT '加载电机轴承温度2'," +
" load_motor_out_tmp float NOT NULL DEFAULT '0' COMMENT '加载电机出口温度'," +
@@ -118,8 +121,36 @@
" UNIQUE KEY motor_id_index (motor_id) USING BTREE" +
") ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;";
Sql_Mysql sql = new Sql_Mysql(conn_pool.getConn());
+ ResultSet res = null;
try {
sql.sqlMysqlExecute(sql_str);
+ //添加备用加载电机绕组温度1
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_elemachinery'"
+ + " AND table_name='tb_load_motor_state'"
+ + " AND column_name='load_motor_wind_tmp1_bp'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Tb_Load_Motor_state
+ + " ADD COLUMN load_motor_wind_tmp1_bp float NOT NULL DEFAULT '0' COMMENT '备用加载电机绕组温度1';");
+ }
+ //添加备用加载电机绕组温度2
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_elemachinery'"
+ + " AND table_name='tb_load_motor_state'"
+ + " AND column_name='load_motor_wind_tmp2_bp'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Tb_Load_Motor_state
+ + " ADD COLUMN load_motor_wind_tmp2_bp float NOT NULL DEFAULT '0' COMMENT '备用加载电机绕组温度2';");
+ }
+ //添加备用加载电机绕组温度3
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_elemachinery'"
+ + " AND table_name='tb_load_motor_state'"
+ + " AND column_name='load_motor_wind_tmp3_bp'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Tb_Load_Motor_state
+ + " ADD COLUMN load_motor_wind_tmp3_bp float NOT NULL DEFAULT '0' COMMENT '备用加载电机绕组温度3';");
+ }
} catch (SQLException e) {
e.printStackTrace();
} finally {
@@ -301,6 +332,9 @@
" load_motor_wind_tmp1 = "+state.load_motor_wind_tmp1+"," +
" load_motor_wind_tmp2 = "+state.load_motor_wind_tmp2+"," +
" load_motor_wind_tmp3 = "+state.load_motor_wind_tmp3+"," +
+ " load_motor_wind_tmp1_bp = "+state.load_motor_wind_tmp1_bp+"," +
+ " load_motor_wind_tmp2_bp = "+state.load_motor_wind_tmp2_bp+"," +
+ " load_motor_wind_tmp3_bp = "+state.load_motor_wind_tmp3_bp+"," +
" load_motor_bear_tmp1 = "+state.load_motor_bear_tmp1+"," +
" load_motor_bear_tmp2 = "+state.load_motor_bear_tmp2+"," +
" load_motor_out_tmp = "+state.load_motor_out_tmp+"," +
--
Gitblit v1.9.1