没有事做随便写了个servlet分页
这个分页效果是用servlet实现的,其实用javabean实现也是一样的
现在把代码贴出来
package
Test;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class Login extends HttpServlet ... {
/** *//**
* author:xinshaoye
* date:2007-8-26
*/
private static final long serialVersionUID = 1L;
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException ...{
response.setContentType("text/html;charset=gbk");
PrintWriter out = response.getWriter();
out.println("<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">");
out.println("<HTML>");
out.println(" <HEAD><TITLE>Login Servlet</TITLE></HEAD>");
out.println(" <BODY>");
out.print("<h2>简单分页</h2>");
out.print("<hr>");
/**//*out.print("<form>");
out.print("用户名:<input type=text name=username/><br>");
out.print("密码:<input type=password name=userpwd/><br>");
out.print("<input type=submit value=提交 />");
out.print("<input type=reset value=重置 />");
out.print("</form>");*/
int pageNow=0;
String pagenow=request.getParameter("pageNow");
if(pagenow==null)
pageNow=1;
else
pageNow=Integer.parseInt(pagenow);
this.fenye(request, response,pageNow);
out.flush();
out.close();
out.println(" </BODY>");
out.println("</HTML>");
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException ...{
this.doGet(request, response);
}
public void fenye(HttpServletRequest req,HttpServletResponse res,int pageNow) throws IOException
...{
int pageSize=10;
//int pageNow=pageNowc;
int rowCount=0;
int pageCount=0;
PrintWriter out=res.getWriter();
Connection conn=null;
PreparedStatement ps=null;
ResultSet rs=null;
try...{
Class.forName("com.mysql.jdbc.Driver");
conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/news","root","gxzheng");
//st=conn.createStatement();
ps=conn.prepareStatement("select count(*) from news");
rs=ps.executeQuery();
if(rs.next())
...{
rowCount=rs.getInt(1);
}
if(rowCount%pageSize==0)
...{
pageCount=rowCount/pageSize;
}
else
...{
pageCount=rowCount/pageSize+1;
}
ps=conn.prepareStatement("select * from news limit "+(pageNow-1)*pageSize+","+pageSize+";");
rs=ps.executeQuery();
out.println("<center>");
out.println("<table border=1>");
while(rs.next())
...{
out.println("<tr>");
out.println("<td>"+rs.getInt(1)+"</td>");
out.println("<td>"+rs.getString(2)+"</td>");
out.println("<td>"+rs.getString(3)+"</td>");
out.println("<td>"+rs.getString(4)+"</td>");
out.println("<td>"+rs.getInt(5)+"</td>");
out.println("</tr>");
}
}catch(Exception e)
...{
e.printStackTrace();
}
out.println("</table>");
if(pageNow!=1)
...{
out.println("<a href=login?pageNow="+(pageNow-1)+" >上一页</a>");
}
for(int i=pageNow;i<=pageNow+5;i++)
...{
out.println("<a href=login?pageNow="+i+">"+i+"</a>" );
}
if(pageNow!=pageCount)
...{
out.println("<a href=login?pageNow="+(pageNow+1)+" >下一页</a>");
}
out.println(" 共"+rowCount+"条记录 "+pageCount+"页");
out.println("</center>");
}
}
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class Login extends HttpServlet ... {
/** *//**
* author:xinshaoye
* date:2007-8-26
*/
private static final long serialVersionUID = 1L;
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException ...{
response.setContentType("text/html;charset=gbk");
PrintWriter out = response.getWriter();
out.println("<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">");
out.println("<HTML>");
out.println(" <HEAD><TITLE>Login Servlet</TITLE></HEAD>");
out.println(" <BODY>");
out.print("<h2>简单分页</h2>");
out.print("<hr>");
/**//*out.print("<form>");
out.print("用户名:<input type=text name=username/><br>");
out.print("密码:<input type=password name=userpwd/><br>");
out.print("<input type=submit value=提交 />");
out.print("<input type=reset value=重置 />");
out.print("</form>");*/
int pageNow=0;
String pagenow=request.getParameter("pageNow");
if(pagenow==null)
pageNow=1;
else
pageNow=Integer.parseInt(pagenow);
this.fenye(request, response,pageNow);
out.flush();
out.close();
out.println(" </BODY>");
out.println("</HTML>");
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException ...{
this.doGet(request, response);
}
public void fenye(HttpServletRequest req,HttpServletResponse res,int pageNow) throws IOException
...{
int pageSize=10;
//int pageNow=pageNowc;
int rowCount=0;
int pageCount=0;
PrintWriter out=res.getWriter();
Connection conn=null;
PreparedStatement ps=null;
ResultSet rs=null;
try...{
Class.forName("com.mysql.jdbc.Driver");
conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/news","root","gxzheng");
//st=conn.createStatement();
ps=conn.prepareStatement("select count(*) from news");
rs=ps.executeQuery();
if(rs.next())
...{
rowCount=rs.getInt(1);
}
if(rowCount%pageSize==0)
...{
pageCount=rowCount/pageSize;
}
else
...{
pageCount=rowCount/pageSize+1;
}
ps=conn.prepareStatement("select * from news limit "+(pageNow-1)*pageSize+","+pageSize+";");
rs=ps.executeQuery();
out.println("<center>");
out.println("<table border=1>");
while(rs.next())
...{
out.println("<tr>");
out.println("<td>"+rs.getInt(1)+"</td>");
out.println("<td>"+rs.getString(2)+"</td>");
out.println("<td>"+rs.getString(3)+"</td>");
out.println("<td>"+rs.getString(4)+"</td>");
out.println("<td>"+rs.getInt(5)+"</td>");
out.println("</tr>");
}
}catch(Exception e)
...{
e.printStackTrace();
}
out.println("</table>");
if(pageNow!=1)
...{
out.println("<a href=login?pageNow="+(pageNow-1)+" >上一页</a>");
}
for(int i=pageNow;i<=pageNow+5;i++)
...{
out.println("<a href=login?pageNow="+i+">"+i+"</a>" );
}
if(pageNow!=pageCount)
...{
out.println("<a href=login?pageNow="+(pageNow+1)+" >下一页</a>");
}
out.println(" 共"+rowCount+"条记录 "+pageCount+"页");
out.println("</center>");
}
}