/**
* Add recruitment request to permanent store.
*
* @param toAdd request to be added
* @return id of added request or -1 if unsuccessful
*/
public int addRecruitmentRequest(RecruitmentRequestBean toAdd) {
String insertStatement =
"insert into recruitmentrequests (requestdep, requestdate, jobtitle, contracttype, yearsofexperience, jobdescription, status) values (?,?,?,?,?,?,?);";
try {
PreparedStatement statement =
connection.prepareStatement(insertStatement, Statement.RETURN_GENERATED_KEYS);
statement.setNString(1, toAdd.getRequestDepartment());
statement.setDate(2, new java.sql.Date(toAdd.getRequestDate().getTime()));
statement.setNString(3, toAdd.getJobTitle());
statement.setNString(4, toAdd.getContractType());
statement.setInt(5, toAdd.getYearsOfExperience());
statement.setNString(6, toAdd.getJobDescription());
statement.setNString(7, "active");
statement.executeUpdate();
ResultSet rs = statement.getGeneratedKeys();
if (rs.first()) {
return rs.getInt(1);
}
} catch (SQLException e) {
e.printStackTrace();
}
return -1;
}
