staticservlet.java

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

package bbs.servlet;

//staticservlet
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import com.db.DBAccess;

public class StaticServlet
    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();
    Calendar cd = Calendar.getInstance();
    //获得当前系统时间
    String year = cd.get(Calendar.YEAR)+"";
    String month = (cd.get(Calendar.MONTH)+1)+"";
    String day = cd.get(Calendar.DAY_OF_MONTH)+"";

    String hour = cd.get(Calendar.HOUR_OF_DAY)+"";
    String minute = cd.get(Calendar.MINUTE)+"";
    String second = cd.get(Calendar.SECOND)+"";
    String time = year + "-" + month + "-" + day + " " + hour + ":" + minute +
        ":" + second;
    DBAccess db = new DBAccess();
    //统计论坛信息
    int count1 = 0;
    int count2 = 0;
    int count3 = 0;
    ArrayList data = null;
    try {
      data = (ArrayList) db.select("bbsTopic");
      for (int i = 0; i < data.size(); i++) {
        count1++;
      }
      data = (ArrayList) db.select("bbsReply");
      for (int i = 0; i < data.size(); i++) {
        count2++;
      }
      data = (ArrayList) db.select("bbsUsers");
      for (int i = 0; i < data.size(); i++) {
        count3++;
      }
      request.setAttribute("bbsTime", time);
      request.setAttribute("bbsCount1", count1 + "");
      request.setAttribute("bbsCount2", count2 + "");
      request.setAttribute("bbsCount3", count3 + "");
      request.getRequestDispatcher("adminStatic.jsp").forward(request, response);
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
    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() {
  }
}