⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 admin_all_bbs.jsp

📁 自己编写的jsp+mysql论坛系统,带后台系统.不是很完善,但是功能是完整的
💻 JSP
字号:
🔍 
<%@ page language="java" contentType="text/html; charset=GBK"
	pageEncoding="GBK"%>
<%@page import="java.util.*,java.io.*,java.sql.*"%>
<%@ include file="../conn.jsp"%>
<%
	request.setCharacterEncoding("GBK");
%>
<!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=GBK">
		<title>管理帖子信息</title>
	</head>
	<body>
		<!-- 载入页头 -->
		<jsp:include page="admin_include.jsp"></jsp:include>
		<%
			String username = "";
			String pageno = "1";
			int permission = 0;
			if ((null != session.getAttribute("adminlogin"))
					&& (null != session.getAttribute("permission"))) {
				username = session.getAttribute("adminlogin").toString();
				permission = Integer.parseInt(session
						.getAttribute("permission").toString());
				//取得页码,为空默认为1
				if (null != request.getParameter("pageno"))
					if (0 < Integer.parseInt(request.getParameter("pageno")))
						pageno = request.getParameter("pageno");
					else
						pageno = "1";
				else
					pageno = "1";
		%>
		管理帖子信息
		<br>
		<table align="center" border="0" width="90
			%">
			<tr>
				<td valign="middle" width="5%" align="center">
					编号
				</td>
				<td valign="middle" width="50%" align="center">
					标题
				</td>
				<td valign="middle" width="5%" align="center">
					修改
				</td>
				<td valign="middle" width="5%" align="center">
					删除
				</td>
			</tr>
			<%
				try {
						int id = 0;
						String title = "";
						String fulltitle = "";
						String strDo = "";
						//取得rs的个数
						int count = 0;
						strDo = "SELECT COUNT(*) FROM " + tbbs;
						rs = stmt.executeQuery(strDo);
						if (rs.next()) {
							count = rs.getInt(1);
							//查询帖子
							if (pageno.equals("1")) {
								strDo = "SELECT * FROM "
										+ tbbs
										+ " LIMIT "
										+ String
												.valueOf(Integer.parseInt(pageno) * 10);
							} else {
								strDo = "SELECT * FROM "
										+ tbbs
										+ " LIMIT "
										+ String
												.valueOf(Integer.parseInt(pageno) * 10 - 10)
										+ " , "
										+ String
												.valueOf(Integer.parseInt(pageno) * 10);
							}
							rs = stmt.executeQuery(strDo);
							while (rs.next()) {
								id = rs.getInt("id");
								title = rs.getString("title");
								//字符过滤&处理
								title = title.replaceAll("&sd", "'");
								title = title.replaceAll("&dd", "\"");
								fulltitle = title;
								if (title.length() > 20)
									title = title.substring(0, 17) + "...";
								out
										.println("<tr><td align='center'>"
												+ id
												+ "</td>"
												+ "<td align='center'><a href=../show_post.jsp?id="
												+ id
												+ " title='"
												+ fulltitle
												+ "'>"
												+ title
												+ "</a></td>"
												+ "<td align='center'><a href=admin_edit_bbs.jsp?id="
												+ id
												+ ">修改</a>"
												+ "<td align='center'><a href=admin_del_bbs.jsp?id="
												+ id + ">删除</a>" + "</td></tr>");
							}
							rs.close();
							out
									.print("<br><br><font color='blue'>列表完毕</font><br><br>");
							//翻页链接
							if (!pageno.equals("1")) {
								if (!pageno.equals("1")) {
									out
											.print("<a href='admin_all_bbs.jsp?pageno="
													+ String.valueOf(Integer
															.parseInt(pageno) - 1)
													+ "'>上一页</a>");
								}
								out.print("&nbsp;&nbsp;");
							}
							if (count > (Integer.parseInt(pageno) * 10)) {
								out
										.print("<a href='admin_all_bbs.jsp?pageno="
												+ String.valueOf(Integer
														.parseInt(pageno) + 1)
												+ "'>下一页</a>");
							}
						}
					} catch (Exception e) {
						e.printStackTrace();
					} finally {
						stmt.close();
						conn.close();
					}
			%>

		</table>
		<%
			} else {
				response.sendRedirect("../error.jsp");
			}
		%>

		<!-- 载入页尾 -->
		<jsp:include page="../include/foot.jsp"></jsp:include>
	</body>
</html>

⌨️ 快捷键说明

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