bbstopic.java~22~

来自「简易的BBS,可以进行排行榜的查询,发布意见,建立一个新的主题」· JAVA~22~ 代码 · 共 47 行

package com.bbs.servlets;

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

public class BBStopic
    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("gb2312");
    try
    {
      String topicname = request.getParameter("topicname").toString();
      String sql = "";
      sql =
          "select top 3 TopicName,count(distinct critiquePerson) Number from bbstable  "
          + "group by TopicName";
      DatabaseConnect ct = new DatabaseConnect();
      ct.DatabaseConnect();
    }catch(Exception e)
    {
      e.printStackTrace();
    }
  }

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