📄 bbsanswer.jsp

📁 JSP入门与提高
💻 JSP
字号:
<html>
<head>
<%@ page contentType="text/html;charset=gb2312" %> 
<title>显示帖子内容并回复</title>
<link rel=stylesheet href="../style.css" type="text/css">
<script LANGUAGE="javascript">
function newwin(url) {
  var newwin=window.open(url,"newwin","toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=yes,resizable=yes,width=400,height=350");
  newwin.focus();
  return false;
}
</script>
</head>
<body>

<center>
<%@ page language="java" import="java.sql.*" %>
<jsp:useBean id="utilBean" scope="page" class="guest.Utility" />
<jsp:useBean id="bbsBean" scope="page" class="firm.firm" />
<%
String serial=request.getParameter("serial");
ResultSet RS = bbsBean.executeQuery("SELECT * from board where serial_no=" + serial);
String speaker;
String title;
String content;
Date providedate;
out.print("<table border='1' cellspacing='0' width='452' bgcolor='#F0F8FF' bordercolorlight='#4DA6FF' bordercolordark='#ECF5FF'>");
out.print("<tr><td>");
if (RS.next()) {
  out.print("<tr><td align='center'>");
  title=RS.getString("title");
  session.putValue("bbstitle",title);
  out.print("<font color='blue'><b>");
  out.print(title);
  out.print("<br></font></b>");
  out.print("<br>");
  speaker = RS.getString("speaker");
  out.print("发帖人：<font color='red'>" + speaker);
  out.print("</font>");
  out.print("&nbsp;&nbsp;&nbsp;");
  out.print("<font color='green'>");
  providedate=RS.getDate("provide_time");
  out.print("发帖时间："+ providedate);
  out.print("</font>");
  out.print("</td></tr>");
  out.print("<tr><td>");
  content=RS.getString("content");
  content=utilBean.addBr(content);
  content=utilBean.RemoveComment(content);
  out.print(content);
}
out.print("</p></td></tr></table>");
RS.close();

//增加点击数量
 String strSQL="update board set click_num=click_num+1  where serial_no=" + serial ; 
 bbsBean.executeUpdate(strSQL);
%>
</center>
</P> 
<center>
回复的帖子：</p>
<%
ResultSet RS1 = bbsBean.executeQuery("select * from board where parent_no=" + serial + " order by serial_no");
     out.print("<table border='1' cellspacing='0' width='452' bgcolor='#F0F8FF' bordercolorlight='#4DA6FF' bordercolordark='#ECF5FF'>");
     while (RS1.next()) {
       out.print("<tr><td>");
       serial=RS1.getString("serial_no");
       title=RS1.getString("title");
       out.print("<li><a href=bbsReply.jsp?serial=" + serial + " onClick=' return newwin(this.href);'>" + title + "</a></li>");
       out.print("</td></tr>");
     }
     out.println("</table>");
     RS1.close();
     bbsBean.closeStmt();
   
%>
</p>
<a href="add_reply.jsp?id=<%=serial%>">回复</a></p>
<p align="center"><a href="javascript:window.close();">[关闭]</a></p>
</center>
</body>
</html>
⌨️ 快捷键说明

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