del.jsp

来自「时空留言本 v1.0 主要功能： ·支持UBB； ·屏蔽HTML； ·加」· JSP 代码 · 共 27 行

<%@ 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();
	}
%>