📄 showsinglecustomerdeal.jsp
字号:
<%
/**
* Title: 商店购物管理系统的完整实现
* Description: 教学示范
* Copyright: Copyright (c) 2003
* Company: 北京师范大学计算机系
* @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的实例*/%>
<head>
<%
String customerName = new String(request.getParameter("customerName").getBytes("8859_1")); //获取指定顾客的姓名
%>
<title>查看顾客<%=customerName%>的交易</title>
</head>
<body>
<h1 align="center">顾客<%=customerName%>完成交易列表</h1>
<p>
<%
try
{
ResultSet rs = shopManageBean.getSingleDeal(customerName); //获取指定姓名的顾客的交易信息
out.println("<table width=75% border=1 align=center><tr>"); //列出指定姓名的顾客的交易信息表格的表头
out.println("<td align=center>售出产品编号</td>");
out.println("<td align=center>售出产品名称</td>");
out.println("<td align=center>售出产品数量</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 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="delSingleCustomerDeal.jsp?customerName=<%=customerName%>">
<div align="center">
<input type="submit" name="Submit" value="删除此顾客信息">
</div>
</form>
<p> </p>
<%
out.println("<p align=center><a href=customerDeal.jsp>返回</a></p>");
%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -