JSP实现的简单分页示例
本文实例讲述了JSP实现的简单分页示例。分享给大家供大家参考，具体如下：
<%@pagelanguage="java"import="java.util.*"contentType="text/html;charset=gbk"%>
<%@pageimport="com.yx.page.db.*"%>
<%@pageimport="java.sql.*"%>
<html>
<head>
<title>MyJSP'page01.jsp'startingpage</title>
</head>
<body>
<center>
<%!
finalStringjspURL="page04.jsp";
%>
<%
//定义如下分页变量
//1、定义每页要显示的记录数
intlineSize=10;
//2、定义一个当前是第几页
intcurrentPage=1;
//接受传过来的当前页
%>
<%
try{
currentPage=Integer.parseInt(request.getParameter("cp"));
}catch(Exceptione){
e.printStackTrace();
}
%>
<%
Connectionconn=null;
PreparedStatementpStmt=null;
ResultSetrs=null;
GetConnectiongetConnection=newGetConnection();//自定义数据库连接操作DAO
%>
<scriptlanguage="javascript">
functionopenPage(curpage){
document.form1.cp.value=curpage;
document.form1.submit();
}
</script>
<formaction="<%=jspURL%>"method="post"name="form1">
<inputname="button1"type="button"value="首页"onClick="openPage(1)">
<inputname="button2"type="button"value="上一页"onClick="openPage(<%=currentPage-1%>)">
<inputname="button3"type="button"value="下一页"onClick="openPage(<%=currentPage+1%>)">
<inputname="button4"type="button"value="尾页">
<inputname="cp"type="hidden"value=""/>
</form>
<tablewidth="80%"border="1">
<%
try{
StringstrSql="select*fromperson";
pStmt=getConnection.getPreStatement(strSql);
rs=pStmt.executeQuery();
%>
<tr>
<tdalign="center">编号</td>
<tdalign="center">登陆名称</td>
<tdalign="center">姓名</td>
<tdalign="center">密码</td>
<tdcolspan="2"align="center">操作</td>
</tr>
<%
for(intx=0;x<(currentPage-1)*lineSize;x++){
rs.next();
}
for(intx=0;x<lineSize;x++){
if(rs.next()){
intid=rs.getInt(1);
Stringuid=rs.getString(2);
Stringname=rs.getString(3);
Stringpass=rs.getString(4);
%>
<tr>
<td><%=id%></td>
<td><%=uid%></td>
<td><%=name%></td>
<td><%=pass%></td>
<td>更改</td>
<td>删除</td>
</tr>
<%
}
}
}catch(Exceptione){
%>
<h4>系统有错误</h4>
<%
e.printStackTrace();
}finally{
getConnection.getAllClose(conn,pStmt,rs);
}
%>
</table>
</center>
</body>
</html>
希望本文所述对大家JSP程序设计有所帮助。