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