📄 toplist.jsp
字号:
<%--
***************文件名 ： topList.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=771 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="770" height="120">
<param name="movie" value="images/headnew.swf">
<param name="quality" value="High">
<embed src="images/headnew.swf" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" name="obj1" width="770" height="120"></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 currentSale>"+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
{
// out.println(sql);
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";
// out.println(ToPage);
//判断是否可正确取得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=topList.jsp?limitNum=<%=limitNum%>&ToPage=<%= 1 %>>到第一页</A>
</TD>
<TD Width=95>
<A Href=topList.jsp?limitNum=<%=limitNum%>&ToPage=<%= ShowPage - 1 %>>到上一页</A>
</TD>
<%
//}
//判断目前所在分页是否为最后一页,
//不是则显示到最后一页与下一页的超链接
if(ShowPage != myPage.pageCount)
{
//下面建立的各超链接将链接至自己,
//并将欲显示的分页以ToPage参数传递自己
%>
<TD Width=97>
<A Href=topList.jsp?limitNum=<%=limitNum%>&ToPage=<%= ShowPage + 1%>>到下一页</A>
</TD>
<TD Width=94>
<A Href=topList.jsp?limitNum=<%=limitNum%>&ToPage=<%= myPage.pageCount %>>到最后一页</A>
</TD>
<%
}
%>
<TD Width=118>
<FORM action=topList.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 + -