【原创】jsp 实现分页功能 - JAVA论坛

楼主
问题点数：0 回复次数：1
【原创】jsp 实现分页功能
程序代码：
<%@ page contentType="text/html" pageEncoding="utf-8" language="java"%>  
<%@ page import="java.sql.*"%>  
<html>  
    <head>  
        <title>hello</title>  
    </head>  
    <body>  
    <table border="1" bgcolor="#FF051">  
    <thead>
        <th>id</th>
        <th>姓名</th>
        <th>性别</th>
        <th>年龄</th>
        <th>电话</th>
        <th>地址</th>
    </thead>
    <tbody>
<%!  
    public static final String driver= "com.mysql.jdbc.Driver";  
    public static final String user= "[Username]";  
    public static final String password= "[Password]";  
    public static final String url= "jdbc:mysql://localhost:3306/[DataBaseName]";  
    public static final int PAGESIZE = 3;  //控制分页数
    int pageCount;                        //控制每页显示的数据数量
     int curPage = 1;                     //当前页面的页数
%>  
<%  
    //一页放5个    
    try{  
        Class.forName(driver);  
        Connection con = DriverManager.getConnection(url,user,password);  
        String sql = "select * from [tableName]";  
        PreparedStatement stat = con.prepareStatement(sql,ResultSet.TYPE_FORWARD_ONLY,ResultSet.CONCUR_READ_ONLY);  
        ResultSet rs = stat.executeQuery();  
        rs.last();  
        int size = rs.getRow();  
        pageCount = (size%PAGESIZE==0)?(size/PAGESIZE):(size/PAGESIZE+1);  
        String temp = request.getParameter("curPage");  
        if(temp==null){  
            temp="1";  
        }  
        curPage = Integer.parseInt(temp);  
        if(curPage>=pageCount) curPage = pageCount; 
        if(curPage<=0){
        curPage=1;
        out.print("已经是第一页了");
        } 
       boolean flag = rs.absolute((curPage-1)*PAGESIZE+1);  
        int count = 0;  
          
        do{  
            if(count>=PAGESIZE)break;  
            String uno = rs.getString(1);  
            String username = rs.getString(2);  
            String gender = rs.getString(3);  
            int age = rs.getInt(4);  
            String phone = rs.getString(5);  
            String address = rs.getString(6);  
            count++; 
   %>  
   
     <tr>  
            <td><%=uno%></td>  
            <td><%=username%></td>  
            <td><%=gender%></td>  
            <td><%=age%></td>  
            <td><%=phone%></td>  
            <td><%=address%></td>  
        </tr>  
            <%  
        }while(rs.next()); 
        con.close();   
    }  
    catch(Exception e){  
          
    }  
%>  
</tbody>
   </table>
   <a href = "index.jsp?curPage=1" >首页</a>  
<a href = "index.jsp?curPage=<%=curPage-1%>" >上一页</a>  
<a href = "index.jsp?curPage=<%=curPage+1%>" >下一页</a>  
<a href = "index.jsp?curPage=<%=pageCount%>" >尾页</a>  
第<%=curPage%>页/共<%=pageCount%>页 
  
</body>  
</html>