?? commendlist.jsp
字號:
<%--
***************文件名 ： commendList.jsp
***************功能 ： 精品推薦頁
***************作者 ： 唐志軍，馬俊
***************接口參數： String limitNum（要查看圖書上個月銷售量的下限） 顯示頁碼：String ToPage (第一次進入時為1)
***************實現過程：
--%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%@ page import="page.page"%>
<HTML><HEAD><TITLE>精品推薦</TITLE>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<SCRIPT language=JavaScript type=text/JavaScript>
<!--
function MM_reloadPage(init) { //reloads the window if Nav4 resized
if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {
document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
}
MM_reloadPage(true);
//-->
</SCRIPT>
<SCRIPT src="images/alt.js"></SCRIPT>
<LINK href="images/default.css" type=text/css
rel=stylesheet>
<META content="Microsoft FrontPage 6.0" name=GENERATOR></HEAD>
<BODY background=images/crossbig.gif
onmouseover="window.status='【歡迎你光臨我們的網站】如果您喜歡本站,別忘了把本站介紹給您的好友哦！：）';return true"
leftMargin=0 topMargin=0 marginheight="0" marginwidth="0">
<SCRIPT language=JavaScript>
<!--
function checkss()
{
if(checkspace(document.searchform.searchkey.value !='請輸入關鍵字')) {
document.searchform.searchkey.focus();
alert("請輸入查詢關鍵字！");
return false;
}
if(checkspace(document.searchform.searchkey.value)) {
document.searchform.searchkey.focus();
alert("請輸入查詢關鍵字！");
return false;
}
document.searchform.submit();
}
function checkspace(checkstr) {
var str = '';
for(i = 0; i < checkstr.length; i++) {
str = str + ' ';
}
return (str == checkstr);
}
//-->
</SCRIPT>
<%
//獲得登錄名，若為空則表示未登錄
String logName=(String) session.getValue("logName");
%>
<TABLE cellSpacing=0 cellPadding=0 width=776 align=center border=0>
<TBODY>
<TR>
<TD width=776 height=14>
<object classid="clsid:D27CDB6E-AE6D-11CF-96B8-444553540000" id="obj1" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,40,0" border="0" width="778" height="169">
<param name="movie" value="images/head1.swf">
<param name="quality" value="High">
<embed src="images/head1.swf" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" name="obj1" width="778" height="169"></object></TD></TR></TBODY></TABLE>
<TABLE cellSpacing=0 cellPadding=0 width=776 align=center
background="images/INDEX_r2_c1.jpg" border=0>
<TBODY>
<TR>
<TD width=160 height=25>
<SCRIPT language=JavaScript type=text/JavaScript>
today=new Date();
function initArray(){
this.length=initArray.arguments.length
for(var i=0;i<this.length;i++)
this[i+1]=initArray.arguments[i] }
var d=new initArray(
"星期日",
"星期一",
"星期二",
"星期三",
"星期四",
"星期五",
"星期六");
document.write(
"<font color=#ffffff>"+
today.getYear()+"年"+
(today.getMonth()+1)+"月"+
today.getDate()+"日 "+
d[today.getDay()+1]+
"</font>");
</SCRIPT>
</TD>
<% if(logName==null)
{
%>
<TD width=616><IMG height=10 src="images/b.gif"
width=10 align=absMiddle><FONT color=#333333><font color="#FFFFFF"> </font> <A
class=a1 href="index.jsp" target=_top>
<% }
else
{
%>
<TD width=616><IMG height=10 src="images/b.gif"
width=10 align=absMiddle><FONT color=#333333><font color="#FFFFFF"> </font> <A
class=a1 href="main.jsp" target=_top>
<% }
%>
<font color="#FFFFFF">首 頁</font></A></FONT><FONT color=#333333><font color="#FFFFFF"> | </font>
<A class=a1 href="userPannel.jsp" target=_top>
<font color="#FFFFFF">個人信息面板</font></FONT><FONT color=#333333><font color="#FFFFFF"> | </font></FONT></a>
<A class=a1 href="newList.jsp?pubDate=2001/2/4&ToPage=1" target=_top>
<font color="#FFFFFF">新品上架</font></A><FONT color=#FFFFFF> | </FONT>
<A class=a1 href="sortList.jsp?sort=計算機硬件&ToPage=1" target=_top>
<font color="#FFFFFF">圖書分類</font></A><FONT color=#FFFFFF> |</FONT>
<A class=a1 href="commendList.jsp?limitNum=10&ToPage=1" target=_top>
<font color="#FFFFFF">精品推薦</font></A><FONT color=#FFFFFF> | </FONT>
<A class=a1 href="topList.jsp?limitNum=10&ToPage=1" target=_top>
<font color="#FFFFFF">排行榜</font></A><FONT color=#FFFFFF> | </FONT>
<a class="a1" target="_top" href="help.jsp">
<font color="#FFFFFF">在線幫助</font></a><FONT color=#FFFFFF>|</FONT></FONT>
<FONT color=#ffffff> </FONT>
<% if(logName==null)
{
%>
<FONT color=#FF0000>您還沒有登錄!!!</FONT>
<% }
else
{
%>
<FONT color=#FF0000>當前登錄用戶：<%=logName%></FONT>
<%
}
%>
<DIV></DIV></TD></TR></TBODY></TABLE>
<TABLE id=Table1 cellSpacing=0 cellPadding=0 width=776 align=center border=0>
<TBODY>
<TR>
<FORM id=Search name=searchform
action=searchResult.jsp?ToPage=1 method=post>
<TD bgColor=#cce3e7 height=26>
<DIV align=center> </DIV>
<DIV align=center><IMG height=16
src="images/search.gif" width=64 align=absMiddle>
<INPUT onfocus="this.value=''" value=請輸入關鍵字 name=searchkey size="20">
<SELECT id=action name=condition>
<OPTION value=1 selected>書 名</OPTION>
<OPTION value=2>作 者</OPTION>
<OPTION value=3>出版社</OPTION>
<OPTION value=4>ISBN</OPTION>
</SELECT>
<INPUT id=Submit1 style="BORDER-RIGHT: #333333 1px solid; BACKGROUND-POSITION: 0% 50%; BORDER-TOP: #333333 1px solid; FONT-WEIGHT: normal; FONT-SIZE: 12px; BACKGROUND-ATTACHMENT: scroll; BORDER-LEFT: #333333 1px solid; COLOR: #333333; LINE-HEIGHT: normal; BORDER-BOTTOM: #333333 1px solid; BACKGROUND-REPEAT: repeat; FONT-STYLE: normal; HEIGHT: 18px; BACKGROUND-COLOR: #cee7ef; FONT-VARIANT: normal" onclick="return checkss();" type=submit value=立即查詢 name=Submit>
</DIV></TD></FORM></TR></TBODY></TABLE>
<%
String limitNum=request.getParameter("limitNum"); //獲得本月銷售量的下限
int ShowPage=0; //顯示的頁號
String sql="SELECT * FROM book";
if(limitNum==null) //沒有分類則全部瀏覽
limitNum="-1";
sql=sql+" WHERE recentSale>"+Integer.parseInt(limitNum);
page myPage=(page)session.getValue("myPage"); //獲得page對象
if(myPage==null) //第一次進入查詢
{
myPage=new page();
myPage.pageSize = 10; //設置每張網頁顯示兩筆記錄
myPage.pageID = 1; //設置欲顯示的頁數
myPage.recordCount = 0; //ResultSet的記錄筆數
myPage.pageCount = 0; //ResultSet分頁后的總頁數
}
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e)
{
out.println(e.toString());
}
try
{
Connection con = DriverManager.getConnection("jdbc:odbc:bookStore");
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs=stmt.executeQuery(sql);
// out.println(sql);
rs.last(); //將指標移至最后一筆記錄
//取得ResultSet中記錄的筆數
myPage.recordCount = rs.getRow();
//計算顯示的頁數
myPage.pageCount = ((myPage.recordCount % myPage.pageSize) == 0 ? (myPage.recordCount/myPage.pageSize) : (myPage.recordCount/myPage.pageSize)+1);
if(myPage.recordCount<=0) //沒有找到
{
%>
<p>
<p>
<p>
<p align=center><font color=red size=4>沒有找到滿足條件的圖書!!!</font>
<p>
<p>
<p>
<%
}
else
{
%>
<CENTER>
<%
String ToPage = request.getParameter("ToPage");
if(ToPage==null)
ToPage="1";
//判斷是否可正確取得ToPage參數,
//可取得則表示JSP網頁應顯示特定分頁記錄的語句
if(ToPage != null)
{
ShowPage = Integer.parseInt(ToPage); //取得指定顯示的分頁頁數
//下面的if語句將判斷用戶輸入的頁數是否正確
if(ShowPage > myPage.pageCount)
{ //判斷指定頁數是否大于總頁數, 是則設置顯示最后一頁
ShowPage = myPage.pageCount;
}
else if(ShowPage <= 0)
{ //若指定頁數小于0, 則設置顯示第一頁的記錄
ShowPage = 1;
}
myPage.pageID=ShowPage;
session.setAttribute("myPage",myPage);
}
// out.println(ShowPage);
rs.absolute((ShowPage - 1) * myPage.pageCount + 1);
//計算欲顯示頁的第一筆記錄位置
%>
<H4> <font color="#00FF00">該類記錄共有
<FONT SIZE = 3 COLOR = red>
<%= myPage.pageCount %></FONT>頁，您目前在第<FONT SIZE = 3 COLOR = red>
<%= ShowPage %></FONT>頁</font></H4>
<table width="750" border="0" cellspacing="1" cellpadding="1">
<tr valign="top">
<td width="638" align="center">
<td width="638" align="center">
<p> </p>
<p>
<b><font color="#0000FF">
電子書店圖書列表</font></b></p>
<p> </p>
<center>
<table width="732" border="1" cellspacing="1" cellpadding="1" bordercolor="#FFFFFF">
<tr align="center">
<td width="62" bordercolor="#FFFFFF"> </td>
<td width="142" bordercolor="#0000FF">圖書名稱</td>
<td width="114" bordercolor="#0000FF">作者</td>
<td width="92" bordercolor="#0000FF">圖書類別</td>
<td width="133" bordercolor="#0000FF">出版社</td>
<td width="102" bordercolor="#0000FF">單價(元)</td>
<td width=175 bordercolor="#0000FF">選擇</td>
<%
//利用For循環配合myPage.pageSize屬性輸出一頁中的記錄
for(int i = 1; i <= myPage.pageSize; i++)
{
%>
<tr> <td width="62" align="center" bordercolor="#FFFFFF"> </td>
<td width="142" align="center" bordercolor="#0000FF"><%= rs.getString("bookName") %></td>
<td align="center" width="114" bordercolor="#0000FF"><%=rs.getString("bookAuthor") %></td>
<td align="center" width="92" bordercolor="#0000FF"><%=rs.getString("bookSort") %></td>
<td align="center" width="133" bordercolor="#0000FF"><%=rs.getString("publisher") %></td>
<td align="center" width="102" bordercolor="#0000FF"><%=rs.getString("bookPrice") %></td>
<td align="center" width="175" bordercolor="#0000FF"> <a href="orderView.jsp?bookID=<%=rs.getString("bookID") %>" >購買</a>
| <a href="detailView.jsp?bookID=<%=rs.getString("bookID") %>">詳細資料</a></td>
</tr>
<%
//下面的if判斷語句用于防止輸出最后一頁記錄時,
//將記錄指標移至最后一筆記錄之后
if(!rs.next()) //判斷是否到達最后一筆記錄
break; //跳出for循環
}
} //沒有圖書else的結束
rs.close();
}
catch(Exception e)
{
out.println(e.toString());
}
%>
</table>
</center>
<TABLE width="649">
<TR valign=baseline align=center>
<%
//判斷目前所在分頁是否為第一頁,
//不是則顯示到第一頁與上一頁的超鏈接
//if(ShowPage != 1)
//{
//下面建立的各超鏈接將鏈接至自己,
//并將欲顯示的分頁以ToPage參數傳遞給自己
%>
<TD Width=118>
</TD>
<TD Width=89>
<A Href=commendList.jsp?limitNum=<%=limitNum%>&ToPage=<%= 1 %>>到第一頁</A>
</TD>
<TD Width=95>
<A Href=commendList.jsp?limitNum=<%=limitNum%>&ToPage=<%= ShowPage - 1 %>>到上一頁</A>
</TD>
<%
//}
//判斷目前所在分頁是否為最后一頁,
//不是則顯示到最后一頁與下一頁的超鏈接
if(ShowPage != myPage.pageCount)
{
//下面建立的各超鏈接將鏈接至自己,
//并將欲顯示的分頁以ToPage參數傳遞自己
%>
<TD Width=97>
<A Href=commendList.jsp?limitNum=<%=limitNum%>&ToPage=<%= ShowPage + 1%>>到下一頁</A>
</TD>
<TD Width=94>
<A Href=commendList.jsp?limitNum=<%=limitNum%>&ToPage=<%= myPage.pageCount %>>到最后一頁</A>
</TD>
<%
}
%>
<TD Width=118>
<FORM action=commendList.jsp?limitNum=<%=limitNum%> method=POST>
到
<!--
供用戶輸入欲查看頁數的文字方塊, 預設值為目前所在的分頁,
當用戶在此文字方塊中完成數據輸入后按下 Enter 即可將數據送出,
相當于按下Submit按鈕, 因此此表單中將省略Submit按鈕
-->
<INPUT type="text" name=ToPage style="HEIGHT: 25px; WIDTH: 40px"
value=<%= ShowPage%> > 頁
</FORM></TD></TR>
</TABLE>
</CENTER>
<TABLE cellSpacing=0 cellPadding=0 width=776 align=center border=0>
<TBODY>
<TR>
<TD>
<TABLE cellSpacing=1 cellPadding=0 width="100%" align=center
bgColor=#89bec6 border=0>
<TBODY>
<TR bgColor=#aacfd5>
<TD style="PADDING-LEFT: 10px"> </TD>
</TR>
</TBODY></TABLE>
<DIV align=center></DIV></TD></TR>
<TR>
<TD height=6></TD></TR>
</TBODY></TABLE>
<HR align=center width=776 color=#339999 SIZE=1>
<TABLE cellSpacing=0 cellPadding=0 width=776 align=center border=0>
<TBODY>
<TR>
<TD align=middle>版權所有 2003-2004 © All rights MagicTeam reseverd
<p> </p>
</TD></TR></TBODY></TABLE>
<DIV align=center></DIV>
</table>
</BODY></HTML>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -