📄 main.jsp
字号:
<%@ page language="java" contentType="text/html; charset=GBK"
pageEncoding="GBK"%>
<%@page import="java.util.*,java.io.*,java.sql.*,sth.*"%>
<%@ include file="conn.jsp"%>
<!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>BBS</title>
</head>
<body>
<!-- 载入页头 -->
<jsp:include page="./include/top.jsp"></jsp:include>
<%
String username = "";
String pageno = "1";
if (null != session.getAttribute("login")) {
username = session.getAttribute("login").toString();
//取得页码,为空默认为1
if (null != request.getParameter("pageno"))
if (0 < Integer.parseInt(request.getParameter("pageno")))
pageno = request.getParameter("pageno");
else
pageno = "1";
else
pageno = "1";
%>
<a href="new_post.jsp">发布新帖</a>
<br>
<hr>
<br>
<table align="center" border="0" width="90%">
<tr>
<td valign="middle" width="50%" align="center">
标题
</td>
<td valign="middle" width="15%" align="center">
作者
</td>
<td valign="middle" width="25%" align="center">
发布时间
</td>
</tr>
<%
int id = 0;
String author = "";
int authorid = 0;
String title = "";
String fulltitle = "";
String dnt = "";
String strDo = "";
codeToString cts = new codeToString();
try {
//取得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");
author = rs.getString("author");
authorid = rs.getInt("authorid");
title = cts.codeToString(rs.getString("title"));
//字符过滤&处理
title = title.replaceAll("&sd", "'");
title = title.replaceAll("&dd", "\"");
fulltitle = title;
if (title.length() > 20)
title = title.substring(0, 17) + "...";
dnt = rs.getString("dnt");
//以表格形式读入帖子标题超链接 以帖id为参数
out.print("<tr>"
+ "<td valign='middle' align='center'>"
+ "<a href='show_post.jsp?id=" + id
+ "' title='" + fulltitle + "'>" + title
+ "</a></td>"
+ "<td valign='middle' align='center'>"
+ "<a href=show_profile.jsp?authorid="
+ authorid + ">" + author + "</a></td>"
+ "<td valign='middle'align='center'>"
+ dnt);
}
rs.close();
out.print("</table><br><br>");
//翻页链接
if (!pageno.equals("1")) {
if (!pageno.equals("1")) {
out.print("<br><br><a href='main.jsp?pageno="
+ String.valueOf(Integer
.parseInt(pageno) - 1)
+ "'>上一页</a>");
}
out.print(" ");
}
if (count > (Integer.parseInt(pageno) * 10)) {
out
.print("<a href='main.jsp?pageno="
+ String.valueOf(Integer
.parseInt(pageno) + 1)
+ "'>下一页</a><br><br>");
}
}
rs.close();
System.out.print("count=" + String.valueOf(count) + "\n");
} catch (Exception e) {
e.printStackTrace();
} finally {
stmt.close();
conn.close();
}
} 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 + -