📄 bbsreplycontent.jsp

📁 j2ee实现简单的bbs功能
💻 JSP
字号:
<%@ page language="java" contentType="text/html;charset=gb2312" %>
<%@ page import="java.sql.*"%>
<%@ page import="BeanLink.DBBean"%>
<jsp:useBean id="dBean" class="BeanLink.DBBean" scope="session"/>
<html>
<head>
<title>显示回复文章的内容</title>
</head>
<body>
<CENTER>
<br>
<%
	String loginSign = (String)session.getValue("loginSign");
	String username = (String)session.getValue("username");//作者名
	if(loginSign!=null&&loginSign.equals("OK"))
	{//显示主题文章及回复文章列表
		out.println("<font size='6' color='blue'>主题文章</font>");
	}
	else
	{//无此权限,定向到用户登录页面
		response.sendRedirect("../index.jsp");
	}
%>
</CENTER>
<%
   String sdriver="sun.jdbc.odbc.JdbcOdbcDriver";
   String sconn="jdbc:odbc:mydb";
   String suser="";
   String spass="";
   String tablename="board";
   
   dBean.openConn(sdriver,sconn,suser,spass);
   ResultSet rs=null;
   String sql = "";
%>
<%
   //显示相应回复文章的内容并更新该记录的点击次数
   String title = "";
   String speaker = "";
   java.util.Date provide_time = null;
   long click_num = 0;
   String content = "";
   String serialNo = request.getParameter("serialNo");
   String serialNoMain = request.getParameter("serialNoMain");
   String titleMain = request.getParameter("titleMain");
   titleMain = new String(titleMain.getBytes("8859_1"));
   String reply_numMain = request.getParameter("reply_numMain");
   
   sql = "select * from "+tablename+" where serialNo="+serialNo;
   rs=dBean.executeQuery(sql);
   if(rs!=null&&rs.next())
   {
	title = rs.getString("title");
	speaker = rs.getString("speaker");
	provide_time = rs.getDate("provide_time");
	click_num = rs.getLong("click_num");
	click_num++;
	content = rs.getString("content");
%>
<table width="80%" align="center" bgcolor="#ccffff" height="38">
<tr>
<td align="center"><%=title%></td>
</tr>
<tr>
<td align="center">发贴人:<%=speaker%>&nbsp;&nbsp;&nbsp;&nbsp;发贴时间:<%=provide_time%></td>
</tr>
<tr>
<td align="left" color="#ffffcc">内   容:</td>
</tr>
<tr>
<td><%=content%></td>
</tr>
</table>
<%
   }
   if(rs!=null)
   {
	rs.close();
        rs = null;
   }
   //更新该记录的点击次数
   sql = "update "+tablename+" set click_num="+click_num+" where serialNo="+serialNo; 
   dBean.executeUpdate(sql);
%>

<center>
<font size="6" color="green">回复帖子</font>
<form method="post" action ="bbsdealreply.jsp?serialNoMain=<%=serialNoMain%>&reply_numMain=<%=reply_numMain%>">
  <P>发帖人:<%=username%></P>
  <p>主  题：<input type="text" name="title" size="70" value="<%="RE:"+titleMain%>"></p>
  <p>表  情:
  <% 
  for(int i=0; i<10; i++)
  {
	String imageNo = "0"+Integer.toString(i);
	String imageAddress = "../../images/"+imageNo+".gif";
	if(i==0)
		out.println("<input type='radio' value="+imageNo+" name='emote' checked><image src="+imageAddress+">&nbsp;");
	else
		out.println("<input type='radio' value="+imageNo+" name='emote'><image src="+imageAddress+">&nbsp;");
  }
  %>
  </p>
  <p>内  容：</p>
  <p><textarea rows="8" name="content" cols="80"></textarea></p>
  <p><input type="submit" value="提交" name="B1">
  <input type="reset" value="重写" name="B2"></p>
</form>
</center>

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

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