del.jsp

来自「这是一个用JAVA语言编写的BBS论坛程序」· JSP 代码 · 共 32 行

<%
/*
 * Copyright:  Copyright (c) 2004 
 * @author http://hi.baidu.com/lael80*/
%>
<%@ page contentType="text/html; charset=gb2312"%>
<%@ page language="java" import="java.sql.*"%>
<% 
response.setHeader("Pragma","No-cache"); 
response.setHeader("Cache-Control","no-cache"); 
response.setDateHeader("Expires", 0); 
%>
<%
int id=Integer.parseInt(request.getParameter("fid"));

try{
  String url="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ="+application.getRealPath("/flash/flash.mdb");
  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  Connection con=DriverManager.getConnection(url);
  Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
 
  int result=stmt.executeUpdate("delete from book where id="+id);

  out.println("<?xml version='1.0' encoding='gb2312'?>");
  out.println("<book>");
  out.println("<pxml result='"+result+"'/>");
  out.println("</book>");

  if(stmt!=null)stmt.close();
  if(con!=null)con.close();
}catch(SQLException e){}
%>