public List<Politician> getQuickSearchResult(String searchQuery) {
if (searchQuery.matches("") || searchQuery.matches(".* .*") || searchQuery.matches(".*%.*"))
return null;
ArrayList<Object> queryValues = new ArrayList<Object>();
String sql = "SELECT * FROM politician WHERE name LIKE ? LIMIT 5";
// queryValues.add("%" +searchQuery +"%");
queryValues.add(searchQuery + "%");
PstmtQuerySet querySet = new PstmtQuerySet(sql, queryValues);
ResultSet rs;
DAOFactory DAO = new DAOFactory();
ArrayList<Politician> searchResultList = new ArrayList<Politician>();
try {
rs = DAO.selectQuery(querySet);
while (rs.next()) {
searchResultList.add(
new Politician(
rs.getInt("id"),
rs.getString("name"),
rs.getString("local"),
getParty(rs.getInt("party_id")),
rs.getString("img_url")));
}
return searchResultList;
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
DAO.closeConnections();
} catch (SQLException e) {
e.printStackTrace();
}
}
return null;
}
public String getParty(int partyId) {
ArrayList<Object> queryValues = new ArrayList<Object>();
String sql = "SELECT * FROM party WHERE id=?";
queryValues.add(partyId);
PstmtQuerySet querySet = new PstmtQuerySet(sql, queryValues);
ResultSet rs;
DAOFactory DAO = new DAOFactory();
try {
rs = DAO.selectQuery(querySet);
if (rs.next()) return rs.getString("name");
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
DAO.closeConnections();
} catch (SQLException e) {
e.printStackTrace();
}
}
return null;
}