public void retrieveOperatingSystem(int id) throws Exception { String retrieveQuery = "SELECT * FROM operatingSystem WHERE id = " + id; ResultSet rs = Helper.retrieve(retrieveQuery); if (rs.next()) { super.setId(rs.getInt("id")); super.setModel(rs.getString("model")); super.setVendor(rs.getString("vendor")); super.setPrice(rs.getDouble("price")); super.setPlatform(rs.getString("platform")); super.setVersion(rs.getString("s_version")); } else { Exception NoSuchTuple = new Exception("Tuple with given id does not exists!"); throw NoSuchTuple; } }
public static ArrayList<OperatingSystem> retrieveAllOperatingSystems() throws Exception { ArrayList<OperatingSystem> operatingSystems = new ArrayList<OperatingSystem>(); String retrieveQuery = "SELECT * FROM operatingSystem"; OperatingSystem operatingSystem; ResultSet rs = Helper.retrieve(retrieveQuery); while (rs.next()) { operatingSystem = new OperatingSystem(); operatingSystem.setId(rs.getInt("id")); operatingSystem.setModel(rs.getString("model")); operatingSystem.setVendor(rs.getString("vendor")); operatingSystem.setPrice(rs.getDouble("price")); operatingSystem.setPlatform(rs.getString("platform")); operatingSystem.setVersion(rs.getString("s_version")); operatingSystems.add(operatingSystem); } return operatingSystems; }