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>