<%@ taglib prefix="c" uri="WEB-INF/tld/c.tld"%> <%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1" import="java.sql.*"%> Product List by Category - DR Kincaid Chair

 


       Product

       Product Search

         


<% if(request.getParameter("productCategory").equals("New")) { %>             New Product
<% } else { %>             New Product
<%} %>
<% if(request.getParameter("productCategory").equals("Transitional")) { %>             Transitional
<% } else { %>             Transitional
<%} %>
<% if(request.getParameter("productCategory").equals("Wood_Carved")) { %>             Wood Carved
<% } else { %>             Wood Carved
<%} %>
<% if(request.getParameter("productCategory").equals("Dining")) { %>             Dining
<% } else { %>             Dining
<%} %>
<% if(request.getParameter("productCategory").equals("Exposed_Wood")) { %>             Exposed Wood
<% } else { %>             Exposed Wood
<%} %>
<% if(request.getParameter("productCategory").equals("Chaise_Loveseat")) { %>             Chaise/Loveseat
<% } else { %>             Chaise/Loveseat
<%} %>
<% if(request.getParameter("productCategory").equals("Bench_Ottoman")) { %>             Bench/Ottoman
<% } else { %>             Bench/Ottoman
<%} %>
<% if(request.getParameter("productCategory").equals("Lounge")) { %>             Lounge
<% } else { %>             Lounge
<%} %>
<% if(request.getParameter("productCategory").equals("Desk")) { %>             Desk
<% } else { %>             Desk
<%} %>
<% if(request.getParameter("productCategory").equals("Barstool")) { %>             Barstool
<% } else { %>             Barstool
<%} %>
<% if(request.getParameter("productCategory").equals("Swivel Rocker")) { %>             Swivel Rocker
<% } else { %>             Swivel Rocker
<%} %>
<% if(request.getParameter("productCategory").equals("Glider")) { %>             Glider
<% } else { %>             Glider
<%} %>
<% if(request.getParameter("productCategory").equals("Traditional")) { %>             Traditional
<% } else { %>             Traditional
<%} %>
<% if(request.getParameter("productCategory").equals("Executive_Contract")) { %>             Executive/Contract
<% } else { %>             Executive/Contract
<%} %>
<% if(request.getParameter("productCategory").equals("Basic")) { %>             Basic
<% } else { %>             Basic
<%} %>


<% if(request.getParameter("productCategory").equals("Upholstered_Headboards")) { %>             Upholstered Headboards
<% } else { %>             Upholstered Headboards
<%} %>
<% if(request.getParameter("productCategory").equals("PillowsThrows")) { %>             Pillows Throws
<% } else { %>             Pillows Throws
<%} %>
<% if(request.getParameter("productCategory").equals("Finishes")) { %>             Finish Samples
<% } else { %>             Finish Samples
<%} %>
<% if(request.getParameter("productCategory").equals("Casters")) { %>             Casters
<% } else { %>             Casters
<%} %>
<% if(request.getParameter("productCategory").equals("Nailhead")) { %>             Nailhead
<% } else { %>             Nailhead
<%} %>

<% String productCategory = request.getParameter("productCategory"); String DRIVER = "org.gjt.mm.mysql.Driver"; Class.forName(DRIVER).newInstance(); Connection con=null; ResultSet rst=null; Statement stmt=null; try{ String url="jdbc:mysql://p41mysql25.secureserver.net/zulzbula?user=zulzbula&password=aFHa1Ciab"; con=DriverManager.getConnection(url); stmt=con.createStatement(); %> <% rst=stmt.executeQuery("SELECT ProductId, ProductName, ProductCategoryName FROM `products` WHERE `ProductCategoryName` = '" + productCategory + "' order by `ProductId`"); %> <% // next three lines determine the number of rows in the result set rst.last(); int numberOfRows = rst.getRow(); rst.beforeFirst(); int numPages; int resultsOfDivision = numberOfRows / 9; if(numberOfRows % 9 == 0) { numPages = numberOfRows / 9; } else { numPages = (numberOfRows / 9) + 1; } String pageNumber = request.getParameter("page"); if (pageNumber == null) { pageNumber = "1"; } int resultSetCursorPosition = 0; //will need this to be whatever page starting index resultSetCursorPosition = (Integer.parseInt(pageNumber) * 9) - 9; %> <% for ( int outerLoop = 0; outerLoop <3; outerLoop++ ) { %> <% for ( int innerLoop = 0; innerLoop <3; innerLoop++ ) { rst.absolute(resultSetCursorPosition + 1); if(!rst.isAfterLast()){ %> <% } // end if resultSetCursorPosition++; } // end for %> <% } rst.close(); con.close(); }catch(Exception e) { response.sendRedirect("missing.html"); } //end of try-catch block %>

<% if(numPages > 1) { %> page   <% } else { %>    <%} %> <% if(numPages > 1) { for(int pages = 0; pages < numPages; pages++) { if(request.getParameter("productCategory").equals("Any") && request.getParameter("age").equals("New")) { if( (String.valueOf(pages + 1).equals(request.getParameter("page"))) || ( request.getParameter("page") == null && pages == 0) ) { %> <%= pages + 1%>   <% } else { %> <%= pages + 1%>   <% } } else { if( (String.valueOf(pages + 1).equals(request.getParameter("page"))) || ( request.getParameter("page") == null && pages == 0) ) { %> <%= pages + 1%>   <% } else { %> <%= pages + 1%>   <% } } } } %>

 
Home        Product        Store Locater         Dealer/Designer Login        Contact