private EventRequestBean getFromResultSet(ResultSet resultSet) throws SQLException { EventRequestBean eventRequest; String id = resultSet.getString(1); eventRequest = new EventRequestBean(id); String name = resultSet.getString(2); eventRequest.setName(name); int clientId = resultSet.getInt(3); eventRequest.setClientId(clientId); String type = resultSet.getString(4); eventRequest.setType(type); Date from = resultSet.getDate(5); eventRequest.setFrom(from); Date to = resultSet.getDate(6); eventRequest.setTo(to); String budget = resultSet.getString(7); eventRequest.setBudget(budget); String status = resultSet.getString(8); eventRequest.setStatus(status); Map<String, String> preferences = eventRequest.getPreferences(); preferences.put("details_photo_video", resultSet.getNString(9)); preferences.put("details_music", resultSet.getNString(10)); preferences.put("details_poster", resultSet.getNString(11)); preferences.put("details_decoration", resultSet.getNString(12)); preferences.put("details_network", resultSet.getNString(13)); preferences.put("details_food_beverages", resultSet.getNString(14)); preferences.put("details_waiter", resultSet.getNString(15)); preferences.put("feedback_budget", resultSet.getNString(16)); return eventRequest; }