package dell_wangguan;
|
|
import java.sql.ResultSet;
|
import java.sql.SQLException;
|
import java.util.ArrayList;
|
import java.util.List;
|
|
import databases.DBConnector;
|
import targets.CommunicationGateway;
|
|
public class Dell_CommunicationGateway {
|
public static List<CommunicationGateway> getCommunicationGateways() throws SQLException {
|
List<CommunicationGateway> gateways = new ArrayList<>();
|
ResultSet rs = DBConnector.queryTableData("communication_gateway");
|
while (rs.next()) {
|
CommunicationGateway gateway = new CommunicationGateway();
|
// ÉèÖÃËùÓÐ×Ö¶ÎÖµ£¨¸ù¾Ý±í½á¹¹Ó³É䣩
|
gateway.setId(rs.getInt("id"));
|
gateway.setDeviceSerialNumber(rs.getString("device_serial_number"));
|
gateway.setIpAddress(rs.getString("ip_address"));
|
gateway.setCommunicationPort(rs.getString("communication_port"));
|
gateway.setChannel1FrequencyPoint(rs.getString("channel1_frequency_point"));
|
gateway.setChannel2FrequencyPoint(rs.getString("channel2_frequency_point"));
|
gateway.setChannel3FrequencyPoint(rs.getString("channel3_frequency_point"));
|
gateway.setChannel4FrequencyPoint(rs.getString("channel4_frequency_point"));
|
gateway.setChannel5FrequencyPoint(rs.getString("channel5_frequency_point"));
|
gateway.setPower(rs.getString("powers")); // ×¢ÒâÁÐÃûÊÇpowers
|
gateway.setSynchronizationTime(rs.getString("synchronization_time"));
|
gateway.setxCoordinate(rs.getString("x_coordinate"));
|
gateway.setyCoordinate(rs.getString("y_coordinate"));
|
gateway.setzCoordinate(rs.getString("z_coordinate"));
|
gateway.setFloor(rs.getString("floors")); // ×¢ÒâÁÐÃûÊÇfloors
|
gateway.setLongitude(rs.getString("longitude"));
|
gateway.setLatitude(rs.getString("latitude"));
|
gateway.setElevation(rs.getString("elevation"));
|
gateway.setVersion(rs.getString("versions")); // ×¢ÒâÁÐÃûÊÇversions
|
gateway.setTagCount(rs.getString("tag_count"));
|
gateway.setStatus(rs.getString("statuss")); // ×¢ÒâÁÐÃûÊÇstatuss
|
gateway.setDeviceAddTime(rs.getString("device_add_time"));
|
gateway.setLatestHeartbeatTime(rs.getString("latest_heartbeat_time"));
|
gateway.setIotCardNumber(rs.getString("iot_card_number"));
|
gateway.setCompany(rs.getString("company"));
|
gateways.add(gateway);
|
}
|
return gateways;
|
}
|
}
|
