纯Jsp分页

最新推荐文章于 2022-06-30 14:29:28 发布

刘利新西安

最新推荐文章于 2022-06-30 14:29:28 发布

阅读量631

点赞数

分类专栏： Jsp

Jsp 专栏收录该内容

48 篇文章 0 订阅

订阅专栏

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"%>
<%@ page import="java.sql.PreparedStatement"%>
<%@ page import="java.sql.ResultSet"%>
<%@ page import="java.sql.Connection"%>
<%@ page import="java.sql.DriverManager"%>
<%!public int nullIntconv(String str) {
		int conv = 0;
		if (str == null) {
			str = "0";
		} else if ((str.trim()).equals("null")) {
			str = "0";
		} else if (str.equals("")) {
			str = "0";
		}
		try {
			conv = Integer.parseInt(str);
		} catch (Exception e) {
		}
		return conv;
	}%>
<%
	Connection conn = null;
	Class.forName("com.mysql.jdbc.Driver").newInstance();
	conn = DriverManager.getConnection(
			"jdbc:mysql://localhost:3306/adconnect", "root",
			"");

	ResultSet rsPagination = null;
	ResultSet rsRowCnt = null;

	PreparedStatement psPagination = null;
	PreparedStatement psRowCnt = null;

	int iShowRows = 5; // Number of records show on per page 
	int iTotalSearchRecords = 10; // Number of pages index shown 

	int iTotalRows = nullIntconv(request.getParameter("iTotalRows"));
	int iTotalPages = nullIntconv(request.getParameter("iTotalPages"));
	int iPageNo = nullIntconv(request.getParameter("iPageNo"));
	int cPageNo = nullIntconv(request.getParameter("cPageNo"));

	int iStartResultNo = 0;
	int iEndResultNo = 0;

	if (iPageNo == 0) {
		iPageNo = 0;
	} else {
		iPageNo = Math.abs((iPageNo - 1) * iShowRows);
	}

	String sqlPagination = "SELECT SQL_CALC_FOUND_ROWS * FROM books limit "
			+ iPageNo + "," + iShowRows + "";

	psPagination = conn.prepareStatement(sqlPagination);
	rsPagination = psPagination.executeQuery();

	 this will count total number of rows 
	String sqlRowCnt = "SELECT FOUND_ROWS() as cnt";
	psRowCnt = conn.prepareStatement(sqlRowCnt);
	rsRowCnt = psRowCnt.executeQuery();

	if (rsRowCnt.next()) {
		iTotalRows = rsRowCnt.getInt("cnt");
	}
%>
<html>
<head>
<title>Pagination of JSP page</title>

</head>
<body>
	<form name="frm">
		<input type="hidden" name="iPageNo" value="<%=iPageNo%>"> <input
			type="hidden" name="cPageNo" value="<%=cPageNo%>"> <input
			type="hidden" name="iShowRows" value="<%=iShowRows%>">
		<table width="100%" cellpadding="0" cellspacing="0" border="0">
			<tr>
				<td>Name</td>
				<td>Batch</td>
				<td>Address</td>
			</tr>
			<%
				while (rsPagination.next()) {
			%>
			<tr>
				<td><%=rsPagination.getString("book_name")%></td>
				<td><%=rsPagination.getString("book_author")%></td>
				<td><%=rsPagination.getString("category")%></td>
			</tr>
			<%
				}
			%>
			<%
				 calculate next record start record and end record 
				try {
					if (iTotalRows < (iPageNo + iShowRows)) {
						iEndResultNo = iTotalRows;
					} else {
						iEndResultNo = (iPageNo + iShowRows);
					}

					iStartResultNo = (iPageNo + 1);
					iTotalPages = ((int) (Math
							.ceil((double) iTotalRows / iShowRows)));

				} catch (Exception e) {
					e.printStackTrace();
				}
			%>
			<tr>
				<td colspan="3">
					<div>
						<%
							 index of pages 

							int i = 0;
							int cPage = 0;
							if (iTotalRows != 0) {
								cPage = ((int) (Math.ceil((double) iEndResultNo
										/ (iTotalSearchRecords * iShowRows))));

								int prePageNo = (cPage * iTotalSearchRecords)
										- ((iTotalSearchRecords - 1) + iTotalSearchRecords);
								if ((cPage * iTotalSearchRecords) - (iTotalSearchRecords) > 0) {
						%>
						<a href="index.jsp?iPageNo=<%=prePageNo%>&cPageNo=<%=prePageNo%>">
							<< Previous</a>
						<%
							}

								for (i = ((cPage * iTotalSearchRecords) - (iTotalSearchRecords - 1)); i <= (cPage * iTotalSearchRecords); i++) {
									if (i == ((iPageNo / iShowRows) + 1)) {
						%>
						<a href="index.jsp?iPageNo=<%=i%>"
							style="cursor: pointer; color: red"><b><%=i%></b></a>
						<%
							} else if (i <= iTotalPages) {
						%>
						<a href="index.jsp?iPageNo=<%=i%>"><%=i%></a>
						<%
							}
								}
								if (iTotalPages > iTotalSearchRecords && i < iTotalPages) {
						%>
						<a href="index.jsp?iPageNo=<%=i%>&cPageNo=<%=i%>"> >> Next</a>
						<%
							}
							}
						%>
						<b>Rows <%=iStartResultNo%> - <%=iEndResultNo%> Total Result <%=iTotalRows%>
						</b>
					</div>
				</td>
			</tr>
		</table>
	</form>
</body>
</html>

原文： http://nscraps.com/Java/557-pagination-jsp-page-example-code.htm

刘利新西安

关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
纯Jsp分页

<%!public int nullIntconv(String str) { int conv = 0; if (str == null) { str = "0"; } else if ((str.trim()).equals("null")) { str = "0"; } else if (str.equals("")) { str = "0"; }
复制链接

扫一扫

专栏目录