ajax.jsp

ajax动态分页

<%@page contentType="text/html; charset=UTF-8"%>
<%@page import="java.sql.*" %>
<%@page import="java.io.*" %>
<%
Connection conn = null;
PreparedStatement stmt = null;
ResultSet rs = null;

try{
    Class.forName("org.gjt.mm.mysql.Driver");
	conn=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/ajaxdemo?useUnicode=true&characterEncoding=UTF-8","root","weqsd");
}catch(java.lang.ClassNotFoundException e){
    e.printStackTrace();
}catch(SQLException ex){
    ex.printStackTrace();
}

response.setContentType("text/xml");
response.setCharacterEncoding("UTF-8");
response.setHeader("Cache-Control", "no-cache");			
PrintWriter writer = response.getWriter();
StringBuffer xml = new StringBuffer("<?xml version=\"1.0\" encoding=\"UTF-8\"?>");
String action = request.getParameter("action");


if (("select").equalsIgnoreCase(action)){
    String sql = "select count(*) from notice";
    int count = 0;
    int totalPage = 0;
    int curPage = 0;
    
    String currentPage = request.getParameter("page");
    try{
        curPage = Integer.valueOf(currentPage);
    }catch(Exception e){
        curPage = 1;
    }
        
    try{
        stmt = conn.prepareStatement(sql);
        rs = stmt.executeQuery();    
        if (rs.next()){
            count=rs.getInt(1); 
        }
        if (count==0) curPage = 0;
   }catch(Exception e){
        rs.close();
        stmt.close();
        conn.close();
        e.printStackTrace();
    }
    
    sql = "select * from notice  order by id asc limit ?,?  ";
    
    int start = 5*(curPage-1);
    
    //int end = start+5-1;
    totalPage = count/5+1;
    if (count==0) totalPage = 0;
    
    try{
        stmt = conn.prepareStatement(sql);
        stmt.setInt(1,start);
        stmt.setInt(2,5);
        rs = stmt.executeQuery();    
    
        xml.append("<response>");
        while(rs.next()){
                xml.append("<notice>");
            	xml.append("<id>");
	            xml.append(rs.getString("id"));
	            xml.append("</id>");
            	xml.append("<content>");
	            xml.append(rs.getString("content"));
	            xml.append("</content>");        
            	xml.append("<createdate>");
	            xml.append(rs.getString("createdate"));
	            xml.append("</createdate>");      
	            xml.append("</notice>");  
        }
        xml.append("<page>");
        xml.append(curPage);
        xml.append("</page>");
        xml.append("<totalPage>");
        xml.append(totalPage);
        xml.append("</totalPage>");
        
        xml.append("</response>");    
    
    
    }catch(Exception e){
        e.printStackTrace();    
    
    }finally{
        rs.close();
        stmt.close();
        conn.close();
    
    }
    


}






writer.print(xml.toString());
writer.close();

%>