添加61850均衡模块参数表

whyclj

2019-08-30 ff0f2f712422eb3f2f0e0dbd7fa1dc6b8e006ec2

添加61850均衡模块参数表

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

@@ -557,5 +557,51 @@
        }

    }



    /**

     *     创建61850均衡供电模块信息表

     * @param pool

     * @param recreate_tb

     */

    public static void createTB_61850_JHState_TableOnRam(MysqlConnPool pool, boolean recreate_tb) {

        String sql_str0 = "DROP TABLE IF EXISTS " + Sql_Mysql.TB_61850_JHState_Table + "; ";

		
        String sql_str1 = "CREATE TABLE IF NOT EXISTS  "+Sql_Mysql.TB_61850_JHState_Table+" (" + 
                "  `num` bigint(20) NOT NULL DEFAULT '0'," + 
                "  `dev_id` int(11) NOT NULL DEFAULT '0'," + 
                "  `dev_version` varchar(255) NOT NULL DEFAULT ''," + 
                "  `input_vol_total` double NOT NULL DEFAULT '0'," + 
                "  `output_vol_total` double NOT NULL DEFAULT '0'," + 
                "  `input_curr_total` double NOT NULL DEFAULT '0'," + 
                "  `output_curr_total` double NOT NULL DEFAULT '0'," + 
                "  `output_vol_one` double NOT NULL DEFAULT '0'," + 
                "  `output_vol_two` double NOT NULL DEFAULT '0'," + 
                "  `output_vol_three` double NOT NULL DEFAULT '0'," + 
                "  `output_vol_four` double NOT NULL DEFAULT '0'," + 
                "  `output_vol_five` double NOT NULL DEFAULT '0'," + 
                "  `output_vol_six` double NOT NULL DEFAULT '0'," + 
                "  `output_vol_seven` double NOT NULL DEFAULT '0'," + 
                "  `output_vol_eight` double NOT NULL DEFAULT '0'," + 
                "  `output_vol_nine` double NOT NULL DEFAULT '0'," + 
                "  `output_vol_ten` double NOT NULL DEFAULT '0'," + 
                "  `dev_temp` double NOT NULL DEFAULT '0'," + 
                "  PRIMARY KEY (`num`)," + 
                "  UNIQUE KEY `index_dev_id_unique` (`dev_id`) USING BTREE" + 
                ") ENGINE=InnoDB DEFAULT CHARSET=utf8;";

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

        try {

            if(true == recreate_tb) {

                sql.sqlMysqlExecute(sql_str0);

            } else {

				
            }

            sql.sqlMysqlExecute(sql_str1);

        } catch (SQLException e) {

            e.printStackTrace();

        } finally {

            sql.close_con();

        }		
    }



    

}


 BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java

@@ -82,6 +82,8 @@
    public final static String BTSGPRSState_Table = DB_RamDB + ".`tb_bts_gprs_state`";                                //gprs 信息表

    

    public final static String FBS9100BattParam_Table = DB_RamDB + ".`tb_fbs9100_battparam`";                        //电池组参数表

	
    public final static String TB_61850_JHState_Table = DB_RamDB +".tb_61850_jhstate";                                //61850均衡61850供电模块信息

    //--------------------------------------------------------------------------------------------//

    //--------------------------------------------------------------------------------------------//

    public final static String AppSys_Table = DB_AppSys + ".`tb_app_sys`";


 BattMonitor_DB_Builder/src/main/main_BTS_DB_Builder.java

@@ -103,6 +103,10 @@
        //重新纠正机房状态表中的机房id和设备id之间的对应关系

        FBS9100_Task_Thread_SQL.checkBTSStationState_TableOnRam(GB_MysqlConnPool);

        

        //创建61850均衡模块信息表

        FBS9100_Task_Thread_SQL.createTB_61850_JHState_TableOnRam(GB_MysqlConnPool,recreate_tb);

		
		
        //初始化数据库  db_battinf

        DB_battinf.init(GB_MysqlConnPool, recreate_tb);