public List<RecruitmentRequestBean> getRecruitmentRequests() {
String query =
"select id, requestdep, requestdate, jobtitle, contracttype, yearsofexperience, jobdescription, status from recruitmentrequests;";
try {
Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery(query);
List<RecruitmentRequestBean> result = new ArrayList<>();
boolean hasNext = resultSet.first();
while (hasNext) {
int id = resultSet.getInt(1);
RecruitmentRequestBean recruitmentRequest = new RecruitmentRequestBean(id);
recruitmentRequest.setRequestDepartment(resultSet.getNString(2));
recruitmentRequest.setRequestDate(resultSet.getDate(3));
recruitmentRequest.setJobTitle(resultSet.getNString(4));
recruitmentRequest.setContractType(resultSet.getNString(5));
recruitmentRequest.setYearsOfExperience(resultSet.getInt(6));
recruitmentRequest.setJobDescription(resultSet.getNString(7));
recruitmentRequest.setStatus(resultSet.getNString(8));
result.add(recruitmentRequest);
hasNext = resultSet.next();
}
return result;
} catch (SQLException e) {
e.printStackTrace();
}
return new ArrayList<>();
}
