1.新增三方接口配置表'web_site.tb_interface'

Administrator

2022-10-27 c50da3449ee8c5793e7fbf4ba924a51c7f2e96d7

1.新增三方接口配置表'web_site.tb_interface'

 BattMonitor_DB_Builder/bin/com/version_inf/version_inf.txt

@@ -691,5 +691,5 @@

V1.44 edit at date 2022-10-27
    1.新增电操开关表'db_ram_db.tb_dev_60870_inverter_info'和'db_ram_db.tb_dev_60870_inverter_state'  
	
    1.新增三方接口配置表'web_site.tb_interface'
    

 BattMonitor_DB_Builder/src/com/database_util/DB_Pwrdev_Data_Rt.java

@@ -17,11 +17,11 @@
        

        createPwrdev_Acdata_Table(pool, recreate);



        System.out.println(Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms));

        //System.out.println(Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms));

        

        createPwrdev_Acdcdata_Table(pool, recreate);

        

        System.out.println(Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms));

        //System.out.println(Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms));



        createPwrdev_Dcdata_Table(pool, recreate);

        


 BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java

@@ -76,6 +76,8 @@
        
        createTB_Map_Outline_Table(pool, recreate);                    //创建首页轮廓图表
        
        createTB_Interface_Table(pool, recreate);                    //创建首页轮廓图表
		
        System.out.println(" DB_web_site init end at " + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms));
    }
    
@@ -177,6 +179,34 @@
        }
    }

    /**
     * 
     * @param pool
     * @param recreate
     */
    private static void createTB_Interface_Table(MysqlConnPool pool, boolean recreate) {
        String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.TB_Interface_Table;
        String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.TB_Interface_Table+ " (" + 
                "  `num` int(11) NOT NULL AUTO_INCREMENT," + 
                "  `interface_number` varchar(255) NOT NULL DEFAULT ''," + 
                "  `interface_name` varchar(255) NOT NULL DEFAULT ''," + 
                "  `enable`int NOT NULL DEFAULT '1'," + 
                "  PRIMARY KEY (`num`) " + 
                ") ENGINE=InnoDB AUTO_INCREMENT=1 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();
        }
    }


    private static void createTb_Weather_City2_Table(MysqlConnPool pool, boolean recreate) {
        String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Weather_City2_Table;

 BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java

@@ -226,6 +226,7 @@
    public static final String Weather_City2_Table = WEB_Site +".`tb_weather_city2`";                    //天气表
    public static final String TB_3D_STATION_Table = WEB_Site +".`tb_3d_station`";                        //3D机房表
    public static final String TB_Map_Outline_Table = WEB_Site +".`tb_map_outline`";                    //首页轮廓图表
    public static final String TB_Interface_Table = WEB_Site +".`tb_interface`";                        //三方接口配置表
                    
    
    

 BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt

@@ -691,5 +691,5 @@

V1.44 edit at date 2022-10-27
    1.新增电操开关表'db_ram_db.tb_dev_60870_inverter_info'和'db_ram_db.tb_dev_60870_inverter_state'  
	
    1.新增三方接口配置表'web_site.tb_interface'
    

 BattMonitor_DB_Builder/src/main/main_BTS_DB_Builder.java

@@ -146,7 +146,7 @@
        //初始化告警数据库 db_alarm
        DB_Alarm.init(GB_MysqlConnPool, recreate_tb);
        
        System.out.println("===="+Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms));
        //System.out.println("===="+Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms));
        //初始化软件配置信息表 db_app_sys
        DB_App_Sys.init(GB_MysqlConnPool, recreate_tb);
        
@@ -169,7 +169,7 @@
        DB_Pwrdev_Inf.init(GB_MysqlConnPool, recreate_tb);
        
        
        System.out.println("===="+Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms));
        //System.out.println("===="+Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms));
        //初始化FBO历史文件数据表
        DB_Fbo_testdata.init(GB_MysqlConnPool, recreate_tb);