コード例 #1
0
 /**
  * @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;
 }
コード例 #2
0
 /**
  * @user admin
  * @param CandidateAction object
  * @return LinkedList of CandidateAction type objects who match the search criteria TODO - provide
  *     search methods for individual queries SQL command like is used to search substrings within
  *     Primary Skillset and Secondary Skillset strings stored in database
  */
 public LinkedList<CandidateAction> searchCandidate(CandidateAction ca) {
   conn = Connect.createConn();
   query1 = "SELECT * FROM its_candidateinformation_tbl WHERE ( ";
   query =
       query1
           + " upper(pskillset) like upper(?) AND upper(sskillset) like upper(?) AND experience=?)";
   System.out.println(query);
   lca = new LinkedList<CandidateAction>();
   try {
     pstmt = conn.prepareStatement(query);
     pstmt.setString(
         1, "%" + ca.getPskillset() + "%"); // used %string% format to search within strings
     pstmt.setString(
         2, "%" + ca.getSskillset() + "%"); // used %string% format to search within strings
     pstmt.setInt(3, ca.getExperience());
     rset = pstmt.executeQuery();
     while (rset.next()) {
       System.out.println("within rset");
       ca1 = new CandidateAction();
       ca1.setCandidateid(rset.getInt(1));
       ca1.setFname(rset.getString(2));
       ca1.setLname(rset.getString(3));
       ca1.setDegree(rset.getString(4));
       ca1.setStream(rset.getString(5));
       ca1.setPskillset(rset.getString(6));
       ca1.setSskillset(rset.getString(7));
       ca1.setExperience(rset.getInt(8));
       ca1.setDesignation(rset.getString(9));
       ca1.setJoining(rset.getString(10).substring(0, 10));
       ca1.setLocation(rset.getString(11));
       System.out.println("rset not null");
       System.out.println(ca1.getCandidateid());
       lca.add(ca1);
     }
     if (lca == null) {
       message = "no records found with given search criteria";
       System.out.println("lca is null");
     } else {
       message = "Candidates with given search criteria are given here";
       System.out.println("lca not null");
     }
     return lca;
   } catch (SQLException e) {
     message = "Exception occured in search candidate";
     System.out.println("Candidate info cannot be fetched " + e);
   } finally {
     closeConn();
   }
   return lca;
 }