jsp 分页（可以用的）

最新推荐文章于 2022-06-24 10:52:51 发布

stevenbill

最新推荐文章于 2022-06-24 10:52:51 发布

阅读量77

点赞数

分类专栏： JAVA 文章标签： JSP Java SQL Oracle Spring

本文链接：https://blog.csdn.net/stevenbill/article/details/83881441

版权

JAVA 专栏收录该内容

332 篇文章 1 订阅

订阅专栏

//more.jsp


<%@ page language="java"
	import="java.util.*,java.sql.*,com.apache.log.util.*,java.sql.ResultSet,java.text.SimpleDateFormat"
	pageEncoding="utf-8"%>
<%@ page import="com.zj.comm.util.Common"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<wml>
<head>
	<meta http-equiv="Cache-Control" content="max-age=0" />
	<meta http-equiv="Cache-Control" content="no-cache" />
</head>
<card id="mobile" title="jsp">
<p>
<a href="index.jsp">活动首页</a>》更多留言
<br/>
<%
int pn=0;
int pagesize=10;
if (request.getParameter("pn") != null)
					pn = Integer.parseInt(request.getParameter("pn"));
	Connection conn = null;
	Connection connl = null;
		PreparedStatement ps = null;
		PreparedStatement psl = null;
		ResultSet rs = null;
		ResultSet rsl = null;
		try {
				conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:ORCL","zshz_db","zshz_db");
				String sql = "select * from (select t.*,rownum rn from( select * from hd_spring  where sign='msg'order by createtime desc)t  where rownum<="+pagesize*(pn+1)+")where rn>"+pagesize*pn+"";
				//out.print(sql);
				ps = conn.prepareStatement(sql);
				ps.executeUpdate();
				rs=ps.executeQuery();
				while (rs.next()) {%>
				-<%=rs.getString("mobile") %>:
				<%=rs.getString("message") %>
				<br/>
				<%	
				}%>
				<%
				connl = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:ORCL","system","orcl");
				String sqll="select count(message) from hd_spring where sign='msg'";
				psl=connl.prepareStatement(sqll);
			//	psl.executeUpdate();
				rsl=psl.executeQuery();
				if(rsl.next()){
				out.print("<a href='more.jsp?pn="+(pn-1)+"'>上一页</a>"+"|");
				out.print("<a href='more.jsp?pn="+(pn+1)+"'>下一页</a>");
			}
			} catch (Exception e) {
				e.printStackTrace();
			} finally {
				if (rs != null) {
					rs.close();
				}
				if (ps != null) {
					ps.close();
				}
				if (conn != null) {
					conn.close();
				}
			}
 %>
<br/>
</p>
</card>
</wml>

JSP分页（不小心在网上找来的）
//page.jsp



<%@ page language="java" contentType="text/html; charset=utf-8"
	pageEncoding="utf-8"%>
<%@ page import="java.sql.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
	<head>
		<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
		<title>Insert title here</title>
	</head>
	<body>

		<%
			Class.forName("com.mysql.jdbc.Driver");
			String url = "jdbc:mysql://localhost:3306/data";
			Connection con = DriverManager.getConnection(url, "root", "root");
			Statement stmt = con.createStatement(
					ResultSet.TYPE_SCROLL_INSENSITIVE,
					ResultSet.CONCUR_READ_ONLY);
			int intPageCount;//总页数
			int intRowCount;//总记录
			int intPageSize;//每页显示记录数
			int intPage;//当前页
			int intNext;//下一页
			int intPrev;//上一页
			int i;
			String strPage;
			strPage = request.getParameter("Page");
			if (strPage == null) {
				intPage = 1;
			} else {
				intPage = Integer.parseInt(strPage);
			}
			String sql = "select * from authors";
			ResultSet rs = stmt.executeQuery(sql);
			rs.last();
			intRowCount = rs.getRow();
			intPageSize = 5;
			intPageCount = (intRowCount + intPageSize - 1) / intPageSize;
			if (intPage > intPageCount) {
				intPage = intPageCount;
			}
			if (intRowCount < intPageSize) {
				intPage = 1;
			}
			if (intPage < 0) {
				intPage = 1;
			}
			;
			i = 0;
			if (intRowCount > 0) {
				rs.absolute((intPage - 1) * intPageSize + 1);
				while (i < intPageSize && !rs.isAfterLast()) {
					out.print(rs.getString("phone") + " ----   "+"    ");
					out.print(rs.getString("address") + " ----   ");
					out.print(rs.getString("au_id") + "<br>");
					rs.next();
					i++;
				}
				rs.close();
				stmt.close();
			}
			intNext = intPage + 1;
			if (intNext > intPageCount) {
				intNext = intPageCount;
			}
			intPrev = intPage - 1;
			if (intPrev < 1) {
				intPrev = 1;
			}
		%>
		共
		<%=intRowCount%>
		记录 共
		<%=intPageCount%>
		页 每页显示
		<%=intPageSize%>
		条记录
		<a href="page.jsp?Page=<%=intNext%>">intNext</a>
		<a href="page.jsp?Page=<%=intPrev%>">intPrev</a>


	</body>
</html>

stevenbill

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
jsp 分页（可以用的）

//more.jsp[code="java"] 活动首页》更多留言 -: [/code]JSP分页（不小心在网上找来的）//page.jsp[code="java"] Insert title here...
复制链接

扫一扫

专栏目录