page.jsp

论坛元程序

<%@ page import="java.sql.*,java.util.*"%>
<%@ page contentType="text/html;charset=gb2312"%>
<jsp:useBean id="yy" scope="page" class="yy.jdbc"/>
<%
  String table=request.getParameter("table");
  String sql="";
  ResultSet rs=null;
  int n=0;
  int count=0;
  int pages=1;//当前页数，默认为1
  int pagesize=2;
  String nowpage=request.getParameter("pages");
  if((nowpage!=null)&&(nowpage!=""))
     pages=Integer.parseInt("nowpage");
  if(pages>0)
  {
     try{
     sql="select count(*) as id from "+table;
     
     rs=yy.executeQuery(sql);
     }catch(Exception e)
     {
     out.println(e.getMessage());
     }
  }if(rs.next())
     count=rs.getInt("id");
  yy.closeConn();
  if(count>0)
  {
    n=(int)(count/pagesize);
    if(n*pagesize<count)
      n++;
      if(n>=1)
      {%>共<%=n%>页:
      <%
         for(int i=1;i<=n;i++)
         out.println("<a href=query.jsp?pages="+i+">"+i+"&nbsp;</a>");
      }
  }%>
  <form action=query.jsp  method=post>
  跳到第：<input type=text name=pages size=2>页
  <input type=submit value=go>
  </form>