public ArrayList<Office> getOffice() {
ArrayList<Office> off = new ArrayList<>();
PreparedStatement ps;
ResultSet rs;
if (dbc.connect()) {
try {
String sqlQuery = "select * from " + getOFFICE_CB();
ps = dbc.getConnection().prepareStatement(sqlQuery);
rs = ps.executeQuery();
while (rs.next()) {
Office o = new Office();
o.setOfficeID(rs.getShort(1));
o.setOfficeName(rs.getNString(2));
o.setOfficeNum(rs.getString(3));
off.add(o);
}
} catch (SQLException ex) {
Logger.getLogger(PersonnelDAO.class.getName()).log(Level.SEVERE, null, ex);
}
}
return off;
}
