📄 delete.jsp
字号:
<html>
<head>
<title>删除</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="../bbs.css">
</head>
<body bgcolor="#FF9900">
<%@ page language="java" import="java.sql.*" %>
<jsp:useBean id="OPDB" scope="page" class="database.OPDB" />
<%
OPDB.connection();
Connection conn =OPDB.getConn();
String id = request.getParameter("id");
String boardid = request.getParameter("boardid");
String manager = (String) session.getValue("manager");
String writename = OPDB.AsciiToChineseString(request.getParameter("writename"));
if (manager != null && boardid.equals(manager)) {
Runtime rt = Runtime.getRuntime();
ServletConfig confi =getServletConfig();
ServletContext context =confi.getServletContext();
String path =context.getRealPath("/");
String sql = "select photo from t_bbs where id = " + id;
ResultSet rs = OPDB.select(conn,sql);
if (rs.next()) {
String photoName = rs.getString(1);
if (photoName != null) {
rt.exec("rm "+path+"/upimage/bbs/"+photoName);
}
rs.close();
}
sql = "delete from t_bbs where id = " + id;
OPDB.delete(conn,sql);
int i = writename.indexOf(OPDB.AsciiToChineseString("[会员]"));
if (i != -1) {
writename = writename.substring(0,i);
sql = "update t_bbs_user set experience = experience - 5 where username = '" + writename + "' and usertype = 'Y'";
}
else {
sql = "update t_bbs_user set experience = experience - 5 where username = '" + writename + "' and usertype = 'N'";
}
//帖子被删,减5点经验
//String sql2 = "update t_bbs_user set experience = experience - 5 where username = '" + writename + "'";
OPDB.update(conn,sql);
%>
<p>该帖子已被删除，请<a href="list.jsp?boardid=<%= boardid %>" target="boardList">刷新浏览!</a></p>
<%
}
else {
%>
<script language="javascript">
alert("您没有斑主权限，请登陆！");
window.location = "../managerlogon.jsp"
</script>
<%
}
%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -