当前位置：文档库 › 假分页代码

假分页代码

<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection"%>
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "https://www.wendangku.net/doc/e813029503.html,/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP分页显示</title>
</head>
<body>
<%
String dbDriver = "com.mysql.jdbc.Driver";
String dbUrl = "jdbc:mysql://localhost:3306/test";
String dbUser = "root";
String dbPass = "root";

String sql = "SELECT T1.* FROM BASIC_STUDENT_BASE T1 ORDER BY T1.STU_ID";

Class.forName(dbDriver);
Connection conn = DriverManager.getConnection(dbUrl, dbUser, dbPass);
PreparedStatement pstmt = conn.prepareStatement(sql);
ResultSet rs = pstmt.executeQuery();

https://www.wendangku.net/doc/e813029503.html,st(); //光标定位到最后一行

int pageSize = 10; // 页大小
int recordCount = rs.getRow(); //总记录数
int pageCount = recordCount % pageSize == 0 ? recordCount / pageSize : recordCount / pageSize + 1;

int showPage = 1; // 当前页
String strShowPage = request.getParameter("showPage");

try {
showPage = Integer.parseInt(strShowPage);
} catch (NumberFormatException e) {
}

if(showPage < 1) {
showPage = 1;
} else if(showPage > pageCount) {
showPage = pageCount;
}

if(showPage == 1) {
rs.beforeFirst(); //光标定位到第0行
} else {
rs.absolute((showPage - 1) * pageSize); //光标定位到指定行
}
%>
<table width="800px;" border="1">
<tr>
<th>学生编号</th>
<th>学生姓名</th>
<th>学生年龄</th>
</tr>
<%
int tempCount = 1;
while(rs.next()) {
%>
<tr>
<td><%=rs.getInt(1)%></td>
<td><%=rs.getString(2)%></td>
<td><%=rs.getInt(3)%></td>
</tr>
<%
if(tempCount++ == 10) {break;}
}
%>
</table>
<table width="800px;" border="1">
<tr>
<td align="right">
每页<%=pageSize%>条/共<%=recordCount%>条第<input type="text" name="showpage" value="<%=showPage%>" size="3">页/共<%=pageCount%>页
<%
if(showPage <= 1) {
%>
首页上一页
<%
} else {
%>
<a href="page.jsp?showPage=1">首页</a>
<a href="page.jsp?showPage=<%=showPage - 1%>">上一页</a>
<%
}
%>

<%
if(showPage >= pageCount) {
%>

下一页尾页
<%
} else {
%>

<a href="page.jsp?showPage=<%=showPage + 1%>">下一页</a>
<a href="page.jsp?showPage=<%=pageCount%>">尾页</a>
<%
}
%>
</td>
</tr>
</table>
<%
rs.close();
pstmt.close();
conn.close();
%>
</body>
</html>