?? cust_select_order.jsp
字號:
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="shopBeans.ConnDB" %>
<%@ page import="java.sql.*" %>
<%
ConnDB conn = new ConnDB();
String c_name=request.getParameter("c_name");
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);
if(rs.next())
{
%>
<style type="text/css">
<!--
.STYLE1 {font-size: 12px}
.STYLE2 {font-size: 14px}
a:link {
text-decoration: none;
}
a:visited {
text-decoration: none;
}
a:hover {
text-decoration: underline;
}
a:active {
text-decoration: none;
}
-->
</style>
<center>
<table width="520" border="1" bordercolor="#99CCFF" cellpadding="0" cellspacing="0" style="border-collapse:collapse">
<!--DWLayoutTable-->
<tr>
<td width="66" height="30" align="center" bgcolor="#99CCFF" class="STYLE2">用戶名</td>
<td width="94" align="center" bgcolor="#99CCFF" class="STYLE2"><span class="STYLE2">訂單號</span></td>
<td width="95" align="center" bgcolor="#99CCFF" class="STYLE2"><span class="STYLE2">訂單時間</span></td>
<td width="77" align="center" bgcolor="#99CCFF" class="STYLE2"><span class="STYLE2">總金額</span></td>
<td colspan="2" align="center" bgcolor="#99CCFF" class="STYLE2"><span class="STYLE2">操作</span></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="STYLE1"><%= order_user %></td>
<td height="32" align="center" class="STYLE1"><%= order_id %></td>
<td height="32" align="center" class="STYLE1"><span class="STYLE1"><%= order_time %></span></td>
<td align="center" class="STYLE1"><%= order_sum %></td>
<td width="107" height="32" align="center" class="STYLE1"><span class="STYLE1">[ <a href="order_view.jsp?order_id=<%= order_id %>">查看詳細資料</a> ]</span></td>
<td width="67" align="center" class="STYLE1"><span class="STYLE1">[ <a href="order_delete.jsp?order_id=<%= order_id %>">刪除</a> ]</span></td>
</tr>
<%
try
{
if(!rs.next()){break;}
}catch(Exception e){}
}
%>
<tr>
<td height="30" colspan="7" 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='cust_select_order.jsp?page="+j+"'>"+j+"</a>");
}
%>
</p></td>
</tr>
</table>
</center>
<%
conn.closeConnection();
}
else
out.println( "<HTML><HEAD><META http-equiv='refresh' content='1; URL=cust_all.jsp' target=Main></HEAD><BODY bgcolor='#FFFFFF'><center><font size=4pt color='red'>" + "沒有任何數據..." + "</font></center></body></html>");
%>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -