public boolean insertSkillInfo(String personnelID, Skill sk) { boolean check = true; PreparedStatement ps; if (dbc.connect()) { try { String sqlQuery = "INSERT INTO " + SKILL_INFO + " VALUES(?,?,?,?,?)"; ps = dbc.getConnection().prepareStatement(sqlQuery); ps.setString(1, personnelID); ps.setShort(2, sk.getNameID()); ps.setShort(3, sk.getClassificationID()); ps.setNString(4, sk.getNote()); if (sk.getEffectiveDate() == null) { ps.setNull(5, java.sql.Types.DATE); } else { ps.setDate(5, sk.getEffectiveDate()); } if (ps.executeUpdate() < 1) { check = false; } } catch (SQLException ex) { Logger.getLogger(PersonnelDAO.class.getName()).log(Level.SEVERE, null, ex); } } return check; }
@Override public Collection<TeacherDTO> getTeachers() { ArrayList<TeacherDTO> teacherDTOs = new ArrayList<>(); Query query = entityManager.createNamedQuery("Teacher.findAll"); List<Teacher> teachers = query.getResultList(); query = entityManager.createNamedQuery("Skill.findAll"); List<Skill> skills = query.getResultList(); ArrayList<SkillDTO> skillsDTO = new ArrayList<>(); for (Skill s : skills) { skillsDTO.add(new SkillDTO(s.getId().intValue(), s.getSkillName())); } for (Teacher t : teachers) { teacherDTOs.add(new TeacherDTO(t.getFirstName(), t.getLastName(), t.getCpr(), skillsDTO)); } return teacherDTOs; }
public ArrayList<Skill> getSkill(String personnelID) { ArrayList<Skill> skList = new ArrayList<>(); PreparedStatement ps; ResultSet rs; if (dbc.connect()) { try { String sqlQuery = "select " + SKILL_COLUMN + " from " + SKILL_INFO + " where MaNV = '" + personnelID + "'"; ps = dbc.getConnection().prepareStatement(sqlQuery); rs = ps.executeQuery(); while (rs.next()) { Skill sk = new Skill(); sk.setNameID(rs.getShort(1)); sk.setClassificationID(rs.getShort(2)); sk.setEffectiveDate(rs.getDate(3)); sk.setNote(rs.getString(4)); sk.setID_IDENTITY(rs.getShort(5)); skList.add(sk); } } catch (SQLException ex) { Logger.getLogger(PersonnelDAO.class.getName()).log(Level.SEVERE, null, ex); } } return skList; }