jsp 分页页数太多，怎么解决分页页数太多问题，每次让它显示10页

hjahfsa 2020-03-17 07:49:49

<%@ page language="java" import="java.util.*,java.sql.*" pageEncoding="utf-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
Class.forName("com.mysql.jdbc.Driver");//加载mysql驱动
Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/blgl", "root", "");//localhost是本机地址，3306是端口号，最后是用户名和密码
Statement stmt=conn.createStatement();//实例化Statement对象
int default_size =30;
int pageCount=0; //页面总数
int rowCount=0; //行数统计
int pagenow=0; //当前页面
int pageSize=default_size;
ResultSetMetaData rsmd =null;
String sql="select count(*) from yw ;";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next())
pageCount=rs.getInt(1);
String usernow = request.getParameter("pagenow");
if(usernow != null && !usernow.isEmpty() ){
pagenow = Integer.parseInt(usernow);
}
sql ="select * from yw limit "+pagenow*pageSize+","+pageSize;

rs = stmt.executeQuery(sql);
rsmd = rs.getMetaData();
%>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8" />
<title>查看药物</title>
<link rel="stylesheet" type="text/css" href="css/bootstrap.css" />

<script src="js/jquery.js" type="text/javascript" charset="utf-8"></script>
<script src="js/bootstrap.js" type="text/javascript" charset="utf-8"></script>
<style type="text/css">
.top {
/* 设置宽度高度背景颜色 */
height: auto;
/*高度改为自动高度*/
width: 100%;
margin-left: 0;
background: rgb(230, 230, 230);

margin-bottom: 3px;
}

.top ul {
/* 清除ul标签的默认样式 */
width: auto;
/*宽度也改为自动*/
list-style-type: none;
white-space: nowrap;
overflow: hidden;
margin-left: 5%;
/* margin-top: 0; */
padding: 0;

}

.top li {
float: left;
/* 使li内容横向浮动，即横向排列 */
margin-right: 2%;
/* 两个li之间的距离*/
position: relative;
overflow: hidden;
}

.top li a {
/* 设置链接内容显示的格式*/
display: block;
/* 把链接显示为块元素可使整个链接区域可点击 */
color: #11;
text-align: center;
padding: 6px;
overflow: hidden;
text-decoration: none;
/* 去除下划线 */

}

.top li a:hover {
/* 鼠标选中时背景变为黑色 */
background-color: white;
}

.top ul li ul {
/* 设置二级菜单 */
margin-left: -0.2px;
background: rgb(230, 230, 230);
position: relative;
display: none;
/* 默认隐藏二级菜单的内容 */

}

.top ul li ul li {
/* 二级菜单li内容的显示 */

float: none;
text-align: center;
}

.top ul li:hover ul {
/* 鼠标选中二级菜单内容时 */
display: block;
}

.toolbars ul li {
list-style: none;
}

.toolbars ul a {
text-decoration: none;
color: #666;
}

.toolbars ul a:hover {
color: #969696 !important;
}

.toolbars {
position: fixed;
top: 0;
right: 0;
height: 100%;
width: 6px;
background-color: #7a6e6e;
}

.toolbars ul {
position: absolute;
top: 40%;
right: 0;
transform: translate(0, -40%);
z-index: 3;
}

.toolbars ul li {
width: 34px;
/* height: 35px; */
margin-bottom: 30px;
font-size: 15px;
background-color: #7A6E6E;
vertical-align: middle;
text-align: center;
position: relative;
}

.toolbars ul .jdvip .toolbars-ico {
display: block;
width: 34px;
/* height: 35px; */
color: #fff;
padding-top: 10px;
padding-bottom: 10px;
background-color: red;
}

.toolbars ul .cart .toolbars-ico {
display: block;
width: 34px;
/* height: 35px; */
color: #fff;
padding-top: 10px;
padding-bottom: 10px;
background-color: blue;
}
</style>
</head>

<body>
<nav class="navbar navbar-default">

<div class="container-fluid">

<div class="navbar-header">
<button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1"
aria-expanded="false">
<span class="sr-only">Toggle navigation</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
<a href="#">
<img alt="Brand" src="img/logo.png">
</a>
</div>
<ul class="nav navbar-nav navbar-right">
<li><a href="#" data-toggle="modal" data-target=".bs-example-modal-sm">
<%=session.getAttribute("UserName") %>
</a></li>
</ul>
</div>
</div>
</nav>
<div class="row">

<div class="top">
<center>
<ul>
<li><a href="glyindex.jsp">主页信息</a></li>
<li>
<a href="ckyish.jsp">医生信息</a>
</li>
<li>
<a href="addyish.jsp">添加医生</a>
</li>
<li>
<a href="ckyaow.jsp">药品信息</a>
</li>
<li>
<a href="addyaow.jsp">添加药品</a>
</li>
<li>
<a href="ckkes.jsp">科室信息</a>
</li>
<li><a href="addkes.jsp">添加科室</a></li>

</ul>
</center>
</div>

</div>

<div class="toolbars">
<ul>
<li class="cart" style="display:{$dsaddress ? 'block': 'none'}">
<a class="toolbars-ico" href="glyindex.jsp">主页</a>
</li>
<li class="cart" style="display:{$dsaddress ? 'block': 'none'}">
<a class="toolbars-ico" href="ckyish.jsp">医生信息</a>
</li>
<li class="cart" style="display:{$dsaddress ? 'block': 'none'}">
<a class="toolbars-ico" href="ckyaow.jsp">药品信息</a>
</li>
<li class="cart" style="display:{$dsaddress ? 'block': 'none'}">
<a class="toolbars-ico" href="ckkes.jsp">科室信息</a>
</li>
</ul>
</div>
<table class="table table-striped">
<tr>
<td>
药物编号：
</td>
<td>药物名称：</td>
<td>药物剂量：</td>

<td>生产厂家：</td>
<td colspan="2">操作</td>
</tr>

<% int col = rsmd.getColumnCount();
while(rs.next()){
%>
<tr>
<%
for(int i=1; i<=col ;i++){
%>
<td><%=rs.getString(i)%></td>
<% } %>
<td><a href="xgyaow.jsp?selectid=<%=rs.getString(1) %>">修改</a></td>
<td><a href="scyaow.jsp?selectid=<%=rs.getString(1) %>">删除</a></td>
</tr>

<% } %>
</table>
<nav aria-label="Page navigation">
<ul class="pagination">

<%
if(pagenow>0) {
%>
<%System.out.println("pagenow_1"+pagenow); %>
<li><a href=ckyaow.jsp?pagenow=<%=pagenow-1%> >【上一页】 </a></li>
<%
}else{
%>
<li><a href=ckyaow.jsp?pagenow=<%=pagenow%> >【上一页】 </a> </li>
<%
}
%>
<%
int useID=0;
int pagenum = pageCount/pageSize ;
if( pageCount % pageSize != 0 ) pagenum++ ;

for( useID=1 ; useID<=pagenum ; useID++ ){
%>

<li><a href=ckyaow.jsp?pagenow=<%=useID-1 %> >【<%=useID %>】</a></li>
<%
}
if( pagenow +1<pagenum ){
%>

<li><a href=ckyaow.jsp?pagenow=<%=1+pagenow%> >【下一页】 </a> </li>
<% }else{ %>
<li><a href=ckyaow.jsp?pagenow=<%=pagenow%> >【下一页】 </a> </li>
<% }%>

</ul>
</nav>
</body>
</html>

...全文

511 3 打赏收藏转发到动态举报

写回复

用AI写文章

3 条回复

切换为时间正序

请发表友善的回复…

发表回复

_大唐双龙 2020-03-23

打赏
举报

一般这个问题都是靠前段分页插件来搞的的。不过学习目的的话也可以自己写一下提供下思路：首先确认每页只展示10个页签，然后判断当前页码。 //总页 int pageSize= 10; //当前页 int page = 7; int index1=1; int index2=pageSize; if(pageSize-page>10){ index1 = (page-5)>0?(page-5)+1:1; index2 = (pageSize>index1+9?index1+9:pageSize); } System.out.println(index1+","+index2); 根据index1来判断循环从哪个数据开始，循环10次即可。

hjahfsa 2020-03-22