From a9f3ec0583d3846b1350a791c9d7f39307c3da6b Mon Sep 17 00:00:00 2001
From: whyclj <1525436766@qq.com>
Date: 星期三, 06 五月 2020 11:41:15 +0800
Subject: [PATCH] 添加放电计划规避时间表
---
BattMonitor_DB_Builder/src/com/database_util/DB_db_user.java | 16 ++++++++--------
1 files changed, 8 insertions(+), 8 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/database_util/DB_db_user.java b/BattMonitor_DB_Builder/src/com/database_util/DB_db_user.java
index 3b47991..622c559 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_db_user.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/DB_db_user.java
@@ -76,41 +76,41 @@
//添加加密告警upassword
ResultSet res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
- + " WHERE table_schema='db_battinf'"
+ + " WHERE table_schema='db_user'"
+ " AND table_name='tb_user_inf'"
+ " AND column_name='upassword'");
if(false == res.next()) {
- sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.DeverrorRecord_Table
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.TB_UserInf
+ " ADD COLUMN `upassword` varchar(64) NOT NULL DEFAULT ''");
}
//添加公钥X
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
- + " WHERE table_schema='db_battinf'"
+ + " WHERE table_schema='db_user'"
+ " AND table_name='tb_user_inf'"
+ " AND column_name='uPubKeyX'");
if(false == res.next()) {
- sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.DeverrorRecord_Table
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.TB_UserInf
+ " ADD COLUMN `uPubKeyX` varchar(200) NOT NULL DEFAULT ''");
}
//添加公钥Y
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
- + " WHERE table_schema='db_battinf'"
+ + " WHERE table_schema='db_user'"
+ " AND table_name='tb_user_inf'"
+ " AND column_name='uPubKeyY'");
if(false == res.next()) {
- sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.DeverrorRecord_Table
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.TB_UserInf
+ " ADD COLUMN `uPubKeyY` varchar(200) NOT NULL DEFAULT ''");
}
//添加uKey_ID
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
- + " WHERE table_schema='db_battinf'"
+ + " WHERE table_schema='db_user'"
+ " AND table_name='tb_user_inf'"
+ " AND column_name='uKey_ID'");
if(false == res.next()) {
- sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.DeverrorRecord_Table
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.TB_UserInf
+ " ADD COLUMN `uKey_ID` varchar(200) NOT NULL DEFAULT ''");
}
--
Gitblit v1.9.1