untitled1.java~4~

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

package com.bbs.connect;

public class Untitled1 {
  public Untitled1() {
    String sql = "";
    nt curPage = 0; //当前的页值。
    int maxPage; //最大的页数。
    int maxRowCount = 0; //最大的行数。
    int rowsPerPage = 20; //控制分页的行数。
    List list = null;
    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);

        list = jt1.queryForList(sql);

        //初始化maxRowCount、maxPage
        if (list == null) {
          list = new ArrayList();
        }

        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);
        }
        List topiclist = new ArrayList();
        topiclist.add(topicname);
        request.getSession(true).setAttribute("backresult", backresult);
        request.getSession(true).setAttribute("topicName", topiclist);
      }
    }catch (Exception e) {
      e.printStackTrace();
      }
    }

  }