From f3c04464c07508700faf6d3c4bcaa777b8e9dd2b Mon Sep 17 00:00:00 2001
From: whyclxw <http://whyclxw@118.89.139.230:10101/r/~whyclxw/IdeaTest.git>
Date: 星期二, 31 八月 2021 10:29:14 +0800
Subject: [PATCH] db_alarm数据库中`tb_battalarm_data`，`tb_devalarm_data`数据库中添加work_flag,msg_flag(tinyint)字段
---
BattMonitor_DB_Builder/src/com/database_util/DB_Alarm.java | 48 ++++++++++++++++++++++++++++++++++++++++++++++--
1 files changed, 46 insertions(+), 2 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/database_util/DB_Alarm.java b/BattMonitor_DB_Builder/src/com/database_util/DB_Alarm.java
index 4c20262..410183a 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_Alarm.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/DB_Alarm.java
@@ -1,5 +1,6 @@
package com.database_util;
+import java.sql.ResultSet;
import java.sql.SQLException;
import com.sql.MysqlConnPool;
@@ -106,11 +107,33 @@
" KEY index_alm_cleared_type (alm_cleared_type)" +
") ENGINE=InnoDB AUTO_INCREMENT=18 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);
+
+
+ //添加指定的work_flag列(派单管理)
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_alarm'"
+ + " AND table_name='tb_devalarm_data'"
+ + " AND column_name='work_flag'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Devalarm_Data_Table
+ + " ADD COLUMN `work_flag` tinyint NOT NULL DEFAULT 0;");
+ }
+
+ //添加指定的msg_flag列(派单管理)
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_alarm'"
+ + " AND table_name='tb_devalarm_data'"
+ + " AND column_name='msg_flag'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Devalarm_Data_Table
+ + " ADD COLUMN `msg_flag` tinyint NOT NULL DEFAULT 0;");
+ }
} catch (SQLException e) {
e.printStackTrace();
} finally {
@@ -225,11 +248,32 @@
" KEY index_alm_level (alm_level)" +
") ENGINE=InnoDB AUTO_INCREMENT=1 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);
+
+ //添加指定的work_flag列(派单管理)
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_alarm'"
+ + " AND table_name='tb_battalarm_data'"
+ + " AND column_name='work_flag'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Battalarm_Data_Table
+ + " ADD COLUMN `work_flag` tinyint NOT NULL DEFAULT 0;");
+ }
+
+ //添加指定的msg_flag列(派单管理)
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_alarm'"
+ + " AND table_name='tb_battalarm_data'"
+ + " AND column_name='msg_flag'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Battalarm_Data_Table
+ + " ADD COLUMN `msg_flag` tinyint NOT NULL DEFAULT 0;");
+ }
} catch (SQLException e) {
e.printStackTrace();
} finally {
--
Gitblit v1.9.1