createdelete.jsp

为html格式的静态网页形式

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" %>
<%@ page import="java.io.*" %>
<%@ page language="java" %>

<jsp:useBean id="ConBean" scope="session" class="com.bitc.ch13.DBCon"/>
<%
String fileid = request.getParameter("url");
String uid = new String(request.getParameter("uid").getBytes("ISO-8859-1"),"GBK");
String s = request.getParameter("s");
Connection con = ConBean.getConnection();
Statement stmt = con.createStatement();
try{
String	strdel = "delete jsp8_news where id = '"+s+"'";
stmt.executeUpdate(strdel);
}catch(Exception e){
out.println(e.toString());
return;
}
stmt.close();
ConBean.close();

String path = request.getRealPath("/");
//建立文件名称和绝对路径的串联
String saveDirectory = request.getRealPath("/")+"\\web/image";
File fileName = new File(path+"\\html", fileid);
//检查文件是否存在
if(fileName.exists())
{
	//存在则删除该文件
	fileName.delete();
%>
	<script language="vbscript">
				msgbox "OK!成功删除了该文章！",vbInformation,"提示"
				window.location="wenzhangx.jsp?id=<%=uid%>"
			</script>
<%
}
else
{
	//不存在该文件则建立该文件
	fileName.createNewFile();
%>
		<script language="vbscript">
				msgbox "Sorry!文章不存在，只删除了数据库记录！",vbInformation,"提示"
				window.location="wenzhangx.jsp?id=<%=uid%>"
			</script>

<%
}
%>