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