~whyclj/BattMonitor_DB_Builder.git

parent: f7c4d768 | 补丁 | 提交 | ignore whitespace

3.新增表 'db_rab_db.tb_dev_6185_almparam' CREATE TABLE `tb_dev_6185_almparam`...

DELL

2024-07-03 6b1bcd3537d3b412296c4db4a4079137231fb3f4

3.新增表 'db_rab_db.tb_dev_6185_almparam'
	CREATE TABLE `tb_dev_6185_almparam` (
		  `num` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '自增主键',
		  `dev_id` int(11) NOT NULL DEFAULT '0' COMMENT '设备id',
		  `op_cmd` int(11) NOT NULL DEFAULT '0' COMMENT '操作命令',
		  `groupvol_high_val` float NOT NULL DEFAULT '0' COMMENT '组端电压高阈值',
		  `groupvol_low_val` float NOT NULL DEFAULT '0' COMMENT '组端电压低阈值',
		  `monvol_high_val` float NOT NULL DEFAULT '0' COMMENT '单体电压高阈值',
		  `monvol_low_val` float NOT NULL DEFAULT '0' COMMENT '单体电压低阈值',
		  `montmp_high_val` float NOT NULL DEFAULT '0' COMMENT '单体温度高阈值',
		  `montmp_low_val` float NOT NULL DEFAULT '0' COMMENT '单体温度低阈值',
		  `monres_high_val` float NOT NULL DEFAULT '0' COMMENT '单体内阻高阈值',
		  `monres_low_val` float NOT NULL DEFAULT '0' COMMENT '单体内阻低阈值',
		  `moncap_high_val` float NOT NULL DEFAULT '0' COMMENT '单体容量高阈值',
		  `moncap_low_val` float NOT NULL DEFAULT '0' COMMENT '单体容量低阈值',
		  PRIMARY KEY (`num`),
		  UNIQUE KEY `index_dev_id` (`dev_id`) USING BTREE
		) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='bts6185相关设备告警阈值遥调表';

5个文件已修改

	BattMonitor_DB_Builder/bin/com/database_util/DB_Ram_db.class	补丁 \| 查看 \| 原始文档 \| blame \| 历史
	BattMonitor_DB_Builder/bin/com/version_inf/version_inf.txt	18 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	BattMonitor_DB_Builder/src/com/database_util/DB_Ram_db.java	41 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java	4 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt	18 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史

 BattMonitor_DB_Builder/bin/com/database_util/DB_Ram_db.class

Binary files differ

 BattMonitor_DB_Builder/bin/com/version_inf/version_inf.txt

@@ -6,6 +6,24 @@
        11029 - 智能母联通信线程 = BMS_ZNBUSBAR_MONITOR
    2.新增FBS9800汇集模块通信对应线程记录
        11030 - FBS9800通信线程 = BMS_FBS9800_DISPLAY
    3.新增表 'db_rab_db.tb_dev_6185_almparam'
        CREATE TABLE `tb_dev_6185_almparam` (
          `num` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '自增主键',
          `dev_id` int(11) NOT NULL DEFAULT '0' COMMENT '设备id',
          `op_cmd` int(11) NOT NULL DEFAULT '0' COMMENT '操作命令',
          `groupvol_high_val` float NOT NULL DEFAULT '0' COMMENT '组端电压高阈值',
          `groupvol_low_val` float NOT NULL DEFAULT '0' COMMENT '组端电压低阈值',
          `monvol_high_val` float NOT NULL DEFAULT '0' COMMENT '单体电压高阈值',
          `monvol_low_val` float NOT NULL DEFAULT '0' COMMENT '单体电压低阈值',
          `montmp_high_val` float NOT NULL DEFAULT '0' COMMENT '单体温度高阈值',
          `montmp_low_val` float NOT NULL DEFAULT '0' COMMENT '单体温度低阈值',
          `monres_high_val` float NOT NULL DEFAULT '0' COMMENT '单体内阻高阈值',
          `monres_low_val` float NOT NULL DEFAULT '0' COMMENT '单体内阻低阈值',
          `moncap_high_val` float NOT NULL DEFAULT '0' COMMENT '单体容量高阈值',
          `moncap_low_val` float NOT NULL DEFAULT '0' COMMENT '单体容量低阈值',
          PRIMARY KEY (`num`),
          UNIQUE KEY `index_dev_id` (`dev_id`) USING BTREE
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='bts6185相关设备告警阈值遥调表';

V2.01 edit at date 2024-04-25
    1.新增表'db_ram_db.tb_intelligentbusbar_state'-智能母联实时状态表

 BattMonitor_DB_Builder/src/com/database_util/DB_Ram_db.java

@@ -136,6 +136,9 @@
        //创建智能母联实时状态信息表
        createIntelligentBusbar_State_Table(pool, recreate);

        //创建BTS6185相关设备告警阈值遥调表
        createDev_6185_AlmpPram_Table(pool, recreate);

        System.out.println(" Db_Ram_Db init end at " + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms));
    }
    
@@ -204,6 +207,44 @@
    }

    /**
     *     创建 BTS6185相关设备告警阈值遥调表
     * @param pool
     * @param recreate
     */
    private static void createDev_6185_AlmpPram_Table(MysqlConnPool pool, boolean recreate) {
        String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Dev_6185_AlmpPram_Table;
        String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Dev_6185_AlmpPram_Table + " (" + 
                "  `num` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '自增主键'," + 
                "  `dev_id` int(11) NOT NULL DEFAULT '0' COMMENT '设备id'," + 
                "  `op_cmd` int(11) NOT NULL DEFAULT '0' COMMENT '操作命令'," + 
                "  `groupvol_high_val` float NOT NULL DEFAULT '0' COMMENT '组端电压高阈值'," + 
                "  `groupvol_low_val` float NOT NULL DEFAULT '0' COMMENT '组端电压低阈值'," + 
                "  `monvol_high_val` float NOT NULL DEFAULT '0' COMMENT '单体电压高阈值'," + 
                "  `monvol_low_val` float NOT NULL DEFAULT '0' COMMENT '单体电压低阈值'," + 
                "  `montmp_high_val` float NOT NULL DEFAULT '0' COMMENT '单体温度高阈值'," + 
                "  `montmp_low_val` float NOT NULL DEFAULT '0' COMMENT '单体温度低阈值'," + 
                "  `monres_high_val` float NOT NULL DEFAULT '0' COMMENT '单体内阻高阈值'," + 
                "  `monres_low_val` float NOT NULL DEFAULT '0' COMMENT '单体内阻低阈值'," + 
                "  `moncap_high_val` float NOT NULL DEFAULT '0' COMMENT '单体容量高阈值'," + 
                "  `moncap_low_val` float NOT NULL DEFAULT '0' COMMENT '单体容量低阈值'," + 
                "  PRIMARY KEY (`num`)," + 
                "  UNIQUE KEY `index_dev_id` (`dev_id`) USING BTREE" + 
                ") ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='BTS6185相关设备告警阈值遥调表';" + 
                ";";
        Sql_Mysql sql = new Sql_Mysql(pool.getConn());
        try {
            if(true == recreate) {			
                sql.sqlMysqlExecute(sql_str01);
            }
            sql.sqlMysqlExecute(sql_str02);	
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            sql.close_con();
        }		
    }
	
    /**
     *     创建电操开关遥测实时状态表
     * @param pool
     * @param recreate

 BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java

@@ -174,7 +174,9 @@
    public final static String FBS9140_Topology_State = DB_RamDB + ".tb_fbs9140_topology_state";                    //并联BTS拓扑状态信息
    public final static String FBS9149_SetParam = DB_RamDB + ".tb_fbs9149_setparam";                                //并联BTS9组参数表
    public final static String Check_Dialog_Table = DB_RamDB + ".tb_check_dialog";                                    //充放电一体机离线检测表
    public final static String IntelligentBusbar_State_Table = DB_RamDB + ".tb_intelligentbusbar_state";                                    //充放电一体机离线检测表
    public final static String IntelligentBusbar_State_Table = DB_RamDB + ".tb_intelligentbusbar_state";            //充放电一体机离线检测表

    public final static String Dev_6185_AlmpPram_Table = DB_RamDB + ".tb_dev_6185_almparam";                        //BTS61850告警参数表

    
    /**************************** db_user数据库 ***************************************************/

 BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt

@@ -6,6 +6,24 @@
        11029 - 智能母联通信线程 = BMS_ZNBUSBAR_MONITOR
    2.新增FBS9800汇集模块通信对应线程记录
        11030 - FBS9800通信线程 = BMS_FBS9800_DISPLAY
    3.新增表 'db_rab_db.tb_dev_6185_almparam'
        CREATE TABLE `tb_dev_6185_almparam` (
          `num` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '自增主键',
          `dev_id` int(11) NOT NULL DEFAULT '0' COMMENT '设备id',
          `op_cmd` int(11) NOT NULL DEFAULT '0' COMMENT '操作命令',
          `groupvol_high_val` float NOT NULL DEFAULT '0' COMMENT '组端电压高阈值',
          `groupvol_low_val` float NOT NULL DEFAULT '0' COMMENT '组端电压低阈值',
          `monvol_high_val` float NOT NULL DEFAULT '0' COMMENT '单体电压高阈值',
          `monvol_low_val` float NOT NULL DEFAULT '0' COMMENT '单体电压低阈值',
          `montmp_high_val` float NOT NULL DEFAULT '0' COMMENT '单体温度高阈值',
          `montmp_low_val` float NOT NULL DEFAULT '0' COMMENT '单体温度低阈值',
          `monres_high_val` float NOT NULL DEFAULT '0' COMMENT '单体内阻高阈值',
          `monres_low_val` float NOT NULL DEFAULT '0' COMMENT '单体内阻低阈值',
          `moncap_high_val` float NOT NULL DEFAULT '0' COMMENT '单体容量高阈值',
          `moncap_low_val` float NOT NULL DEFAULT '0' COMMENT '单体容量低阈值',
          PRIMARY KEY (`num`),
          UNIQUE KEY `index_dev_id` (`dev_id`) USING BTREE
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='bts6185相关设备告警阈值遥调表';

V2.01 edit at date 2024-04-25
    1.新增表'db_ram_db.tb_intelligentbusbar_state'-智能母联实时状态表

			@@ -6,6 +6,24 @@
			11029 - 智能母联通信线程 = BMS_ZNBUSBAR_MONITOR
			2.新增FBS9800汇集模块通信对应线程记录
			11030 - FBS9800通信线程 = BMS_FBS9800_DISPLAY
			3.新增表 'db_rab_db.tb_dev_6185_almparam'
			CREATE TABLE `tb_dev_6185_almparam` (
			`num` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '自增主键',
			`dev_id` int(11) NOT NULL DEFAULT '0' COMMENT '设备id',
			`op_cmd` int(11) NOT NULL DEFAULT '0' COMMENT '操作命令',
			`groupvol_high_val` float NOT NULL DEFAULT '0' COMMENT '组端电压高阈值',
			`groupvol_low_val` float NOT NULL DEFAULT '0' COMMENT '组端电压低阈值',
			`monvol_high_val` float NOT NULL DEFAULT '0' COMMENT '单体电压高阈值',
			`monvol_low_val` float NOT NULL DEFAULT '0' COMMENT '单体电压低阈值',
			`montmp_high_val` float NOT NULL DEFAULT '0' COMMENT '单体温度高阈值',
			`montmp_low_val` float NOT NULL DEFAULT '0' COMMENT '单体温度低阈值',
			`monres_high_val` float NOT NULL DEFAULT '0' COMMENT '单体内阻高阈值',
			`monres_low_val` float NOT NULL DEFAULT '0' COMMENT '单体内阻低阈值',
			`moncap_high_val` float NOT NULL DEFAULT '0' COMMENT '单体容量高阈值',
			`moncap_low_val` float NOT NULL DEFAULT '0' COMMENT '单体容量低阈值',
			PRIMARY KEY (`num`),
			UNIQUE KEY `index_dev_id` (`dev_id`) USING BTREE
			) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='bts6185相关设备告警阈值遥调表';

			V2.01 edit at date 2024-04-25
			1.新增表'db_ram_db.tb_intelligentbusbar_state'-智能母联实时状态表

			@@ -136,6 +136,9 @@
			//创建智能母联实时状态信息表
			createIntelligentBusbar_State_Table(pool, recreate);

			//创建BTS6185相关设备告警阈值遥调表
			createDev_6185_AlmpPram_Table(pool, recreate);

			System.out.println(" Db_Ram_Db init end at " + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms));
			}

			@@ -204,6 +207,44 @@
			}

			/**
			* 创建 BTS6185相关设备告警阈值遥调表
			* @param pool
			* @param recreate
			*/
			private static void createDev_6185_AlmpPram_Table(MysqlConnPool pool, boolean recreate) {
			String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Dev_6185_AlmpPram_Table;
			String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Dev_6185_AlmpPram_Table + " (" +
			" `num` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '自增主键'," +
			" `dev_id` int(11) NOT NULL DEFAULT '0' COMMENT '设备id'," +
			" `op_cmd` int(11) NOT NULL DEFAULT '0' COMMENT '操作命令'," +
			" `groupvol_high_val` float NOT NULL DEFAULT '0' COMMENT '组端电压高阈值'," +
			" `groupvol_low_val` float NOT NULL DEFAULT '0' COMMENT '组端电压低阈值'," +
			" `monvol_high_val` float NOT NULL DEFAULT '0' COMMENT '单体电压高阈值'," +
			" `monvol_low_val` float NOT NULL DEFAULT '0' COMMENT '单体电压低阈值'," +
			" `montmp_high_val` float NOT NULL DEFAULT '0' COMMENT '单体温度高阈值'," +
			" `montmp_low_val` float NOT NULL DEFAULT '0' COMMENT '单体温度低阈值'," +
			" `monres_high_val` float NOT NULL DEFAULT '0' COMMENT '单体内阻高阈值'," +
			" `monres_low_val` float NOT NULL DEFAULT '0' COMMENT '单体内阻低阈值'," +
			" `moncap_high_val` float NOT NULL DEFAULT '0' COMMENT '单体容量高阈值'," +
			" `moncap_low_val` float NOT NULL DEFAULT '0' COMMENT '单体容量低阈值'," +
			" PRIMARY KEY (`num`)," +
			" UNIQUE KEY `index_dev_id` (`dev_id`) USING BTREE" +
			") ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='BTS6185相关设备告警阈值遥调表';" +
			";";
			Sql_Mysql sql = new Sql_Mysql(pool.getConn());
			try {
			if(true == recreate) {
			sql.sqlMysqlExecute(sql_str01);
			}
			sql.sqlMysqlExecute(sql_str02);
			} catch (SQLException e) {
			e.printStackTrace();
			} finally {
			sql.close_con();
			}
			}

			/**
			* 创建电操开关遥测实时状态表
			* @param pool
			* @param recreate

			@@ -174,7 +174,9 @@
			public final static String FBS9140_Topology_State = DB_RamDB + ".tb_fbs9140_topology_state"; //并联BTS拓扑状态信息
			public final static String FBS9149_SetParam = DB_RamDB + ".tb_fbs9149_setparam"; //并联BTS9组参数表
			public final static String Check_Dialog_Table = DB_RamDB + ".tb_check_dialog"; //充放电一体机离线检测表
			public final static String IntelligentBusbar_State_Table = DB_RamDB + ".tb_intelligentbusbar_state"; //充放电一体机离线检测表
			public final static String IntelligentBusbar_State_Table = DB_RamDB + ".tb_intelligentbusbar_state"; //充放电一体机离线检测表

			public final static String Dev_6185_AlmpPram_Table = DB_RamDB + ".tb_dev_6185_almparam"; //BTS61850告警参数表


			/************************** db_user数据库 *************************************************/