product.jsp

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

<%@ page language="java" import="java.util.*" import="java.sql.*" 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 catid = request.getParameter("catid");		
%>
     			
<style type="text/css">
<!--
.style6 {font-family: Verdana, Arial, Helvetica, sans-serif; color: #9900CC; }
.style7 {color: #9900CC}
.style8 {color: #999900}
-->
</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"><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="316" border="1" cellspacing="0" bordercolor="#CCCCCC">
      <tr>
        <td height="27" colspan="2" bgcolor="#FFFFFF"><div align="center"></div>          
          <div align="center" class="style6">
            <div align="left"></div>
            </a></div><%=catid%>
          <div align="left"></div>
          <div align="left"></div></td>
        </tr>
      <tr>
        <td width="156" bgcolor="#CCCCCC"><div align="center"><span class="style6">ProductID</span></div></td>
        <td width="150" bgcolor="#CCCCCC" class="style1"><div align="center"><span class="style6">productName</span></div></td>
      </tr>
<%  try{
		Connection conn = connBean.getConnection();
		if(conn != null){
			java.sql.Statement dstmt = conn.createStatement(); 
   		 	ResultSet rs = dstmt.executeQuery("select productid,name from product where category = '"+catid+"'");
   		 	while(rs.next()){
   		 		String productId = rs.getString("productid");
   		 		String productName = rs.getString("name");
   		 		String url  ="item.jsp?productid="+productId +"&&productName="+productName;
%>
	<tr>
        <td><div align="center"><span class="style7"><%=productId%></div></td>
        <td><div align="center"><span class="style7"><a href="<%=url%>"><%= productName%></a></div></td>
      </tr>       
<%            }
    			 rs.close();
        	}
     }
    catch(Exception e){
     }
%>
      
    </table></td>
  </tr>
</table>
<%@include file="../bottom.htm"%>