viewproductbycategory.jsp

网上购物系统,相信看后会有很大收获,用java,jsp,servlet编写

<%@ page contentType="text/html; charset=GBK" language="java" errorPage="../error.jsp" %>
<%@ page import="java.util.*,java.sql.*"%>
<%@ page import="test.bo.*,test.models.*"%>
<jsp:useBean id="cartBO" class="test.bo.CartBO" scope="page"/>

<%
 //request.setCharacterEncoding("gbk");
  String catid=request.getParameter("catid");
  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 from product as product,"+
  "item as item where product.category='"+ catid +"'"+
  " and product.productid=item.productid and item.status='1'";

  Collection temp=null;
  try{
    temp=cartBO.searchItem(sql);
  }
   catch(Exception e){}
   Iterator it=temp.iterator();
%>
 <table align="center" bgcolor="#008800" border="0" cellspacing="2" cellpadding="5">
        <tr bgcolor="#cccccc">
         <td align="center"><b>名称 </b></td>
         <td align="center"><b>价格 </b></td>
         <td align="center"><b>会员价格 </b></td>
         <td align="center"><b>出版社 </b></td>
         <td align="center"><b>详细信息 </b></td>
         <td align="center"><b>放入购物车 </b></td>
    </tr>
  <%
  while(it.hasNext())
   {
     Item item=(Item)it.next();

     try{
        out.println("<tr><td align='center' bgcolor='#E1F5FF' width='20%'>"+item.getProduct().getName()+"</td>");
        out.println("<td align='center' bgcolor='#E1F5FF' width='20%'>"+item.getListPrice()+"</td>");
        out.println("<td align='center' bgcolor='#E1F5FF' width='20%'>"+item.getUnitCost()+"</td>");
        out.println("<td align='center' bgcolor='#E1F5FF' width='20%'>"+item.getSupplier()+"</td>");
        %>
        <td align='center' bgcolor='#E1F5FF' width='10%'><a href="<%=request.getContextPath()%>/shop/viewProduct.jsp?productId=<%=item.getProductId()%>">查看</a></td>
        <td align='center' bgcolor='#E1F5FF' width='10%'><a href="<%=request.getContextPath()%>/shop/addProduct.jsp?itemId=<%=item.getItemId()%>">添加</a></td></tr>
        <%
      }
      catch(Exception e)
      {
           e.printStackTrace();
      }
    }
    %>
</table>