2.新增表'db_ram_db.tb_check_dialog' CREATE TABLE `tb_check_dialog` ( `nu...

Administrator

2023-10-11 61b944654f948047a667d1fab85e85c76290901b

2.新增表'db_ram_db.tb_check_dialog'
		CREATE TABLE `tb_check_dialog` (
		  `num` bigint(20) NOT NULL AUTO_INCREMENT,
		  `dev_id` int(64) NOT NULL DEFAULT '910000001',
		  `test_start_time` datetime NOT NULL DEFAULT '1982-01-01 00:00:00',
		  PRIMARY KEY (`num`)
		) ENGINE=InnoDB DEFAULT CHARSET=utf8;

 BattMonitor_DB_Builder/bin/com/database_util/DB_Alarm.class

Binary files differ

 BattMonitor_DB_Builder/bin/com/database_util/DB_Ram_db.class

Binary files differ

 BattMonitor_DB_Builder/bin/com/version_inf/version_inf.txt

@@ -3,6 +3,15 @@

V1.88 edit at date 2023-10-09
    1.修复表 `db_app_sys`.`tb_page_param`中默认数据插入bug修复
    2.新增表'db_ram_db.tb_check_dialog'
        CREATE TABLE `tb_check_dialog` (
          `num` bigint(20) NOT NULL AUTO_INCREMENT,
          `dev_id` int(64) NOT NULL DEFAULT '910000001',
          `test_start_time` datetime NOT NULL DEFAULT '1982-01-01 00:00:00',
          PRIMARY KEY (`num`)
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

		
    
V1.87 edit at date 2023-09-09 
    1.表`db_app_sys`.`tb_page_param` 插入默认数据

 BattMonitor_DB_Builder/src/com/database_util/DB_Alarm.java

@@ -69,7 +69,7 @@
                    + " AND table_name='" + tablename + "'"
                    + " AND column_name='alm_severity'");
                if(false == res2.next()) {
                    sql.sqlMysqlExecute(" ALTER TABLE db_alarm." + tablename 
                    sql.sqlMysqlTotalExecute(" ALTER TABLE db_alarm." + tablename 
                        + " ADD COLUMN `alm_severity` int(11) NOT NULL DEFAULT '1' COMMENT '告警重要等级[0:重要；1:紧急]';");
                }
            

 BattMonitor_DB_Builder/src/com/database_util/DB_Ram_db.java

@@ -129,11 +129,40 @@
        
        //创建并联BTS9组参数表
        createFBS9149_SetParam(pool,recreate);
		
        //创建充放电一体机离线检测表
        createCheck_Dialog_Table(pool,recreate);

        System.out.println(" Db_Ram_Db init end at " + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms));
    }
    
    /**
     *     创建充放电一体机离线检测表
     * @param pool
     * @param recreate
     */
    private static void createCheck_Dialog_Table(MysqlConnPool pool, boolean recreate) {
        String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Check_Dialog_Table;
        String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Check_Dialog_Table + " (" + 
                "  `num` bigint(20) NOT NULL AUTO_INCREMENT," + 
                "  `dev_id` int(64) NOT NULL DEFAULT '910000001'," + 
                "  `test_start_time` datetime NOT NULL DEFAULT '1982-01-01 00:00:00'," + 
                "  PRIMARY KEY (`num`)" + 
                ") ENGINE=InnoDB DEFAULT CHARSET=utf8;";
        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

@@ -167,6 +167,7 @@
    public final static String DEV60870_Inverter_Info = DB_RamDB + ".tb_dev_60870_inverter_info";                    //电操开关遥测实时状态表
    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";                                    //充放电一体机离线检测表

    
    /**************************** db_user数据库 ***************************************************/
@@ -1254,6 +1255,13 @@
        sql.setQueryTimeout(60);
        sql.execute(sql_str);
    }
    //执行sql语句
    public void sqlMysqlTotalExecute(String sql_str) throws SQLException
    {
        Statement sql = mysql_con.createStatement();
        sql.setQueryTimeout(5*60);
        sql.execute(sql_str);
    }
    
    
    //在事物中执行多条sql语句

 BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt

@@ -3,6 +3,15 @@

V1.88 edit at date 2023-10-09
    1.修复表 `db_app_sys`.`tb_page_param`中默认数据插入bug修复
    2.新增表'db_ram_db.tb_check_dialog'
        CREATE TABLE `tb_check_dialog` (
          `num` bigint(20) NOT NULL AUTO_INCREMENT,
          `dev_id` int(64) NOT NULL DEFAULT '910000001',
          `test_start_time` datetime NOT NULL DEFAULT '1982-01-01 00:00:00',
          PRIMARY KEY (`num`)
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

		
    
V1.87 edit at date 2023-09-09 
    1.表`db_app_sys`.`tb_page_param` 插入默认数据