addproduct.jsp

一个JSP的登陆管理系统

<%@ page contentType="text/html; charset=gb2312" language="java" errorPage="../error.jsp" %>
<%@ page import="java.util.*,java.sql.*"%>
<%@ page import="test.bo.*,test.models.*"%>
<jsp:useBean id="cartItem" class="test.models.CartItem" scope="session"/>
<jsp:useBean id="cart"  class="test.models.Cart" scope="session"/>
<%
  test.bo.CartBO cartBO=new test.bo.CartBO();

  String itemId=(String)request.getParameter("itemId");
  String sql="select product.productid as productid,product.name as name,"+
  "item.listprice as listprice,item.unitcost as unitcost,item.itemid as itemid,item.supplier  as supplier,"+
  "item.status as status,item.attr1 as attr1,item.attr2 as attr2,item.attr3 as attr3,item.attr4 as attr4,item.attr5 as attr5 "+
  "from product as product,item as item where product.productid=item.productid  and item.itemid='"+itemId+"'";
   Item temp=cartBO.getCartItem(sql);
   cart.addItem(temp,true);
   response.sendRedirect("viewCart.jsp");
%>