alm_delay_time -修改为允许为空 alm_high_level_upper -修改为允许为空 alm_low_level_l...

DELL

2024-01-31 f21e98a421cb34f20aa9a419436d07f8c9960134

alm_delay_time       -修改为允许为空
alm_high_level_upper -修改为允许为空
alm_low_level_lower  -修改为允许为空

 BattMonitor_DB_Builder/bin/com/database_util/DB_Param.class

Binary files differ

 BattMonitor_DB_Builder/src/com/database_util/DB_Param.java

@@ -130,7 +130,10 @@
            if(false == res.next()) {

                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Dev_Param_Table 

                        + " ADD COLUMN `alm_delay_time` int(11) NOT NULL DEFAULT '60' COMMENT '告警延迟时长[单位：秒]';");

            }

            }else {

                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Dev_Param_Table 
                        + " CHANGE COLUMN `alm_delay_time` `alm_delay_time`  int(11) NULL DEFAULT '60' COMMENT '告警延迟时长[单位：秒]';");

            } 
            res = null;

            //添加alm_high_level_upper

            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"

@@ -140,6 +143,9 @@
            if(false == res.next()) {

                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Dev_Param_Table 

                        + " ADD COLUMN `alm_high_level_upper` int(11) NOT NULL DEFAULT '1' COMMENT '上上限告警等级';");

            }else {

                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Dev_Param_Table 
                        + " CHANGE COLUMN `alm_high_level_upper` `alm_high_level_upper` int(11) NULL DEFAULT '1' COMMENT '上上限告警等级';");

            }

            res = null;

            //添加alm_low_level_lower

@@ -150,6 +156,9 @@
            if(false == res.next()) {

                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Dev_Param_Table 

                        + " ADD COLUMN `alm_low_level_lower` int(11) NOT NULL DEFAULT '1' COMMENT '下下限告警等级';");

            }else {

                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.Dev_Param_Table 
                        + " CHANGE COLUMN `alm_low_level_lower` `alm_low_level_lower` int(11) NULL DEFAULT '1' COMMENT '下下限告警等级';");

            }

        } catch (SQLException e) {

            e.printStackTrace();