📄 productsold.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>
<title>查看售出商品</title>
</head>
<body>
<h1 align="center">售出商品列表</h1>
<p>
<%
try
{
ResultSet rs = shopManageBean.getProductSold(); //获取售出商品信息
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 productPrice = rs.getString("product_price");
String sellNumber = rs.getString("sell_number");
String sellProfit = rs.getString("sell_profit");
out.println("<tr>");
out.println("<td align=center>" + productID + "</td>");
out.println("<td align=center>" + productName + "</td>");
out.println("<td align=center>" + productPrice + "</td>");
out.println("<td align=center>" + sellNumber + "</td>");
out.println("<td align=center>" + sellProfit + "</td>");
out.println("</tr>");
}
out.println("</table>");
}
catch(Exception ex) //捕捉异常
{
ex.printStackTrace();
}
%>
</p>
<form name="form1" method="post" action="delSoldProduct.jsp">
<div align="center">请输入商品编号：
<input type="text" name="productID">
<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=customerDeal.jsp>处理用户购买表</a></p>");
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -