jsp实现分页技术

最新推荐文章于 2024-09-12 15:31:55 发布

ruanjiantaotao

最新推荐文章于 2024-09-12 15:31:55 发布

阅读量1k

点赞数

分类专栏： web 文章标签： jsp string sql class border import

本文链接：https://blog.csdn.net/ruanjiantaotao/article/details/704396

版权

web 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

<%@ page contentType="text/html;charset=GBK"%>
<%@ page import="java.sql.*,com.applestudio.util.*"%>
<%@ page errorPage="error.jsp"%>
<%
request.setCharacterEncoding("GBK");
int PageSize= 5;
int RecordNum=0;
int PageNum=1;
int CurrentPage;
int CurrentIndex;

String strPage = request.getParameter("page");
if(strPage==null){
CurrentPage = 1;
}else{
CurrentPage = Integer.parseInt(strPage);
if(CurrentPage<1) CurrentPage = 1;
}

OperationDB odb=new OperationDB();
String sql;
ResultSet rs;
%>
<html>
<head>
<title>测试分页</title>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body>

<table width="98%" border="0" cellpadding="0" cellspacing="0" height="151">
<%
sql="select * from sutdent";
rs=odb.executeQuery(sql);
if(!rs.last()){
out.println("<tr><td align=center height=25>无数据.</td></tr>");
}else{
RecordNum = rs.getRow();

PageNum = (RecordNum+PageSize-1) / PageSize;

if(CurrentPage>PageNum) CurrentPage = PageNum;

if(PageNum>0){
CurrentIndex=(CurrentPage-1) * PageSize + 1;
rs.absolute(CurrentIndex);
int endRow=CurrentIndex+PageSize;
while(!rs.isAfterLast()&&rs.getRow()!=endRow){
%>
<tr>
<td bgcolor="#dddddd" height="25"><b><%=rs.getString("name")%></b></td>
</tr>

<%
rs.next();
}
}
rs.close();
}

%>
<tr>
<td width="78%" style="padding:0;" align="right" height="8">
<%if(CurrentPage>1){%>
<a href="?page=1">第一页</a> 
<a href="?page=<%=CurrentPage-1%>">上一页</a> 
<%}else{%>
<font class="stext">第一页  上一页 </font>
<%}if(CurrentPage<PageNum){%>
<a href="?page=<%=CurrentPage+1%>">下一页</a> 
<a href="?page=<%=PageNum%>">第末页</a>
<%}else{%>
<font class="stext">下一页  第末页</font>
<%}%> 转到第<select οnchange="window.location='?page='+this.value" name="gopage">
<%for(int i=1;i<=PageNum;i++){%>
<option <%if(i==CurrentPage){%>selected<%}%> value="<%=i%>"><%=i%></option>
<%}%></select>页
</td>
</table>
</body>
</html>