untitled1.java~1~

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

package com.bbs.connect;

public class Untitled1 {
  public Untitled1() {
  }

  String sql = "";
  public int curPage = 0; //当前的页值。
  public int maxPage; //最大的页数。
  public int maxRowCount = 0; //最大的行数。
  public static int rowsPerPage = 20; //控制分页的行数。
  public List list = null;
  public List TaxisResult = null;
  try {
    sql = "";
    JdbcTemplate jt1 = new JdbcTemplate();
    DataSource ds1;
    if (topicname != null) {
      sql =
          "select topicName,critiquePerson,critiqueTime,critiqueContext from dbo.bbstable  ";
      DatabaseConnect dbc1 = new DatabaseConnect();
      ds1 = dbc1.DatabaseConnect();
      jt1 = new JdbcTemplate(ds1);
    }
    try {
      list = jt1.queryForList(sql);
    }
    catch (Exception ex) {
      log.error(ex.toString(), ex);
    }
    //初始化maxRowCount、maxPage
    if (list == null) {
      list = new ArrayList();
    }
    maxRowCount = list.size();
    if (maxRowCount % rowsPerPage == 0) {
      maxPage = maxRowCount / rowsPerPage;
    }
    else {
      maxPage = maxRowCount / rowsPerPage + 1;
    }
    List senddate = new ArrayList(); //传递日期参数
    List sendplace = new ArrayList(); //传递地点参数
    List taxisdatalist = new ArrayList(); //排序后的数据集
    List backresult = new ArrayList(); //返回页面数据
    List backmaxpage = new ArrayList(); //返回页面数据
    List backcurpage = new ArrayList(); //返回当前页
    senddate.add(request.getParameter("f_month"));
    sendplace.add(request.getParameter("area"));
    backmaxpage.add(String.valueOf(maxPage));
    //request.getSession(true).setAttribute("senddate", datestr);
    //request.getSession(true).setAttribute("sendplace", area);
    request.getSession(true).setAttribute("maxPage", backmaxpage);
    taxisdatalist = list;
    if (request.getParameter("page") != null) {
      curPage = Integer.parseInt(request.getParameter("page"));
    }
    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);
    }
    if (curPage > 1 && taxisdatalist != null) {
      for (int i = 0; i < rowsPerPage; i++) {
        if (taxisdatalist.size() == ( (curPage - 1) * rowsPerPage + i)) {
          break;
        }
        if (taxisdatalist.get( (curPage - 1) * rowsPerPage + i) != null) {
          backresult.add(taxisdatalist.get( (curPage - 1) * rowsPerPage + i));
        }
      }
      if (request.getParameter("page") != null) {
        curPage = Integer.parseInt(request.getParameter("page"));
        backcurpage.add(String.valueOf(curPage));
      }
      request.getSession(true).setAttribute("curpage", curPage);

    }
    List topiclist = new ArrayList();
    topiclist.add(topicname);
    request.getSession(true).setAttribute("backresult", backresult);
    request.getSession(true).setAttribute("topicName", topiclist);
  }catch(Exception e)
  {

  }
}