del.jsp

开发环境：J2SDK1.42+Resin2.1.5+ACCESS2000 运行要求： ·Windows 2000 或 Windows XP 安装 J2SDK1.42+Resin2.1.5+

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="error.jsp" %>
<jsp:useBean id="DBConnection" scope="page" class="com.guestbook.DBConnection"/>
<%
   String id=request.getParameter("id");
   Connection conn=conn=DBConnection.getConnectionToAccess(application.getRealPath("/data/guestbook.mdb"));
   Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); 
   String sqlr="delete  from Guestbook where id=" +id;
   
    try{
//out.print(sql);
         stmt.executeUpdate(sqlr);
         response.sendRedirect("index.jsp");
      }
	  catch(Exception e){
        response.sendRedirect("error.jsp?error=2");//数据库更新出错！
     }
	if(conn!=null)
	{
		conn.close();
	}
	if(stmt!=null)
	{
		stmt.close();
	}
%>