JSP實現的簡單分頁示例

2024-09-05 00:22:23

字體：大中小

來源：轉載

供稿：網友

這篇文章主要介紹了JSP實現的簡單分頁,涉及jsp簡單數據庫查找及遍歷實現分頁的相關技巧,具有一定參考借鑒價值,需要的朋友可以參考下

本文實例講述了JSP實現的簡單分頁示例。分享給大家供大家參考，具體如下：

<%@ page language="java" import="java.util.*" contentType="text/html; charset=gbk"%>

<%@ page import="com.yx.page.db.*"%>

<%@ page import="java.sql.*" %>

<html>

<head>

<title>My JSP 'page01.jsp' starting page</title>

</head>

<body>

<center>

<%!

final String jspURL = "page04.jsp";

%>

<%

// 定義如下分頁變量

// 1、定義每頁要顯示的記錄數

int lineSize = 10 ;

// 2、定義一個當前是第幾頁

int currentPage = 1 ;

//接受傳過來的當前頁

%>

<%

try{

currentPage = Integer.parseInt(request.getParameter("cp"));

}catch(Exception e){

e.printStackTrace();

}

%>

<%

Connection conn = null;

PreparedStatement pStmt = null;

ResultSet rs = null;

GetConnection getConnection = new GetConnection(); //自定義數據庫連接操作 DAO

%>

<script language="javascript">

function openPage(curpage){

document.form1.cp.value=curpage;

document.form1.submit();

}

</script>

<form action="<%=jspURL%>" method="post" name="form1">

<input name="button1" type="button" value="首頁" onClick="openPage(1)">

<input name="button2" type="button" value="上一頁" onClick="openPage(<%=currentPage-1%>)">

<input name="button3" type="button" value="下一頁" onClick="openPage(<%=currentPage+1%>)">

<input name="button4" type="button" value="尾頁">

<input name="cp" type="hidden" value="" />

</form>

<table width="80%" border="1">

<%

try{

String strSql= "select * from person";

pStmt = getConnection.getPreStatement(strSql);

rs = pStmt.executeQuery();

%>

<tr>

<td align="center">編號</td>

<td align="center">登陸名稱</td>

<td align="center">姓名</td>

<td align="center">密碼</td>

<td colspan="2" align="center">操作</td>

</tr>

<%

for(int x=0; x<(currentPage-1)*lineSize; x++){

rs.next();

}

for(int x=0; x<lineSize; x++){

if(rs.next()){

int id = rs.getInt(1);

String uid = rs.getString(2);

String name = rs.getString(3);

String pass = rs.getString(4);

%>

<tr>

<td><%=id%></td>

<td><%=uid%></td>

<td><%=name%></td>

<td><%=pass%></td>

<td>更改</td>

<td>刪除</td>

</tr>

<%

}

}

}catch(Exception e){

%>

<h4>系統有錯誤</h4>

<%

e.printStackTrace();

}finally{

getConnection.getAllClose(conn,pStmt,rs);

}

%>

</table>

</center>

</body>

</html>