?? subpass.jsp
字號:
<%@ page contentType="text/html;charset=GBK" language="java" import="java.sql.*" errorPage="" %>
<jsp:useBean id="mdb" class="ckstudio.db.mysqlconn" scope="page"/>
<%
if(session.getAttribute("user_name")==null){%><br>1.你尚未登錄!請登錄后再訂購本站商品!<br>2.第一次來本站，請先注冊會員（免費）!<br><br>
<%}else{
%>
<link href="css.css" rel="stylesheet" type="text/css">
<script>
function openbag(id) { window.open("submore.jsp?sub_id="+id,"","height=400,width=600,left=190,top=0,resizable=yes,scrollbars=yes,status=no,toolbar=no,menubar=no,location=no");}
</script><head>
<title>訂單列表</title>
<link href=css.css rel=STYLESHEET type=text/css>
</head>
<table border="0" width="100%" cellspacing="0" style="border-collapse: collapse" cellpadding="0">
<tr>
<td width="100%" colspan="4">
<img border="0" src="img/promo_list_top.gif" width="100%" height="4"></td>
</tr>
<tr>
<td width="100%" colspan="4" bgcolor="#989DA5" height="25" align="center">
<b><font color="#FF0000">未處理訂單 </font> <a href="submitsub.jsp"><font color="#FFFFFF">點擊查看已處理訂單</font></a></b></td>
</tr>
<%!
boolean IsInt(String NInt)
{
try {
int n;
n=Integer.parseInt(NInt);
return true;
}
catch(NumberFormatException e){
return false;
}
}
%>
<%String mypage;
int intpage=1;
mypage=request.getParameter("page");
if(mypage=="")
intpage=1;
if(!IsInt(mypage))
intpage=1;
if(IsInt(mypage))
intpage=Integer.parseInt(mypage);
if(intpage<1)
intpage=1;
mypage=Integer.toString(intpage);
String sql;
sql="select * from sub where user_name='"+session.getValue("user_name")+"' and sub_check='false'";
ResultSet rs;
rs=mdb.executeQuery(sql);
if(!rs.next())
out.print("暫且沒有任何訂單");
else{
int PageSize =10; //設置每張網頁顯示兩條記錄
int ShowPage = 1; //設置欲顯示的頁數
int RowCount = 0; //ResultSet的記錄數目
int PageCount = 0; //ResultSet分頁后的總頁數
int duoyu=0;
//建立ResultSet(結果集)對象，并執行SQL語句
rs.last(); //將指標移至最后一筆記錄
RowCount=rs.getRow();
duoyu=RowCount % PageSize;
if(duoyu==0)
{
PageCount=RowCount/PageSize;
}
else{
PageCount=(RowCount-duoyu)/PageSize;
PageCount++;
}
// PageCount=((RowCount % PageSize) == 0?(RowCount/PageSize) : (RowCount/PageSize)+1);
//計算顯示的頁數
//String ToPage = request.getParameter("ToPage");
//if(ToPage==""){ToPage="1";}
//判斷是否可正確取得ToPage參數,
//可取得則表示JSP網頁應顯示特定分頁記錄的語句
//if(ToPage!=""){
ShowPage=intpage; //取得指定顯示的分頁頁數
//下面的if語句將判斷用戶輸入的頁數是否正確
if(ShowPage>PageCount)
{ //判斷指定頁數是否大于總頁數, 是則設置顯示最后一頁
ShowPage=PageCount;
}
else if(ShowPage<=0)
{ //若指定頁數小于0, 則設置顯示第一頁的記錄
ShowPage = 1;
}
rs.absolute((ShowPage - 1) * PageSize + 1);
//計算欲顯示頁的第一筆記錄位置
/**
rs.pagesize=10
totalrec=rs.recordcount
totalpage=rs.pagecount
if page>totalpage then page=totalpage
rs.absolutepage=page
rs.cachesize=rs.pagesize
i=0
dim sub_id(),user_name(),sub_number(),sub_adds(),sub_date()
do while not rs.eof and (i<rs.pagesize)
i=i+1
redim preserve sub_id(i),user_name(i),sub_number(i),sub_adds(i),sub_date(i)
sub_id(i)=rs("sub_id")
user_name(i)=rs("user_name")
sub_number(i)=rs("sub_number")
sub_adds(i)=rs("sub_adds")
sub_date(i)=rs("sub_date")
rs.movenext
loop
rs.close
**/
%>
<tr>
<td width="100%" colspan="4" bgcolor="#ECECEC" height="20">共<font color=red><%=PageCount%></font>頁 第<%=intpage%>頁
<font color=666666><%if(intpage-1>0){%><a href="subpass.jsp?page=<%=intpage-1%>">上一頁</a><%}else{%>上一頁<%}%><%if (intpage+1<=PageCount){%><a href="subpass.jsp?page=<%=intpage+1%>">下一頁</a><%}else{%>下一頁</font><%}
%></td>
</tr>
<tr>
<td width="25%" bgcolor="#ECECEC" height="20">訂單號</td>
<td width="25%" bgcolor="#ECECEC" height="20">訂貨人</td>
<td width="25%" bgcolor="#ECECEC" height="20">地址</td>
<td width="25%" bgcolor="#ECECEC" height="20">日期</td>
</tr>
<%int i=1;
rs.previous();
while(rs.next()&&i<=PageSize){
i++;
int sub_id=rs.getInt("sub_id");
String sub_number=rs.getString("sub_number");
String user_name=rs.getString("user_name");
String sub_adds=rs.getString("sub_adds");
Date sub_date=rs.getDate("sub_date");
%>
<tr>
<td width="25%" bgcolor="#ECECEC" height="20"><a href='javascript:openbag(<%=sub_id%>)'><%=sub_number%></a> </td>
<td width="25%" bgcolor="#ECECEC" height="20"><%=user_name%> </td>
<td width="25%" bgcolor="#ECECEC" height="20"><%=sub_adds%> </td>
<td width="25%" bgcolor="#ECECEC" height="20"><%=sub_date%> </td>
</tr>
<%
}%>
<tr>
<td width="100%" colspan="4" bgcolor="#ECECEC" height="20">共<font color=red><%=PageCount%></font>頁 第<%=intpage%>頁
<font color=666666><%if(intpage-1>0){%><a href="subpass.jsp?page=<%=intpage-1%>">上一頁</a><%}else{%>上一頁<%}%> <%if (intpage+1<=PageCount){%><a href="subpass.jsp?page=<%=intpage+1%>">下一頁</a><%}else{%>下一頁</font><%
}%></td>
</tr>
</table>
<%}
}
mdb.Close();%>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -