bookquery.jsp

这是一个JSP的网上书店

<%@ page import="java.sql.*,javax.sql.*" %>
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<jsp:useBean id="myCart" scope="session" class="myBook.ShoppingCart" />

<%
     String userName=(String)session.getAttribute("name");
     String login=(String)session.getAttribute("login");
     if(login!=null && login.equals("OK"))
	 {
%>

<table width="100%" border="0">
  <tr bgcolor="#336699">
    <td colspan="2">当前用户：<%=userName %></td>
    <td align=center>
        目前共购买了<font color=red><%=myCart.getTotal() %></font>本图书
    </td>
  </tr>
  <tr>
    <td width="69">

    </td>
    <td width="462" colspan="2">
      <%@ include file="link.jsp"%>
    </td>
  </tr>
 
</table><br>

<%
   int pages=0;
   int currentPage=1;
   int pageSize=5;

   if(request.getParameter("pageTo")!=null)
   {
       currentPage=Integer.parseInt(request.getParameter("pageTo"));
   }

%>
<table color=blue border>
<tr>
     <td width=10%>编号</td>
     <td>书名</td>
     <td>作者</td>
     <td>出版社</td>
     <td>价格</td>
     <td>&nbsp;</td>
</tr>
<% 
   try{
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");  //注册驱动程序 
		Connection con = DriverManager.getConnection("jdbc:odbc:userDB", "", "");  
		Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
		ResultSet  rs  =  stmt.executeQuery("select * from book");

                rs.last();//将结果集指针移到最后一条数据
                int rows=rs.getRow();//获取最后一条数据的位置

                //计算总页数
                pages=rows/pageSize;
                if(rows-pages*pageSize!=0)
                {
                     pages++;
                }
                
                int i=1;

                rs.first();//移动指针到结果集的第一条数据
                rs.absolute((currentPage-1)*pageSize+1);//移动指针到要显示的第一条数据


		do{
                      int bookno=rs.getInt("bookno");
                      String bookname=rs.getString("bookname");
                      String author=rs.getString("author");
                      String publisher=rs.getString("publisher");
                      float price=rs.getFloat("price");

                      out.print("<tr>");
               	      out.print("<td>" + bookno+"</td>");
		      out.print("<td>" + bookname+"</td>");
		      out.print("<td>" + author+"</td>");
		      out.print("<td>" + publisher+"</td>");
 		      out.print("<td>" + price +"</td>");
%>

		      <td><a href="addBookToCart.jsp?bookno=<%=bookno %>&bookname=<%=bookname %>&author=<%=author %>&price=<%=price %>&publisher=<%=publisher %>">购买</a>

<%

                      out.print("</tr>");
                      i++;
 
		}while(i<=pageSize&&rs.next());

		rs.close();
		stmt.close();
		con.close();	    
		}catch(Exception e){
		    e.printStackTrace();
		}

%>

</table>

<br>

<% if(currentPage>1)
  {
%>
  <a href="bookQuery.jsp?pageTo=<%=currentPage-1 %>">上一页</a>
<%
  }
%>

<% for(int i=1;i<=pages;i++)
  {
%>
  &nbsp;<a href="bookQuery.jsp?pageTo=<%=i %>"><%=i%></a>
<%
  }
%>

<% if(currentPage<pages)
  {
%>
&nbsp;&nbsp;<a href="bookQuery.jsp?pageTo=<%=currentPage+1 %>">下一页</a>
<%
  }
%>
<br>

<form action="bookQuery.jsp" method="post">
    当前页：<%=currentPage %>/<%=pages %>&nbsp;&nbsp;显示第<input type="text" name="pageTo" size=3>页
    <input type="submit" value="确定">

</form>
<%
   }else{
      response.sendRedirect("loginForm.jsp");
}
%>