showtopic.java

功能描述 1） 后台：管理员负责对整个论坛进行管理

package bbs.servlet;

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import bbs.db.TopicDB;
import bbs.bean.BbsTopic;
import com.db.DBAccess;
import bbs.bean.BbsUsers;
import bbs.db.ReplayDB;

public class ShowTopic
    extends HttpServlet {
  private static final String CONTENT_TYPE = "text/html; charset=GBK";

  //Initialize global variables
  public void init() throws ServletException {
  }

  //Process the HTTP Get request
  public void doGet(HttpServletRequest request, HttpServletResponse response) throws
      ServletException, IOException {
    response.setContentType(CONTENT_TYPE);
    PrintWriter out = response.getWriter();
    //从数据库获得帖子的信息
    String tid = request.getParameter("tid");
    String uname = request.getParameter("uname");
    String cpage = request.getParameter("cpage");
    uname = new String(uname.getBytes("ISO-8859-1"));
    int ccpp;
    if (cpage == null || cpage.equals("")) {
      cpage = "1";
    }

    HttpSession session = request.getSession();
    try
    {
      ccpp = Integer.parseInt(cpage);
      TopicDB db = new TopicDB();
      BbsTopic topic = db.selectTopic(tid);
      DBAccess dbTwo = new DBAccess();
      ReplayDB rdb = new ReplayDB();
      rdb.setRows(10);
      BbsUsers user = dbTwo.selectUser(uname);
      session.setAttribute("topic",topic);
      session.setAttribute("user",user);
      request.setAttribute("data",rdb.select(Integer.parseInt(tid),ccpp));
      int rows = rdb.getRows();
      int pageCount = rdb.getPageCount();
      request.setAttribute("cpage", ccpp + "");
      request.setAttribute("row", rows + "");
      request.setAttribute("pages", pageCount + "");

      db.setClickCount(Integer.parseInt(tid));
      request.getRequestDispatcher("showtopic.jsp").forward(request,response);
    }
    catch(Exception ex){
      ex.printStackTrace();
      request.setAttribute("message", "数据库操作发生错误！");
      request.getRequestDispatcher("error.jsp").forward(request, response);

    }
    out.close();
  }

  //Process the HTTP Post request
  public void doPost(HttpServletRequest request, HttpServletResponse response) throws
      ServletException, IOException {
    doGet(request, response);
  }

  //Clean up resources
  public void destroy() {
  }
}