?? customerdeal.jsp
字號(hào):
<%
/**
* Title: 商店購(gòu)物管理系統(tǒng)的完整實(shí)現(xiàn)
* Description: 教學(xué)示范
* Copyright: Copyright (c) 2003
* Company: 北京師范大學(xué)計(jì)算機(jī)系
* @author 孫一林
* @version 1.0
*/
%>
<%@ page contentType="text/html; charset=GBK" %>
<html>
<%@ page import="java.sql.*"%>
<jsp:useBean id="shopManageBean" scope="session" class="shopmanagesystem.shopManageSystemBean"/> <%/*使用shopManageSystemBean的實(shí)例*/%>
<head>
<title>查看完成的交易</title>
</head>
<body>
<h1 align="center">完成交易列表</h1>
<p>
<%
try
{
ResultSet rs = shopManageBean.getDealInfo(); //獲取所有顧客交易信息
out.println("<table width=75% border=1 align=center><tr>"); //列出顧客交易表格的表頭
out.println("<td align=center>售出產(chǎn)品編號(hào)</td>");
out.println("<td align=center>售出產(chǎn)品名稱</td>");
out.println("<td align=center>售出產(chǎn)品數(shù)量</td>");
out.println("<td align=center>顧客姓名</td>");
out.println("<td align=center>顧客地址</td>");
out.println("</tr>");
while(rs.next()) //列出顧客交易信息
{
String productID = rs.getString("product_id");
String productName = rs.getString("product_name");
String buyNumber = rs.getString("buy_number");
String customerName = rs.getString("customer_name");
String customerAddress = rs.getString("customer_address");
out.println("<tr>");
out.println("<td align=center>" + productID + "</td>");
out.println("<td align=center>" + productName + "</td>");
out.println("<td align=center>" + buyNumber + "</td>");
out.println("<td align=center>" + customerName + "</td>");
out.println("<td align=center>" + customerAddress + "</td>");
out.println("</tr>");
}
out.println("</table>");
}
catch(Exception ex) //捕捉異常
{
ex.printStackTrace();
}
%>
</p>
<form name="form1" method="post" action="showSingleCustomerDeal.jsp">
<div align="center">請(qǐng)輸入顧客姓名：
<input type="text" name="customerName">
<input type="submit" name="Submit" value="查詢">
</div>
</form>
<p> </p>
<%
out.println("<p align=center><a href=productList.jsp>處理貨物信息表</a></p>");
out.println("<p align=center><a href=productSold.jsp>處理貨物售出表</a></p>");
%>
</body>
</html>?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -