jsp+mysql分页查询,谁能提供一个完整的示例代码 100分,

这是SQLServer的,你稍微改下就行了<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@page import="java.sql.*"%>
<html>
<body>
<%
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=student";
String user="sa";
String password="command";
Connection conn=DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql;
int pagecount=0;//总页数
int pagesize=4;//一页4行记录
int showpage=1;//默认显示页为第一页
int recordcount=0;//总记录数
String topage=request.getParameter("topage");
if(!(topage==null))
   showpage=Integer.parseInt(topage);
sql="select count (*) recordcount from T_Student";
ResultSet rs=stmt.executeQuery(sql);
rs.next();
recordcount=rs.getInt("recordcount");
pagecount=(recordcount+pagesize-1)/pagesize;
if(showpage>pagecount)
    showpage=pagecount;
else if(showpage<=0)
    showpage=1;
sql="SELECT TOP "+pagesize +" * FROM T_Student WHERE (xh NOT IN (SELECT TOP "+(showpage-1)*pagesize +" xh FROM T_Student ORDER BY xh)) ORDER BY xh";
rs=stmt.executeQuery(sql);
%><form action="#"> //就是跳转到本页，也可以不写，默认是本页
<table cellspacing="0" cellPadding="3" border=1 bordercolor="#B0B0B0" rules="all" width="100%">
<tr bgcolor="#6699FF">
<td>学号</td>
<td>姓名</td>
<td>性别</td>
</tr>
<%
   while(rs.next()){
%>
<tr>
<td><%=rs.getString(1)%>  </td>
<td><%=rs.getString(2)%>  </td>
<td><%=rs.getString(3)%>  </td>
</tr>
<%}%>
</table>
<table cellspacing="0" cellPadding="3" border=1 bordercolor="#B0B0B0">
<tr>
<td>
<a href="index.jsp?topage=<%=1%>">第一页</a>
<a href="index.jsp?topage=<%=showpage-1%>">上一页</a>
<a href="index.jsp?topage=<%=showpage+1%>">下一页</a>
<a href="index.jsp?topage=<%=pagecount%>">最后一页</a>
<span><input name="topage" type="text" class="txt_grey" value="<%=showpage%>"></span>
</td>
</tr>
</table>
<%
rs.close();
stmt.close();
conn.close();%>
</form>
</body>
</html>

<%@   page   contentType="text/html;   charset=GBK"%>
  <%@   page   import="java.sql.*"%>
  <%
      int   pagesize=2;//每页显示记录数
      int   recordcount=0;//记录总数
      int   pagecount=0;//总页数
      int   pageid=1;//待显页码
      Connection   conn=null;
      try{
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      conn=DriverManager.getConnection("jdbc:odbc:jspguest","sa","sa");
      Statement   stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);

      String   sql="select   *   from   message";
      ResultSet   rs=stmt.executeQuery(sql);
      rs.last();
      recordcount=rs.getRow();//取得总记录数
      pagecount=(recordcount%pagesize==0?(recordcount/pagesize):(recordcount/pagesize)+1);//取得总页数
      int   count=1;
      String   strpage=request.getParameter("pageid");
      if(strpage==null)   pageid=1;
      else   pageid=Integer.parseInt(strpage);
      if(pageid>recordcount)   pageid=recordcount;
      if(recordcount>0){
      rs.absolute((pageid-1)*pagesize+1);}
      int   i=0;
      //rs.previous();
      rs.beforeFirst();
      while(rs.next()&&count<=pagesize){
      count++;
      i++;
            out.print(rs.getString("name"));
    out.print("||");
    out.print(rs.getString("title"));
    out.print("<br/>");

        }
        out.print("共");
        out.print(pagecount);
        out.print("页");

        out.print("共");
        out.print(recordcount);
        out.print("条");

        out.print("第");
        out.print(pageid);
        out.print("页");

        out.print("<br/>");
        if(pageid<pagecount){
        out.print("<a   href=del.jsp?pageid=");
        out.print(pageid+1);
        out.print(">下一页</a>");}
        if(pageid>1){
        out.print("<a   href=del.jsp?pageid=");
        out.print(pageid-1);
        out.print(">上一页</a>");}
        out.print("<br/>");
        for(int   j=1;j<=pagecount;j++){
        out.print("<a   href=del.jsp?pageid=");
        out.print(j);
        out.print(">");
        out.print(j);
        out.print("</a>");}
        stmt.close();
      conn.close();
      }
      catch(ClassNotFoundException   e){
          out.println(e.getMessage());
  }
  catch(SQLException   e)   {
  out.println(e.getMessage());
  }
  finally{
    try{
      if(conn   !=   null)
        conn.close();
        }
        catch(Exception   e){}
      }
      %>
把连接字符串改一下就好了

晕了 mysql 用 limit 呀select **** limit begin,sizebegin 表示从哪行开始
size 表示返回行数就是每页显示多少记录begin ＝ (page-1)*size

int PageSize=10,i=0,RowCount=0,PageCount;
int GetPage=Chk.IsPage(request.getParameter("page"));
ResultSet RSs=Conn.executeQuery("Select Count(SID) As s From comments where SID ="+ID);
if(RSs.next()){
RowCount=RSs.getInt("s");
}
PageCount = (RowCount+PageSize-1) / PageSize;
if(GetPage>PageCount) GetPage = PageCount;
int p=(GetPage-1)*PageSize;
String sqlComment="Select * From comments where SID = "+ID+" Order By ID ASC limit "+p+","+PageSize+"";

我们教程里对jsp分页有很深刻的讲解。
见：http://www.family168.com/tutorial/jsp/html/jsp-ch-15.html

调试易

jsp+mysql分页查询,谁能提供一个完整的示例代码 100分,

解决方案 »