📄 myshop.jsp
字号:
<%@ page contentType="text/html;charset=gb2312" %>
<%@ include file="incoming/common.jsp"%>
<%@ include file="incoming/check.jsp"%>
<html>
<head>
<title>网上书店</title>
<link href="incoming/style.css" rel="stylesheet" type="text/css">
</head>
<body>
<div align="center">
<table width="700" border="1" cellpadding="0" cellspacing="0" bordercolor="#CCCCCC">
<tr>
<td height="87" align="center"><br>
<img src="images/bookhead.jpg" width="700" height="110"> </td>
</tr>
</table>
<table width="700" border="1" cellpadding="0" cellspacing="0" bordercolor="#CCCCCC">
<tr>
<td width="164"><div align="center"><a href="index.jsp">首页</a></div></td>
<td width="224"><div align="center"><a href="booklist.jsp">在线购书</a></div></td>
<td width="304" align="right"><div align="center"><a href="shopcar.jsp">我的购物车</a> </div> <div align="center"></div></td>
<td width="304" align="right"><div align="center"><a href="myshop.jsp">我的订单</a></div></td>
<td width="304" align="right"><div align="center"><a href="admin/login.jsp">网站管理</a></div></td>
<td width="304" align="right"><div align="center">当前日期:<%=dateString%></div></td>
</tr>
</table>
<table width="700" border="1" cellpadding="0" cellspacing="0" bordercolor="#CCCCCC">
<tr>
<td width="148" height="285"><table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="#CCCCCC">
<tr>
<td height="40"><div align="center"><a href="userinfo.jsp">查看个人信息</a></div></td>
</tr>
<tr>
<td height="50"><div align="center"><a href="modifyuserinfo.jsp">修改个人信息</a></div></td>
</tr>
</table></td>
<td width="546" valign="top"><div align="center">
<p> </p>
<br>
<a class="title">您的订单</a><br>
<%
String userid=(String)session.getValue("userid");
String sql = "SELECT * FROM myorder WHERE USER_ID='"+userid+"'";
DBSQLManager dbsm = new DBSQLManager();
dbsm.setSqlStr(sql);
dbsm.executeQuery();
ResultSet rs = dbsm.getRs();
%>
<table width="80%" height="48" border="1" cellpadding="1" cellspacing="1">
<tr>
<td width="120" height="24"><div align="center">订单号</div></td>
<td width="71"><div align="center">金额</div></td>
<td width="156"><div align="center">订单日期</div></td>
<td width="70"><div align="center">详情</div></td>
</tr>
<% while(rs.next())
{
%>
<tr>
<td height="22"><div align="center"><%=rs.getString("ORDER_ID")%></div></td>
<td><div align="center"><%=rs.getFloat("PRICE_NUM")%></div></td>
<td><div align="center"><%=rs.getString("ORDER_DATE")%></div></td>
<td><div align="center"><a href="orderitem.jsp?orderid=<%=rs.getString("ORDER_ID")%>">查看</a></div></td>
</tr>
<%}%>
</table>
</div></td>
</tr>
</table>
<hr width="700">
<table width="700" border="0" cellspacing="2" cellpadding="2">
<tr>
<td align="center" bgcolor="#CCCCCC">峰杰工作技术中心<br>
CopyRight@2006<br>
Email:<a href="mailto:zfno1@163.com">zfno1@163.com</a></td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -