e07c132fcbab001d1412e7a87039532d

项目名叫网上图书馆

<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%@ taglib uri="http://struts.apache.org/tags-bean" prefix="bean"%> 
<%@ taglib uri="http://struts.apache.org/tags-html" prefix="html"%>
<jsp:useBean id="t" class="com.center.jsp.struts.datebase.Database" scope="session"/>
<jsp:useBean id="pagebean" scope="page" class="com.center.jsp.struts.datebase.Pagination"/>
<%
    int curPages = pagebean.curPages(pagebean.strPage(request,"page"));//Pagination.strPage(request,"page")取page值传递给curPages()方法
	ResultSet rs_count=t.executeQuery("select count(*) as t from adminbookinfo");//传递进数据库处 理的javabean
			  rs_count.next();
    int resultconts=rs_count.getInt("t");//取得总的数据数
    int totalPages =pagebean.getPages(resultconts);//取出总页数
    ResultSet rs=pagebean.getPageSet(t.executeQuery("select * from adminbookinfo"),curPages);//获取 指针的结果集参数是(结果集，页数)
%>
<table width="580" border="0" align="left" cellpadding="1" cellspacing="1" bgcolor="#CCCCCC">
        <%
		int i=1; 
	    %>
        <%
		while (rs.next())
		{%>
        <tr>
                <td width="100" rowspan="7" bgcolor="#FFFFFF" align="center"><img src="load/<%=rs.getString(11)%>" width="90" height="90" target="_blank"><br>
				进馆时间：<%=rs.getString("bookintime")%>				</td>
                <td bgcolor="#FFFFFF" align="center">书名：<%=rs.getString("bookname") %></td>
          </tr>
              <tr>
                <td bgcolor="#FFFFFF" align="center">作者：<%=rs.getString("bookauthor")%></td>
              </tr>
              <tr>
                <td bgcolor="#FFFFFF" align="center">图书类型：<%=rs.getString("bookbiglocation")%><br><%=rs.getString("booksmalllocation")%>				</td>
              </tr>
              <tr>
                <td bgcolor="#FFFFFF" align="center">出版社：<%=rs.getString("bookchubanshe")%></td>
              </tr>
              <tr>
                <td bgcolor="#FFFFFF" align="center">说明：<%=rs.getString("bookshuoming") %></td>
              </tr>
              <tr>
                <td bgcolor="#FFFFFF" align="center">出租价格：<%=rs.getString("bookborrowprice")%></td>
              </tr>
              <tr>
                <td bgcolor="#FFFFFF" align="center"><label>
  
   <div align="center">&nbsp;&nbsp;<a href="xiangxiinfo.jsp?bookid=<%=rs.getString("bookid")%>&bookname=<%=rs.getString("bookname")%>&bookauthor=<%=rs.getString("bookauthor")%>&bookbiglocation=<%=rs.getString("bookbiglocation")%>&booksmalllocation=<%=rs.getString("booksmalllocation")%>&bookshuliang=<%=rs.getString("bookshuliang")%>&bookchubanshe=<%=rs.getString("bookchubanshe")%>&bookinprice=<%=rs.getString("bookinprice")%>&bookshuoming=<%=rs.getString("bookshuoming")%>&bookimage=<%=rs.getString("bookimage")%>&bookintime=<%=rs.getString("bookintime")%>&bookborrowprice=<%=rs.getString("bookborrowprice")%>"><img src="images/na-122.gif" width="80" height="19" border="0"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href="order.jsp?bookid=<%=rs.getString("bookid")%>&bookname=<%=rs.getString("bookname")%>&bookauthor=<%=rs.getString("bookauthor")%>&bookbiglocation=<%=rs.getString("bookbiglocation")%>&booksmalllocation=<%=rs.getString("booksmalllocation")%>&bookshuliang=<%=rs.getString("bookshuliang")%>&bookchubanshe=<%=rs.getString("bookchubanshe")%>&bookinprice=<%=rs.getString("bookinprice")%>&bookshuoming=<%=rs.getString("bookshuoming")%>&bookimage=<%=rs.getString("bookimage")%>&bookintime=<%=rs.getString("bookintime")%>&bookborrowprice=<%=rs.getString("bookborrowprice")%>"><img src="images/na-121.gif" width="81" height="19" border="0"></a></div>
   </label></td>
              </tr>
             
        <%
			i=i+1;
			if(i>pagebean.getRows())
			break;
   		}
        %>
		 <tr>
                <td bgcolor="#FFFFFF" align="center" colspan="2">
				共<%=totalPages%>页：当前第<%=pagebean.getCurPages()%>页:<a href="page.jsp?page=1">首页</a>
	<%
		
		if(curPages>1)
		{
	%>
			<a href="page.jsp?page=<%=curPages-1%>">上一页</a>
	<%
		}
	%>
	
	<%
	for(int a=1;a<=totalPages;a++)
	{
	%>
	<a href="page.jsp?page=<%=a%>"><%=a%></a>
	<%
	}
	%>
	
	<%
		if(curPages<totalPages)
		{
	%>
			<a href="page.jsp?page=<%=curPages+1%>">下一页</a>
	<%
		}
	%>
	<a href="page.jsp?page=<%=totalPages%>">尾页</a>
				</td>
        </tr>
        </table>