📄 my_goods_management.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java"%>
<%@ page import="java.sql.*"%>
<jsp:useBean scope="page" id="books" class="mypkg.books" />
<jsp:useBean scope="page" id="goods" class="mypkg.goods" />
<%
//获取当前访问用户的用户名
String s_UserName = (String) session.getAttribute("UserName");
if(s_UserName == null)
{
s_UserName = "";
}
//获取当前访问用户的索引号
long l_UserID = (Long) session.getAttribute("UserID");
goods.setUserID(l_UserID);
//获取当前访问用户购物车中的所有信息
ResultSet rs = goods.show_goods();
%>
<!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=gb2312">
<title>欢迎光临网上书店</title>
<link rel=stylesheet type=text/css href="../lib/book.css">
</head>
<body bgcolor="#F4FFFE">
<form name="form1" method="post" action="user_form.jsp">
<label><br>
<br><div align="center">
<table width="787" height="224" cellspacing="0" cellpadding="0" border="1">
<tr bgcolor="#0066ff">
<td width="100%" height="30" align="center" colspan="6"><font color="#ffffff"><%=s_UserName%> 的购物车</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; //所有商品的总价
//循环显示所有购物信息
int i=0;
while(rs.next())
{
long l_GoodsID = rs.getLong("GoodsID");
books.setBookID(rs.getLong("BookID"));
books.init();
int i_BuyNumber = rs.getInt("BuyNumber");
//计算商品总价
total = i_BuyNumber * books.getPrice() + total;
String bookname=books.getBookName();
float price=books.getPrice();
int number=i_BuyNumber;
String author=books.getAuthor();
i=1;
%>
<tr>
<td width="25%" height="25" align="left"> <a href="book_detail.jsp?BookID=<%=books.getBookID()%>" target="_self"><font color="#0000ff"><%=bookname%></font></a></td>
<td width="15%" height="25" align="left"> <%=author%></td>
<td width="20%" height="25" align="left"> <%=books.getPub()%></td>
<td width="10%" height="25" align="left"> <%=price%></td>
<td width="15%" height="25" align="center"><%=number%><br></td>
<td width="15%" height="25" align="center"><input type="button" name="btn" value="更改数量" onclick='javascript:window.location="gai.jsp?GoodsID=<%=l_GoodsID%>"'><input type="button" name="btn" value="清除" onclick='javascript:window.location="delete_goods.jsp?GoodsID=<%=l_GoodsID%>"'></td>
</tr>
<%
}
%>
<tr>
<td height="30" align="center" colspan="6">总计：<font color="#0000ff"><%=total%></font> （RMB）
<%session.setAttribute("total",total);%>
</td>
</tr>
</table>
<p><%rs.close();%>
</p>
</div>
</label><div align="center"><label><p>
<%if(i==1)out.print("<input type=submit name=Submit value=提交购物车>");
else out.print("购物车内没有物品");%>
</p></label></div><br><div align="center"><label>
</label></div></form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -