📄 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>
<%@ include file="incoming/header.jsp"%>
<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>
<%@ include file="incoming/footer.jsp"%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -