<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*, java.util.regex.*, java.util.Random, 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" %><% 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; Driver DriverrsNixon = (Driver)Class.forName(MM_bidango_DRIVER).newInstance(); Connection ConnrsNixon = DriverManager.getConnection(MM_bidango_STRING,MM_bidango_USERNAME,MM_bidango_PASSWORD); PreparedStatement StatementrsNixon = ConnrsNixon.prepareStatement("SELECT * FROM products where c06 = 'Watches' and manufacturer = 'Nixon' order by rand() limit 4"); ResultSet rsNixon = StatementrsNixon.executeQuery(); boolean rsNixon_isEmpty = !rsNixon.next(); boolean rsNixon_hasData = !rsNixon_isEmpty; Object rsNixon_data; int rsNixon_numRows = 0; Driver DriverrsRandom = (Driver)Class.forName(MM_bidango_DRIVER).newInstance(); Connection ConnrsRandom = DriverManager.getConnection(MM_bidango_STRING,MM_bidango_USERNAME,MM_bidango_PASSWORD); PreparedStatement StatementrsRandom = ConnrsRandom.prepareStatement("SELECT * FROM products where c06 = 'Watches' order by rand() limit 6"); ResultSet rsRandom = StatementrsRandom.executeQuery(); boolean rsRandom_isEmpty = !rsRandom.next(); boolean rsRandom_hasData = !rsRandom_isEmpty; Object rsRandom_data; int rsRandom_numRows = 0; %><% int Repeat6__numRows = 6; int Repeat6__index = 0; rsRandom_numRows += Repeat6__numRows; int Repeat3__numRows = 4; int Repeat3__index = 0; rsNixon_numRows += Repeat3__numRows; %>

CHECK OUT THE NIXON WATCHES SELECTION!! -   VIEW ALL   <%String image= "default"; String lookForGif = "default"; String lookForJpg = "default"; String replaceWithGif = "default"; String replaceWithJpg = "default"; String jpg = "default"; String gif = "default"; while ((rsNixon_hasData)&&(Repeat3__numRows-- != 0)) { image=(((rsNixon_data = rsNixon.getObject("imageurl"))==null || rsNixon.wasNull())?"":rsNixon_data).toString(); lookForGif = ".+gif$"; lookForJpg = ".+jpg$"; //regex jpg = "default"; gif = "default"; replaceWithGif = "gif"; replaceWithJpg = "jpg"; //replacement gif = Pattern.compile(lookForGif).matcher(image).replaceAll(replaceWithGif); jpg = Pattern.compile(lookForJpg).matcher(image).replaceAll(replaceWithJpg);%> <% Repeat3__index++; rsNixon_hasData = rsNixon.next(); } %> _<%=((rsNixon.getObject("name")!=null)?rsNixon.getObject("name"):"")%>.html"><% if(jpg.equals("jpg")) { %>&width=100&height=100" border="0"><% } if(gif.equals("gif")) { %>" width="100" border="0"><% } %> $<%=((rsNixon.getObject("price")!=null)?rsNixon.getObject("price"):"")%> <%=((rsNixon.getObject("name")!=null)?rsNixon.getObject("name"):"")%> Watch MORE FEATURED WATCHES <%String image6= "default"; String lookForGif6 = "default"; String lookForJpg6 = "default"; String replaceWithGif6 = "default"; String replaceWithJpg6 = "default"; String jpg6 = "default"; String gif6 = "default"; while ((rsRandom_hasData)&&(Repeat6__numRows-- != 0)) { image6=(((rsRandom_data = rsRandom.getObject("imageurl"))==null || rsRandom.wasNull())?"":rsRandom_data).toString(); lookForGif6 = ".+gif$"; lookForJpg6 = ".+jpg$"; //regex jpg6 = "default"; gif6 = "default"; replaceWithGif6 = "gif"; replaceWithJpg6 = "jpg"; //replacement gif6 = Pattern.compile(lookForGif6).matcher(image6).replaceAll(replaceWithGif6); jpg6 = Pattern.compile(lookForJpg6).matcher(image6).replaceAll(replaceWithJpg6);%> <% Repeat6__index++; rsRandom_hasData = rsRandom.next(); } %> _<%=((rsRandom.getObject("name")!=null)?rsRandom.getObject("name"):"")%>.html"><% if(jpg6.equals("jpg")) { %>&width=60&height=60" border="0"><% } if(gif6.equals("gif")) { %>" width="60" border="0"><% } %> $<%=((rsRandom.getObject("price")!=null)?rsRandom.getObject("price"):"")%> <%=((rsRandom.getObject("name")!=null)?rsRandom.getObject("name"):"")%> Watch   FIND A WATCH SEARCH THROUGH OUR SELECTION -OR- select a brand <% while (rsBrand_hasData) { %> "><%=((rsBrand.getObject("manufacturer")!=null)?rsBrand.getObject("manufacturer"):"")%> <% rsBrand_hasData = rsBrand.next(); } rsBrand.close(); rsBrand = StatementrsBrand.executeQuery(); rsBrand_hasData = rsBrand.next(); rsBrand_isEmpty = !rsBrand_hasData; %> 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 use gasoline or extra shopping time. 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

<% rsBrand.close(); StatementrsBrand.close(); ConnrsBrand.close(); rsRandom.close(); StatementrsRandom.close(); ConnrsRandom.close(); rsNixon.close(); StatementrsNixon.close(); ConnrsNixon.close(); %>