get.jsp

这是一个用JAVA语言编写的BBS论坛程序

<%
/*
 * Copyright:  Copyright (c) 2004 
 * @author http://hi.baidu.com/lael80*/
%>
<%@ page contentType="text/html; charset=gb2312"%>
<%@ page language="java" import="java.sql.*"%>
<%!
public String chkNull(String sStr){
  if(sStr==null||sStr.trim().equals(""))sStr="";
  return sStr.trim();
}  
%>
<% 
response.setHeader("Pragma","No-cache"); 
response.setHeader("Cache-Control","no-cache"); 
response.setDateHeader("Expires", 0); 
%>
<%
out.println("<?xml version='1.0' encoding='gb2312'?>");

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);

  String name,qq,mail,home,theme,content,tdate,reply,ip;
  ResultSet rs=null;
  
  out.println("<book>");

  rs=stmt.executeQuery("select * from book where id="+id);
  while(rs.next()){
    name=chkNull(rs.getString("name"));
    qq=chkNull(rs.getString("qq"));
    mail=chkNull(rs.getString("mail"));
    home=chkNull(rs.getString("home"));
    theme=chkNull(rs.getString("theme"));
    content=chkNull(rs.getString("content"));
    tdate=chkNull(rs.getString("tdate"));
    reply=chkNull(rs.getString("reply"));
    ip=chkNull(rs.getString("ip"));

    out.println("<pxml fname='"+name+"' fqq='"+qq+"' fmail='"+mail+"' fhome='"+home+"' ftheme='"+theme+"' fcontent='"+content+"' fdate='"+tdate+"' freply='"+reply+"' fip='"+ip+"'/>");
  } 
  out.println("</book>");
  if(rs!=null)rs.close();
  if(stmt!=null)stmt.close();
  if(con!=null)con.close();
}catch(SQLException e){}
%>