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;
    }
}