<%@ 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="https://bbs.csdn.net/topics/css/bootstrap.css" />
<!--jquery在bootstrap.js之前-->
<script src="https://bbs.csdn.net/topics/js/jquery.js" type="text/javascript" charset="utf-8"></script>
<script src="https://bbs.csdn.net/topics/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">
<!-- Brand and toggle get grouped for better mobile display -->
<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="https://bbs.csdn.net/topics/#">
<img alt="Brand" src="https://img.uj5u.com/2020/09/23/124894230739581.png">
</a>
</div>
<ul class="nav navbar-nav navbar-right">
<li><a href="https://bbs.csdn.net/topics/#" data-toggle="modal" data-target=".bs-example-modal-sm">
<%=session.getAttribute("UserName") %>
</a></li>
</ul>
</div><!-- /.navbar-collapse -->
</div><!-- /.container-fluid -->
</nav>
<div class="row">
<div class="top">
<center>
<ul>
<li><a href="https://bbs.csdn.net/topics/glyindex.jsp">主頁資訊</a></li>
<li>
<a href="https://bbs.csdn.net/topics/ckyish.jsp">醫生資訊</a>
</li>
<li>
<a href="https://bbs.csdn.net/topics/addyish.jsp">添加醫生</a>
</li>
<li>
<a href="https://bbs.csdn.net/topics/ckyaow.jsp">藥品資訊</a>
</li>
<li>
<a href="https://bbs.csdn.net/topics/addyaow.jsp">添加藥品</a>
</li>
<li>
<a href="https://bbs.csdn.net/topics/ckkes.jsp">科室資訊</a>
</li>
<li><a href="https://bbs.csdn.net/topics/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="https://bbs.csdn.net/topics/glyindex.jsp">主頁</a>
</li>
<li class="cart" style="display:{$dsaddress ? 'block': 'none'}">
<a class="toolbars-ico" href="https://bbs.csdn.net/topics/ckyish.jsp">醫生資訊</a>
</li>
<li class="cart" style="display:{$dsaddress ? 'block': 'none'}">
<a class="toolbars-ico" href="https://bbs.csdn.net/topics/ckyaow.jsp">藥品資訊</a>
</li>
<li class="cart" style="display:{$dsaddress ? 'block': 'none'}">
<a class="toolbars-ico" href="https://bbs.csdn.net/topics/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="https://bbs.csdn.net/topics/xgyaow.jsp?selectid=">修改</a></td>
<td><a href="https://bbs.csdn.net/topics/scyaow.jsp?selectid=">洗掉</a></td>
</tr>
<% } %>
</table>
<nav aria-label="Page navigation">
<ul class="pagination">
<%
if(pagenow>0) {
%>
<%System.out.println("pagenow_1"+pagenow); %>
<li><a href=https://bbs.csdn.net/topics/ckyaow.jsp?pagenow= >【 上一頁 】
<%
}else{
%>
<li><a href=https://bbs.csdn.net/topics/ckyaow.jsp?pagenow= >【 上一頁 】
<%
}
%>
<%
int useID=0;
int pagenum = pageCount/pageSize ;
if( pageCount % pageSize != 0 ) pagenum++ ;
for( useID=1 ; useID<=pagenum ; useID++ ){
%>
<li><a href=https://bbs.csdn.net/topics/ckyaow.jsp?pagenow= >【】
<%
}
if( pagenow +1<pagenum ){
%>
<li><a href=https://bbs.csdn.net/topics/ckyaow.jsp?pagenow= >【 下一頁 】
<% }else{ %>
<li><a href=https://bbs.csdn.net/topics/ckyaow.jsp?pagenow= >【 下一頁 】
<% }%>
</ul>
</nav>
</body>
</html>
uj5u.com熱心網友回復：
每次顯示10頁，是什么意思？如果覺得分頁頁數太多的話，那就增加每頁顯示條數。即修改int default_size =30;這個引數即可。
uj5u.com熱心網友回復：
就是在第7頁時，要讓下面的頁碼只顯示相鄰的10個頁碼uj5u.com熱心網友回復：
一般這個問題都是靠前段分頁插件來搞的的。不過學習目的的話也可以自己寫一下提供下思路：
首先確認每頁只展示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次即可。
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/110233.html
標籤：Web 開發