<%@ page language="java" import="java.sql.*" %>
 

Category:
Keyword:


advanced search

 
<% Class.forName("com.mysql.jdbc.Driver"); Connection myConn = DriverManager.getConnection("jdbc:mysql:///dejavulab_com?user=dejavu&password=stupid"); String cat = new String(request.getParameter("cat")); String catE = new String(""); String keyw = new String(request.getParameter("keyw")); String keywE = new String(""); int trr = 0; Statement stmt = myConn.createStatement(); String iid = request.getParameter("id"); ResultSet myResultSet = stmt.executeQuery("select * from item where id = " + iid); if (myResultSet != null) { while (myResultSet.next()) { String ieqclass = myResultSet.getString("eqclass"); String ieqtype = myResultSet.getString("eqtype"); String ieqbrand = myResultSet.getString("eqbrand"); String imodelno = myResultSet.getString("modelno"); String iserialno = myResultSet.getString("serialno"); String iorigalpr = myResultSet.getString("originalpr"); String ipricesource = myResultSet.getString("prsource"); String ipriceyear = myResultSet.getString("pryear"); String isellingpr = myResultSet.getString("sellingpr"); String icostacq = myResultSet.getString("costacq"); String iwhenacq = myResultSet.getString("whenacq"); String iwhereacq = myResultSet.getString("whereacq"); String ieqage = myResultSet.getString("eqage"); String icurrentmodel = myResultSet.getString("currentmodel"); String idetaildesc = myResultSet.getString("detaildesc"); String iacc = myResultSet.getString("acc"); String iliterature = myResultSet.getString("literature"); String istockno = myResultSet.getString("stockno"); String ieqsold = myResultSet.getString("eqsold"); String call = myResultSet.getString("call"); %>

   Equipment Details      
 

Photos taken before rebuild
  Equipment Class <%=ieqclass%>
Type <%=ieqtype%>
Brand <%=ieqbrand%>
Model Number <%=imodelno%>
Serial Number <%=iserialno%>
Stock Number <%=istockno%>
Selling Price <%if (ieqsold.compareTo("99")==0) {%>SOLD<%} else {if (call.compareTo("0")==0) {%>$<%=isellingpr%> (USD)<%} else {%>CALL<%}}%>

Description:  <%=idetaildesc%>
Accessories: <%=iacc%>
Literature Available: <%=iliterature%>
Warranty: 180 days parts and labor warranty!


<%}}%>
Equipment Search Results
<% if (cat.compareTo(catE)==0) {} else { %>
Category: <%=cat%> <%trr = 99;%> <%} if (keyw.compareTo(keywE)!=0 && trr==99) {%> , and <%} if (keyw.compareTo(keywE)==0) {} else { %> Key Word: <%=keyw%> <%} Integer numberToShow2 = new Integer(request.getParameter("ipp")); Integer offset2 = new Integer(request.getParameter("offset")); int numberToShow=0; if(numberToShow2.intValue() == 0) { numberToShow=20; }else{ numberToShow = numberToShow2.intValue(); } int offset = offset2.intValue(); boolean endofdb = false; int counter = 0; int nextOffset = offset + numberToShow; int prevOffset = offset - numberToShow; int newstart = 0; int boogers=0; int switcher=0; int yaya; int bumper=17; myResultSet = null; myResultSet = stmt.executeQuery("select * from item where eqclass like \""+cat+"%\" and ((modelno like \"%"+keyw+"%\" or eqclass like \"%"+keyw+"%\" or serialno like \"%"+keyw+"%\" or eqbrand like \"%"+keyw+"%\" or detaildesc like \"%"+keyw+"%\" or eqtype like \"%"+keyw+"%\" or acc like \"%"+keyw+"%\" or stockno like \"%"+keyw+"%\" or literature like \"%"+keyw+"%\") or stockno = '+keyw+') order by eqclass;"); %>
    
<% String ieqdisp; int mini=0; while (mini <%} else {%> <%}} boogers=99; counter++; if (switcher==1) {%> <%switcher=0; } else { switcher=1;%> <%}%> <% if (cat.compareTo(catE)==0) { %> <%}else{} if (cat.compareTo(catE)==0) { %> <% if (cat.compareTo(catE)==0) { %> <% if (cat.compareTo(catE)==0) { %> <% if (cat.compareTo(catE)==0) { %> <% } } //ending eqdisp if statement if (counter != numberToShow) { endofdb = true; } if (boogers!=0) { %>
Category Type Brand Model Price ($USD) More InfoType Brand Model Price ($USD) More Info
<%= classStr %>
 <%}else{%> <%}%>
<%= equiptypeStr %>
 <%}else{%> <%}%>
<%= brandStr %>
 <%}else{%> <%}%>
<%= modelnoStr %>
 <%}else{%> <%} if (ieqsold.compareTo("99")==0) {%>
SOLD <%} else { if (call==0) {%>
$<%=proppriceStr%> <%} else {%>
CALL<%}}%>

Click Here


Displaying items <%=offset+1%>-<%=offset+counter%>   


<% } else {%>

NO ITEMS FOUND MATCHING YOUR SEARCH CRITERIA
Please refine your search and try again.
<% } if (offset<=0) { %>          <% } else { %>
Previous Page<%}%>            <% if (!endofdb) { %> Next Page <% if (!endofdb) { myResultSet.close(); stmt.close(); myConn.close(); } } %>

   Search Equipment      
 
Enter below the category you wish to search by
and/or a keyword search.
 

Category Search 

Keyword Search 


Items per page
25   50   100   ALL


<% myResultSet.close(); stmt.close(); myConn.close(); %>


Webpage and all contents ©2000- Deja Vu Lab and Test Equipment Inc.