?? my_order.jsp
字號:
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="shopbean.ConnDB" %>
<%@ page import="java.sql.*" %>
<%
ConnDB conn = new ConnDB();
String c_name=(String)session.getAttribute("c_name");
String c_header=(String)session.getAttribute("c_header");
if(c_name=="" || c_name==null)
{
out.println("<script language='javascript'>alert('請先登錄!');window.location.href='index_.jsp';</script>");
}
try
{
String order_user="",order_id="",order_time="",order_sum="";
String sql="select order_user,order_id,order_time,order_sum from Orders where order_user='"+c_name+"'";
ResultSet rs = conn.doQuery(sql);
%>
<html>
<head>
<title>Easy Buy Online</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="CSS/style.css" rel="stylesheet">
<style type="text/css">
<!--
.STYLE1 {font-size: 12px}
.STYLE2{
font-size: 14px;
}
.STYLE9 {color: #FF0000}
a:link {
text-decoration: none;
}
a:visited {
text-decoration: none;
}
a:hover {
text-decoration: underline;
}
a:active {
text-decoration: none;
}
-->
</style>
</head>
<body>
<jsp:include page="title.jsp" flush="true"/>
<jsp:include page="menu.jsp" flush="true"/>
<center>
<table width="782" border="1" bordercolor="#99CCFF" cellspacing="0" cellpadding="0" style="border-collapse:collapse">
<!--DWLayoutTable-->
<tr>
<td width="183" align="center" valign="top"><jsp:include page="login.jsp" flush="true"/></td>
<td width="602" valign="top"><table width="100%" border="0" bordercolor="#99CCFF" style="border-collapse:collapse" cellspacing="0" cellpadding="0">
<tr>
<td height="14" colspan="5" align="center"> </td>
</tr>
<tr>
<td width="2%" height="37" align="center"> </td>
<td width="18%" height="34" align="center" bgcolor="#99CCFF" class="STYLE2"><img src="..\images/logo/order.JPG" width="55" height="35"></td>
<td width="25%" align="left" bgcolor="#99CCFF" class="STYLE2">我的訂單</td>
<td width="53%" align="center" bgcolor="#99CCFF"> </td>
<td width="2%"> </td>
</tr>
<tr>
<td colspan="5"> </td>
</tr>
<tr>
<td colspan="5">
<center>
<table width="96%" border="1" bordercolor="#99CCFF" cellpadding="0" cellspacing="0" style="border-collapse:collapse">
<!--DWLayoutTable-->
<tr>
<td width="80" height="30" align="center" bgcolor="#FFFFFF" class="STYLE2">用戶名</td>
<td width="127" align="center" bgcolor="#FFFFFF" class="STYLE2">訂單號</td>
<td width="141" align="center" bgcolor="#FFFFFF" class="STYLE2">訂單時間</td>
<td width="83" align="center" bgcolor="#FFFFFF" class="STYLE2">總金額</td>
<td width="126" align="center" bgcolor="#FFFFFF" class="STYLE2">操作</td>
</tr>
<%
String str=(String)request.getParameter("page");
if(str==null)
{
str="0";
}
int pagesize=10;
rs.last();
int recordCount=rs.getRow();
int maxPage=0;
maxPage=(recordCount%pagesize==0)?(recordCount/pagesize):(recordCount/pagesize+1);
int currentPage=Integer.parseInt(str);
if(currentPage<1)
{
currentPage=1;
}
else
{
if(currentPage>maxPage)
{
currentPage=maxPage;
}
}
rs.absolute((currentPage-1)*pagesize+1);
for(int i=1;i<=pagesize;i++)
{
order_user=rs.getString("order_user");
order_id=rs.getString("order_id");
order_time=rs.getString("order_time");
order_sum=rs.getString("order_sum");
%>
<tr>
<td height="35" align="center" class="STYLE2"><%= order_user %></td>
<td height="32" align="center" class="STYLE2"><%= order_id %></td>
<td height="32" align="center" class="STYLE2"><span class="STYLE2"><%= order_time %></span></td>
<td align="center" class="STYLE2">￥<%= order_sum %></td>
<td height="32" align="center" class="STYLE1"><span class="STYLE1">[ <a href="#" title="預覽" onClick="window.open('my_order_product.jsp?order_id=<%= order_id %>','help','scrollbars=yes,resizable=yes,width=650,height=300')">查看詳細資料</a> ]</span></td>
</tr>
<%
try
{
if(!rs.next()){break;}
}catch(Exception e){}
}
%>
<tr>
<td height="30" colspan="6" align="center"><p align="center" class="STYLE1">共 <span class="STYLE1"><%= recordCount %></span> 個記錄,分<span class="STYLE1"> <%= maxPage %> </span>顯示,當前頁<strong>:</strong> 第 <span class="STYLE1"><%= currentPage %> </span>頁
<%
for(int j=1;j<=maxPage;j++)
{
out.print(" <a href='my_order.jsp?page="+j+"'>"+j+"</a>");
}
}
catch(Exception e){}
%>
</p></td>
</tr>
</table>
</center>
<table width="100%" height="42" border="0" bordercolor="#99CCFF" align="center" cellpadding="0" cellspacing="0" style="border-collapse:collapse">
<tr align="center" valign="middle">
<td width="74%" height="21" class="tableBorder_B1"> </td>
<td width="26%" height="21" colspan="-3" align="left" class="tableBorder_B1"></td>
</tr>
<tr align="center" valign="middle">
<td height="21" colspan="2"><input type="button" class="STYLE1" value=" 返回購物 " onClick="window.location.href='index_.jsp'"/></td>
</tr>
</table> </td>
</tr>
<tr>
<td colspan="5"> </td>
</tr>
</table> </td>
</tr>
</table>
</tr>
</table>
</td>
</tr>
</table>
</center>
<br>
<jsp:include page="copyright.jsp" flush="true"/>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -