delete.jsp

来自「一个使用jdbc存储和调用大对象（比如图片等）的例子」· JSP 代码 · 共 62 行

JSP

62 行

<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>

delete.jsp - 源码说明

本页面展示了「一个使用jdbc存储和调用大对象（比如图片等）的例子」中的 delete.jsp 源码文件，采用 JSP 编程语言编写，共 62 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与jdbc相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C

搜索代码Ctrl + F

全屏模式F11

增大字号Ctrl + =

减小字号Ctrl + -

显示快捷键?