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