当前位置：首页 > 资讯 > 技术文档

jsp实现页面分页功能代码

时间：2020-09-24 09:37 编辑：来源：阅读：
扫一扫，手机访问

摘要：jsp实现页面分页功能代码

核心代码：

<%@ 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>

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

全部评论(0)

上一篇：nodejs个人博客开发第六步数据分页
下一篇：基于Jquery的动态添加控件并取值的实现代码

资讯排行榜
更多>>