String recNameQuery = "SELECT recipe_name " +
"FROM recipe, ingredient_recipe " +
"WHERE recipe.recipe_id = ingredient_recipe.recipe_id AND (ingredient_recipe.ingredient_id = ?";
//For Loop for preparing rest of Query String
for(int i = 1; i < extractedIngredientIDs.size(); i ++) {
recNameQuery += "OR ingredient_recipe.ingredient_id = ?";
} // end for
recNameQuery += ") GROUP BY recipe_name";
st = dbconn.prepareStatement(recNameQuery);
//For Loop for preparing statement
for(int i = 1; i < extractedIngredientIDs.size()+1; i ++) {
st.setInt(i, extractedIngredientIDs.get(i-1));
} // end for
rs = st.executeQuery();
while(rs.next()){
recipesToDisplay.add(rs.getString("recipe_name"));
}
ListModel recipeListBoxModel =
new DefaultComboBoxModel(recipesToDisplay.toArray());
recipeListBox.removeAll();
recipeListBox.setModel(recipeListBoxModel);
} // end if anyParam