<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*, java.util.regex.*, java.util.Map, java.util.HashMap" errorPage="" %> <%@ taglib prefix="c" uri="http://java.sun.com/jstl/core" %> <%@ taglib prefix="fmt" uri="http://java.sun.com/jstl/fmt" %> <%@ taglib prefix="sql" uri="http://java.sun.com/jstl/sql" %> <%@ taglib prefix="str" uri="http://jakarta.apache.org/taglibs/string-1.0.1" %> <%@ include file="/Connections/bidango.jsp" %> <% String sort = "name"; if (request.getParameter("sort") !=null) {sort = (String)request.getParameter("sort") ;} String brand = "adidas"; if (request.getParameter("b") !=null) {brand = (String)request.getParameter("b") ;} %> <% Driver DriverrsSearch = (Driver)Class.forName(MM_bidango_DRIVER).newInstance(); Connection ConnrsSearch = DriverManager.getConnection(MM_bidango_STRING,MM_bidango_USERNAME,MM_bidango_PASSWORD); PreparedStatement StatementrsSearch = ConnrsSearch.prepareStatement("SELECT programname, name, description, manufacturer, saleprice, price, buyurl, imageurl FROM products Where c06 = 'Watches' and manufacturer = '" + brand + "' order by " + sort + ""); ResultSet rsSearch = StatementrsSearch.executeQuery(); boolean rsSearch_isEmpty = !rsSearch.next(); boolean rsSearch_hasData = !rsSearch_isEmpty; Object rsSearch_data; int rsSearch_numRows = 0; %> <% Driver DriverrsBrand = (Driver)Class.forName(MM_bidango_DRIVER).newInstance(); Connection ConnrsBrand = DriverManager.getConnection(MM_bidango_STRING,MM_bidango_USERNAME,MM_bidango_PASSWORD); PreparedStatement StatementrsBrand = ConnrsBrand.prepareStatement("SELECT distinct manufacturer FROM products where c06 = 'Watches' order by manufacturer"); ResultSet rsBrand = StatementrsBrand.executeQuery(); boolean rsBrand_isEmpty = !rsBrand.next(); boolean rsBrand_hasData = !rsBrand_isEmpty; Object rsBrand_data; int rsBrand_numRows = 0; %> <% int Repeat1__numRows = 15; int Repeat1__index = 0; rsSearch_numRows += Repeat1__numRows; %> <% // *** Recordset Stats, Move To Record, and Go To Record: declare stats variables int rsSearch_first = 1; int rsSearch_last = 1; int rsSearch_total = -1; if (rsSearch_isEmpty) { rsSearch_total = rsSearch_first = rsSearch_last = 0; } //set the number of rows displayed on this page if (rsSearch_numRows == 0) { rsSearch_numRows = 1; } %> <% // *** Recordset Stats: if we don't know the record count, manually count them if (rsSearch_total == -1) { // count the total records by iterating through the recordset for (rsSearch_total = 1; rsSearch.next(); rsSearch_total++); // reset the cursor to the beginning rsSearch.close(); rsSearch = StatementrsSearch.executeQuery(); rsSearch_hasData = rsSearch.next(); // set the number of rows displayed on this page if (rsSearch_numRows < 0 || rsSearch_numRows > rsSearch_total) { rsSearch_numRows = rsSearch_total; } // set the first and last displayed record rsSearch_first = Math.min(rsSearch_first, rsSearch_total); rsSearch_last = Math.min(rsSearch_first + rsSearch_numRows - 1, rsSearch_total); } %> <% String MM_paramName = ""; %> <% // *** Move To Record and Go To Record: declare variables ResultSet MM_rs = rsSearch; int MM_rsCount = rsSearch_total; int MM_size = rsSearch_numRows; String MM_uniqueCol = ""; MM_paramName = ""; int MM_offset = 0; boolean MM_atTotal = false; boolean MM_paramIsDefined = (MM_paramName.length() != 0 && request.getParameter(MM_paramName) != null); %> <% // *** Move To Record: handle 'index' or 'offset' parameter if (!MM_paramIsDefined && MM_rsCount != 0) { //use index parameter if defined, otherwise use offset parameter String r = request.getParameter("index"); if (r==null) r = request.getParameter("offset"); if (r!=null) MM_offset = Integer.parseInt(r); // if we have a record count, check if we are past the end of the recordset if (MM_rsCount != -1) { if (MM_offset >= MM_rsCount || MM_offset == -1) { // past end or move last if (MM_rsCount % MM_size != 0) // last page not a full repeat region MM_offset = MM_rsCount - MM_rsCount % MM_size; else MM_offset = MM_rsCount - MM_size; } } //move the cursor to the selected record int i; for (i=0; rsSearch_hasData && (i < MM_offset || MM_offset == -1); i++) { rsSearch_hasData = MM_rs.next(); } if (!rsSearch_hasData) MM_offset = i; // set MM_offset to the last possible record } %> <% // *** Move To Record: if we dont know the record count, check the display range if (MM_rsCount == -1) { // walk to the end of the display range for this page int i; for (i=MM_offset; rsSearch_hasData && (MM_size < 0 || i < MM_offset + MM_size); i++) { rsSearch_hasData = MM_rs.next(); } // if we walked off the end of the recordset, set MM_rsCount and MM_size if (!rsSearch_hasData) { MM_rsCount = i; if (MM_size < 0 || MM_size > MM_rsCount) MM_size = MM_rsCount; } // if we walked off the end, set the offset based on page size if (!rsSearch_hasData && !MM_paramIsDefined) { if (MM_offset > MM_rsCount - MM_size || MM_offset == -1) { //check if past end or last if (MM_rsCount % MM_size != 0) //last page has less records than MM_size MM_offset = MM_rsCount - MM_rsCount % MM_size; else MM_offset = MM_rsCount - MM_size; } } // reset the cursor to the beginning rsSearch.close(); rsSearch = StatementrsSearch.executeQuery(); rsSearch_hasData = rsSearch.next(); MM_rs = rsSearch; // move the cursor to the selected record for (i=0; rsSearch_hasData && i < MM_offset; i++) { rsSearch_hasData = MM_rs.next(); } } %> <% // *** Move To Record: update recordset stats // set the first and last displayed record rsSearch_first = MM_offset + 1; rsSearch_last = MM_offset + MM_size; if (MM_rsCount != -1) { rsSearch_first = Math.min(rsSearch_first, MM_rsCount); rsSearch_last = Math.min(rsSearch_last, MM_rsCount); } // set the boolean used by hide region to check if we are on the last record MM_atTotal = (MM_rsCount != -1 && MM_offset + MM_size >= MM_rsCount); %> <% // *** Go To Record and Move To Record: create strings for maintaining URL and Form parameters String MM_keepBoth,MM_keepURL="",MM_keepForm="",MM_keepNone=""; String[] MM_removeList = { "index", MM_paramName }; // create the MM_keepURL string if (request.getQueryString() != null) { MM_keepURL = '&' + request.getQueryString(); for (int i=0; i < MM_removeList.length && MM_removeList[i].length() != 0; i++) { int start = MM_keepURL.indexOf(MM_removeList[i]) - 1; if (start >= 0 && MM_keepURL.charAt(start) == '&' && MM_keepURL.charAt(start + MM_removeList[i].length() + 1) == '=') { int stop = MM_keepURL.indexOf('&', start + 1); if (stop == -1) stop = MM_keepURL.length(); MM_keepURL = MM_keepURL.substring(0,start) + MM_keepURL.substring(stop); } } } // add the Form variables to the MM_keepForm string if (request.getParameterNames().hasMoreElements()) { java.util.Enumeration items = request.getParameterNames(); while (items.hasMoreElements()) { String nextItem = (String)items.nextElement(); boolean found = false; for (int i=0; !found && i < MM_removeList.length; i++) { if (MM_removeList[i].equals(nextItem)) found = true; } if (!found && MM_keepURL.indexOf('&' + nextItem + '=') == -1) { MM_keepForm = MM_keepForm + '&' + nextItem + '=' + java.net.URLEncoder.encode(request.getParameter(nextItem)); } } } // create the Form + URL string and remove the intial '&' from each of the strings MM_keepBoth = MM_keepURL + MM_keepForm; if (MM_keepBoth.length() > 0) MM_keepBoth = MM_keepBoth.substring(1); if (MM_keepURL.length() > 0) MM_keepURL = MM_keepURL.substring(1); if (MM_keepForm.length() > 0) MM_keepForm = MM_keepForm.substring(1); %> <% // *** Move To Record: set the strings for the first, last, next, and previous links String MM_moveFirst,MM_moveLast,MM_moveNext,MM_movePrev; { String MM_keepMove = MM_keepBoth; // keep both Form and URL parameters for moves String MM_moveParam = "index="; // if the page has a repeated region, remove 'offset' from the maintained parameters if (MM_size > 1) { MM_moveParam = "offset="; int start = MM_keepMove.indexOf(MM_moveParam); if (start != -1 && (start == 0 || MM_keepMove.charAt(start-1) == '&')) { int stop = MM_keepMove.indexOf('&', start); if (start == 0 && stop != -1) stop++; if (stop == -1) stop = MM_keepMove.length(); if (start > 0) start--; MM_keepMove = MM_keepMove.substring(0,start) + MM_keepMove.substring(stop); } } // set the strings for the move to links StringBuffer urlStr = new StringBuffer("watches").append("~").append(MM_keepMove); if (MM_keepMove.length() > 0) urlStr.append('&'); urlStr.append(MM_moveParam); MM_moveFirst = urlStr + "0"; MM_moveLast = urlStr + "-1"; MM_moveNext = urlStr + Integer.toString(MM_offset+MM_size); MM_movePrev = urlStr + Integer.toString(Math.max(MM_offset-MM_size,0)); } %> <% int TFM_middlePages,TFM_startLink,TFM_endLink,TFM_LimitPageEndCount; int TFM_LimitCounter,TFM_LimitLinksEndCount,TM_LinksEndCount; %> <% int rsSearch_TFMcurrentPage; int rsSearch_TFMtotalPages; if(MM_size>0) { rsSearch_TFMcurrentPage = (int)Math.ceil((double)rsSearch_last/MM_size); rsSearch_TFMtotalPages = (int)Math.ceil((double)rsSearch_total/MM_size); }else{ rsSearch_TFMcurrentPage = 0; rsSearch_TFMtotalPages = 0; } %> Compare Prices on <str:capitalizeAllWords> <% out.print(brand); %></str:capitalizeAllWords> Watches For Back To School
Compare Prices and read reviews on <str:capitalizeAllWords> 
                              <% out.print(brand); %></str:capitalizeAllWords> Watches For Back To School
   

A COMPLETE LIST OF BRANDS

A - L M - Z
100866
Abacus
Accessory Time
Adidas
American Pride
Anne Klein
Anne Klein II
Armani
Avocet
Brunton
Bulova
Calvin Klein
Caravelle
Casio
Citizen
Diesel
Disney
DKNY
ESQ
Esquire
Fendi
Field & Stream
Fossil
FreeStyle
Givenchy
Gucci
Guess
Guess Collection
Hamilton
Hamilton_MIB
Highgear
Kenneth Cole
Lancaster
Longines
Luminox
Movado
Nautica
Nike
Nike Watches
Nixon
Oakley
Pierre Cardin
Polar
Pulsar
Puma
Rado
Reaction
Rip Curl
Roxy
Seiko
Seiko Clocks
Skagen
Spoon
Sports Instruments
Storm
Suunto
Suunto USA
Swatch
Swiss Army
Tag Heuer
TechnoMarine
Timberland
Timex
Tissot
Tommy Bahama
Tommy Hilfiger
Vanceur
Vestal
Wenger
Wired
Wittnauer
   
 
 
 
FIND A WATCH
SEARCH THROUGH OUR SELECTION
 
COMPARE PRICES FROM THESE TOP ONLINE WATCH SHOPS
Watchzone.com
BackcountryStore.com
USOUTDOOR.com
Fossil.com
CompUSA.com
 
POPULAR BRANDS



GUESS
CASIO
FREESTYLE
DIESEL
DKNY
BULOVA
ARMANI
HAMILTON
NAUTICA
TIMEX
HILFIGER
SEIKO
OAKLEY
NIKE
PUMA
ROXY
RIP CURL
SWATCH

view complete brands list
ABOUT US
We are your dedicated web professionals, that assist our business friends in spreading the word about their business. We believe in the evolution of easier to manage shopping malls with an online business. The customer has a larger selection and can shop without having to wait in line or drive and park. With free shipping often times and no sales tax in most cases, how can this not be the best option? We believe this to be the truth and are proud to be a part of it.
Home | Brands | Links | Site Map
<% rsSearch.close(); StatementrsSearch.close(); ConnrsSearch.close(); %> <% rsBrand.close(); StatementrsBrand.close(); ConnrsBrand.close(); %>