Here is the class for the cart -
import java.util.*;
import javax.servlet.http.HttpServletRequest;
public class ShoppingBasket extends Object {
private Vector basket = null;
String product = null;
String submit = null;
float price = 0;
public ShoppingBasket() {
basket = new Vector();
}
public void setProduct(String product) {
this.product = product;
}
public void setPrice(float price) {
this.price = price;
}
public void setSubmit(String submit) {
this.submit = submit;
}
public Vector getProducts() {
return basket;
}
public float getPrice() {
return price;
}
public void addProduct(String product) {
basket.add(product);
}
public void removeProduct(String product) {
basket.remove(product);
}
public void processRequest(HttpServletRequest req) {
if(submit!=null) {
if(submit.equals("Add")) {
addProduct(product);
}
else if(submit.equals("remove")) {
removeProduct(product);
}
reset();
}
}
public void reset() {
submit = null;
product = null;
}
}
**
The JSP page using it is like this -
//Uses parameters passed from previous page
String product = request.getParameter("product");
String submit = request.getParameter("submit");
if ( (product!=null) && (submit!=null) ) {
%>
<jsp:useBean id="basket" scope="session" class="catalogue.ShoppingBasket"/>
<jsp:setProperty name="basket" property="*"/>
<% basket.processRequest(request);
%>
Vector products = basket.getProducts();
for(int i=0;i<products.size();i++) {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection(dbURL,"","");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM CD WHERE title LIKE '"+ product + "'");
while (rs.next()) {
float price = rs.getFloat("price");
%>
<tr>
<td align="center" width="130"><font color="black" face="tahoma" size="2"><%=products.get(i)%> </td>
<td align="center" width="80"><font color="black" face="tahoma" size="2">� <%=basket.getPrice()%></td>
<td align="center" width="80"><input type=text name="quantity" size="2"></td>
<td align="center" width="60"><font color="black" face="tahoma" size="2"><a href="Purchase.jsp?product=<%=products.get(i)%>&submit=remove"
style="text-decoration: none">
<font color="darkblue">Remove</font></a></font>
</td>
</tr>
<%
}
}
if (products.size() == 0) {
%>
</table>
<br>
<font color="black" face="Tahoma"><b> Your basket is currently empty</b></font>
<%
}
%>
</table>
<%
}
%>
Any help?