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

2024-02-05 15:10:03 201

<%@pageimport="web09.shop.DBUtil"%> <%@pageimport="java.sql.ResultSet"%> <%@pageimport="java.sql.PreparedStatement"%> <%@pageimport="java.sql.Connection"%> <%@pagelanguage="java"pageEncoding="UTF-8"%> 数据分页 .pagea{ min-width:34px; height:34px; border:1pxsolid#e1e2e3; cursor:pointer; display:block; float:left; text-decoration:none; text-align:center; line-height:34px; } .pagea:HOVER{ background:#f2f8ff; border:1pxsolid#38f; } .pagea.prev{ width:50px; } .pagespan{ width:34px; height:34px; border:1pxsolidtransparent; cursor:pointer; display:block; float:left; text-decoration:none; text-align:center; line-height:34px; cursor:default; } ID 姓名年龄专业 <% DBUtildbutil=newDBUtil(); Connectionconn=dbutil.getCon(); //Connectionconn=newDBUtil().getCon(); PreparedStatementpstmt1=conn.prepareStatement("selectcount(*)fromstudent"); ResultSetrs1=pstmt1.executeQuery(); rs1.next(); intrecordCount=rs1.getInt(1);//记录总数 intpageSize=10;//每页记录数 intstart=1;//显示开始页 intend=10;//显示结束页 intpageCount=recordCount%pageSize==0?recordCount/pageSize:recordCount/pageSize+1; intcurrPage=request.getParameter("p")==null?1:Integer.parseInt(request.getParameter("p")); currPage=currPage<1?1:currPage; currPage=currPage>pageCount?pageCount:currPage; PreparedStatementpst=conn.prepareStatement("select*fromstudentlimit?,?"); pst.setInt(1,currPage*pageSize-pageSize); pst.setInt(2,pageSize); ResultSetrs=pst.executeQuery(); while(rs.next()){ %> <%=rs.getInt(1)%> <%=rs.getString(2)%> <%=rs.getInt("age")%> <%=rs.getString(4)%> <% } %> <% out.print(String.format("首页",1)); if(currPage>=7){ start=currPage-5; end=currPage+4; } if(start>(pageCount-10)){ start=pageCount-9; } if(currPage>1){ out.print(String.format("上一页",currPage-1)); } for(inti=start;i<=end;i++){ if(i>pageCount)break; Stringpageinfo=String.format("%d",i,i); if(i==currPage){ pageinfo=String.format("%d",i); } out.print(pageinfo); } if(currPage<=pageCount){ out.print(String.format("下一页",currPage+1)); } out.print(String.format("尾页",pageCount)); %>

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

热门推荐

随机推荐