delete.jsp

JSP+oracle开发实例精粹》随书光盘

<%@ page language="java" contentType="text/html; charset=gb2312" import="java.sql.*"%>
<jsp:useBean id="db" class="yhgl.connectDB" />
<%
try
{
	String id = request.getParameter("id");
	String sql = "delete from YHGL_TABLE where id = '"+id+"'";
	db.executeUpdate(sql);
		%>
		<script language="javascript">
			alert("操作成功!")；
			self.location.href="list.jsp";
		</script>
		<%
}
catch(Exception e)
{
	session.setAttribute("error","3");
	response.redirect("error.jsp");
	e.printStackTrace();
}
%>