flash.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 pageid=Integer.parseInt(request.getParameter("fpageid"));

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 id,name,theme,tdate,reply;
  ResultSet rs=null;

  int datacount=0;  
  rs=stmt.executeQuery("select count(id) from book");
  try{
    rs.next();
    datacount=rs.getInt(1);
  }catch(Exception ex){}
  if(rs!=null)rs.close();

  int pagecount=(datacount+12)/13;
  int currentcount=13;
  if(pagecount==pageid)currentcount=datacount-(pagecount-1)*13;
  if(datacount==0){pagecount=1;currentcount=0;}

  int limitstart=(pageid-1)*13;

  out.println("<book>");
  out.println("<pxml fdatacount='"+datacount+"' fpagecount='"+pagecount+"' fcurrentcount='"+currentcount+"'/>");

  rs=stmt.executeQuery("select * from book order by id desc");
  if(pageid!=1)rs.absolute(limitstart);
  int i=0;
  while(rs.next()){
    id=chkNull(rs.getString("id"));
    name=chkNull(rs.getString("name"));
    theme=chkNull(rs.getString("theme"));
    tdate=chkNull(rs.getString("tdate"));
    if(rs.getString("reply")==null||rs.getString("reply").equals(""))reply="";
    else reply="已复";
    out.println("<pxml fid='"+id+"' fname='"+name+"' ftheme='"+theme+"' fdate='"+tdate+"' freply='"+reply+"'/>");

    i++;
    if(i==13)break;
  }
  out.println("</book>");
  if(rs!=null)rs.close();
  if(stmt!=null)stmt.close();
  if(con!=null)con.close();
}catch(SQLException e){}
%>