updated displayCategories to build /QueryByCatID anchor tag;
deleted old class & servlets per Bella's instruction;
minor jsp presentation modifications: bold column headers in results, $ before product price, oz. after product weight;
updated web.xml to include Bella's QueryByProd servlet mapping;
modification to Bella's QueryByProd servlet(with Bella's approval in order to reach a testable state):
modified searchByProductID to take a String input (removed need to cast prodNumber user input to an int), commented out unnecessary html code (results table built via displayProducts.jsp), removed rs = null instantiation, added an if/else to check the user string input(prodNumber) for a number & run searchByProductID if it does & searchByProductDesc if it does not; created a javadoc section above each method (**needs to be completed);
tested servlet by right-clicking>run file on QueryByProd.java & adding prodNumber=1000 or prodNumber=pin to confirm correct methods run & forward request properly to displayProducts.jsp;
****next step is to link the 'search' button in header to call Bella's servlet directly****
updated javaScript in utils.js to run QueryCateries.java servlet upon user selection of Browse Catalog link;
updated displayCategories.jsp to run QueryByCatID.java servlet upon user selection of any category;
removed form/button from browseCats.html since no longer needed;
removed form/button from searchProds.html; ***search button still needs to be directed to QueryByProd.java servlet;
***next to do: modify result when Electronics category [empty] is selected to notify user that no products currently exist in the Electronics category
updated javaScript in utils.js to run QueryByProd.java servlet upon user selection of Search button;
***next to do: modify result when Electronics category [empty] is selected to notify user that no products currently exist in the Electronics category;
minor comment updates to notate the javaScript modifications in utils.js (header & footer javaScript file);
updated QueryByProd servlet's searchByProdID() method to allow for all products to display when search box is left empty and search button is selected (written by Bella);
added an if/else to displayProducts.jsp to check for prodList to be null, if so prints an error message, if not runs the search query and displays the tables (Bella's check, modified by Scott);
general display clean-up within jsp: added line breaks to end of table in order to add space between table & footer(), centered & bolded null product list search result error message, moved the header & column html code to follow the null check so it will not display with the error message if product list is null, updated table border setting to include the column & row data with uniformity;