From f407b78f0e7f201ba61d2a5aea20a7cb9d37089e Mon Sep 17 00:00:00 2001 From: Administrator <1525436766@qq.com> Date: 星期一, 20 二月 2023 09:30:49 +0800 Subject: [PATCH] 电操核容线程添加数据重载字段 --- BattMonitor_DB_Builder/src/com/database_util/DB_App_Sys.java | 9 +++++++++ 1 files changed, 9 insertions(+), 0 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 e6205a3..c1cb7f1 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 @@ -605,6 +605,15 @@ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.App_Sys_Table + " ADD COLUMN `AppServer_Reinit_BattGroupData_61851_EN` tinyint(1) NOT NULL DEFAULT '0' COMMENT '杩滅▼閲嶅惎瑁呯疆閲嶆柊鍔犺浇鏈烘埧淇℃伅';"); } + //娣诲姞鐢垫搷鏍稿绾跨▼閲嶈浇鏁版嵁 + 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_60870_EN'"); + if(false == res.next()) { + sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.App_Sys_Table + + " ADD COLUMN `AppServer_Reinit_BattGroupData_60870_EN` tinyint(1) NOT NULL DEFAULT '0' COMMENT '鐢垫搷鏍稿閲嶆柊鍔犺浇鏈烘埧淇℃伅';"); + } } catch (SQLException e) { e.printStackTrace(); -- Gitblit v1.9.1