/** * @user admin * @param CandidateAction object * @return true if candidate information added in database else false Generates a unique candidate * id for each candidate and fills the candidate information into the database */ public boolean addCandidate(CandidateAction ca) { conn = Connect.createConn(); try { int j = genCandidateid(); query = "insert into its_candidateinformation_tbl values(?,?,?,?,?,?,?,?,?,?,?, default)"; pstmt = conn.prepareStatement(query); pstmt.setInt(1, j); pstmt.setString(2, ca.getFname()); pstmt.setString(3, ca.getLname()); pstmt.setString(4, ca.getDegree()); pstmt.setString(5, ca.getStream()); pstmt.setString(6, ca.getPskillset()); pstmt.setString(7, ca.getSskillset()); pstmt.setInt(8, ca.getExperience()); pstmt.setString(9, ca.getDesignation()); pstmt.setString(10, ca.getJoining()); pstmt.setString(11, ca.getLocation()); int i = pstmt.executeUpdate(); if (i == 1) { message = "Candidate successfully added. Candidate ID is:" + j; return true; } if (i == 0) { message = "Candidate could not be added"; return false; } } catch (SQLException e) { message = "exception occured "; System.out.println("Cannot add data into candidate table " + e); return false; } finally { closeConn(); } return false; }