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