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