启动时默认录入未添加的机房的内阻测试计划记录

DELL

2024-03-27 2993f12d24195683aed69ff88ff53af2a198fe55

启动时默认录入未添加的机房的内阻测试计划记录

 BattMonitor_DB_Builder/bin/com/database_util/DB_web_site.class

Binary files differ

 BattMonitor_DB_Builder/src/com/database_util/DB_web_site.java

@@ -196,16 +196,31 @@
                "  PRIMARY KEY (`num`) USING BTREE" + 
                ") ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='机房内阻测试计划信息表';";
        Sql_Mysql sql = new Sql_Mysql(pool.getConn());
        ResultSet res = null;
        try {
            if(true == recreate) {            
                sql.sqlMysqlExecute(sql_str01);
            }
            sql.sqlMysqlExecute(sql_str02);    
			
			
            res = sql.sqlMysqlQuery("    SELECT DISTINCT(StationId) FROM " + Sql_Mysql.BattInf_Table +
                                    "    WHERE StationId NOT IN (" + 
                                    "        SELECT stationid " + 
                                    "        FROM " + Sql_Mysql.Tb_Resset_Station_Table +
                                    "    )");
            while(res.next()) {
                String station_id = res.getString("StationId");
                sql.sqlMysqlExecute("INSERT INTO web_site.tb_resset_station(stationid) VALUES("+station_id+");");
            }		
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            if(null  != res) {
                try {
                    res.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
            sql.close_con();
        }
    }