蓄电池监控管理平台数据库初始化程序
Administrator
2022-08-23 2d672ca4a0332b682e6d6af7171c406bec03adef
V1.40 edit at date 2022-08-23
1.表'db_ram_db.tb_fbs9100_sysparam'表新增字段并联电源系统参数
`floatChargeVolt` float NOT NULL DEFAULT '0' COMMENT '浮充电压[并联电源]',
`disChargeVolt` float NOT NULL DEFAULT '0' COMMENT '后备放电电压[并联电源]',
`dischargeVoltLimit` float NOT NULL DEFAULT '0' COMMENT
'放电电压下限[并联电源]',
`monomerLowVolt` float NOT NULL DEFAULT '0' COMMENT '单体下限[并联电源]',
`monomerLowCount` int(11) NOT NULL DEFAULT '0' COMMENT
'单体下限个数[并联电源]',
`autoEQChargeStartimeTime` int(11) NOT NULL DEFAULT '0' COMMENT
'自动启动均充周期(天)[并联电源]',
`autoEQChargetTime` int(11) NOT NULL DEFAULT '0' COMMENT
'均充时长[并联电源]',
5个文件已修改
99 ■■■■■ 已修改文件
BattMonitor_DB_Builder/bin/com/version_inf/version_inf.txt 10 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
BattMonitor_DB_Builder/src/com/database_util/DB_Dev_TestParam.java 1 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
BattMonitor_DB_Builder/src/com/database_util/DB_Ram_db.java 76 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt 10 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
BattMonitor_DB_Builder/src/main/main_BTS_DB_Builder.java 2 ●●● 补丁 | 查看 | 原始文档 | blame | 历史
BattMonitor_DB_Builder/bin/com/version_inf/version_inf.txt
@@ -654,4 +654,12 @@
          `a059_switchVolMin` float NOT NULL DEFAULT '0' COMMENT '回切组端电压范围低',
            `a059_switchVolMax` float NOT NULL DEFAULT '0' COMMENT '回切组端电压范围高',        
        
V1.40 edit at date 2022-08-23
    1.表'db_ram_db.tb_fbs9100_sysparam'表新增字段并联电源系统参数
          `floatChargeVolt` float NOT NULL DEFAULT '0' COMMENT '浮充电压[并联电源]',
          `disChargeVolt` float NOT NULL DEFAULT '0' COMMENT '后备放电电压[并联电源]',
          `dischargeVoltLimit` float NOT NULL DEFAULT '0' COMMENT '放电电压下限[并联电源]',
          `monomerLowVolt` float NOT NULL DEFAULT '0' COMMENT '单体下限[并联电源]',
          `monomerLowCount` int(11) NOT NULL DEFAULT '0' COMMENT '单体下限个数[并联电源]',
          `autoEQChargeStartimeTime` int(11) NOT NULL DEFAULT '0' COMMENT '自动启动均充周期(天)[并联电源]',
          `autoEQChargetTime` int(11) NOT NULL DEFAULT '0' COMMENT '均充时长[并联电源]',
BattMonitor_DB_Builder/src/com/database_util/DB_Dev_TestParam.java
@@ -51,6 +51,7 @@
            res = sql.sqlMysqlQuery(sql_str_sel);
            while(res.next()) {
                int battgroupid = res.getInt("BattGroupId");
                sql.sqlMysqlUseDB(Sql_Mysql.DB_DEV_TESTPARAM);
                if(!sql.sqlMysqlCheckIfTableExist(Sql_Mysql.Batt_TestParam_Table + battgroupid)) {
                    sql.sqlMysqlExecute(" CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Batt_TestParam_Table + battgroupid + " (" + 
                            "  `num` bigint(20) NOT NULL AUTO_INCREMENT," + 
BattMonitor_DB_Builder/src/com/database_util/DB_Ram_db.java
@@ -1801,6 +1801,82 @@
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SysParam_Table 
                        + " ADD COLUMN `StandyVolt` float NOT NULL DEFAULT '0' COMMENT '后备电压(V)';");
            }
            /*
             *
             *  2022-08-23 并联电源新增参数设置
             * ***********************************************************/
            //添加字段floatChargeVolt     浮充电压[并联电源]
            res = null;
            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
                    + " WHERE table_schema='db_ram_db'"
                    + " AND table_name='tb_fbs9100_sysparam'"
                    + " AND column_name='floatChargeVolt'");
            if(false == res.next()) {
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SysParam_Table
                        + " ADD COLUMN `floatChargeVolt` float NOT NULL DEFAULT '0' COMMENT '浮充电压[并联电源]';");
            }
            //添加字段disChargeVolt     后备放电电压[并联电源]
            res = null;
            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
                    + " WHERE table_schema='db_ram_db'"
                    + " AND table_name='tb_fbs9100_sysparam'"
                    + " AND column_name='disChargeVolt'");
            if(false == res.next()) {
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SysParam_Table
                        + " ADD COLUMN `disChargeVolt` float NOT NULL DEFAULT '0' COMMENT '后备放电电压[并联电源]';");
            }
            //添加字段dischargeVoltLimit     放电电压下限[并联电源]
            res = null;
            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
                    + " WHERE table_schema='db_ram_db'"
                    + " AND table_name='tb_fbs9100_sysparam'"
                    + " AND column_name='dischargeVoltLimit'");
            if(false == res.next()) {
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SysParam_Table
                        + " ADD COLUMN `dischargeVoltLimit` float NOT NULL DEFAULT '0' COMMENT '放电电压下限[并联电源]';");
            }
            //添加字段monomerLowVolt     单体下限[并联电源]
            res = null;
            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
                    + " WHERE table_schema='db_ram_db'"
                    + " AND table_name='tb_fbs9100_sysparam'"
                    + " AND column_name='monomerLowVolt'");
            if(false == res.next()) {
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SysParam_Table
                        + " ADD COLUMN `monomerLowVolt` float NOT NULL DEFAULT '0' COMMENT '单体下限[并联电源]';");
            }
            //添加字段monomerLowCount     单体下限个数[并联电源]
            res = null;
            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
                    + " WHERE table_schema='db_ram_db'"
                    + " AND table_name='tb_fbs9100_sysparam'"
                    + " AND column_name='monomerLowCount'");
            if(false == res.next()) {
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SysParam_Table
                        + " ADD COLUMN `monomerLowCount` int(11) NOT NULL DEFAULT '0' COMMENT '单体下限个数[并联电源]';");
            }
            //添加字段autoEQChargeStartimeTime     自动启动均充周期(天)[并联电源]
            res = null;
            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
                    + " WHERE table_schema='db_ram_db'"
                    + " AND table_name='tb_fbs9100_sysparam'"
                    + " AND column_name='autoEQChargeStartimeTime'");
            if(false == res.next()) {
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SysParam_Table
                        + " ADD COLUMN `autoEQChargeStartimeTime` int(11) NOT NULL DEFAULT '0' COMMENT '自动启动均充周期(天)[并联电源]';");
            }
            //添加字段autoEQChargetTime     均充时长[并联电源]
            res = null;
            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
                    + " WHERE table_schema='db_ram_db'"
                    + " AND table_name='tb_fbs9100_sysparam'"
                    + " AND column_name='autoEQChargetTime'");
            if(false == res.next()) {
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SysParam_Table
                        + " ADD COLUMN `autoEQChargetTime` int(11) NOT NULL DEFAULT '0' COMMENT '均充时长[并联电源]';");
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt
@@ -654,4 +654,12 @@
          `a059_switchVolMin` float NOT NULL DEFAULT '0' COMMENT '回切组端电压范围低',
            `a059_switchVolMax` float NOT NULL DEFAULT '0' COMMENT '回切组端电压范围高',        
        
V1.40 edit at date 2022-08-23
    1.表'db_ram_db.tb_fbs9100_sysparam'表新增字段并联电源系统参数
          `floatChargeVolt` float NOT NULL DEFAULT '0' COMMENT '浮充电压[并联电源]',
          `disChargeVolt` float NOT NULL DEFAULT '0' COMMENT '后备放电电压[并联电源]',
          `dischargeVoltLimit` float NOT NULL DEFAULT '0' COMMENT '放电电压下限[并联电源]',
          `monomerLowVolt` float NOT NULL DEFAULT '0' COMMENT '单体下限[并联电源]',
          `monomerLowCount` int(11) NOT NULL DEFAULT '0' COMMENT '单体下限个数[并联电源]',
          `autoEQChargeStartimeTime` int(11) NOT NULL DEFAULT '0' COMMENT '自动启动均充周期(天)[并联电源]',
          `autoEQChargetTime` int(11) NOT NULL DEFAULT '0' COMMENT '均充时长[并联电源]',
BattMonitor_DB_Builder/src/main/main_BTS_DB_Builder.java
@@ -30,7 +30,7 @@
    /**************************************************************************/
    /**************************************************************************/
    public final static boolean app_debug = false;
    public final static float m_VersionNum = (float) 1.39;
    public final static float m_VersionNum = (float) 1.40;
    public final static String m_Version = "Welcome To Use BTS DB BUILDER V" + m_VersionNum + " RC_20180908";
    /**************************************************************************/
    /**************************************************************************/