V1.63 edit at date 2021-07-27 1.表'db_ram_db.tb_fbs9100_setparam'新增恒流参数字段

Administrator

2021-07-27 4d32a9903a11f33cf0e14da25f1e7286b50258f6

V1.63 edit at date 2021-07-27
	1.表'db_ram_db.tb_fbs9100_setparam'新增恒流参数字段

 BattMonitor_DB_Builder/bin/com/version_inf/version_inf.txt

@@ -186,3 +186,10 @@
V1.61 edit at date 2021-07-12

    1.线程监控表新增线程记录"ProcessId:11017",'BMS_BATT_LOADUPDATE','蓄电池负载更新线程'---默认启动

    
V1.62 edit at date 2021-07-20

    1.表'db_ram_db.tb_fbs9100_setparam'新增FGCD_A059设备相关的参数列字段

    2.修复'db_ram_db.tb_bts_gprs_state'表中初始化字段错误bug

	
V1.63 edit at date 2021-07-27

    1.表'db_ram_db.tb_fbs9100_setparam'新增恒流参数字段

	

 BattMonitor_DB_Builder/config.xml

@@ -2,7 +2,7 @@

<root>
  <mysql_ramdb_recreate_en>false</mysql_ramdb_recreate_en>
  <mysql_server_ip>127.0.0.1</mysql_server_ip>
  <mysql_server_ip>192.168.10.79</mysql_server_ip>
  <!--SOURCE_BATTDATA_TYPE_FBSDEV = 0-->
  <!--SOURCE_BATTDATA_TYPE_SQLSERVER = 1-->
  <!--SOURCE_BATTDATA_TYPE_C_INTERFACE = 2-->

 BattMonitor_DB_Builder/src/com/database_util/DB_Ram_db.java

@@ -605,14 +605,73 @@
                "  PRIMARY KEY (num)" + 

                ") ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;";

        Sql_Mysql sql = new Sql_Mysql(pool.getConn());

        ResultSet res = null;

        try {

            if(true == recreate) {            

                sql.sqlMysqlExecute(sql_str01);

            }

            sql.sqlMysqlExecute(sql_str02);        

			
            //添加字段app_conn_max

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

                    + " WHERE table_schema='db_ram_db'"

                    + " AND table_name='tb_server_state'"

                    + " AND column_name='app_conn_max'");

            if(false == res.next()) {

                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.ServerState_Table 
                        + " ADD COLUMN app_conn_max int(11) NOT NULL DEFAULT '0';");

            }

			
            //添加字段app_busy_conn_cnt

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

                    + " WHERE table_schema='db_ram_db'"

                    + " AND table_name='tb_server_state'"

                    + " AND column_name='app_busy_conn_cnt'");

            if(false == res.next()) {

                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.ServerState_Table 
                        + " ADD COLUMN app_busy_conn_cnt int(11) NOT NULL DEFAULT '0';");

            }

			
            //添加字段app_idle_conn_cnt

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

                    + " WHERE table_schema='db_ram_db'"

                    + " AND table_name='tb_server_state'"

                    + " AND column_name='app_idle_conn_cnt'");

            if(false == res.next()) {

                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.ServerState_Table 
                        + " ADD COLUMN app_idle_conn_cnt int(11) NOT NULL DEFAULT '0';");

            }

			
            //添加字段server_cpu_rate

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

                    + " WHERE table_schema='db_ram_db'"

                    + " AND table_name='tb_server_state'"

                    + " AND column_name='server_cpu_rate'");

            if(false == res.next()) {

                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.ServerState_Table 
                        + " ADD COLUMN server_cpu_rate float NOT NULL DEFAULT '0';");

            }

			
            //添加字段     server_network_rate

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

                    + " WHERE table_schema='db_ram_db'"

                    + " AND table_name='tb_server_state'"

                    + " AND column_name='server_network_rate'");

            if(false == res.next()) {

                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.ServerState_Table 
                        + " ADD COLUMN server_network_rate float NOT NULL DEFAULT '0';");

            }

			
        } catch (SQLException e) {

            e.printStackTrace();

        } finally {

            if(null != res) {

                try {

                    res.close();

                } catch (SQLException e) {

                    e.printStackTrace();

                }

            }

            sql.close_con();

        }

    }

@@ -1246,22 +1305,15 @@
    public static void createBTSGPRSState_Table(MysqlConnPool pool, boolean recreate) {

        String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.BTSGPRSState_Table;

        String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.BTSGPRSState_Table + " (" + 

                "  num bigint(20) NOT NULL AUTO_INCREMENT," + 
                "  station_id bigint(20) NOT NULL DEFAULT '0'," + 
                "  dev_id bigint(20) NOT NULL DEFAULT '0'," + 
                "  record_datetime varchar(20) NOT NULL DEFAULT '2015-12-02 12:10:00'," + 
                "  station_stat int(11) NOT NULL DEFAULT '0'," + 
                "  station_poff_start_time varchar(20) NOT NULL DEFAULT '2015-12-02 12:10:00'," + 
                "  station_fadian_start_time varchar(20) NOT NULL DEFAULT '2015-12-02 12:10:00'," + 
                "  station_diaozhan_start_time varchar(20) NOT NULL DEFAULT '2015-12-02 12:10:00'," + 
                "  station_temp float NOT NULL DEFAULT '0'," + 
                "  station_damp float NOT NULL DEFAULT '0'," + 
                "  station_dooropen_start_time varchar(20) NOT NULL DEFAULT '2015-12-02 12:10:00'," + 
                "  station_xuhang_start_time varchar(20) NOT NULL DEFAULT '2015-12-02 12:10:00'," + 
                "  station_xuhang_end_time varchar(20) NOT NULL DEFAULT '2015-12-02 12:10:00'," + 
                "  PRIMARY KEY (num)," + 
                "  UNIQUE KEY index_station_id_uniq (station_id)" + 
                ") ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;";

                "  `num` bigint(20) NOT NULL AUTO_INCREMENT," + 
                "  `dev_id` bigint(20) NOT NULL DEFAULT '0'," + 
                "  `op_cmd` int(11) NOT NULL DEFAULT '0'," + 
                "  `AT_cmd` varchar(20) NOT NULL DEFAULT ''," + 
                "  `ack_inf` varchar(50) NOT NULL DEFAULT ''," + 
                "  `bts_task_inf` varchar(1024) NOT NULL DEFAULT ''," + 
                "  PRIMARY KEY (`num`)," + 
                "  UNIQUE KEY `index_dev_id_uniq` (`dev_id`)" + 
                ") ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;";

        Sql_Mysql sql = new Sql_Mysql(pool.getConn());

        try {

            if(true == recreate) {            

@@ -1372,11 +1424,30 @@
                "  KEY index_BattGroupId (BattGroupId)" + 

                ") ENGINE=InnoDB AUTO_INCREMENT=347 DEFAULT CHARSET=utf8;";

        Sql_Mysql sql = new Sql_Mysql(pool.getConn());

        ResultSet res = null;

        try {

            if(true == recreate) {            

                sql.sqlMysqlExecute(sql_str01);

            }

            sql.sqlMysqlExecute(sql_str02);        

            //添加字段mon_JH_curr

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

                    + " WHERE table_schema='db_ram_db'"

                    + " AND table_name='tb_batt_rtdata'"

                    + " AND column_name='mon_JH_curr'");

            if(false == res.next()) {

                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattRtData_Table 
                        + " ADD COLUMN mon_JH_curr float NOT NULL DEFAULT '0';");

            }

            //添加字段mon_LY_vol

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

                    + " WHERE table_schema='db_ram_db'"

                    + " AND table_name='tb_batt_rtdata'"

                    + " AND column_name='mon_LY_vol'");

            if(false == res.next()) {

                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattRtData_Table 
                        + " ADD COLUMN mon_LY_vol float NOT NULL DEFAULT '0';");

            }

        } catch (SQLException e) {

            e.printStackTrace();

        } finally {


 BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java

@@ -60,6 +60,7 @@
        

        createLicense_Table(pool, recreate);                        //创建超级用户表以及添加vip用户

        

        createDatabase_Backup_Table(pool, recreate);                //创建数据库备份表

    }

    



@@ -1025,6 +1026,36 @@
    }

    

    /**

     *    创建数据库备份表  web_site.tb_database_backup

     */

    public static void createDatabase_Backup_Table(MysqlConnPool pool, boolean recreate) {

        String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Database_Backup_Table;

        String sql_str02 = "CREATE TABLE IF NOT EXISTS "+Sql_Mysql.Database_Backup_Table+" (" + 
                "  `num` int(11) NOT NULL AUTO_INCREMENT," + 
                "  `database_name` varchar(64) NOT NULL," + 
                "  `table_name` varchar(64) NOT NULL," + 
                "  `backup_en` int(11) NOT NULL DEFAULT '0'," + 
                "  `backup_flag` int(11) NOT NULL DEFAULT '0'," + 
                "  `note` varchar(64) NOT NULL DEFAULT '保留'," + 
                "  PRIMARY KEY (`num`)" + 
                ") ENGINE=InnoDB AUTO_INCREMENT=128 DEFAULT CHARSET=utf8;" + 
                ""; 
        Sql_Mysql sql = new Sql_Mysql(pool.getConn());

        try {

            if(true == recreate) {			
                //sql.sqlMysqlExecute(sql_str01);

                //sql.sqlMysqlExecute(sql_str02);

            }

            sql.sqlMysqlExecute(sql_str02);                                    //创建基站故障表		
			
        } catch (SQLException e) {

            e.printStackTrace();

        } finally {

            sql.close_con();

        }

    }

	
    /**

     *    创建电池组更换记录表

     */

    public static void createBattReplace_Table(MysqlConnPool pool, boolean recreate) {

@@ -1244,6 +1275,8 @@
        

    }

    

	
	
    public static void main(String[] args) {

        MysqlConnPool pool = new MysqlConnPool("123.207.82.239", 3360, 10);

        DB_web_site website = new DB_web_site();


 BattMonitor_DB_Builder/src/com/dev/fbs9100/FBS9100_Task_Thread_SQL.java

@@ -317,6 +317,26 @@
                    + "`ChargeCurrSet` FLOAT NOT NULL DEFAULT 0, "

                    + "`MonomerTmp_High` FLOAT NOT NULL DEFAULT 0, "

                    + "`AutoTestStartVol`  float NOT NULL DEFAULT 0, "            //起始电压

                    + "`MonCount` int(11) NOT NULL DEFAULT '0' COMMENT '每组单体数'," 
                    + "`MonVol` float(11,0) NOT NULL DEFAULT '0' COMMENT '单体电压'," 
                    + "`DisPower` float(11,0) NOT NULL DEFAULT '0' COMMENT '预放功率（0.1kw）'," 
                    + "`DisPreRes` float(11,0) NOT NULL DEFAULT '0' COMMENT '放电阻值(mΩ)   '," 
                    + "`CharCap` int(11) NOT NULL DEFAULT '0' COMMENT '充电容量(AH)'," 
                    + "`CharTimeLong` int(11) NOT NULL DEFAULT '0' COMMENT '充电时长(min)'," 
                    + "`FloatCharTimeLong` int(11) NOT NULL DEFAULT '0' COMMENT '浮充时长'," 
                    + "`CharSotpCurr` float(11,0) NOT NULL DEFAULT '0' COMMENT '截止电流(0.1A)    ',"  
                    + "`MonVolHightLimit` float(11,0) NOT NULL DEFAULT '0' COMMENT '单体上限(0.01V)',"  
                    + "`MonVolHightLimitCount` int(11) NOT NULL DEFAULT '0' COMMENT '单体上限数量',"  
                    + "`CharHighTmp` int(11) NOT NULL DEFAULT '0' COMMENT '充电过温'," 
                    + "`DisWaitTime` int(11) NOT NULL DEFAULT '0' COMMENT '放完静置(0-500分钟)',"  
                    + "`CharWaitTime` int(11) NOT NULL DEFAULT '0' COMMENT '充完静置(0-500分钟)',"

                    + "`FlowOver_Count` int(11) NOT NULL DEFAULT '1' COMMENT '恒流总阶段数[1-3]',"  
                    + "`FlowOver_CharCurr_1` float(11,0) NOT NULL DEFAULT '0' COMMENT '恒流1阶段充电电流',"  
                    + "`FlowOver_CharCurr_2` float(11,0) NOT NULL DEFAULT '0' COMMENT '恒流2阶段充电电流',"  
                    + "`FlowOver_CharCurr_3` float(11,0) NOT NULL DEFAULT '0' COMMENT '恒流3阶段充电电流',"  
                    + "`FlowOver_CharTime_1` int(11) NOT NULL DEFAULT '0' COMMENT '恒流1阶段充电时长'," 
                    + "`FlowOver_CharTime_2` int(11) NOT NULL DEFAULT '0' COMMENT '恒流2阶段充电时长',"  
                    + "`FlowOver_CharTime_3` int(11) NOT NULL DEFAULT '0' COMMENT '恒流3阶段充电时长',"			
                    + " UNIQUE INDEX index_dev_id_uniq (`dev_id`), "

                    + " PRIMARY KEY (`num`) ) "

                    + " ENGINE=MEMORY DEFAULT CHARSET=utf8";

@@ -430,6 +450,208 @@
                                + " ADD COLUMN `OffLineYHOnceCycle` int(11) NOT NULL DEFAULT '1';");

            }

            

            /*     2021-07-19 edit by lijun 
             *  FGCD_A059设备新增参数

             */

            //添加指定的MonCount列(每组单体数)

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

                    + " WHERE table_schema='db_ram_db'"

                    + " AND table_name='tb_fbs9100_setparam'"

                    + " AND column_name='MonCount'");

            if(false == res.next()) {

                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SetParam_Table 
                                + " ADD COLUMN `MonCount` int(11) NOT NULL DEFAULT '0' COMMENT '每组单体数';");

            }

			
            //添加指定的MonVol列(单体电压)

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

                    + " WHERE table_schema='db_ram_db'"

                    + " AND table_name='tb_fbs9100_setparam'"

                    + " AND column_name='MonVol'");

            if(false == res.next()) {

                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SetParam_Table 
                                + " ADD COLUMN `MonVol` float(11,0) NOT NULL DEFAULT '0' COMMENT '单体电压';");

            }

			
            //添加指定的DisPower列(预放功率（0.1kw）)

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

                    + " WHERE table_schema='db_ram_db'"

                    + " AND table_name='tb_fbs9100_setparam'"

                    + " AND column_name='DisPower'");

            if(false == res.next()) {

                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SetParam_Table 
                                + " ADD COLUMN `DisPower` float(11,0) NOT NULL DEFAULT '0' COMMENT '预放功率（0.1kw）';");

            }

			
            //添加指定的DisPreRes列(放电阻值(mΩ))

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

                    + " WHERE table_schema='db_ram_db'"

                    + " AND table_name='tb_fbs9100_setparam'"

                    + " AND column_name='DisPreRes'");

            if(false == res.next()) {

                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SetParam_Table 
                                + " ADD COLUMN `DisPreRes` float(11,0) NOT NULL DEFAULT '0' COMMENT '放电阻值(mΩ)';");

            }

			
            //添加指定的CharCap列(充电容量(AH))

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

                    + " WHERE table_schema='db_ram_db'"

                    + " AND table_name='tb_fbs9100_setparam'"

                    + " AND column_name='CharCap'");

            if(false == res.next()) {

                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SetParam_Table 
                                + " ADD COLUMN `CharCap` int(11) NOT NULL DEFAULT '0' COMMENT '充电容量(AH)';");

            }

			
            //添加指定的CharTimeLong列(充电时长(min))

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

                    + " WHERE table_schema='db_ram_db'"

                    + " AND table_name='tb_fbs9100_setparam'"

                    + " AND column_name='CharTimeLong'");

            if(false == res.next()) {

                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SetParam_Table 
                                + " ADD COLUMN `CharTimeLong` int(11) NOT NULL DEFAULT '0' COMMENT '充电时长(min)';");

            }

			
            //添加指定的FloatCharTimeLong列(浮充时长)

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

                    + " WHERE table_schema='db_ram_db'"

                    + " AND table_name='tb_fbs9100_setparam'"

                    + " AND column_name='FloatCharTimeLong'");

            if(false == res.next()) {

                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SetParam_Table 
                                + " ADD COLUMN `FloatCharTimeLong` int(11) NOT NULL DEFAULT '0' COMMENT '浮充时长';");

            }

			
            //添加指定的CharSotpCurr列(截止电流(0.1A))

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

                    + " WHERE table_schema='db_ram_db'"

                    + " AND table_name='tb_fbs9100_setparam'"

                    + " AND column_name='CharSotpCurr'");

            if(false == res.next()) {

                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SetParam_Table 
                                + " ADD COLUMN `CharSotpCurr` float(11,0) NOT NULL DEFAULT '0' COMMENT '截止电流(0.1A)';");

            }

			
            //添加指定的MonVolHightLimit列(单体上限(0.01V))

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

                    + " WHERE table_schema='db_ram_db'"

                    + " AND table_name='tb_fbs9100_setparam'"

                    + " AND column_name='MonVolHightLimit'");

            if(false == res.next()) {

                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SetParam_Table 
                                + " ADD COLUMN `MonVolHightLimit` float(11,0) NOT NULL DEFAULT '0' COMMENT '单体上限(0.01V)';");

            }

			
            //添加指定的MonVolHightLimitCount列(单体上限数量)

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

                    + " WHERE table_schema='db_ram_db'"

                    + " AND table_name='tb_fbs9100_setparam'"

                    + " AND column_name='MonVolHightLimitCount'");

            if(false == res.next()) {

                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SetParam_Table 
                                + " ADD COLUMN `MonVolHightLimitCount` int(11) NOT NULL DEFAULT '0' COMMENT '单体上限数量';");

            }

			
            //添加指定的CharHighTmp列(充电过温)

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

                    + " WHERE table_schema='db_ram_db'"

                    + " AND table_name='tb_fbs9100_setparam'"

                    + " AND column_name='CharHighTmp'");

            if(false == res.next()) {

                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SetParam_Table 
                                + " ADD COLUMN `CharHighTmp` int(11) NOT NULL DEFAULT '0' COMMENT '充电过温';");

            }

			
            //添加指定的DisWaitTime列(放完静置(0-500分钟))

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

                    + " WHERE table_schema='db_ram_db'"

                    + " AND table_name='tb_fbs9100_setparam'"

                    + " AND column_name='DisWaitTime'");

            if(false == res.next()) {

                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SetParam_Table 
                                + " ADD COLUMN `DisWaitTime` int(11) NOT NULL DEFAULT '0' COMMENT '放完静置(0-500分钟)';");

            }

			
            //添加指定的CharWaitTime列(充完静置(0-500分钟))

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

                    + " WHERE table_schema='db_ram_db'"

                    + " AND table_name='tb_fbs9100_setparam'"

                    + " AND column_name='CharWaitTime'");

            if(false == res.next()) {

                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SetParam_Table 
                                + " ADD COLUMN `CharWaitTime` int(11) NOT NULL DEFAULT '0' COMMENT '充完静置(0-500分钟)';");

            }

			
            //添加指定的FlowOver_Count列(恒流总阶段数[1-3])

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

                    + " WHERE table_schema='db_ram_db'"

                    + " AND table_name='tb_fbs9100_setparam'"

                    + " AND column_name='FlowOver_Count'");

            if(false == res.next()) {

                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SetParam_Table 
                                + " ADD COLUMN `FlowOver_Count` int(11) NOT NULL DEFAULT '1' COMMENT '恒流总阶段数[1-3]';");

            }

			
            //添加指定的FlowOver_CharCurr_1列(恒流1阶段充电电流)

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

                    + " WHERE table_schema='db_ram_db'"

                    + " AND table_name='tb_fbs9100_setparam'"

                    + " AND column_name='FlowOver_CharCurr_1'");

            if(false == res.next()) {

                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SetParam_Table 
                                + " ADD COLUMN `FlowOver_CharCurr_1` float(11,0) NOT NULL DEFAULT '0' COMMENT '恒流1阶段充电电流';");

            }

			
            //添加指定的FlowOver_CharCurr_2列(恒流2阶段充电电流)

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

                    + " WHERE table_schema='db_ram_db'"

                    + " AND table_name='tb_fbs9100_setparam'"

                    + " AND column_name='FlowOver_CharCurr_2'");

            if(false == res.next()) {

                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SetParam_Table 
                                + " ADD COLUMN `FlowOver_CharCurr_2` float(11,0) NOT NULL DEFAULT '0' COMMENT '恒流2阶段充电电流';");

            }

			
            //添加指定的FlowOver_CharCurr_3列(恒流3阶段充电电流)

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

                    + " WHERE table_schema='db_ram_db'"

                    + " AND table_name='tb_fbs9100_setparam'"

                    + " AND column_name='FlowOver_CharCurr_3'");

            if(false == res.next()) {

                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SetParam_Table 
                                + " ADD COLUMN `FlowOver_CharCurr_3` float(11,0) NOT NULL DEFAULT '0' COMMENT '恒流3阶段充电电流';");

            }

			
            //添加指定的FlowOver_CharTime_1列(恒流1阶段充电时长)

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

                    + " WHERE table_schema='db_ram_db'"

                    + " AND table_name='tb_fbs9100_setparam'"

                    + " AND column_name='FlowOver_CharTime_1'");

            if(false == res.next()) {

                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SetParam_Table 
                                + " ADD COLUMN `FlowOver_CharTime_1` int(11) NOT NULL DEFAULT '0' COMMENT '恒流1阶段充电时长';");

            }

			
            //添加指定的FlowOver_CharTime_2列(恒流2阶段充电时长)

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

                    + " WHERE table_schema='db_ram_db'"

                    + " AND table_name='tb_fbs9100_setparam'"

                    + " AND column_name='FlowOver_CharTime_2'");

            if(false == res.next()) {

                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SetParam_Table 
                                + " ADD COLUMN `FlowOver_CharTime_2` int(11) NOT NULL DEFAULT '0' COMMENT '恒流2阶段充电时长';");

            }

			
            //添加指定的FlowOver_CharTime_3列(恒流3阶段充电时长)

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

                    + " WHERE table_schema='db_ram_db'"

                    + " AND table_name='tb_fbs9100_setparam'"

                    + " AND column_name='FlowOver_CharTime_3'");

            if(false == res.next()) {

                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100SetParam_Table 
                                + " ADD COLUMN `FlowOver_CharTime_3` int(11) NOT NULL DEFAULT '0' COMMENT '恒流3阶段充电时长';");

            }

        } catch (SQLException e) {

            e.printStackTrace();

        } finally {


 BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java

@@ -203,6 +203,7 @@
    public final static String Dev_Restart_Plan_Table = WEB_Site +".`tb_dev_restart_plan`";                //设备定期重启计划表

    public final static String Vip_User_Table = WEB_Site +".`tb_vip_user`";                                //超级用户表

    public final static String License_Table = WEB_Site +".`tb_license`";                                //超级用户表

    public final static String Database_Backup_Table = WEB_Site +".`tb_database_backup`";                                //超级用户表

    

    

    /***************************** db_battinf数据库  ***************************************/


 BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt

@@ -186,3 +186,10 @@
V1.61 edit at date 2021-07-12

    1.线程监控表新增线程记录"ProcessId:11017",'BMS_BATT_LOADUPDATE','蓄电池负载更新线程'---默认启动

    
V1.62 edit at date 2021-07-20

    1.表'db_ram_db.tb_fbs9100_setparam'新增FGCD_A059设备相关的参数列字段

    2.修复'db_ram_db.tb_bts_gprs_state'表中初始化字段错误bug

	
V1.63 edit at date 2021-07-27

    1.表'db_ram_db.tb_fbs9100_setparam'新增恒流参数字段

	

 BattMonitor_DB_Builder/src/main/main_BTS_DB_Builder.java

@@ -26,7 +26,7 @@
    /**************************************************************************/

    /**************************************************************************/

    public final static boolean app_debug = false;

    public final static float m_VersionNum = (float) 1.60;

    public final static float m_VersionNum = (float) 1.62;

    public final static String m_Version = "Welcome To Use BTS DB BUILDER V" + m_VersionNum + " RC_20180908";

    /**************************************************************************/

    /**************************************************************************/