电操核容线程添加数据重载字段

Administrator

2023-02-20 f407b78f0e7f201ba61d2a5aea20a7cb9d37089e

电操核容线程添加数据重载字段

 BattMonitor_DB_Builder/src/com/battdata_rt/BattData_RT_RamDB_Thread_SQL.java

@@ -447,6 +447,7 @@
                                + " AppServer_Reinit_BattGroupData_LD9_EN = 1,"

                                + " AppServer_Reinit_BattGroupData_A059_EN = 1,"

                                + " AppServer_Reinit_BattGroupData_61851_EN = 1,"

                                + " AppServer_Reinit_BattGroupData_60870_EN = 1,"

                                + " AppServer_Reinit_BattGroupData_FBO4830_EN = 1"

                                + " WHERE num > 0"

                                ;


 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();