📄 goods_management.jsp
字号:
<%@ page contentType="text/html; charset=UTF-8" language="java"%>
<%@ page import="java.sql.*"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>欢迎光临网上商城</title>
<link rel=stylesheet type=text/css href="./lib/ware.css">
<jsp:useBean scope="page" id="Ware" class="com.wssd.Ware" />
<jsp:useBean scope="page" id="Sort" class="com.wssd.Sort" />
<jsp:useBean scope="page" id="Goods" class="com.wssd.Goods" />
</head>
<body bgcolor="#F4FFFE">
<% request.setCharacterEncoding("UTF-8");
//获取当前访问用户的用户名
String sUserName = (String) session.getAttribute("UserName");
//获取当前访问用户的索引号
long lUserID = (Long) session.getAttribute("UserID");
Goods.setUserID(lUserID);
//获取当前访问用户购物车中的所有信息
ResultSet rs = Goods.show_my_goods();
%>
<div align="center">
<table width="90%" cellpadding="0" cellspacing="0" border="1">
<tr bgcolor="#0066FF">
<td width="100%" height="30" align="center" colspan="6"><font color="#FFFFFF"><%=sUserName%> 的购物车</font></td>
</tr>
<tr>
<td width="25%" height="25" align="center"><font color="#0000FF">商品名称</font></td>
<td width="15%" height="25" align="center"><font color="#0000FF">商品产地</font></td>
<td width="20%" height="25" align="center"><font color="#0000FF">生产厂家</font></td>
<td width="10%" height="25" align="center"><font color="#0000FF">价格</font></td>
<td width="15%" height="25" align="center"><font color="#0000FF">购买数量</font></td>
<td width="15%" height="25" align="center"><font color="#0000FF">从购物车中清除</font></td>
</tr>
<%
float total = 0; //所有商品的总价
//循环显示所有购物信息
while(rs.next())
{
long lGoodsID = rs.getLong("GoodsID");
Ware.setWareID(rs.getLong("WareID"));
Ware.init();
int iBuyNumber = rs.getInt("BuyNumber");
//计算商品总价
total = iBuyNumber * Ware.getPrice() + total;
%>
<tr>
<td width="25%" height="25" align="left"> <a href="ware_detail.jsp?WareID=<%=Ware.getWareID()%>" target="_self"><font color="#0000FF"><%=Ware.getWareName()%></font></a></td>
<td width="15%" height="25" align="left"> <%=Ware.getCompany()%></td>
<td width="20%" height="25" align="left"> <%=Ware.getAddr()%></td>
<td width="10%" height="25" align="left"> <%=Ware.getPrice()%></td>
<td width="15%" height="25" align="center"><%=iBuyNumber%></td>
<td width="15%" height="25" align="center"><input type="button" name="btn" value="清除" onClick='javascript:window.location="delete_goods.jsp?GoodsID=<%=lGoodsID%>"'></td>
</tr>
<%
}
%>
<tr>
<td height="30" align="center" colspan="6">总计：<font color="#0000FF"><%=total%></font> （RMB）</td>
</tr>
</table>
<%rs.close();%>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -