public ArrayList<Experience> getExperience(String personnelID) { ArrayList<Experience> exList = new ArrayList<>(); PreparedStatement ps; ResultSet rs; if (dbc.connect()) { try { String sqlQuery = "select " + EXPERIENCE_COLUMN + " from " + EXPERIENCE_INFO + " where MaNV = '" + personnelID + "'"; ps = dbc.getConnection().prepareStatement(sqlQuery); rs = ps.executeQuery(); while (rs.next()) { Experience ex = new Experience(); ex.setCompName(rs.getString(1)); ex.setPos(rs.getString(2)); ex.setJob(rs.getString(3)); ex.setStartDate(rs.getDate(4)); ex.setEndDate(rs.getDate(5)); ex.setReferName(rs.getString(6)); ex.setReferPhone(rs.getString(7)); ex.setReferEmail(rs.getString(8)); ex.setReferPos(rs.getString(9)); ex.setID_IDENTITY(rs.getShort(10)); exList.add(ex); } } catch (SQLException ex) { Logger.getLogger(PersonnelDAO.class.getName()).log(Level.SEVERE, null, ex); } } return exList; }