📄 myshop.jsp
字号:
<%@ page contentType="text/html;charset=gb2312" %>
<html>
<head>
<title>-- 我的信息 -- 音乐天堂 --</title>
<style type="text/css">
<!--
body {
background-image: url(../IMAGES/bg01.gif);
}
.style9 {
font-size: 12pt;
font-weight: bold;
}
.style11 {font-size: 14px}
-->
</style>
<link href="../theme/style.css" rel="stylesheet" type="text/css">
</head>
<body>
<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="../User/userinfo.jsp">查看个人信息</a></div></td>
</tr>
<tr>
<td height="50"><div align="center"><a href="../User/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>
</body>
</html>
<!--点击“leftlogged.jsp”中的“我的信息”后将出现此页面-->
<!--点击“确定购买”后将出现“checkout.jsp”页面-->
<!--点击“查看”后将出现“orderitem.jsp”页面-->⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -