📄 sortlist.jsp
字号:
<%--
***************文件名 ： sortList.jsp
***************功能 ： 分类浏览页
***************作者 ： 唐志军，马俊
***************接口参数： 分类名：sort 显示页码：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><applet archive="ansnow.jar" code="ansnow.class" width="771" height="120">
<param name="credits" value="Applet by Fabio Ciucci (www.anfyteam.com)">
<param name="flakes1" value="500">
<param name="flakes2" value="300">
<param name="flakes3" value="100">
<param name="flakes4" value="0">
<param name="windmax" value="1">
<param name="windvariation" value="7">
<param name="speed" value="7">
<param name="backimage" value="images/111.jpg">
<param name="bgcolor" value="000135">
<param name="overtext" value="NO">
<param name="overimg" value="NO">
<param name="overimgX" value="0">
<param name="overimgY" value="0">
<param name="textscroll" value="snowscr.txt">
<param name="texttype" value="zooming">
<param name="textvspace" value="10">
<param name="textminfont" value="8">
<param name="textmaxfont" value="172">
<param name="textoffset" value="0">
<param name="textspeed" value="1">
<param name="textfont" value="TimesRoman">
<param name="textbold" value="YES">
<param name="textitalic" value="YES">
<param name="textsize" value="28">
<param name="textshadow" value="YES">
<param name="TextSColR" value="0">
<param name="TextSColG" value="0">
<param name="TextSColB" value="0">
<param name="TextColR" value="255">
<param name="TextColG" value="80">
<param name="TextColB" value="80">
<param name="TextJumpAmp" value="0">
<param name="TextJumpSpd" value="0">
<param name="TextSineAmp" value="0">
<param name="TextSineSpd" value="0">
<param name="TextSineAngle" value="0">
<param name="regcode" value="NO">
<param name="reglink" value="NO">
<param name="regnewframe" value="NO">
<param name="regframename" value="_blank">
<param name="statusmsg" value="Snow">
<param name="memdelay" value="1000">
<param name="priority" value="3">
<param name="MinSYNC" value="10">
Please <A HREF="http://www.anfyteam.com/java/">download Java(tm)</A>.
</applet></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 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 sort=request.getParameter("sort"); //获得分类
int ShowPage=0; //显示的页号
String sql="SELECT * FROM book";
if(sort!=null) //没有分类则全部浏览
sql=sql+" WHERE bookSort='"+sort+"'";
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);
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>
<img border="0" src="images/5.gif" width="180" height="30"><p>
<p>
<p>
<%
}
else
{
%>
<CENTER>
<H4><img border="0" src="../../images/8.gif" width="130" height="30"></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><font color="#00FF00">该类记录共有
<FONT SIZE = 3 COLOR = red>
<%= myPage.pageCount %></FONT>页，您目前在第<FONT SIZE = 3 COLOR = red>
<%= ShowPage %></FONT>页</font></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=sortList.jsp?sort=<%=sort%>&ToPage=<%= 1 %>>到第一页</A>
</TD>
<TD Width=95>
<A Href=sortList.jsp?sort=<%=sort%>&ToPage=<%= ShowPage - 1 %>>到上一页</A>
</TD>
<%
//}
//判断目前所在分页是否为最后一页,
//不是则显示到最后一页与下一页的超链接
if(ShowPage != myPage.pageCount)
{
//下面建立的各超链接将链接至自己,
//并将欲显示的分页以ToPage参数传递自己
%>
<TD Width=97>
<A Href=sortList.jsp?sort=<%=sort%>&ToPage=<%= ShowPage + 1%>>到下一页</A>
</TD>
<TD Width=94>
<A Href=sortList.jsp?sort=<%=sort%>&ToPage=<%= myPage.pageCount %>>到最后一页</A>
</TD>
<%
}
%>
<TD Width=118>
<FORM action=sortList.jsp?sort=<%=sort%> 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 + -