jsp实现页面分页功能代码

Java  /  管理员 发布于 7年前   207

核心代码：

<%@ page contentType="text/html" pageEncoding="GB2312" language="java"%><%@ page import="java.sql.*"%><html><head><title>hello</title></head><body><table border="1" spacing="2"><%!public static final String DRIVER = "com.mysql.jdbc.Driver";public static final String USER = "root";public static final String PASS = "";public static final String URL = "jdbc:mysql://localhost:3306/teachinfo";public static final int PAGESIZE = 5;int pageCount;int curPage = 1;%><%//一页放5个String user = null;String pass = null;try{Class.forName(DRIVER);Connection con = DriverManager.getConnection(URL,USER,PASS);String sql = "SELECT * FROM department";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 tmp = request.getParameter("curPage");if(tmp==null){tmp="1";}curPage = Integer.parseInt(tmp);if(curPage>=pageCount) curPage = pageCount;boolean flag = rs.absolute((curPage-1)*PAGESIZE+1);out.println(curPage);//输出到屏幕上int count = 0;do{if(count>=PAGESIZE)break;int departmentid = rs.getInt(1);String departmentname = rs.getString(2);count++;%><tr><td><%=departmentid%></td><td><%=departmentname%></td></tr><%}while(rs.next());con.close();}catch(Exception e){}%></table><a href = "fenye.jsp?curPage=1" >首页</a><a href = "fenye.jsp?curPage=<%=curPage-1%>" >上一页</a><a href = "fenye.jsp?curPage=<%=curPage+1%>" >下一页</a><a href = "fenye.jsp?curPage=<%=pageCount%>" >尾页</a>第<%=curPage%>页/共<%=pageCount%>页</body></html>

本篇代码希望各位朋友喜欢！


  • 上一条：
    Jsp真分页实例---分页
    下一条：
    jsp实现仿QQ空间新建多个相册名称并向相册中添加照片功能

    • 昵称：

    邮箱：

    0条评论 (评论内容有缓存机制,请悉知!)
    Top

    Copyright·© 2019 侯体宗版权所有· 粤ICP备20027696号 PHP交流群

    侯体宗的博客