showsection.java

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

package bbs.servlet;

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


public class ShowSection
    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();
    //字符集
    request.setCharacterEncoding("GB2312");
    //分页
    String id = request.getParameter("sid");
    String name = request.getParameter("sname");
    String cpage = request.getParameter("cpage");
    String sname = request.getParameter("sname1");
    String kname = request.getParameter("kname");
    if(name == null || name.equals("")){
      name = (String) request.getAttribute("topicuser");
    }
    if(id == null){
      id = (String)request.getAttribute("sid");
    }
    if(sname == null){
      sname = (String)request.getAttribute("s2name");
      kname = (String)request.getAttribute("k2name");
    }else {
      sname = new String(sname.getBytes("ISO-8859-1"));
      kname = new String(kname.getBytes("ISO-8859-1"));
    }

    int ccpp;
    if (cpage == null || cpage.equals("")) {
      cpage = "1";
    }

    try {
      ccpp = Integer.parseInt(cpage);
      TopicDB db = new TopicDB();
      db.setRows(15);
      ArrayList data = db.select(ccpp,id);
      int pageCount = db.getPageCount();
      int rows = db.getRows();
      request.setAttribute("topicdata", data);
      request.setAttribute("cpage", ccpp + "");
      request.setAttribute("row", rows + "");
      request.setAttribute("pages", pageCount + "");
      request.setAttribute("uname",name);
      request.setAttribute("sid",id);
      request.setAttribute("sname",sname);
      request.setAttribute("kname",kname);
      request.getRequestDispatcher("main.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() {
  }
}