📄 myorder.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage=""%>
<jsp:useBean id="conndb" scope="page" class="beans.connDB"/>
<jsp:useBean id="chstr" scope="page" class="beans.chStr"/>
<HTML>
<HEAD>
<TITLE>Site Title</TITLE>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=gb2312">
<style type="../../web/text/css">
<!--
@import url("../../web/css_link.css");
@import url("../../web/text.css");
@import url("../../web/css_link.css");
-->
</style>
</HEAD>
<BODY BGCOLOR=#FFFFFF LEFTMARGIN=0 TOPMARGIN=0 MARGINWIDTH=0 MARGINHEIGHT=0>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="334" valign="top">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="189" height="334" valign="top" background="../../web/images/side_back.jpg">
<table width="100%" height="516" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="516" valign="top" background="../../web/images/home_side.jpg">
</td>
</tr>
</table></td>
<td valign="top" bgcolor="#FFFFFF"><br>
<br>
<%int orderID=0;
String submitdate="";
String carry="";
String pay="";
String status="";
String executedate="";
ResultSet rs=conndb.executeQuery("select * from orderdata where username='"+session.getAttribute("Username")+"'");
if(!(rs.next())){
%>
<table width="100%">
<tr bgcolor="E0E0E0" valign="top">
<td bgcolor="E0E0E0" align="center"><font size="2"><%out.println("您没有提交的定单");%></font></td>
</tr>
<tr bgcolor="E0E0E0" valign="top">
<td bgcolor="E0E0E0"><div align="center">
<input name="submit" type="button" value="确定" onClick="history.back(1);">
</div></td>
</tr>
</table>
<%}else{%>
<table width="100%" border="0" cellspacing="1" cellpadding="1" align="center">
<tr valign="middle">
<td width="117" >
<div align="center"><font size="2"><strong>定单号</strong></font></div></td>
<td width="154">
<div align="center"><font size="2"><strong>提交时间</strong></font></div></td>
<td width="133">
<div align="center"><font size="2"><strong>运送方式</strong></font></div></td>
<td width="130">
<div align="center"><font size="2"><strong>付款方式</strong></font></div></td>
<td width="101">
<div align="center"><font size="2"><strong>状态</strong></font></div></td>
<td width="150">
<div align="center"><font size="2"><strong>发货时间</strong></font></div></td>
</tr>
<%do
{orderID=rs.getInt("orderID");
submitdate=rs.getString("submitdate");
carry=rs.getString("carry");
pay=rs.getString("pay");
status=rs.getString("status");
executedate=rs.getString("executedate");
%>
<tr bgcolor="E0E0E0" valign="middle">
<td height="22" bgcolor="E0E0E0">
<div align="center"><a href="myorder_detail.jsp?ID=<%=orderID%>"><font size="2"><%=orderID%></font></a></div></td>
<td bgcolor="E0E0E0">
<div align="center"><font size="2"><%=submitdate%></font></div></td>
<td bgcolor="E0E0E0">
<div align="center"><font size="2"><%=carry%></font></div></td>
<td bgcolor="E0E0E0">
<div align="center"><font size="2"><%=pay%></font></div></td>
<td bgcolor="E0E0E0">
<div align="center"><font size="2"><%=status%></font></div></td>
<td bgcolor="E0E0E0">
<div align="center"><font size="2"><%=executedate%></font></div></td>
</tr>
<%}while(rs.next());}%>
</table>
</td>
</tr>
</table></td>
</tr>
</table>
<div align="center"></div>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="1%" height="19" valign="top" background="../../web/images/link_bar_hold.jpg"><img src="../../web/images/link_bar_hold.jpg" width="9" height="23"></td>
<td width="99%" background="../../web/images/link_bar_hold.jpg"><div align="center">:
<a href="#">License Agreemen</a>t : <a href="#">Jobs</a> : <a href="#">Site
Map</a> :</div></td>
</tr>
</table>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" bordercolor="#000000">
<tr>
<td height="34" bgcolor="#000000"><div align="center">
<p class="smWhite">2003 Copyright Information or webmaster information</p>
</div></td>
</tr>
</table>
</BODY>
</HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -