看看JSP中怎樣實現分頁顯示（僱員管理）

mlinge-奮鬥吧發表於2012-08-01

分頁顯示在實際的開發中使用的是非常的多，下面是一個對僱員列表進行顯示的例子，分別使用不分頁、分頁（假分頁和真分頁）進行顯示，有完整的程式碼，如果你想學習分頁，這絕對是很好的學習資料。

1、不使用分頁進行顯示，程式碼如下：

emp_list.jsp:

<%@ page contentType="text/html" pageEncoding="GBK"%>
<%@ page import="java.sql.*" %>
<html>
<head><title>僱員列表顯示</title>
<style type="text/css">
<!--
.STYLE6 {font-size: 12px}
.STYLE10 {font-size: 14px; font-weight: bold; }
-->
</style>
</head>
	<script language="javascript">
		function changeColor(obj,color){
			obj.bgColor = color ;
		}
	</script>
<body>
<%!
	public static final String DBDRIVER = "oracle.jdbc.driver.OracleDriver" ;
	public static final String DBURL = "jdbc:oracle:thin:@localhost:1521:ORACLE" ;
	public static final String DBUSER = "scott" ;
	public static final String DBPASSWORD = "tiger" ;
%>
<%
	Connection conn = null ;
	PreparedStatement pstmt = null ;
	ResultSet rs = null ;
%>
<%
	Class.forName(DBDRIVER) ;
	conn = DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD) ;
	String sql = "SELECT empno,ename,job,hiredate,sal,comm FROM emp ORDER BY empno" ;
	pstmt = conn.prepareStatement(sql) ;
	rs = pstmt.executeQuery() ;
%>
<center>
	<h1>僱員列表</h1>
<TABLE BORDER="1" cellpadding="5" cellspacing="0" bgcolor="F2F2F2" width="80%">
	<TR onMouseOver="changeColor(this,'white')" onMouseOut="changeColor(this,'F2F2F2')">
		<td align="center" valign="middle"><span class="STYLE10">編號</span></td>
		<td align="center" valign="middle"><span class="STYLE10">姓名</span></td>
		<td align="center" valign="middle"><span class="STYLE10">職位</span></td>
		<td align="center" valign="middle"><span class="STYLE10">僱傭日期</span></td>
		<td align="center" valign="middle"><span class="STYLE10">工資</span></td>
		<td align="center" valign="middle"><span class="STYLE10">獎金</span></td>
	</TR>
<%
	while(rs.next()){
		int empno = rs.getInt(1) ;
		String ename = rs.getString(2) ;
		String job = rs.getString(3) ;
		Date hiredate = rs.getDate(4) ;
		double sal = rs.getDouble(5) ;
		double comm = rs.getDouble(6) ;
%>
	<TR onMouseOver="changeColor(this,'white')" onMouseOut="changeColor(this,'F2F2F2')">
		<td align="center" valign="middle"><span class="STYLE6"><%=empno%></span></td>
		<td align="center" valign="middle"><span class="STYLE6"><%=ename%></span></td>
		<td align="center" valign="middle"><span class="STYLE6"><%=job%></span></td>
		<td align="center" valign="middle"><span class="STYLE6"><%=hiredate%></span></td>
		<td align="center" valign="middle"><span class="STYLE6"><%=sal%></span></td>
		<td align="center" valign="middle"><span class="STYLE6"><%=comm%></span></td>
	</TR>
<%
	}
%>
</table>
<%
	conn.close() ;
%>
</center>
</body>
</html>

不分頁顯示的時候的執行效果如下：

2、使用假分頁來進行顯示，程式碼如下：

emp_list_false.jsp:

<%@ page contentType="text/html" pageEncoding="GBK"%>
<%@ page import="java.sql.*" %>
<html>
<head><title>僱員列表顯示</title>
<style type="text/css">
<!--
.STYLE6 {font-size: 12px}
.STYLE10 {font-size: 14px; font-weight: bold; }
-->
</style>
</head>
	<script language="javascript">
		function changeColor(obj,color){
			obj.bgColor = color ;
		}
	</script>
<body>
<%!
	public static final String URL = "emp_list_false.jsp" ;
%>
<%!
	public static final String DBDRIVER = "oracle.jdbc.driver.OracleDriver" ;
	public static final String DBURL = "jdbc:oracle:thin:@localhost:1521:MLDN" ;
	public static final String DBUSER = "scott" ;
	public static final String DBPASSWORD = "tiger" ;
%>
<%
	Connection conn = null ;
	PreparedStatement pstmt = null ;
	ResultSet rs = null ;
%>
<%
	int currentPage = 1 ;	// 為當前所在的頁，預設在第1頁
	int lineSize = 3 ;		// 每次顯示的記錄數
	int allRecorders = 0 ;	// 表示全部的記錄數
	int pageSize = 1 ;		// 表示全部的頁數（尾頁）
	int lsData[] = {1,3,5,7,9,10,15,20,25,30,50,100} ;
%>
<%
	try{
		currentPage = Integer.parseInt(request.getParameter("cp")) ;
	} catch(Exception e) {}
	try{
		lineSize = Integer.parseInt(request.getParameter("ls")) ;
	} catch(Exception e) {}
%>
<%
	Class.forName(DBDRIVER) ;
	conn = DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD) ;
	String sql = "SELECT COUNT(empno) FROM emp" ;
	pstmt = conn.prepareStatement(sql) ;
	rs = pstmt.executeQuery() ;
	if(rs.next()){	// 取得全部的記錄數
		allRecorders = rs.getInt(1) ;
	}
%>
<center> 
	<h1>僱員列表</h1>
<script language="javascript">
	function go(num){
		document.getElementById("cp").value = num ;
		document.spform.submit() ;	// 表單提交
	}
</script>
<%
	pageSize = (allRecorders + lineSize -1) / lineSize ;
%>
<%
	sql = "SELECT empno,ename,job,hiredate,sal,comm FROM emp ORDER BY empno" ;
	pstmt = conn.prepareStatement(sql) ;
	rs = pstmt.executeQuery() ;
%>
<form name="spform" action="<%=URL%>" method="post">
	<input type="button" value="首頁" onclick="go(1)" <%=currentPage==1?"DISABLED":""%>>
	<input type="button" value="上一頁" onclick="go(<%=currentPage-1%>)" <%=currentPage==1?"DISABLED":""%>>
	<input type="button" value="下一頁" onclick="go(<%=currentPage+1%>)" <%=currentPage==pageSize?"DISABLED":""%>>
	<input type="button" value="尾頁" onclick="go(<%=pageSize%>)" <%=currentPage==pageSize?"DISABLED":""%>>
	跳轉到第<select name="selcp" onchange="go(this.value)">
		<%
			for(int x=1;x<=pageSize;x++){
		%>
				<option value="<%=x%>" <%=x==currentPage?"SELECTED":""%>><%=x%></option>
		<%
			}
		%>
	</select>頁
	每頁顯示
		<select name="ls" onchange="go(1)">
		<%
			for(int x=0;x<lsData.length;x++){
		%>
			<option value="<%=lsData[x]%>" <%=lsData[x]==lineSize?"SELECTED":""%>><%=lsData[x]%></option>
		<%
			}
		%>
		</select>
	條
	<input type="hidden" name="cp" value="1">
</form>
<TABLE BORDER="1" cellpadding="5" cellspacing="0" bgcolor="F2F2F2" width="100%">
	<TR onMouseOver="changeColor(this,'white')" onMouseOut="changeColor(this,'F2F2F2')">
		<td align="center" valign="middle"><span class="STYLE10">編號</span></td>
		<td align="center" valign="middle"><span class="STYLE10">姓名</span></td>
		<td align="center" valign="middle"><span class="STYLE10">職位</span></td>
		<td align="center" valign="middle"><span class="STYLE10">僱傭日期</span></td>
		<td align="center" valign="middle"><span class="STYLE10">工資</span></td>
		<td align="center" valign="middle"><span class="STYLE10">獎金</span></td>
	</TR>
<%
for(int x=0;x<(currentPage-1)*lineSize;x++){
	rs.next() ;
}
for(int x=0;x<lineSize;x++){
	if(rs.next()){
		int empno = rs.getInt(1) ;
		String ename = rs.getString(2) ;
		String job = rs.getString(3) ;
		Date hiredate = rs.getDate(4) ;
		double sal = rs.getDouble(5) ;
		double comm = rs.getDouble(6) ;
%>
	<TR onMouseOver="changeColor(this,'white')" onMouseOut="changeColor(this,'F2F2F2')">
		<td align="center" valign="middle"><span class="STYLE6"><%=empno%></span></td>
		<td align="center" valign="middle"><span class="STYLE6"><%=ename%></span></td>
		<td align="center" valign="middle"><span class="STYLE6"><%=job%></span></td>
		<td align="center" valign="middle"><span class="STYLE6"><%=hiredate%></span></td>
		<td align="center" valign="middle"><span class="STYLE6"><%=sal%></span></td>
		<td align="center" valign="middle"><span class="STYLE6"><%=comm%></span></td>
	</TR>
<%
	}
}
%>
</table>
<%
	conn.close() ;
%>
</center>
</body>
</html>

使用假分頁進行顯示的時候的效果如下：

3、使用真分頁進行顯示僱員列表，程式碼如下：

emp_list_true.jsp:

<%@ page contentType="text/html" pageEncoding="GBK"%>
<%@ page import="java.sql.*" %>
<html>
<head><title>僱員列表顯示</title>
<style type="text/css">
<!--
.STYLE6 {font-size: 12px}
.STYLE10 {font-size: 14px; font-weight: bold; }
-->
</style>
</head>
	<script language="javascript">
		function changeColor(obj,color){
			obj.bgColor = color ;
		}
	</script>
<body>
<%!
	public static final String URL = "emp_list_true.jsp" ;
%>
<%!
	public static final String DBDRIVER = "oracle.jdbc.driver.OracleDriver" ;
	public static final String DBURL = "jdbc:oracle:thin:@localhost:1521:ORACLE" ;
	public static final String DBUSER = "scott" ;
	public static final String DBPASSWORD = "tiger" ;
%>
<%
	Connection conn = null ;
	PreparedStatement pstmt = null ;
	ResultSet rs = null ;
%>
<%
	int currentPage = 1 ;	// 為當前所在的頁，預設在第1頁
	int lineSize = 3 ;		// 每次顯示的記錄數
	int allRecorders = 0 ;	// 表示全部的記錄數
	int pageSize = 1 ;		// 表示全部的頁數（尾頁）
	int lsData[] = {1,3,5,7,9,10,15,20,25,30,50,100} ;
%>
<%
	try{
		currentPage = Integer.parseInt(request.getParameter("cp")) ;
	} catch(Exception e) {}
	try{
		lineSize = Integer.parseInt(request.getParameter("ls")) ;
	} catch(Exception e) {}
%>
<%
	Class.forName(DBDRIVER) ;
	conn = DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD) ;
	String sql = "SELECT COUNT(empno) FROM emp" ;
	pstmt = conn.prepareStatement(sql) ;
	rs = pstmt.executeQuery() ;
	if(rs.next()){	// 取得全部的記錄數
		allRecorders = rs.getInt(1) ;
	}
%>
<center> 
	<h1>僱員列表</h1>
<script language="javascript">
	function go(num){
		document.getElementById("cp").value = num ;
		document.spform.submit() ;	// 表單提交
	}
</script>
<%
	pageSize = (allRecorders + lineSize -1) / lineSize ;
%>
<%
	sql = 	"SELECT * FROM (	" + 
			" SELECT empno,ename,job,hiredate,sal,comm,ROWNUM rn " +
			" FROM emp WHERE ROWNUM<=? ORDER BY empno) temp " + 
			" WHERE temp.rn>? " ;
	pstmt = conn.prepareStatement(sql) ;
	pstmt.setInt(1,currentPage * lineSize) ;
	pstmt.setInt(2,(currentPage-1) * lineSize) ;
	rs = pstmt.executeQuery() ;
%>
<form name="spform" action="<%=URL%>" method="post">
	<input type="button" value="首頁" onclick="go(1)" <%=currentPage==1?"DISABLED":""%>>
	<input type="button" value="上一頁" onclick="go(<%=currentPage-1%>)" <%=currentPage==1?"DISABLED":""%>>
	<input type="button" value="下一頁" onclick="go(<%=currentPage+1%>)" <%=currentPage==pageSize?"DISABLED":""%>>
	<input type="button" value="尾頁" onclick="go(<%=pageSize%>)" <%=currentPage==pageSize?"DISABLED":""%>>
	跳轉到第<select name="selcp" onchange="go(this.value)">
		<%
			for(int x=1;x<=pageSize;x++){
		%>
				<option value="<%=x%>" <%=x==currentPage?"SELECTED":""%>><%=x%></option>
		<%
			}
		%>
	</select>頁
	每頁顯示
		<select name="ls" onchange="go(1)">
		<%
			for(int x=0;x<lsData.length;x++){
		%>
			<option value="<%=lsData[x]%>" <%=lsData[x]==lineSize?"SELECTED":""%>><%=lsData[x]%></option>
		<%
			}
		%>
		</select>
	條
	<input type="hidden" name="cp" value="1">
</form>
<TABLE BORDER="1" cellpadding="5" cellspacing="0" bgcolor="F2F2F2" width="80%">
	<TR onMouseOver="changeColor(this,'white')" onMouseOut="changeColor(this,'F2F2F2')">
		<td align="center" valign="middle"><span class="STYLE10">編號</span></td>
		<td align="center" valign="middle"><span class="STYLE10">姓名</span></td>
		<td align="center" valign="middle"><span class="STYLE10">職位</span></td>
		<td align="center" valign="middle"><span class="STYLE10">僱傭日期</span></td>
		<td align="center" valign="middle"><span class="STYLE10">工資</span></td>
		<td align="center" valign="middle"><span class="STYLE10">獎金</span></td>
	</TR>
<%
	while(rs.next()){
		int empno = rs.getInt(1) ;
		String ename = rs.getString(2) ;
		String job = rs.getString(3) ;
		Date hiredate = rs.getDate(4) ;
		double sal = rs.getDouble(5) ;
		double comm = rs.getDouble(6) ;
%>
	<TR onMouseOver="changeColor(this,'white')" onMouseOut="changeColor(this,'F2F2F2')">
		<td align="center" valign="middle"><span class="STYLE6"><%=empno%></span></td>
		<td align="center" valign="middle"><span class="STYLE6"><%=ename%></span></td>
		<td align="center" valign="middle"><span class="STYLE6"><%=job%></span></td>
		<td align="center" valign="middle"><span class="STYLE6"><%=hiredate%></span></td>
		<td align="center" valign="middle"><span class="STYLE6"><%=sal%></span></td>
		<td align="center" valign="middle"><span class="STYLE6"><%=comm%></span></td>
	</TR>
<%
	}
%>
</table>
<%
	conn.close() ;
%>
</center>
</body>
</html>

真分頁顯示的結果如下：

JSP怎樣將查詢的資料實現分頁操作
2020-12-03
JS
java web實現分頁顯示資料
2015-08-04
JavaWeb
jsp分頁功能的實現
2014-11-19
JS
用javabean來實現MySQL的分頁顯示(轉)
2007-08-11
JavaBeanMySql
asp.net mvc 中利用jquery datatables 實現資料分頁顯示
2017-06-22
ASP.NETMVCjQuery
用struts的標籤怎樣實現分頁？
2003-04-29
php分頁顯示
2021-09-09
PHP
MyFaces整合sitemesh，以及使用MyFaces實現資料分頁顯示
2006-03-09
利用ASP實現Oracle資料記錄的分頁顯示
2009-09-29
Oracle
JSP中讀資料庫顯示為“??”怎麼辦？
2003-05-08
JS資料庫
JBOSS執行JSP檔案，頁面顯示如下資訊JBOSS執行JSP檔案，頁面顯示如下
2004-07-03
JS
實現分頁顯示資料[並按關鍵字查詢]
2012-08-01
flash在jsp中不能顯示？
2009-12-04
JS
win10工作管理員顯示不全怎麼解決_win10工作管理員顯示不全的修復方法
2020-02-11
Win10
java-用SSH框架實現將查詢的資訊分頁顯示
2016-11-16
Java框架
如何實現網頁文字原格式顯示
2017-02-26
網頁
C# GridView 分頁顯示
2009-07-10
C#View
gridview中實現分頁
2009-10-28
View
使用PagedDataSource類實現DataList和Repeater控制元件的分頁顯示 (轉)
2007-08-16
控制元件
Laravel 怎樣來實現，後臺管理員操作詳情 CURD 記錄？
2019-05-26
Laravel
關於黑馬旅遊網的實現 --- 分頁查詢功能，點選分頁碼不顯示資料
2020-09-26
java byte[] 轉圖片在jsp頁面顯示
2012-08-24
JavaJS
php怎麼實現定位地圖顯示
2021-09-11
PHP地圖
petStore管理員的Rich Client無法顯示
2003-08-21
client
用CSS樣式實現顯示隱藏層 (轉)
2007-12-05
CSS
【JS】javascript實現頁面顯示數字時鐘
2018-06-26
JSJavaScript
Win10系統怎麼在工作管理員顯示顯示卡溫度
2019-08-23
Win10
實現小資料量和海量資料的通用分頁顯示儲存過程
2007-01-11
儲存過程
利用MySQL的一個特性實現MySQL查詢結果的分頁顯示(轉)
2007-08-15
MySql
MongoDB之資料查詢（分頁顯示）
2017-08-24
MongoDB
ListView分頁顯示上拉載入更多
2016-08-05
View
admin\index.jsp中的main.jsp無法顯示？
2002-11-04
IndexJSAI
word首頁不顯示頁碼怎麼設定如何讓頁碼從第二頁開始顯示
2022-04-22
Django實現圖片上傳並前端頁面顯示
2020-06-26
Django前端
將分頁功能從JSP頁面中獨立出來
2015-04-22
JS
【分類不顯示】後臺設定了分類，前臺怎麼不顯示？
2019-05-11
oracle rownum分頁與顯示記錄小測
2013-01-10
Oracle
Mybatis分頁外掛只顯示第一頁的問題
2018-09-29
MyBatis

看看JSP中怎樣實現分頁顯示（僱員管理）

相關文章