viewcatalog.jsp

来自「一个用MYECLIPSE开发的网上购物系统。 基本功能都已经实现」· JSP 代码 · 共 55 行

<%@ 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");
	}			
%>
     			
<style type="text/css">
<!--
.style6 {font-family: Verdana, Arial, Helvetica, sans-serif; color: #9900CC; }
.style7 {color: #9900CC}
-->
</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"><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 width="156" bgcolor="#CCCCCC"><div align="center"><span class="style6">catalogId</span></div></td>
        <td width="150" bgcolor="#CCCCCC" class="style1"><div align="center" class="style6">name</a></div></td>
      </tr>
<%  try{
		Connection conn = connBean.getConnection();
		if(conn != null){
			java.sql.Statement dstmt = conn.createStatement(); 
   		 	ResultSet rs = dstmt.executeQuery("select catid,name from category");
   		 	while(rs.next()){
   		 		String catid = rs.getString("catid");
   		 		String url  ="product.jsp?catid="+catid;
%>
	<tr>
        <td><div align="center"><span class="style7"><%=catid%></div></td>
        <td><div align="center"><span class="style7"><a href="<%=url%>"><%= rs.getString("name")%></a></div></td>
      </tr>       
<%            }
    			 rs.close();
        	}
     }
    catch(Exception e){
     }
%>
      
    </table></td>
  </tr>
</table>
<%@include file="../bottom.htm"%>