The code is all below.
I have a repeating record (invoice) page that sorts correctly.
I want the users to be able to check a checkbox within the same form, allowing the
record to be set-aside and displayed in a persistent location (cart) when a button is
pressed.
I have added:
a button to perform the set-aside
the checkbox in the repeating area containing ID
and have created the page to display the persistent data.
How do I program the button on the sort page,
and how do I program the session logic on the set-aside(cart) page?
I want to try to perform this task using only JSP, for the cart needs to be funtioning
by week end. Thanks for any advice you can provide!
------------------------------------------------------
Invoice Page
<%@page language="java" import="java.sql.*"%>
<%@ include file="../Connections/connBeachwear.jsp" %>
<%
String rsBeachwear__varCheckbox = "1";
String rsBeachwear__showCheckbox = "no";
if (request.getParameter ("valueCheckbox") !=null) {rsBeachwear__varCheckbox =
(String)request.getParameter ("valueCheckbox") ;}
%>
<%
String rsBeachwear__name = "ID";//default sort value
if (request.getParameter ("order") !=null) {rsBeachwear__name =
(String)request.getParameter ("order");}
String rsBeachwear__sort = "ASC";//default sort value
if (request.getParameter ("sort") !=null) {rsBeachwear__sort =
(String)request.getParameter ("sort");}
String rsBeachwear__orderby ="ID";//default value
if (request.getParameter ("order") !=null) {rsBeachwear__orderby =
(String)request.getParameter("order");}
String rsBeachwear__sortby ="ASC";//default value
if (request.getParameter ("sort") !=null) {rsBeachwear__sortby =
(String)request.getParameter("sort");}
%>
<%
Driver DriverrsBeachwear =
(Driver)Class.forName(MM_connBeachwear_DRIVER).newInstance();
Connection ConnrsBeachwear =
DriverManager.getConnection(MM_connBeachwear_STRING,MM_connBeachwear_USERNAME,MM_connBeachwear_PASSWORD);
String chkValues[]=request.getParameterValues("valueCheckbox");
StringBuffer prepStr=new StringBuffer("SELECT ID, Item, Color, Size FROM Beachwear
WHERE ID=");
for(int x = 0; x < chkValues.length; ++x) {
prepStr.append(chkValues[x]);
if((x+1)<chkValues.length){
prepStr.append(" OR ID=");
}//end if
}//end for loop
prepStr.append(" ORDER BY " + rsBeachwear__name + " " + rsBeachwear__sort );
PreparedStatement
StatementrsBeachwear=ConnrsBeachwear.prepareStatement(prepStr.toString());
ResultSet rsBeachwear = StatementrsBeachwear.executeQuery();
Object rsBeachwear_data;
%>
<title>Beachwear Title</title>
<body bgcolor="#FFFFFF">
<p> </p>
<p> </p>
<p><br>
INVOICE<br>
</p>
<%//FORM "GET" METHOD<%>
<form name="form1" method="get" action="Invoice.jsp">
<p align="center">
<%
//NEW BUTTON TO SUBMIT CHECK-MARKED RECORDS TO CART: NOT SURE HOW TO CODE???
%>
<input type="submit" name="Submit2" value="Set Aside All Records Checked">
</p>
<%while(rsBeachwear.next()){ ; %>
<table width="75%" border="1">
<tr>
<td width="8%">ID:</td>
<td width="69%"><%=(((rsBeachwear_data = rsBeachwear.getObject("ID"))==null ||
rsBeachwear.wasNull())?"":rsBeachwear_data)%></td>
<td width="23%">
<% SEND-RECORD-TO-CART CHECKBOX %>
<div align="center">Set-Aside:
<input type="checkbox" name="cbSetAside" value="<%=(((rsBeachwear_data =
rsBeachwear.getObject("ID"))==null || rsBeachwear.wasNull())?"":rsBeachwear_data)%>">
</div>
</td>
</tr>
<tr>
<td width="8%">ITEM:</td>
<td colspan="2"><%=(((rsBeachwear_data = rsBeachwear.getObject("Item"))==null ||
rsBeachwear.wasNull())?"":rsBeachwear_data)%></td>
</tr>
<tr>
<td width="8%">COLOR:</td>
<td colspan="2"><%=(((rsBeachwear_data = rsBeachwear.getObject("Color"))==null
|| rsBeachwear.wasNull())?"":rsBeachwear_data)%></td>
</tr>
<tr>
<td width="8%">SIZE:</td>
<td colspan="2"><%=(((rsBeachwear_data = rsBeachwear.getObject("Size"))==null ||
rsBeachwear.wasNull())?"":rsBeachwear_data)%></td>
</tr>
<%
//TEST TO DETERMINE IF CHECKBOX ROW SHOULD BE DISPLAYED???
if (rsBeachwear__showCheckbox == "yes") { %>
<tr>
<td width="8%"> </td>
<td colspan="2">
<input type="checkbox" name="valueCheckbox" value="<%=(((rsBeachwear_data =
rsBeachwear.getObject("ID"))==null || rsBeachwear.wasNull())?"":rsBeachwear_data)%>"
checked>
</td>
</tr>
<%
}
%>
</table>
<%
}
%>
<p> </p>
<br>
<table width="54%" border="1">
<tr>
<td width="29%">
<div align="center">Parameter </div>
</td>
<td width="28%">
<div align="center">1</div>
</td>
<td width="43%">
<div align="center">2</div>
</td>
</tr>
<tr>
<td width="29%">
<div align="center">
<input type="submit" value="Sort Now">
</div>
</td>
<td width="28%">
<div align="center">
<select name="order" size="1">
<option value="ID" <% if (rsBeachwear__orderby.equals("ID"))
{out.print("selected"); } %> >ID</option>
<option value="Item" <% if (rsBeachwear__orderby.equals("Item"))
{out.print("selected"); } %> >Item</option>
<option value="Color" <% if (rsBeachwear__orderby.equals("Color"))
{out.print("selected"); } %> >Color</option>
<option value="Size" <% if (rsBeachwear__orderby.equals("Size"))
{out.print("selected"); } %> >Size</option>
</select>
</div>
</td>
<td width="43%">
<div align="center">
<select name="sort" size="1">
<option value="ASC" <% if (rsBeachwear__sortby.equals("ASC"))
{out.print("selected"); } %>>Ascending</option>
<option value="DESC" <% if (rsBeachwear__sortby.equals("DESC"))
{out.print("selected"); } %>>Descending</option>
</select>
</div>
</td>
</tr>
</table>
</form>
<%
rsBeachwear.close();
ConnrsBeachwear.close();
%>
------------------------------------------------------------
<%@page language="java" import="java.sql.*"%>
<%@ include file="../Connections/connBeachwear.jsp" %>
<%
String rsBeachwear__varCheckbox = "1";
if (request.getParameter ("valueCheckbox") !=null) {rsBeachwear__varCheckbox =
(String)request.getParameter ("cbSetAside") ;}
%>
<%
Driver DriverrsBeachwear =
(Driver)Class.forName(MM_connBeachwear_DRIVER).newInstance();
Connection ConnrsBeachwear =
DriverManager.getConnection(MM_connBeachwear_STRING,MM_connBeachwear_USERNAME,MM_connBeachwear_PASSWORD);
String chkValues[]=request.getParameterValues("cbSetAside");
StringBuffer prepStr=new StringBuffer("SELECT ID, Item, Color, Size FROM Beachwear
WHERE ID=");
for(int x = 0; x < chkValues.length; ++x) {
prepStr.append(chkValues[x]);
if((x+1)<chkValues.length){
prepStr.append(" OR ID=");
}//end if
}//end for loop
PreparedStatement
StatementrsBeachwear=ConnrsBeachwear.prepareStatement(prepStr.toString());
ResultSet rsBeachwear = StatementrsBeachwear.executeQuery();
Object rsBeachwear_data;
%>
<title>Beachwear Title</title>
<body bgcolor="#FFFFFF">
<p> </p>
<p> </p>
<p><br>
SET-ASIDE RECORDS<br>
</p>
<%//FORM "GET" METHOD <%>
<form name="form1" method="get" action="SetAside.jsp">
<p align="center">
<input type="submit" name="Submit2" value="Remove unchecked records">
</p>
<%while(rsBeachwear.next()){ %>
<table width="75%" border="1">
<tr>
<td width="8%">ID:</td>
<td width="69%"><%=(((rsBeachwear_data = rsBeachwear.getObject("ID"))==null ||
rsBeachwear.wasNull())?"":rsBeachwear_data)%></td>
<td width="23%">
<div align="center">Set-Aside:
<input type="checkbox" name="cbSetAside" value="<%=(((rsBeachwear_data =
rsBeachwear.getObject("ID"))==null || rsBeachwear.wasNull())?"":rsBeachwear_data)%>"
checked>
</div>
</td>
</tr>
<tr>
<td width="8%">ITEM:</td>
<td colspan="2"><%=(((rsBeachwear_data = rsBeachwear.getObject("Item"))==null ||
rsBeachwear.wasNull())?"":rsBeachwear_data)%></td>
</tr>
<tr>
<td width="8%">COLOR:</td>
<td colspan="2"><%=(((rsBeachwear_data = rsBeachwear.getObject("Color"))==null
|| rsBeachwear.wasNull())?"":rsBeachwear_data)%></td>
</tr>
<tr>
<td width="8%">SIZE:</td>
<td colspan="2"><%=(((rsBeachwear_data = rsBeachwear.getObject("Size"))==null ||
rsBeachwear.wasNull())?"":rsBeachwear_data)%></td>
</tr>
</table>
<%
}
%>
<p> </p>
</form>
<%
rsBeachwear.close();
ConnrsBeachwear.close();
%>
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://archives.java.sun.com/jsp-interest.html
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.jsp
http://www.jguru.com/faq/index.jsp
http://www.jspinsider.com
