int recordCount = 0;
try {
while (rs.next()) {
int siteCode = rs.getInt("facility_code");
String siteName = rs.getString("facility_name");
SiteMatch s = new SiteMatch(siteCode, siteName);
siteList.add(s);
}
rs.close();
} catch (SQLException ex) {
Logger.getLogger(SiteList.class.getName()).log(Level.SEVERE, null, ex);