📄 displaylist.jsp

📁 java+oracle 完成通讯录的增删改查
💻 JSP
字号:
<%@ page language="java" contentType="text/html; charset=gbk"
	pageEncoding="gbk"%>
<%@ page import="java.sql.*,db.selectList"%>


<%!ResultSet rs = null;

	int pageSize = 3;// 页面大小

	int pages = 1;//第几页

	int totalPage = 0;//总页数

	String str = "";

	public String showOnePage(ResultSet rs, int pages, int pageSize) {
		str = "";
		try {
			rs.absolute((pages - 1) * pageSize + 1);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		for (int i = 1; i <= pageSize; i++) {
			str += displayOneResult(rs);
			try {
				if (!rs.next())
					break;
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		return str;
	}

	public String displayOneResult(ResultSet rs) {
		String text = "";
		try {
			text += "<tr>";
			text += "<td>" + rs.getString("id") + "</td>";
			text += "<td>" + rs.getString("name") + "</td>";
			text += "<td>" + rs.getString("phone") + "</td>";
			text += "<td>" + rs.getString("address") + "</td>";
			text += "<td>" + rs.getString("qq") + "</td>";
			text += "<td>" + rs.getString("email") + "</td>";
			text += "</tr>";
		} catch (SQLException e) {
			e.printStackTrace();
		}

		return text;

	}%>
<%
		try {
		rs = selectList.getAllResult();
	} catch (Exception e) {
		e.printStackTrace();
	}
%>

<html>

	<head>
		<title>分页浏览</title>

	</head>
	<body>
		<h2 align="center">
			分页显示
		</h2>
		<hr>
		<center>
			<table border="1">
				<tr bgcolor="lightblue">
					<th>
						编号
					</th>
					<th>
						姓名
					</th>
					<th>
						电话
					</th>
					<th>
						地址
					</th>
					<th>
						QQ
					</th>
					
					<th>
						email
					</th>
				</tr>


				<%
					String UserName = (String)session.getAttribute("username");
					if (UserName == null) {
						out.println("对不起，你还没登录，请先<a href=login.jsp>登录</a>");
					} else {
						totalPage = selectList.getTotalPage(3);
						try {
							if (request.getParameter("Page") == null
							|| request.getParameter("Page").equals("")) {
						pages = 1;

							} else
						pages = Integer.parseInt(request.getParameter("Page"));
						} catch (java.lang.NumberFormatException e) {

							e.printStackTrace();
							pages = 1;
						}
						if (pages < 1)
							pages = 1;
						if (pages > totalPage)
							pages = totalPage;
						out.println(showOnePage(rs, pages, pageSize));
					}
				%>

			</table>
			<form action="displayList.jsp" method="get">
				<%
						if (pages != 1) {
						out.println("<a href=displayList.jsp?Page=1>第一页</a>");
						out.println("<a href=displayList.jsp?Page=" + (pages - 1)
						+ ">上一页</a>");

					}
					if (pages != totalPage) {
						out.println("<a href=displayList.jsp?Page=" + (pages + 1)
						+ ">下一页</a>");
						out.println("<a href=displayList.jsp?Page=" + totalPage
						+ ">最后一页</a>");
					}
					rs.close();
				%>
				<p>
					输入页数：
					<input type="text" name="Page" size="3" value="<%=pages%>">
					<input type="submit" value="翻页">
					页数:
					<font color="red"><%=pages%>/<%=totalPage%> </font>
				</p>

			</form>
		</center>
		<hr>

	</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -