紫晶中的tb_battmap_information表中添加stationName3字段

whyclj

2019-12-02 90c0fe3cc6fae4fd252c6ad1cbf5a30a3f557b70

紫晶中的tb_battmap_information表中添加stationName3字段

 BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java

@@ -854,6 +854,7 @@
                "  `num` int(11) NOT NULL AUTO_INCREMENT," + 

                "  `stationId` varchar(128) NOT NULL," + 

                "  `stationName` varchar(128) NOT NULL," + 

                "  `stationName3` varchar(128) DEFAULT ''," + 
                "  `address` varchar(128) NOT NULL," + 

                "  `longitude` double(11,8) NOT NULL DEFAULT '0.00000000'," + 

                "  `latitude` double(11,8) NOT NULL DEFAULT '0.00000000'," + 

@@ -863,6 +864,7 @@
                "  KEY `index_num` (`num`)" + 

                ") ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;"; 

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

        ResultSet rs = null;

        try {

            if(true == recreate) {            

                //sql.sqlMysqlExecute(sql_str01);

@@ -870,6 +872,16 @@
            }else {

            }

            sql.sqlMysqlExecute(sql_str02);            //创建基站定位表

            /************************** 添加 stationName3 字段 **************************************/

            String sql_str03 = " SELECT * FROM information_schema.columns  "

                    + " WHERE table_schema= 'web_site' "

                    + " AND table_name='tb_battmap_information' "

                    + " AND column_name='stationName3'";

            rs = sql.sqlMysqlQuery(sql_str03);

            if(false == rs.next()) {

                sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattMapInformation_Table 
                                + " ADD COLUMN `stationName3` varchar(128) NOT NULL DEFAULT '';");

            }

        } catch (SQLException e) {

            e.printStackTrace();

        } finally {

@@ -898,6 +910,7 @@
                //sql.sqlMysqlExecute(sql_str02);

            }

            sql.sqlMysqlExecute(sql_str02);                                    //创建基站故障表        

			
        } catch (SQLException e) {

            e.printStackTrace();

        } finally {


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

@@ -17,7 +17,7 @@
     * @param con_pool

     * @param al_param

     */

    public static void createFBS9100S_DFU_TableOnRam(MysqlConnPool con_pool)

    public static void createFBS9100S_DFU_TableOnRam(MysqlConnPool con_pool,boolean recreate_tb)

    {

        String str1 = "DROP TABLE IF EXISTS " + Sql_Mysql.FBS9100S_DFUState_Table;

        String str2 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.FBS9100S_DFUState_Table

@@ -40,7 +40,9 @@
        

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

        try {

            if(recreate_tb) {

            sql.sqlMysqlExecute(str1);

            }

            sql.sqlMysqlExecute(str2);

            

            

@@ -64,6 +66,6 @@
    

    public static void main(String[] args) {

        MysqlConnPool conn_pool = new MysqlConnPool("127.0.0.1",3360,5);

        createFBS9100S_DFU_TableOnRam(conn_pool);

        createFBS9100S_DFU_TableOnRam(conn_pool,false);

    }

}


 BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java

@@ -650,7 +650,7 @@
                        }

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

                        //为紫晶平台添加指定的列

                        boolean isZijing = true;

                        boolean isZijing = false;

                        if(isZijing) {

                            //添加电压等级列

                            res = sqlMysqlQuery("SELECT * FROM information_schema.columns"

@@ -891,6 +891,25 @@
            }

        }

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

        //-----------------------------  tb_fbsdev_statechange_inf 表中新增2个字段  ----------------------------------------------------------------//

        res = sqlMysqlQuery("SELECT DATA_TYPE FROM information_schema.columns"

                + " WHERE table_schema='db_app_sys'"

                + " AND table_name='tb_fbsdev_statechange_inf'"

                + " AND column_name='eve_type'");

        if(false == res.next()) {

            sqlMysqlExecute("ALTER TABLE " + FBSDevStateChangeInf_Table 
                    + " ADD COLUMN `eve_type` int DEFAULT 0;");

        }

		
        res = sqlMysqlQuery("SELECT DATA_TYPE FROM information_schema.columns"

                + " WHERE table_schema='db_app_sys'"

                + " AND table_name='tb_fbsdev_statechange_inf'"

                + " AND column_name='module_num'");

        if(false == res.next()) {

            sqlMysqlExecute("ALTER TABLE " + FBSDevStateChangeInf_Table 
                    + " ADD COLUMN `module_num` int DEFAULT 0;");

        }

		
    }

    

    //使用db数据库


 BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt

@@ -112,3 +112,9 @@
V1.43 edit at date 2019-09-24

    1.在'db_ram_db'数据库中的表'tb_fbs9100_setparam'表中添加61850中的在线压低和离线续航周期值

    2.在'db_battinf'数据库中的表'tb_battinf'中添加紫晶那边的电池组信息列
	
V1.44 edit at date 2019-12-01

    1.在'web_site'数据库中的表'tb_battmap_information'表中添加stationName3字段用于判断

	
	
	

 BattMonitor_DB_Builder/src/main/main_BTS_DB_Builder.java

@@ -16,7 +16,7 @@
    /**************************************************************************/

    /**************************************************************************/

    public final static boolean app_debug = false;

    public final static float m_VersionNum = (float) 1.043;

    public final static float m_VersionNum = (float) 1.044;

    public final static String m_Version = "Welcome To Use BTS DB BUILDER V" + m_VersionNum + " RC_20180908";

    /**************************************************************************/

    /**************************************************************************/

@@ -81,10 +81,12 @@
            FBS9100_Task_Thread_SQL.createFBS9100S_DCDC_DataTableOnRam(GB_MysqlConnPool);

            //创建CmccPowerData表

            FBS9100_Task_Thread_SQL.createFBS9100CmccPowerDataOnRam(GB_MysqlConnPool);

            //创建tb_fbs9100S_DFU_StateTable表并向表中添加数据

            FBS9100S_DFU_SQL.createFBS9100S_DFU_TableOnRam(GB_MysqlConnPool);

            

        }

		
        //创建tb_fbs9100S_DFU_StateTable表并向表中添加数据[修复数据库中缺失字段bug]

        FBS9100S_DFU_SQL.createFBS9100S_DFU_TableOnRam(GB_MysqlConnPool,recreate_tb);



        //创建tb_fbs9100s_setparam表

        FBS9100_Task_Thread_SQL.createFBS9100SetTestParamTableOnRam(GB_MysqlConnPool,recreate_tb);