newlist.jsp

面向对象软件工程案例

     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>&nbsp;&nbsp;
<p>&nbsp;&nbsp;
<p>&nbsp;&nbsp;
<p align=center>&nbsp;<img border="0" src="images/5.gif" width="195" height="35"><p>&nbsp;&nbsp;
<p>&nbsp;&nbsp;
<p>&nbsp;&nbsp;
<%
    }
    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); 
//计算欲显示页的第一笔记录位置
%><br><br><br>
<font color="#00FF00"><font size="2">该类记录共有  
</font>  
<FONT SIZE = 2 COLOR = red>
<%= myPage.pageCount %></FONT><font size="2">页，您目前在第</font><FONT SIZE = 2 COLOR = red>
<%= ShowPage %></FONT><font size="2">页</font></font><font size="2"> </font>
<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">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;    
                </font></b><img border="0" src="images/8.gif" width="130" height="30"></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">&nbsp; <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=newList.jsp?pubDate=<%=pubDate%>&ToPage=<%= 1 %>>到第一页</A>
	</TD>
	<TD Width=95>
	<A Href=newList.jsp?pubDate=<%=pubDate%>&ToPage=<%= ShowPage - 1 %>>到上一页</A>
	</TD>
	<%
//}

//判断目前所在分页是否为最后一页,
//不是则显示到最后一页与下一页的超链接
if(ShowPage != myPage.pageCount)
{
//下面建立的各超链接将链接至自己, 
//并将欲显示的分页以ToPage参数传递自己
	%>	
	<TD Width=97>
	<A Href=newList.jsp?pubDate=<%=pubDate%>&ToPage=<%= ShowPage + 1%>>到下一页</A>
	</TD>  
	<TD Width=94>
	<A Href=newList.jsp?pubDate=<%=pubDate%>&ToPage=<%= myPage.pageCount %>>到最后一页</A>
	</TD>
	<%
}
%>
<TD Width=118>
<FORM action=newList.jsp?pubDate=<%=pubDate%> 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>版权所有&nbsp;2003-2004&nbsp;&copy;&nbsp;All rights MagicTeam reseverd              
      <p>　</p>
    </TD></TR></TBODY></TABLE>         
<DIV align=center></DIV>
</table>
</BODY></HTML>