From 8db779331bf6cdeacaa95d61ac1c38cc3635791c Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期二, 17 八月 2021 17:05:23 +0800
Subject: [PATCH] .67 edit at date 2021-08-17 1.db_battinf.tb_battinf表新增视频链接地址字段'video_url'
---
BattMonitor_DB_Builder/src/com/database_util/DB_App_Sys.java | 15 ++++++++++++++-
1 files changed, 14 insertions(+), 1 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/database_util/DB_App_Sys.java b/BattMonitor_DB_Builder/src/com/database_util/DB_App_Sys.java
index 0851d03..e2c8537 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_App_Sys.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/DB_App_Sys.java
@@ -1,5 +1,6 @@
package com.database_util;
+import java.sql.ResultSet;
import java.sql.SQLException;
import com.sql.MysqlConnPool;
@@ -209,6 +210,7 @@
" SqlDB_BackUpManual_EN tinyint(1) NOT NULL DEFAULT '0'," +
" AppServer_Reinit_BattGroupData_EN tinyint(1) NOT NULL DEFAULT '0'," +
" AppServer_Reinit_BattGroupData_LD9_EN tinyint(1) NOT NULL DEFAULT '0'," +
+ " AppServer_Reinit_BattGroupData_A059_EN tinyint(1) NOT NULL DEFAULT '0'," +
" AppServer_Reinit_Config_EN tinyint(1) NOT NULL DEFAULT '0'," +
" AppServer_Version float NOT NULL DEFAULT '1'," +
" AppClient_Version float NOT NULL DEFAULT '1'," +
@@ -216,11 +218,22 @@
" PRIMARY KEY (num)" +
") ENGINE=InnoDB AUTO_INCREMENT=2 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);
+ //添加充放电一体机蓄电池组录入状态
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_app_sys'"
+ + " AND table_name='tb_app_sys'"
+ + " AND column_name='AppServer_Reinit_BattGroupData_A059_EN'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.App_Sys_Table
+ + " ADD COLUMN AppServer_Reinit_BattGroupData_A059_EN tinyint(1) NOT NULL DEFAULT '0';");
+ }
+
} catch (SQLException e) {
e.printStackTrace();
} finally {
--
Gitblit v1.9.1