⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 eee.java

📁 简易的BBS,可以进行排行榜的查询,发布意见,建立一个新的主题
💻 JAVA
字号:
🔍 
package com.bbs.servlets;

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import org.springframework.jdbc.core.JdbcTemplate;
import com.bbs.connect.DatabaseConnect;
import javax.sql.DataSource;

public class eee
    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();
    out.println("<html>");
    out.println("<head><title>eee</title></head>");
    out.println("<body bgcolor=\"#ffffff\">");
    out.println("<p>The servlet has received a " + request.getMethod() +
                ". This is the reply.</p>");
    out.println("</body>");
    out.println("</html>");
    out.close();
  }

  //Process the HTTP Post request
  public void doPost(HttpServletRequest request, HttpServletResponse response) throws
      ServletException, IOException {
    String sql = "";
    int curPage = 0; //当前的页值。
    int maxPage = 0; //最大的页数。
    int maxRowCount = 0; //最大的行数。
    int rowsPerPage = 20; //控制分页的行数。
    List list = new ArrayList();
    List TaxisResult = new ArrayList();
    String topicname = request.getParameter("topicname");
    try {
      sql = "";
      JdbcTemplate jt1 = new JdbcTemplate();
      DataSource ds1;
      if (topicname != null) {
        sql =
            "select TOP 3 a.topicName,count(distinct b.critiquePerson) Number "
            +
            "from  topic a left join  bbstable b  on  a.topicname =b.topicname  "
            + "group by a.topicName";
        DatabaseConnect dbc1 = new DatabaseConnect();
        ds1 = dbc1.DatabaseConnect();
        jt1 = new JdbcTemplate(ds1);
        list = jt1.queryForList(sql);
        //初始化maxRowCount、maxPage
        if (list == null) {
          list = new ArrayList();
        }
        List taxisdatalist = new ArrayList(); //排序后的数据集
        List backresult = new ArrayList(); //返回页面数据
        List backmaxpage = new ArrayList(); //返回页面数据
        List backcurpage = new ArrayList(); //返回当前页
        backmaxpage.add(String.valueOf(maxPage));
        taxisdatalist = list;
        request.getSession(true).setAttribute("maxPage", maxPage);
        taxisdatalist = list;
        if (request.getParameter("page") != null) {
          curPage = Integer.parseInt(request.getParameter("page"));
        }
        if (taxisdatalist.size() > 0) {
          if ( (curPage == 0 || curPage == 1) && taxisdatalist != null) {
            for (int i = 0; i < rowsPerPage; i++) {
              if (taxisdatalist.size() == (i + 1) || taxisdatalist.size() == 0) {
                break;
              }
              if (taxisdatalist.get(i) != null) {
                backresult.add(taxisdatalist.get(i));
              }
            }
            curPage = 1;
            backcurpage.add(String.valueOf(curPage));
            request.getSession(true).setAttribute("curpage", curPage);
          }
        }
        request.getSession(true).setAttribute("backresult", backresult);
        request.getSession(true).setAttribute("topicname", topicname);
      }
    }
    catch (Exception e) {
      e.printStackTrace();
    }
  }

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

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -