<%@ page import="medicallogistics.*,java.sql.*,java.util.*" errorPage="" %>

Click to view product list:
Group 1 Surfaces | Group 2 Surfaces | Wheelchair Cushions

<% try { ProductDb pdb = new ProductDb(); ResultSet groupRS = pdb.query(ProductDb.sqlProductGroupList); if (groupRS!=null && groupRS.next() ) { do { // print product list try { out.println("

"); out.println("

"+groupRS.getString("name")+"

"); // print medicare criteria if (groupRS.getString("criteriaName")!=null) { out.println("

Medicare Qualifying Criteria

"); out.println("

"+groupRS.getString("criteria")+"

"); } //finished ProductDisplay dp = new ProductDisplay(); out.println(""); out.println(dp.displayProductByGroup(groupRS.getInt("id"),groupRS,pdb.getConn())); out.println("

"); out.println("

"); } catch(Exception e) {out.println(e.getMessage());} } while (groupRS.next());// while out.println("

"); } // if there is group pdb.closeAllConnection(); } catch (Exception e) { // product group list out.println("Error getting product group:"+e.getMessage()); } %>