jsp页面数据分页模仿百度分页效果(实例讲解)

浅沫记忆

废话不多说，直接上代码
请根据自己的项目、包名修改

<%@page import="web09.shop.DBUtil"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.Connection"%>
<%@ page language="java" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
  <meta charset="UTF-8">
  <title>数据分页</title>
  <style type="text/css">
  .page a{
    min-width: 34px;
    height: 34px;
    border: 1px solid #e1e2e3;
    cursor: pointer;
    display:block;
    float: left;
    text-decoration: none;
    text-align:center;
    line-height: 34px;    
  }
  
  .page a:HOVER {
    background: #f2f8ff;
    border: 1px solid #38f ;
  }
  .page a.prev{
    width:50px;
  }
  .page span{
    width: 34px;
    height: 34px;
    border: 1px solid transparent;
    cursor: pointer;
    display:block;
    float: left;
    text-decoration: none;
    text-align:center;
    line-height: 34px;
    cursor: default;
  }
  </style>
</head>
<body>
<table class="tt" border="1" align="center" width="80%" cellpadding="10">
  <tr>
  <th>ID</th>
  <th>姓名</th>
  <th>年龄</th>
  <th>专业</th>
  </tr>
  <%
  DBUtil dbutil=new DBUtil();
  Connection conn=dbutil.getCon();
  //Connection conn = new DBUtil().getCon();
  PreparedStatement pstmt1 = conn.prepareStatement("select count(*) from student");
  ResultSet rs1 = pstmt1.executeQuery();
  rs1.next();
  int recordCount = rs1.getInt(1);   //记录总数
  int pageSize = 10;      //每页记录数
  int start=1;      //显示开始页
  int end=10;        //显示结束页
  int pageCount = recordCount%pageSize==0 ? recordCount/pageSize : recordCount/pageSize+1; 
  int currPage = request.getParameter("p")==null ? 1 : Integer.parseInt(request.getParameter("p"));
  
  currPage = currPage<1 ? 1 : currPage;
  currPage = currPage>pageCount ? pageCount : currPage;
  
  PreparedStatement pst = conn.prepareStatement("select * from student limit ?,?");
  pst.setInt(1,currPage*pageSize-pageSize);
  pst.setInt(2,pageSize);
  ResultSet rs = pst.executeQuery();
  
  while(rs.next()){
  %>
  <tr align="center">
  <td><%=rs.getInt(1) %></td>
  <td><%=rs.getString(2) %></td>
  <td><%=rs.getInt("age") %></td>
  <td><%=rs.getString(4) %></td>
  </tr>
  <%
  }
  %>
  <tr>
   <th colspan="4" class="page">
     <% 
     out.print(String.format("<a class="prev" href="?p=%d">首页</a>",1));
     if(currPage>=7){
       start=currPage-5;
       end=currPage+4;
     }
     if(start>(pageCount-10)){
       start=pageCount-9;
     }
     if(currPage>1){
       out.print(String.format("<a class="prev" href="?p=%d">上一页</a>",currPage-1));
     }
     
     for(int i=start;i<=end;i++){
       if(i>pageCount) break;
       String pageinfo=String.format("<a href="?p=%d">%d</a>",i,i);
       if(i==currPage){
       pageinfo=String.format("<span>%d</span>",i);
       }
       out.print(pageinfo);
     }
     
     if(currPage<=pageCount){
       out.print(String.format("<a class="prev" href="?p=%d">下一页</a>",currPage+1));
     }
     
     out.print(String.format("<a class="prev" href="?p=%d">尾页</a>",pageCount)); 
     %>
   </th>
   </tr>
</table>
</body>
</html>

以上这篇jsp页面数据分页模仿百度分页效果(实例讲解)就是小编分享给大家的全部内容了，希望能给大家一个参考，也希望大家多多支持CodeAE代码之家。

[JSP] jsp页面数据分页模仿百度分页效果(实例讲解)

相关帖子

显卡废了的表现

windows7忘记开机密码了怎么办 win7开机密码怎么跳过删除

利用CSS样式将网页变黑白色效果

2023微信红包封面制作教程,快来领取你的红包封面吧

Excel 使用技巧 - 如何使光标所在行的数据自动变颜色

7种好看的鼠标点击效果

好看的CSS3滑动按钮特效

php实现超简的分页功能

视频压缩软件_VideoMinimizer

Discuz X重置应用中心数据的方法

浅沫记忆 LV3