delete.jsp

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

<%@ page language="java" contentType="text/html; charset=gb2312" import="java.sql.*"%>
<jsp:useBean id="db" class="yhgl.connectDB" />
<%
	String id = request.getParameter("id");
	try
	{
		String sql = "delete from WSTP_LANMU where ID="+id;
		db.executeUpdate(sql);
		sql = "delete from WSYP_XUANZE where TOPIC_IC="+id;
		db.executeUpdate(sql);
	}
	catch(Exception e)
	{
		e.printStackTrace();
		session.setAttribute("error","2");
		response.sendRedirect("error.jsp");
	}
	finally
	{
		db.closeDB();
	}
%>
<script language="javascript">
	alert("操作成功");
	self.location.href="admin.jsp";
</script>