/** * @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; }