%@ 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;
%>
Watch Store - Compare Prices on Watches by Nixon, Fossil, Gucci and More
CHECK
OUT THE NIXON WATCHES SELECTION!! -
<%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();
}
%>
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();
}
%>
FIND A WATCH
SEARCH THROUGH OUR SELECTION
-OR-
COMPARE PRICES FROM THESE
TOP ONLINE WATCH SHOPS
Watchzone.com
BackcountryStore.com
USOUTDOOR.com
Fossil.com
CompUSA.com
POPULAR BRANDS
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.
<%
rsBrand.close();
StatementrsBrand.close();
ConnrsBrand.close();
rsRandom.close();
StatementrsRandom.close();
ConnrsRandom.close();
rsNixon.close();
StatementrsNixon.close();
ConnrsNixon.close();
%>