moved the PRODUCT_TABLE_NAME variable from the QueryByCatID servlet methods to the Connection.java class in the database package;
updated the QueryByCatID() method to then call Connection.PRODUCT_TABLE_NAME;
created an addProductList(Product prod) method in the ProductList class to utilize during sql query blocks;
removed prodObject product list variable instantiation from QueryByProd servlet class, replaced to call the results.addProductList() method instead;
removed prodObject product list variable instantiation from QueryByCatID servlet class, replaced to call the results.addProductList() method instead;
removed catObject category list variable instantiation from QueryCategory servlet class, replaced to call the results.addCategoryList() method instead;
moved the CATEGORY_TABLE_NAME variable instantiation from the QueryCategory servlet into the Connection class;
merge Scott's update and adjust updater servlets to use tablename constant