<%@ taglib prefix="c" uri="WEB-INF/tld/c.tld"%> <%@ taglib prefix="sql" uri="WEB-INF/tld/sql.tld"%> <%@ page language="java" contentType="text/html; charset=iso-8859-1" pageEncoding="ISO-8859-1" import="java.sql.*"%> Product Detail - DR Kincaid Chair
<% String DRIVER = "org.gjt.mm.mysql.Driver"; Class.forName(DRIVER).newInstance(); Connection con=null; ResultSet rst=null; Statement stmt=null; try{ String productID = request.getParameter("productID"); 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, Width, Height, Depth, SeatHeight, ArmHeight, SeatDepth, Feature_1, Feature_2, Feature_3, AP_ID_1, AP_1_FEATURE_1, AP_1_FEATURE_2, AP_1_FEATURE_3, AP_ID_2, AP_2_FEATURE_1, AP_2_FEATURE_2, AP_2_FEATURE_3, AP_ID_3, AP_3_FEATURE_1, AP_3_FEATURE_2, AP_3_FEATURE_3, RelatedProductID1, RelatedProductName1, RelatedProductID2, RelatedProductName2, RelatedProductID3, RelatedProductName3, RelatedProductID4, RelatedProductName4 FROM `products` WHERE `ProductID` = '" + productID + "'"); if(rst.next()) { %>

       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
<%} %>

<% } //close if else { %> <%} }catch(Exception e) { response.sendRedirect("missing.html"); } //end of try-catch block %>
<%= rst.getString("ProductID") %> <%= rst.getString("ProductName") %>

Dimensions (W H D):

<%= rst.getString("Width")%>  <%= rst.getString("Height") %>  <%= rst.getString("Depth") %>

<% if(!rst.getString("SeatHeight").equals("")) { %>

Seat Height:

<%= rst.getString("SeatHeight")%>

<% } %> <% if(!rst.getString("ArmHeight").equals("")) { %>

Arm Height:

<%= rst.getString("ArmHeight")%>

<% } %> <% if(!rst.getString("SeatDepth").equals("")) { %>

Seat Depth:

<%= rst.getString("SeatDepth")%>

<% } %> <% if(!rst.getString("Feature_1").equals("")) { %>

Description:

<%= rst.getString("Feature_1")%>
<%= rst.getString("Feature_2")%>
<%= rst.getString("Feature_3")%>

<% } %> <% if( (!rst.getString("AP_ID_1").equals("")) || (!rst.getString("AP_ID_2").equals("")) || (!rst.getString("AP_ID_3").equals("")) ) { %>

 

also available (not photographed):

<% } %> <% if((rst.getString("AP_ID_1")) != "") { %>

<%= rst.getString("AP_ID_1") %>
<% } %> <% if(!rst.getString("AP_1_Feature_1").equals("")) { %> <%= rst.getString("AP_1_Feature_1") %>
<% } %> <% if(!rst.getString("AP_1_Feature_2").equals("")) { %> <%= rst.getString("AP_1_Feature_2") %>
<% } %> <% if(!rst.getString("AP_1_Feature_3").equals("")) { %> <%= rst.getString("AP_1_Feature_3") %>
<% } %> <% if(!rst.getString("AP_ID_2").equals("")) { %>

<%= rst.getString("AP_ID_2") %>
<% } %> <% if(!rst.getString("AP_2_Feature_1").equals("")) { %> <%= rst.getString("AP_2_Feature_1") %>
<% } %> <% if(!rst.getString("AP_2_Feature_2").equals("")) { %> <%= rst.getString("AP_2_Feature_2") %>
<% } %> <% if(!rst.getString("AP_2_Feature_3").equals("")) { %> <%= rst.getString("AP_2_Feature_3") %>
<% } %> <% if(!rst.getString("AP_ID_3").equals("")) { %>

<%= rst.getString("AP_ID_3") %>
<% } %> <% if(!rst.getString("AP_3_Feature_1").equals("")) { %> <%= rst.getString("AP_3_Feature_1") %>
<% } %> <% if(!rst.getString("AP_3_Feature_2").equals("")) { %> <%= rst.getString("AP_3_Feature_2") %>
<% } %> <% if(!rst.getString("AP_3_Feature_3").equals("")) { %> <%= rst.getString("AP_3_Feature_3") %>
<% } %>

 

.jpg" >

&productName=<%= rst.getString("ProductName")%>&width=<%= rst.getString("Width")%>&heigth=<%= rst.getString("Height")%>&depth=<%= rst.getString("Depth")%>','View', 'width=612,height=784,scrollbars=yes,resizable=yes')" href="javascript:" class="middleLinksSansBold">view larger image

 

<% if( (!rst.getString("RelatedProductID1").equals("")) || (!rst.getString("RelatedProductID2").equals("")) || (!rst.getString("RelatedProductID3").equals("")) || (!rst.getString("RelatedProductID4").equals("")) ) { %>

Related items (click item below to view):

<% if(!rst.getString("RelatedProductID1").equals("")) { %> &productCategory=<%= rst.getString("ProductCategoryName")%>" class="middleLinks"> <% } %> <% if(!rst.getString("RelatedProductID2").equals("")) { %> &productCategory=<%= rst.getString("ProductCategoryName")%>" class="middleLinks"> <% } %> <% if(!rst.getString("RelatedProductID3").equals("")) { %> &productCategory=<%= rst.getString("ProductCategoryName")%>" class="middleLinks"> <% } %> <% if(!rst.getString("RelatedProductID4").equals("")) { %> &productCategory=<%= rst.getString("ProductCategoryName")%>" class="middleLinks"> <% } %> <%} %>

 

 < previous page

We are sorry.  Item number <%= productID %> is currently unavailable for viewing.

For more information on item number <%= productID %> please contact DR Kincaid Chair's corporate office.

 < Previous page
 
Home        Product        Store Locater         Dealer/Designer Login        Contact