V1.89 edit at date 2021-11-03 1:新增'db_ram_db'.'tb_fbs9100_battparam'新增字段 ...

Administrator

2021-11-03 759095409ec1fb036f6c8080c1fc9feacac185e9

V1.89 edit at date 2021-11-03
	1:新增'db_ram_db'.'tb_fbs9100_battparam'新增字段
		  `BattGroupCountSum` int(11) NOT NULL DEFAULT '0' COMMENT
'电池组总数(铅酸+锂电，只读)',
		  `LiBattGroupCount` int(11) NOT NULL DEFAULT '0' COMMENT '锂电组数',
		  `LiEachGroupBattCount` int(11) NOT NULL DEFAULT '0' COMMENT '锂电节数',

 BattMonitor_DB_Builder/src/com/database_util/DB_Ram_db.java

@@ -1609,15 +1609,50 @@
                "  FloatChargeCurr float NOT NULL DEFAULT '0'," + 
                "  OnlineVolLow float NOT NULL DEFAULT '0'," + 
                "  GroupConnType int(11) NOT NULL DEFAULT '0'," + 
                "  BattGroupCountSum int(11) NOT NULL DEFAULT '0'," + 
                "  LiBattGroupCount int(11) NOT NULL DEFAULT '0'," + 
                "  LiEachGroupBattCount int(11) NOT NULL DEFAULT '0'," + 
                "  PRIMARY KEY (num)," + 
                "  UNIQUE KEY index_dev_id_uniq (dev_id)" + 
                ") ENGINE=MEMORY 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);        
			
			
            //添加字段BattGroupCountSum
            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
                    + " WHERE table_schema='db_ram_db'"
                    + " AND table_name='tb_fbs9100_battparam'"
                    + " AND column_name='BattGroupCountSum'");
            if(false == res.next()) {
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100BattParam_Table 
                        + " ADD COLUMN `BattGroupCountSum` int(11) NOT NULL DEFAULT '0' COMMENT '电池组总数(铅酸+锂电，只读)';");
            }
			
            //添加字段LiBattGroupCount
            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
                    + " WHERE table_schema='db_ram_db'"
                    + " AND table_name='tb_fbs9100_battparam'"
                    + " AND column_name='LiBattGroupCount'");
            if(false == res.next()) {
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100BattParam_Table 
                        + " ADD COLUMN `LiBattGroupCount` int(11) NOT NULL DEFAULT '0' COMMENT '锂电组数';");
            }
			
            //添加字段LiEachGroupBattCount
            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
                    + " WHERE table_schema='db_ram_db'"
                    + " AND table_name='tb_fbs9100_battparam'"
                    + " AND column_name='LiEachGroupBattCount'");
            if(false == res.next()) {
                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.FBS9100BattParam_Table 
                        + " ADD COLUMN `LiEachGroupBattCount` int(11) NOT NULL DEFAULT '0' COMMENT '锂电节数';");
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
@@ -1687,7 +1722,7 @@
            sql.sqlMysqlExecute(sql_str02);


            //添加字段mon_JH_curr
            //添加字段op_cmd
            res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
                    + " WHERE table_schema='db_ram_db'"
                    + " AND table_name='tb_bts_gprs_state'"
@@ -1699,6 +1734,13 @@
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            if(null != res) {
                try {
                    res.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
            sql.close_con();
        }
    }

 BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt

@@ -308,4 +308,10 @@
    
V1.88 edit at date 2021-10-29
    1：新增`db_user`.`tb_user_log` 表下字段 operation_detail
    
V1.89 edit at date 2021-11-03
    1:新增'db_ram_db'.'tb_fbs9100_battparam'新增字段
          `BattGroupCountSum` int(11) NOT NULL DEFAULT '0' COMMENT '电池组总数(铅酸+锂电，只读)',
          `LiBattGroupCount` int(11) NOT NULL DEFAULT '0' COMMENT '锂电组数',
          `LiEachGroupBattCount` int(11) NOT NULL DEFAULT '0' COMMENT '锂电节数',
    

 BattMonitor_DB_Builder/src/main/main_BTS_DB_Builder.java

@@ -28,7 +28,7 @@
    /**************************************************************************/
    /**************************************************************************/
    public final static boolean app_debug = false;
    public final static float m_VersionNum = (float) 1.88;
    public final static float m_VersionNum = (float) 1.89;
    public final static String m_Version = "Welcome To Use BTS DB BUILDER V" + m_VersionNum + " RC_20180908";
    /**************************************************************************/
    /**************************************************************************/