page.jsp.bak

论坛元程序

<%@ 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;
     out.println(sql);
     rs=yy.executeQuery(sql);
     }catch(Exception e)
     {
     out.println(e.getMessage());
     }
  }%>
  <form action=query.jsp  method=post>
  跳到第：<input type=text name=pages size=2>页
  <input type=submit value=go>
  </form>