Java Ajax分页,jsp ajax分页

import java.io.IOException; import java.io.PrintWriter; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.sql.*; public class AjaxServer extends HttpServlet { public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { //当前页 int currpage = Integer.parseInt(request.getParameter("currpage")==null?"1":request.getParameter("currpage")); //总的记录数 int total = this.getResultCount(); //分页单位 int pagesize = 5; //Page类对象 Page page = new Page(total,currpage,pagesize); //用于返回给前台页面的XML文档 StringBuffer xmlDOM = new StringBuffer(); //调用查询方法 ResultSet rs = this.getResultSet(page.getStart(),page.getPagesize()); //添加XML根 xmlDOM.append("<root>"); try { //添加数据库查询出来的数据 xmlDOM.append("<persons>"); while (rs.next()) { xmlDOM.append("<person>"); xmlDOM.append("<sid>" + rs.getString("sid") + "</sid>"); xmlDOM.append("<sname>" + rs.getString("sname") + "</sname>"); xmlDOM.append("<sage>" + rs.getString("sage") + "</sage>"); xmlDOM.append("</person>"); } rs.close(); xmlDOM.append("</persons>"); } catch (SQLException e) {} //添加分页信息 xmlDOM.append("<page>"); xmlDOM.append("<currpage>"+page.getCurrpage()+"</currpage>"); xmlDOM.append("<pagecount>"+page.getPagecount()+"</pagecount>"); xmlDOM.append("</page>"); xmlDOM.append("</root>"); //调用打印方法 this.print(request, response, xmlDOM.toString()); } public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { this.doGet(request, response); } /** * @category 打印出XMLDOM文档,用于前台页面的接收 * @author Powered By BennyTan QQ:1565804 * @param request * @param response * @param xmlDOM * @throws IOException */ private void print(HttpServletRequest request, HttpServletResponse response,String xmlDOM) throws IOException{ response.setCharacterEncoding("gb2312"); response.setContentType("text/xml"); PrintWriter out = response.getWriter(); out.print(xmlDOM); out.close(); } /** * @author QQ:1565804 * @category 返回当前页的查询结果 * @param 行号 * @param 长度 * @return ResultSet */ private ResultSet getResultSet(int start,int len){ Connection conn = null; PreparedStatement pstmt = null; ResultSet rs = null; try { Class.forName("com.mysql.jdbc.Driver"); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } try { conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/ajax","root","root"); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } String sql = "select * from person order by sid limit ?,?"; try { pstmt = conn.prepareStatement(sql); pstmt.setInt(1, start); pstmt.setInt(2, len); rs = pstmt.executeQuery(); } catch (SQLException e) { e.printStackTrace(); } return rs; } /** * @author QQ:1565804 * @return 数据库中总的记录数 */ private int getResultCount(){ int count=0; Connection conn = null; Statement stmt = null; ResultSet rs = null; try { Class.forName("com.mysql.jdbc.Driver"); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } try { conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/ajax","root","root"); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } String sql = "select count(*) from person"; try { stmt = conn.createStatement(); rs = stmt.executeQuery(sql); } catch (SQLException e) { e.printStackTrace(); } try { while(rs.next()){ count = rs.getInt(1); } stmt.close(); rs.close(); conn.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return count; } }