/**
* @param rs
* @return object RequestRoom
* @throws SQLException
*/
private RequestRoom getRequestRoom(ResultSet rs) throws SQLException {
User user = new User();
user.setId(rs.getInt("users.id"));
Client client = new Client();
client.setUser(user);
client.setLastname(rs.getString(ColumnNames.LASTNAME));
client.setFirstname(rs.getString(ColumnNames.FIRSTNAME));
RequestRoom requestRoom = new RequestRoom();
requestRoom.setId(rs.getInt("requests.id"));
requestRoom.setClient(client);
requestRoom.setAmountOfBed(rs.getInt(ColumnNames.AMOUNT_OF_BED));
requestRoom.setClassOfRoom(rs.getString(ColumnNames.CLASS));
requestRoom.setArrivalDate(rs.getDate(ColumnNames.ARRIVAL_DATE));
requestRoom.setDepartureDate(rs.getDate(ColumnNames.DEPARTURE_DATE));
return requestRoom;
}
/**
* @param id
* @return object RequestRoom
* @throws SQLException
*/
public RequestRoom get(Integer id) throws SQLException {
Connection c = MySQLDatabase.getConnection();
PreparedStatement s = c.prepareStatement(DB_GET_REQUEST);
s.setInt(1, id);
ResultSet rs = s.executeQuery();
RequestRoom requestRoom = new RequestRoom();
if (rs.next()) {
requestRoom.setId(id);
requestRoom.setClassOfRoom(rs.getString(ColumnNames.CLASS));
requestRoom.setAmountOfBed(rs.getInt(ColumnNames.AMOUNT_OF_BED));
requestRoom.setDepartureDate(rs.getDate(ColumnNames.DEPARTURE_DATE));
requestRoom.setArrivalDate(rs.getDate(ColumnNames.ARRIVAL_DATE));
Client client = new Client();
User user = new User();
user.setId(rs.getInt(ColumnNames.USER_ID));
client.setUser(user);
requestRoom.setClient(client);
}
MySQLDatabase.releaseConnection(c);
return requestRoom;
}