item.jsp

一个用MYECLIPSE开发的网上购物系统。 基本功能都已经实现

<%@ page language="java" import="java.util.*" import="java.sql.*" 
import="db.Cart"
contentType="text/html;charset=gb2312" %>
<%request.setCharacterEncoding("gb2312");%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%@include file="../header.htm"%>
<jsp:useBean id = "connBean" scope="page" class="db.DbAccess"/>
<% if(session.isNew()){
	response.sendRedirect("../default.jsp");
	}	
	String productId = request.getParameter("productid");	
	String productName = request.getParameter("productName");
%>
     			
<style type="text/css">
<!--
.style6 {font-family: Verdana, Arial, Helvetica, sans-serif; color: #9900CC; }
.style7 {color: #9900CC}
.style10 {font-size: 12px}
-->
</style>

<table width="100%" border="0">
  <tr>
    <td width="21%" height="187"><p align="center"><a href="../cart/cart.jsp"><img src="../images/index_n_06.gif" width="78" height="34" border="0"></a></p>
    <p align="center" class="style1"><span class="style7"><a href="viewCatalog.jsp" class="style7">mainPage</a></span></p>
    <p align="center" class="style1"><a href="../sign/signout.jsp" class="style7">signout</a></p></td>
    <td width="79%"><table width="484" border="1" cellspacing="0" bordercolor="#CCCCCC">
      <tr>
        <td height="27" colspan="4" bgcolor="#FFFFFF"><div align="center"></div>          
          <div align="center" class="style6">
            <div align="left"></div>
            </a></div><%=productName%>
          <div align="left"></div>
          <div align="left"></div></td>
        </tr>
      <tr>
        <td width="99" bgcolor="#CCCCCC"><div align="center"><span class="style6">Item ID </span></div></td>
        <td width="145" bgcolor="#CCCCCC" class="style1"><div align="center"><span class="style6">Item Name</span></div></td>
        <td width="106" bgcolor="#CCCCCC" class="style6"><div align="center">Item Price </div></td>
        <td width="116" bgcolor="#CCCCCC" class="style1">&nbsp;</td>
      </tr>
<%  try{
		Connection conn = connBean.getConnection();
	
		if(conn != null){
			java.sql.Statement dstmt = conn.createStatement(); 
   		 	ResultSet rs = dstmt.executeQuery("select itemid,attr1,listprice from item where productid = '"+productId+"'");
   		 	while(rs.next()){
   		 		String itemId = rs.getString("itemid");
   		 		String name = rs.getString("attr1");
   		 		double listprice = rs.getDouble("listprice");
   		 		String url = "../cart/cart-item.jsp?itemid="+itemId+"&&price="+listprice+"&&name="+name +" "+productName;
%>
	<tr>
        <td><div align="center"><span class="style7"><%=itemId%></div></td>
        <td><div align="center"><span class="style7"><%= name+" "+productName%></div></td>
        <td><div align="center"><span class="style7"><%= listprice%></div></td>
        <td><div align="center" class="style6 style10"><a href=<%= url%> >Add to Cart </a></div></td>
	</tr>       
<%            }
    			 rs.close();
        	}
     }
    catch(Exception e){
     }
%>
      
    </table></td>
  </tr>
</table>
<%@include file="../bottom.htm"%>