From a0c67802902622ce5fe13d800e74cf31b2ed7399 Mon Sep 17 00:00:00 2001
From: DELL <DELL@192.168.0.109>
Date: 星期一, 13 四月 2020 08:50:28 +0800
Subject: [PATCH] 在用户表和电池信息表中添加uKey信息
---
BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java | 44 ++++++++++++++++++++++++++++++++++++++++++--
1 files changed, 42 insertions(+), 2 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java b/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java
index aea823d..c8c0507 100644
--- a/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java
+++ b/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java
@@ -649,8 +649,8 @@
+ " ADD COLUMN `charge_curr_max` float DEFAULT '20'");
}
//---------------------------------------------------------------------------------------------//
- //为紫晶平台添加指定的列
- boolean isZijing = false;
+ //为紫晶南网平台添加指定的列
+ boolean isZijing = true;
if(isZijing) {
//添加电压等级列
res = sqlMysqlQuery("SELECT * FROM information_schema.columns"
@@ -815,6 +815,46 @@
+ " ADD COLUMN `JunChargeVoltageValue` float DEFAULT '0'");
}
+
+ //公钥X
+ res = sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_battinf'"
+ + " AND table_name='tb_battinf'"
+ + " AND column_name='PublicKeyX'");
+ if(false == res.next()) {
+ sqlMysqlExecute("ALTER TABLE " + BattInf_Table
+ + " ADD COLUMN `PublicKeyX` varchar(200) NOT NULL DEFAULT ''");
+ }
+
+ //公钥Y
+ res = sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_battinf'"
+ + " AND table_name='tb_battinf'"
+ + " AND column_name='PublicKeyY'");
+ if(false == res.next()) {
+ sqlMysqlExecute("ALTER TABLE " + BattInf_Table
+ + " ADD COLUMN `PublicKeyY` varchar(200) NOT NULL DEFAULT ''");
+ }
+
+ //KeyID
+ res = sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_battinf'"
+ + " AND table_name='tb_battinf'"
+ + " AND column_name='KeyID'");
+ if(false == res.next()) {
+ sqlMysqlExecute("ALTER TABLE " + BattInf_Table
+ + " ADD COLUMN `KeyID` varchar(200) NOT NULL DEFAULT ''");
+ }
+
+ //唯一索引
+ res = sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_battinf'"
+ + " AND table_name='tb_battinf'"
+ + " AND column_name='SerialNumber'");
+ if(false == res.next()) {
+ sqlMysqlExecute("ALTER TABLE " + BattInf_Table
+ + " ADD COLUMN `SerialNumber` varchar(200) NOT NULL DEFAULT ''");
+ }
}
--
Gitblit v1.9.1