delete.jsp

来自「JSP+oracle开发实例精粹》随书光盘」· JSP 代码 · 共 36 行

<%@ page contentType="text/html; charset=gb2312" import="java.sql.*"%>
<jsp:useBean id="db" class="xwfb.connectDB" />
<%
	String id = request.getParameter("id");
	try
	{
		String sql = "delete from XWFB_NEWS where id ="+id;
		db.executeUpdate(sql);
		sql = "delete from XWFB_COMMENT where news_id ="+id;
		db.executeUpdate(sql);
		%>
		<script language="javascript">
			alert("删除成功");
			self.location.href = "index.jsp";
		</script>
		<%
	}
	catch(Exception e)
	{
		session.setAttribute("error","1");
		response.sendRedirect("error.jsp");
	}
	finally
	{
		try
		{
			db.closeDB();
		}
		catch(Exception ee)
		{
			session.setAttribute("error","1");
			response.sendRedirect("error.jsp");
		}
	}

%>