📄 editly.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*,java.lang.Math.*" %>
<%@ include file="inc/config.jsp"%>
<%@ include file="inc/style.jsp"%>
<%@ include file="session.jsp"%>
<jsp:useBean id="FaceFilter" scope="page" class="dreamtime.guestbook.FaceFilter"/>
<jsp:useBean id="UbbCode" scope="page" class="dreamtime.guestbook.UbbCode"/>
<%
/*******************************************************************
* *
* 梦想年华 JSP 版留言本 *
* *
* 版权所有: wsp.hniuca.net *
* ` CopyRight 2005-2006 DreamTime All Rights Reserved *
* *
* 程序制作: [梦想年华] *
* Email:fanwsp@126.com *
* QQ:122142023 *
* HomePage:http://wsp.hniuca.net *
* *
* 郑重申明：该程序仅提个人用户免费使用,未经本人同意， *
* 严禁用于商业用途！ *
* *
*********************************************************************/
%>
<html>
<head>
<title>编辑留言</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<SCRIPT src="inc/ubbcode.js"></SCRIPT>
<SCRIPT src="inc/post.js"></SCRIPT>
</head>
<%
request.setCharacterEncoding("gb2312"); //设置编码方式为gb2312
//处理表单，并进行异常处理
String action = request.getParameter("action");
if(action!=null && action.equals("edit"))
{
String EditContent=request.getParameter("Content");
if(EditContent == null || EditContent.equals("") || EditContent.length() > LybMaxByte)
{
out.println("<br><br><br><p><table width=\"640\" border=\"1\" align=\"center\"><tr height=\"25\"><td>");
out.println("<div align=\"center\" class=\"info\"><br>编辑留言内容不能为空！");
out.println("<br><br>编辑留言内容不能大于" + LybMaxByte +"个字符！<br><br>请仔细核对您的输入！<br>");
out.println("<br><a href=\"#\" onClick=\"javascript:history.go(-1);\">返回</a><br></div></td></tr></table>");
return;
}
UbbCode.setSource(EditContent);
UbbCode.run();
EditContent=UbbCode.getResult();
FaceFilter.setSource(EditContent);
FaceFilter.run();
EditContent=FaceFilter.getResult();
try{
id = Integer.parseInt(request.getParameter("id"));
sql = "update guestbook set Content='" + EditContent + "',EditTime='"+ NowTime +"' where ID="+id;
stmt.executeUpdate(sql);
//stmt.close();
//DBConn.close();
}catch(SQLException e){
//out.println(e.getMessage());
session.setAttribute("error",error2);
session.setAttribute("url",sPage+"?id="+id);
response.sendRedirect("error.jsp");
return;
}
out.println("<SCRIPT LANGUAGE='JavaScript'>alert('编辑留言成功!');location.href='adminly.jsp';</SCRIPT>");
//out.println(sql);
}
//读取指定的ID
request.setCharacterEncoding("gb2312"); //设置编码方式为gb2312
try{
id = Integer.parseInt(request.getParameter("id")); //将字符串转换成整型
}catch(Exception e){
//out.println(e.getMessage());
session.setAttribute("error",error1);
session.setAttribute("url","adminly.jsp");
response.sendRedirect("error.jsp");
return;
}
try{
sql="select * from guestbook where id=" +id; //构造SQL语句
rs = stmt.executeQuery(sql);
}catch(SQLException e){
//out.println(e.getMessage());
session.setAttribute("error",error2);
session.setAttribute("url","adminly.jsp");
response.sendRedirect("error.jsp");
return;
}
//读留言信息
rs.next();
int ID=rs.getInt("ID");
String Name=rs.getString("Name");
String QQ=rs.getString("QQ");
String Mail=rs.getString("Mail");
String ComeFrom=rs.getString("ComeFrom");
String Time=rs.getString("UpdateTime");
String Title=rs.getString("Title");
String Sex=rs.getString("Sex");
String Face=rs.getString("Face");
String Content=rs.getString("Content");
String ReContent=rs.getString("ReContent");
String ReTime=rs.getString("ReTime");
String Secret=rs.getString("Secret");
String IP=rs.getString("IP");
%>
<body>
<%=TopInfo(true)%>
<a name="ly"></a>
<table border="0" align="center" width="640">
<tr>
<td valign="top"><table width="100%" height="23%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="176" align="left" valign="top">
<br>
<table width="640" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="69" valign="top">
<form name="form" method="post" action="editly.jsp" onSubmit="return ReplyCheck()">
<table width="100%" border="1" align="center" cellpadding="6" cellspacing="1" style="border-collapse:collapse">
<tr>
<td height="25" colspan="4" background="images/bg<%=LybSkin%>.gif">
<div align="center"><span class="title">编辑留言</span></div> </td>
</tr>
<tr>
<td width="17%"><div align="center" class="chinese">姓 名：</div></td>
<td width="33%" height="25" class="chinese"><%=Name%>
<input name="id" type="hidden" id="id" value="<%=ID%>"></td>
<td width="10%" height="25"><div align="center" class="chinese">OICQ：</div></td>
<td width="40%" class="chinese"><%=QQ%> </td>
</tr>
<tr>
<td>
<div align="center" class="chinese">电子邮箱：</div></td>
<td height="25" class="chinese"><%=Mail%> </td>
<td height="29"><div align="center" class="chinese">来 自：</div></td>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -