%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*, java.util.regex.*, java.util.Random, java.util.Map, java.util.LinkedHashMap" errorPage="" %><%@ taglib prefix="c" uri="http://java.sun.com/jstl/core" %><%@ 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/snowboardBindings.jsp" %><%
String brand = "Salomon";
if (request.getParameter("brand") !=null) {brand = (String)request.getParameter("brand") ;}
Driver DriverrsSearch = (Driver)Class.forName(MM_snowboardBindings_DRIVER).newInstance();
Connection ConnrsSearch = DriverManager.getConnection(MM_snowboardBindings_STRING,MM_snowboardBindings_USERNAME,MM_snowboardBindings_PASSWORD);
PreparedStatement StatementrsSearch = ConnrsSearch.prepareStatement("SELECT * FROM products where c06 = 'snowboard bindings' and manufacturer = '" + brand + "'");
ResultSet rsSearch = StatementrsSearch.executeQuery();
boolean rsSearch_isEmpty = !rsSearch.next();
boolean rsSearch_hasData = !rsSearch_isEmpty;
Object rsSearch_data;
int rsSearch_numRows = 0;
Object currCategory;
int fourCount = 0;
%>
<%
Driver DriverrsTop1 = (Driver)Class.forName(MM_snowboardBindings_DRIVER).newInstance();
Connection ConnrsTop1 = DriverManager.getConnection(MM_snowboardBindings_STRING,MM_snowboardBindings_USERNAME,MM_snowboardBindings_PASSWORD);
PreparedStatement StatementrsTop1 = ConnrsTop1.prepareStatement("SELECT * FROM products WHERE c06 = 'snowboard bindings' and manufacturer = '" + brand + "' order by price desc limit 1");
ResultSet rsTop1 = StatementrsTop1.executeQuery();
boolean rsTop1_isEmpty = !rsTop1.next();
boolean rsTop1_hasData = !rsTop1_isEmpty;
Object rsTop1_data;
int rsTop1_numRows = 0;
int Repeat1__numRows = 21;
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(request.getRequestURI()).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;
}
%>
Welcome to snowboard-bindings.net
- Here you can find a collection of top notch snowboard shops
and where to buy snowboard bindings online. Find discount prices,
closeouts, gear on sale, plus snowboard binding reviews by people
who have actually used the equipment from salomon snowboard bindings,
ride, k2, burton and flow.
Click on these links to launch the more pages about
snowboard bindings
Salomon bindings - SP3 model are their fully featured bindings
with Salomon's trademark performance and durability.
The new SP3 salomon snowboard bindings include an all-new,
lighter, stiffer SensiShaped(tm) composite highback with
grip-pads on the wing for efficient lateral support. Salomon
made these with a generous forward lean -- 8 to 35 degrees
-- for a fully personalized response.
The Salomon SP3 bindings do more than get the job done.
A light weight, comfortable, workhorse set of bindings
at a modest price.
Salomon Bindings Review
I've been riding with the salomon sp3 bindings for about
3 years now. I use them on my 162.5 sequence snowboard.
I freeride mostly, but I like to ride the pipe a bit
and the park when it's not packed out. These Salomon
Snowboard Bindings allow for plenty of adjustment, so
you can tailor them to your specific needs. The salomon
snowboard bindings straps are convenient, comfortable
and very easy to strap on. The straps are fat and cushy,
comfortable to ride in all day long. No tools required.
The salomon buckles are smooth and easy to use. Easy
to strap into from a standing position with one hand.
The ratchets work perfect. These highly recommend these
salomon snowboard bindings because they are easy to
get in and out of. The salomon sp3 is a great lightweight
and responsive binding.