~whyclj/BattMonitor_DB_Builder.git

parent: 541329aa | 补丁 | 提交 | ignore whitespace

4.'db_app_sys.tb_app_sys'表新增字段 `AppServer_Reinit_BattGroupData_FBO60010CT...

DELL

2024-11-21 93cfb0628116db7847be6d06b54f1d591bc0a8e2

4.'db_app_sys.tb_app_sys'表新增字段
		`AppServer_Reinit_BattGroupData_FBO60010CT_EN` tinyint(1) NOT NULL
DEFAULT '0' COMMENT 'FBO60010CT_ZX重载数据标识',
  		`AppServer_Reinit_BattGroupData_61850_EN` tinyint(1) NOT NULL
DEFAULT '0' COMMENT '61850设备重载电池组数据',
  		`AppServer_Reinit_BattGroupData_61851_EN` tinyint(1) NOT NULL
DEFAULT '0' COMMENT '61851设备重载电池组数据',
  		`AppServer_Reinit_BattGroupData_61852_EN` tinyint(1) NOT NULL
DEFAULT '0' COMMENT '61852设备重载电池组数据',
  		`AppServer_Reinit_BattGroupData_61853_EN` tinyint(1) NOT NULL
DEFAULT '0' COMMENT 'BTS2202_4802_LR',

6个文件已修改

	BattMonitor_DB_Builder/bin/com/database_util/DB_App_Sys.class	补丁 \| 查看 \| 原始文档 \| blame \| 历史
	BattMonitor_DB_Builder/bin/com/database_util/DB_web_site.class	补丁 \| 查看 \| 原始文档 \| blame \| 历史
	BattMonitor_DB_Builder/bin/com/version_inf/version_inf.txt	3 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	BattMonitor_DB_Builder/src/com/database_util/DB_App_Sys.java	29 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java	10 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt	3 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史

 BattMonitor_DB_Builder/bin/com/database_util/DB_App_Sys.class

Binary files differ

 BattMonitor_DB_Builder/bin/com/database_util/DB_web_site.class

Binary files differ

 BattMonitor_DB_Builder/bin/com/version_inf/version_inf.txt

@@ -17,6 +17,9 @@
    4.'db_app_sys.tb_app_sys'表新增字段
        `AppServer_Reinit_BattGroupData_FBO60010CT_EN` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'FBO60010CT_ZX重载数据标识',
          `AppServer_Reinit_BattGroupData_61850_EN` tinyint(1) NOT NULL DEFAULT '0' COMMENT '61850设备重载电池组数据',
          `AppServer_Reinit_BattGroupData_61851_EN` tinyint(1) NOT NULL DEFAULT '0' COMMENT '61851设备重载电池组数据',
          `AppServer_Reinit_BattGroupData_61852_EN` tinyint(1) NOT NULL DEFAULT '0' COMMENT '61852设备重载电池组数据',
          `AppServer_Reinit_BattGroupData_61853_EN` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'BTS2202_4802_LR',

V2.07 edit at date 2024-10-28
    1.表'db_app_sys.tb_page_param'表中默认新增用户密码时效配置，默认插入值'-1'-永不失效 

 BattMonitor_DB_Builder/src/com/database_util/DB_App_Sys.java

@@ -738,6 +738,7 @@
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.App_Sys_Table 
                        + " ADD COLUMN `AppServer_Reinit_BattGroupData_FBO4830_EN` tinyint(1) NOT NULL DEFAULT '0' COMMENT '重新FBO4830线程加载机房信息';");
            }
            res = null;
            //添加FBO60010CT重载数据
            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
                    + " WHERE table_schema='db_app_sys'"
@@ -747,6 +748,7 @@
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.App_Sys_Table 
                        + " ADD COLUMN `AppServer_Reinit_BattGroupData_FBO60010CT_EN` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'FBO60010CT_ZX重载数据标识';");
            }
            res = null;
            //添加61850重载数据
            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
                    + " WHERE table_schema='db_app_sys'"
@@ -756,6 +758,33 @@
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.App_Sys_Table 
                        + " ADD COLUMN `AppServer_Reinit_BattGroupData_61850_EN` tinyint(1) NOT NULL DEFAULT '0' COMMENT '61850设备重载电池组数据';");
            }
            //添加61851重载数据
            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_61851_EN'");
            if(false == res.next()) {
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.App_Sys_Table 
                        + " ADD COLUMN `AppServer_Reinit_BattGroupData_61851_EN` tinyint(1) NOT NULL DEFAULT '0' COMMENT '61851设备重载电池组数据';");
            }
            //添加61852重载数据
            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_61852_EN'");
            if(false == res.next()) {
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.App_Sys_Table 
                        + " ADD COLUMN `AppServer_Reinit_BattGroupData_61852_EN` tinyint(1) NOT NULL DEFAULT '0' COMMENT '61852设备重载电池组数据';");
            }
            //添加61853重载数据
            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_61853_EN'");
            if(false == res.next()) {
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.App_Sys_Table 
                        + " ADD COLUMN `AppServer_Reinit_BattGroupData_61853_EN` tinyint(1) NOT NULL DEFAULT '0' COMMENT '61853设备重载电池组数据';");
            }
            
        } catch (SQLException e) {
            e.printStackTrace();

 BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java

@@ -4321,6 +4321,16 @@
            if(false == res.next()) {
                sql.sqlMysqlExecute(" INSERT INTO " + Sql_Mysql.ProcessSurvey_Table + "(ProcessId,ProcessName,ProcessTime,Process_starttime,ServerName,ServerFlag,ProcessVersion,note,OutTime) VALUES ('11030', 'BMS_FBS9800_DISPLAY',     '1970-01-01 00:00:00', '1970-01-01 00:00:00', 'BMS_FBS9800_DISPLAY', '2', 'v1.100', 'FBS9800汇集模块通信线程', '300');");
            }
            //FBO-60010CT-11031
            res = sql.sqlMysqlQuery("SELECT ProcessName FROM "+ Sql_Mysql.ProcessSurvey_Table + " WHERE ProcessId = 11031");
            if(false == res.next()) {
                sql.sqlMysqlExecute(" INSERT INTO " + Sql_Mysql.ProcessSurvey_Table + "(ProcessId,ProcessName,ProcessTime,Process_starttime,ServerName,ServerFlag,ProcessVersion,note,OutTime) VALUES ('11031', 'BMS_FBO60010CT_ZX',     '1970-01-01 00:00:00', '1970-01-01 00:00:00', 'BMS_FBO60010CT_ZX', '2', 'v1.100', 'FBO60010CT_ZX通信线程', '300');");
            }
            //BTS2202-4820-LR-11032
            res = sql.sqlMysqlQuery("SELECT ProcessName FROM "+ Sql_Mysql.ProcessSurvey_Table + " WHERE ProcessId = 11032");
            if(false == res.next()) {
                sql.sqlMysqlExecute(" INSERT INTO " + Sql_Mysql.ProcessSurvey_Table + "(ProcessId,ProcessName,ProcessTime,Process_starttime,ServerName,ServerFlag,ProcessVersion,note,OutTime) VALUES ('11032', 'BMS_BTS61853_MONITOR',     '1970-01-01 00:00:00', '1970-01-01 00:00:00', 'BMS_BTS61853_MONITOR', '2', 'v1.100', 'BTS2202_4802_LR通信线程', '300');");
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {

 BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt

@@ -17,6 +17,9 @@
    4.'db_app_sys.tb_app_sys'表新增字段
        `AppServer_Reinit_BattGroupData_FBO60010CT_EN` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'FBO60010CT_ZX重载数据标识',
          `AppServer_Reinit_BattGroupData_61850_EN` tinyint(1) NOT NULL DEFAULT '0' COMMENT '61850设备重载电池组数据',
          `AppServer_Reinit_BattGroupData_61851_EN` tinyint(1) NOT NULL DEFAULT '0' COMMENT '61851设备重载电池组数据',
          `AppServer_Reinit_BattGroupData_61852_EN` tinyint(1) NOT NULL DEFAULT '0' COMMENT '61852设备重载电池组数据',
          `AppServer_Reinit_BattGroupData_61853_EN` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'BTS2202_4802_LR',

V2.07 edit at date 2024-10-28
    1.表'db_app_sys.tb_page_param'表中默认新增用户密码时效配置，默认插入值'-1'-永不失效

			@@ -17,6 +17,9 @@
			4.'db_app_sys.tb_app_sys'表新增字段
			`AppServer_Reinit_BattGroupData_FBO60010CT_EN` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'FBO60010CT_ZX重载数据标识',
			`AppServer_Reinit_BattGroupData_61850_EN` tinyint(1) NOT NULL DEFAULT '0' COMMENT '61850设备重载电池组数据',
			`AppServer_Reinit_BattGroupData_61851_EN` tinyint(1) NOT NULL DEFAULT '0' COMMENT '61851设备重载电池组数据',
			`AppServer_Reinit_BattGroupData_61852_EN` tinyint(1) NOT NULL DEFAULT '0' COMMENT '61852设备重载电池组数据',
			`AppServer_Reinit_BattGroupData_61853_EN` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'BTS2202_4802_LR',

			V2.07 edit at date 2024-10-28
			1.表'db_app_sys.tb_page_param'表中默认新增用户密码时效配置，默认插入值'-1'-永不失效

			@@ -738,6 +738,7 @@
			sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.App_Sys_Table
			+ " ADD COLUMN `AppServer_Reinit_BattGroupData_FBO4830_EN` tinyint(1) NOT NULL DEFAULT '0' COMMENT '重新FBO4830线程加载机房信息';");
			}
			res = null;
			//添加FBO60010CT重载数据
			res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
			+ " WHERE table_schema='db_app_sys'"
			@@ -747,6 +748,7 @@
			sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.App_Sys_Table
			+ " ADD COLUMN `AppServer_Reinit_BattGroupData_FBO60010CT_EN` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'FBO60010CT_ZX重载数据标识';");
			}
			res = null;
			//添加61850重载数据
			res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
			+ " WHERE table_schema='db_app_sys'"
			@@ -756,6 +758,33 @@
			sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.App_Sys_Table
			+ " ADD COLUMN `AppServer_Reinit_BattGroupData_61850_EN` tinyint(1) NOT NULL DEFAULT '0' COMMENT '61850设备重载电池组数据';");
			}
			//添加61851重载数据
			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_61851_EN'");
			if(false == res.next()) {
			sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.App_Sys_Table
			+ " ADD COLUMN `AppServer_Reinit_BattGroupData_61851_EN` tinyint(1) NOT NULL DEFAULT '0' COMMENT '61851设备重载电池组数据';");
			}
			//添加61852重载数据
			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_61852_EN'");
			if(false == res.next()) {
			sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.App_Sys_Table
			+ " ADD COLUMN `AppServer_Reinit_BattGroupData_61852_EN` tinyint(1) NOT NULL DEFAULT '0' COMMENT '61852设备重载电池组数据';");
			}
			//添加61853重载数据
			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_61853_EN'");
			if(false == res.next()) {
			sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.App_Sys_Table
			+ " ADD COLUMN `AppServer_Reinit_BattGroupData_61853_EN` tinyint(1) NOT NULL DEFAULT '0' COMMENT '61853设备重载电池组数据';");
			}

			} catch (SQLException e) {
			e.printStackTrace();

			@@ -4321,6 +4321,16 @@
			if(false == res.next()) {
			sql.sqlMysqlExecute(" INSERT INTO " + Sql_Mysql.ProcessSurvey_Table + "(ProcessId,ProcessName,ProcessTime,Process_starttime,ServerName,ServerFlag,ProcessVersion,note,OutTime) VALUES ('11030', 'BMS_FBS9800_DISPLAY', '1970-01-01 00:00:00', '1970-01-01 00:00:00', 'BMS_FBS9800_DISPLAY', '2', 'v1.100', 'FBS9800汇集模块通信线程', '300');");
			}
			//FBO-60010CT-11031
			res = sql.sqlMysqlQuery("SELECT ProcessName FROM "+ Sql_Mysql.ProcessSurvey_Table + " WHERE ProcessId = 11031");
			if(false == res.next()) {
			sql.sqlMysqlExecute(" INSERT INTO " + Sql_Mysql.ProcessSurvey_Table + "(ProcessId,ProcessName,ProcessTime,Process_starttime,ServerName,ServerFlag,ProcessVersion,note,OutTime) VALUES ('11031', 'BMS_FBO60010CT_ZX', '1970-01-01 00:00:00', '1970-01-01 00:00:00', 'BMS_FBO60010CT_ZX', '2', 'v1.100', 'FBO60010CT_ZX通信线程', '300');");
			}
			//BTS2202-4820-LR-11032
			res = sql.sqlMysqlQuery("SELECT ProcessName FROM "+ Sql_Mysql.ProcessSurvey_Table + " WHERE ProcessId = 11032");
			if(false == res.next()) {
			sql.sqlMysqlExecute(" INSERT INTO " + Sql_Mysql.ProcessSurvey_Table + "(ProcessId,ProcessName,ProcessTime,Process_starttime,ServerName,ServerFlag,ProcessVersion,note,OutTime) VALUES ('11032', 'BMS_BTS61853_MONITOR', '1970-01-01 00:00:00', '1970-01-01 00:00:00', 'BMS_BTS61853_MONITOR', '2', 'v1.100', 'BTS2202_4802_LR通信线程', '300');");
			}
			} catch (SQLException e) {
			e.printStackTrace();
			} finally {