bbstopicservlet.java

简易的BBS,可以进行排行榜的查询,发布意见,建立一个新的主题

package com.bbs.servlets;

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import com.bbs.connect.DatabaseConnect;

import org.springframework.jdbc.core.JdbcTemplate;
import javax.sql.DataSource;
import com.bbs.po.BBSCritiqueBean;

public class BBStopicServlet
    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 {
    doPost(request, response);
  }

  //Process the HTTP Post request
  public void doPost(HttpServletRequest request, HttpServletResponse response) throws
      ServletException, IOException {
    //response.setContentType(CONTENT_TYPE);
    response.setCharacterEncoding(CONTENT_TYPE);
    request.setCharacterEncoding("GBK");
    try
    {
      String topicname = request.getParameter("topicname");
      String sql = "";
      sql = "select TOP 2 a.topicName,count(distinct b.critiquePerson) Number "
          +"from  topic a left join  bbstable b  on  a.topicname =b.topicname  "
          + "group by a.topicName order by Number";
      DatabaseConnect dbc = new DatabaseConnect();
      DataSource ds = dbc.DatabaseConnect();
      JdbcTemplate jt = new JdbcTemplate(ds);
      List list = jt.queryForList(sql);
      BBSCritiqueBean bbsp = new BBSCritiqueBean();
      if (list!=null)
      {
        List pagecontent = new ArrayList();
        pagecontent= list;
        for (int i=0;i<list.size();i++)
        {

        }
        request.getSession(true).setAttribute("pagecontentUrl",pagecontent);
        request.setAttribute("pagecontenturl", pagecontent);
      }
      request.getRequestDispatcher("/selectBbs.jsp&accounts="+request.getParameter("accounts")).forward(request, response);
    }catch(Exception e)
    {
      e.printStackTrace();
    }
  }

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