package dell_anchor;
|
import databases.DBConnector;
|
import targets.LocationBaseStation;
|
import java.sql.ResultSet;
|
import java.sql.SQLException;
|
import java.util.ArrayList;
|
import java.util.List;
|
|
public class Dell_BaseStation {
|
static List<LocationBaseStation> baseStations;
|
|
public static List<LocationBaseStation> getBaseStations() throws SQLException {
|
baseStations = new ArrayList<>();
|
ResultSet rs = DBConnector.queryTableData("location_base_station");
|
|
while (rs.next()) {
|
LocationBaseStation baseStation = new LocationBaseStation();
|
baseStation.setId((int) rs.getLong("id"));
|
baseStation.setCode(rs.getString("base_station_id"));
|
baseStation.setStatus(rs.getString("statuss"));
|
baseStation.setXCoordinate(rs.getString("x_coordinate"));
|
baseStation.setYCoordinate(rs.getString("y_coordinate"));
|
baseStation.setZCoordinate(rs.getString("z_coordinate"));
|
baseStation.setLongitude(rs.getString("longitude"));
|
baseStation.setLatitude(rs.getString("latitude"));
|
baseStation.setElevation(rs.getString("elevation"));
|
baseStation.setHorizontalAngle(rs.getString("horizontal_angle"));
|
baseStation.setPitchAngle(rs.getString("pitch_angle"));
|
baseStation.setFloor(rs.getString("located_layer"));
|
baseStation.setGroup(rs.getString("located_group"));
|
baseStation.setRange(rs.getString("range"));
|
baseStation.setSyncStatus(rs.getString("sync_status"));
|
baseStation.setSyncType(rs.getString("sync_type"));
|
baseStation.setSyncBaseStation(rs.getString("sync_base_station"));
|
baseStation.setIpAddress(rs.getString("ip_address"));
|
baseStation.setPort(rs.getString("ports"));
|
baseStation.setFirmwareVersion(rs.getString("firmware_version"));
|
baseStation.setJudgmentDistance(rs.getString("judgment_distance"));
|
baseStation.setBattery(rs.getString("battery"));
|
baseStation.setCalibrationDistance(rs.getString("calibration_distance"));
|
baseStation.setSignalSendTime(rs.getString("signal_transmission_time"));
|
baseStation.setCommunicationGroup(rs.getString("communication_group"));
|
baseStation.setIconAddress(rs.getString("icon_url"));
|
baseStation.setOnlineTime(rs.getString("online_time"));
|
baseStation.setOfflineTime(rs.getString("offline_time"));
|
baseStation.setOfflineDuration(rs.getString("offline_duration"));
|
baseStation.setAlgorithmDimension(rs.getString("algorithm_dimension"));
|
baseStation.setBottomHeight(rs.getString("located_bottom_height"));
|
baseStation.setTopHeight(rs.getString("located_top_height"));
|
baseStation.setIsBarometricStation(rs.getString("barometric_base_station"));
|
baseStation.setSwitchDistance(rs.getString("handover_distance"));
|
baseStation.setMaxDistance(rs.getString("maximum_distance"));
|
baseStation.setOutputAllRanging(rs.getString("output_all_base_station_ranging"));
|
baseStation.setCompany(rs.getString("company"));
|
baseStation.setCrossLayerHeight(rs.getString("cross_layer_height"));
|
baseStation.setCrossLayerGroup(rs.getString("cross_layer_group"));
|
baseStation.setRequiredDistance(rs.getString("must_pass_distance"));
|
baseStation.setAdjacent1(rs.getString("adjacent1"));
|
baseStation.setAdjacent2(rs.getString("adjacent2"));
|
baseStation.setAdjacent3(rs.getString("adjacent3"));
|
baseStation.setAdjacent4(rs.getString("adjacent4"));
|
baseStation.setAdjacent5(rs.getString("adjacent5"));
|
baseStation.setAdjacent6(rs.getString("adjacent6"));
|
baseStation.setAdjacent7(rs.getString("adjacent7"));
|
baseStation.setAdjacent8(rs.getString("adjacent8"));
|
baseStation.setAdjacent9(rs.getString("adjacent9"));
|
baseStation.setAdjacent10(rs.getString("adjacent10"));
|
baseStation.setReserved1(rs.getString("reserved1"));
|
baseStation.setReserved2(rs.getString("reserved2"));
|
baseStation.setReserved3(rs.getString("reserved3"));
|
baseStation.setReserved4(rs.getString("reserved4"));
|
baseStation.setReserved5(rs.getString("reserved5"));
|
baseStation.setReserved6(rs.getString("reserved6"));
|
baseStation.setReserved7(rs.getString("reserved7"));
|
baseStation.setReserved8(rs.getString("reserved8"));
|
baseStation.setReserved9(rs.getString("reserved9"));
|
baseStation.setReserved10(rs.getString("reserved10"));
|
baseStation.setReserved11(rs.getString("reserved11"));
|
baseStation.setReserved12(rs.getString("reserved12"));
|
baseStation.setReserved13(rs.getString("reserved13"));
|
baseStation.setReserved14(rs.getString("reserved14"));
|
baseStation.setReserved15(rs.getString("reserved15"));
|
baseStation.setReserved16(rs.getString("reserved16"));
|
|
baseStations.add(baseStation);
|
}
|
return baseStations;
|
}
|
}
|
