📄 reply.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" %>
<jsp:useBean id="DBConnection" scope="page" class="com.guestbook.DBConnection"/>
<jsp:useBean id="FaceFilter" scope="page" class="com.guestbook.FaceFilter"/>
<jsp:useBean id="HTMLFilter" scope="page" class="com.guestbook.HTMLFilter"/>
<jsp:useBean id="UbbCode" scope="page" class="com.guestbook.UbbCode"/>
<%
Boolean a=(Boolean)session.getAttribute("a");
Connection conn=DBConnection.getConnectionToAccess(application.getRealPath("data/guestbook.mdb"));
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
if(a==null||a.booleanValue()==false)
{
%>
<script language=JavaScript>
alert('此页面仅对站长开放！');
location.href="index.jsp"
</script>
<%
}else{
String Reply=request.getParameter("Reply");
if (Reply==null)
{
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>SunShine留言本v1.0-回复留言</title>
<style type="text/css"><!--
.f12 {font-family: "宋体";
font-size: 12px;
color: #000000;
text-decoration: none;
line-height: 23px;}
-->
</style>
<script language="javascript">
function check(){
if(post.content.value==""){
alert("请输入管理员回复");
return false;
}
</script>
<SCRIPT src="images/index.js"></SCRIPT>
</head>
<body bgcolor="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<form action="Reply.jsp?Reply=Reply&id=<%=java.lang.Integer.parseInt(request.getParameter("id"))%>" method="post" name="post" id="post"">
<%
String id=request.getParameter("id");
String sql1="select * from Guestbook where id="+id;
ResultSet Rs=stmt.executeQuery(sql1);
while(Rs.next())
{
%>
<br>
<table width="95%" align=center cellpadding=3 cellspacing=1 bgcolor="#969696" class=f12>
<tr>
<td align=left bgcolor="#f1f1f1" > 标题：<%=Rs.getString("usertitle")%><br>
时间：<%=Rs.getString("mydate")%><br>
<font color="#333333">--------------------------------------------------------------------------------</font><br>
<%=Rs.getString("content")%></td>
</tr>
<tr>
<td bgcolor="#f1f1f1" > <div align="center"><strong><font color="#333333">管理员回复</font></strong></div></td>
</tr>
<tr>
<td align=left bgcolor="#f1f1f1" > <select name="selectFont" id="selectFont" onChange="setFont(this.options[this.selectedIndex].value)">
<option selected>选择字体</option>
<option value="宋体">宋体</option>
<option value="黑体">黑体</option>
<option value="隶书">隶书</option>
<option value="幼圆">幼圆</option>
<option value="仿宋_GB2312">仿宋_GB2312</option>
<option value="Arial">Arial</option>
<option value="Times New Roman">Times New Roman</option>
</select> <select name="selectSize" id="selectSize" onChange="setSize(this.options[this.selectedIndex].value)">
<option selected>字体大小</option>
<option value="6">6</option>
<option value="8">8</option>
<option value="10">10</option>
<option value="12">12</option>
<option value="14">14</option>
<option value="18">18</option>
<option value="24">24</option>
<option value="36">36</option>
</select> <select name="selectColor" id="selectColor" onChange="setColor(this.options[this.selectedIndex].value)">
<option value="" selected>选择颜色</option>
<option value="red">红色</option>
<option value="blue">蓝色</option>
<option value="yellow">黄色</option>
<option value="green">绿色</option>
</select> <br>
<a href="javascript:" onClick="addBold()"><img src="images/ubb/bold.gif" alt="字体加粗" width="20" height="20" border="0"></a>
<a href="javascript:" onClick="addEm()"><img src="images/ubb/italic.gif" alt="字体倾斜" width="20" height="20" border="0"></a>
<img src="images/ubb/separator.gif" width="6" height="20"> <a href="javascript:" onClick="addLeft()">
<img src="images/ubb/left.gif" alt="字体左对齐" width="20" height="20" border="0"></a>
<a href="javascript:" onClick="addCenter()"> <img src="images/ubb/center.gif" alt="字体居中" width="20" height="20" border="0"></a>
<a href="javascript:" onClick="addRight()"> <img src="images/ubb/right.gif" alt="字体靠右" width="20" height="20" border="0"></a>
<img src="images/ubb/separator.gif" width="6" height="20"> <a href="javascript:" onClick="addimages()"><img src="images/ubb/image.gif" alt="引用外部图片" width="20" height="20" border="0"></a>
<img src="images/ubb/date.gif" alt="插入日期" width="20" height="20"> <img src="images/ubb/separator.gif" width="6" height="20">
<a href="javascript:" onClick="addQuote()"><img src="images/ubb/quote.gif" alt="插入引用" width="20" height="20" border="0"></a>
<a href="javascript:" onClick="addURL()"><img src="images/ubb/link.gif" alt="加入超链接" width="20" height="20" border="0"></a>
<a href="javascript:" onClick="addEmail()"><img src="images/ubb/email.gif" alt="插入Email" width="20" height="20" border="0"></a>
<BR>
<textarea name="content" cols="60" rows="12" wrap="VIRTUAL" class="form" id="content" style="background-color:#E4E4E4"><%if(Rs.getString("recontent")==null){}else{%><%=Rs.getString("recontent")%><%}%></textarea>
<BR>
点击表情符号可以将其加入正文（正文内容不能大于<B>600</B>个字符）。<BR> <script type="text/javascript" language="javascript">
for(var i=0;i<20;i++)
{
if(i<10)
{
document.write("<a href=\"javascript:\" onClick=\"addMood(\':em0"+i+"\')\"><img src='images/ubbface/0"+i+".gif' border=0></a>");
}
else
{
document.write("<a href=\"javascript:\" onClick=\"addMood(\':em"+i+"\')\"><img src='images/ubbface/"+i+".gif' border=0></a>");
}
}
</script> </td>
</tr>
<tr>
<td align=left bgcolor="#f1f1f1" > <input type=submit value="提 交" name=Submit>
<input type=reset value="清 除" name=Submit2>
<input name="checkButton" type="button" id="checkButton" onClick="checkLength()" value="查看文章长度">
</td>
</tr>
</table>
<% } %>
</form>
</body>
</html>
<%
}
else
{
String content=request.getParameter("content");
byte b[]=content.getBytes("ISO-8859-1");
content=new String(b);
String id=request.getParameter("id");
java.util.Date date=new java.util.Date();
String datetime=new Timestamp(date.getTime()).toString();
HTMLFilter.setSource(content);
HTMLFilter.run();
content=HTMLFilter.getResult();
UbbCode.setSource(content);
UbbCode.run();
content=UbbCode.getResult();
FaceFilter.setSource(content);
FaceFilter.run();
content=FaceFilter.getResult();
String sql="update Guestbook set recontent='"+content+"',remydate='"+datetime+"' where id="+id;
try{
stmt.executeUpdate(sql);
}
catch(Exception e)
{
response.sendRedirect("error.jsp?error=2");//数据库更新出错！
}
if(conn!=null)
{
conn.close();
}
if(stmt!=null)
{
stmt.close();
}
%>
<script>self.opener.location.reload();</script>
<script>self.close();</script>
<%
}
}
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -