📄 edit.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" %>
<%@ include file="name.jsp" %>
<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 edit=request.getParameter("edit");
if (edit==null)
{
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title><%=name%>-编辑留言</title>
<style type="text/css">
<!--
body {
border: 1px 1 #CCCCCC;
}
.bian {
border-top-width: 1px;
border-top-style: solid;
border-top-color: #969696;
border-bottom-width: 1px;
border-bottom-style: solid;
border-bottom-color: #999999;
}
.f12 {
font-family: "宋体";
font-size: 12px;
color: #000000;
text-decoration: none;
line-height: 23px;
}
.bian1 {
border-right-width: 1px;
border-left-width: 1px;
border-right-style: solid;
border-left-style: solid;
border-right-color: #969696;
border-left-color: #969696;
}
a:link {
font-family: "宋体";
font-size: 12px;
color: #333333;
text-decoration: none;
}
a:visited {
font-family: "宋体";
font-size: 12px;
color: #333333;
text-decoration: none;
}
a:hover {
font-family: "宋体";
font-size: 12px;
color: #333333;
text-decoration: underline;
}
a:active {
font-family: "宋体";
font-size: 12px;
color: #333333;
text-decoration: none;
}
-->
</style>
<SCRIPT src="images/index.js"></SCRIPT>
</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<form action="Edit.jsp?edit=edit&id=<%=java.lang.Integer.parseInt(request.getParameter("id"))%>" method="post" name="post" id="post"">
<%
String id=request.getParameter("id");
String sql="select * from Guestbook where id="+id;
ResultSet Rs=stmt.executeQuery(sql);
while(Rs.next())
{
%>
<br>
<table width="95%" align=center
cellpadding=3 cellspacing=1 bgcolor="#969696" class=f12 style="WORD-BREAK: break-all">
<tbody>
<TR bgcolor="#FFFFFF">
<TD width="20%" height=19 align=right bgcolor="#f1f1f1" class=tablebody3>标题：</TD>
<TD width="80%" height=19 bgcolor="#e1ebba" class=tablebody2> <INPUT name=usertitle value="<%=Rs.getString("usertitle")%>" size=40
maxLength=100> <B> <font color="#FF0000">必填</font></B></TD>
</TR>
<TR bgcolor="#FFFFFF">
<TD width="20%"
height=160 align=right vAlign=top bgcolor="#f1f1f1" class=tablebody3>正文：</TD>
<TD width="80%" height=160 bgcolor="#e1ebba" class=tablebody2> <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="15" wrap="VIRTUAL" class="form" id="content" style="background-color:#E4E4E4"><%=Rs.getString("content")%></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> <br> <div id="ch"> <br>
</div></TD>
</TR>
<tr bgcolor="#FFFFFF">
<td
height=21 colspan=2 align=middle valign=center class=tablebody1>
<input type=submit value="提 交" name=Submit> <input type=reset value="清 除" name=Submit2>
<input name="checkButton" type="button" id="checkButton" onClick="checkLength()" value="查看文章长度">
</td>
</tr>
</tbody>
</table>
</form>
<% } %>
</body>
</html>
<%
}else{
String usertitle=request.getParameter("usertitle");
byte c[]=usertitle.getBytes("ISO-8859-1");
usertitle=new String(c);
String content=request.getParameter("content");
byte d[]=content.getBytes("ISO-8859-1");
content=new String(d);
String id=request.getParameter("id");
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 sql1="update Guestbook set usertitle='"+usertitle+"',content='"+content+"' where id="+id;
try{
stmt.executeUpdate(sql1);
}
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 + -