public void valueChanged(ListSelectionEvent e) { if (!e.getValueIsAdjusting()) { updateLog("Filter Event: " + filterName); // Loop through all the Filters defined in the XML file for (filter f : settings.filters.values()) { // If the filter selection does not constrain against this particular filter // do not query the database to update the filter if (f.constrains.containsKey(filterName) == false) { continue; } String sqlStatement = f.sqlBaseStatement + qBuilder.genWhereConstrains(f, getAllFilterSelection()) + qBuilder.genOrderBy(f); updateLog("\tSQL " + f.title + ": " + sqlStatement); updateFilter(f, sqlStatement); } String sqlStatement = settings.resultFilter.sqlBaseStatement + qBuilder.genWhereConstrains(settings.resultFilter, getAllFilterSelection()) + qBuilder.genOrderBy(settings.resultFields); updateLog("\tSQL results: " + sqlStatement); // execQuery("music", sqlStatement ); updateResults(sqlStatement); } } }