JSP的一种分页

public class PageBeanForm {

 BaseFactory baseFactory = new BaseFactory();

 private int currentPage;

 private int totalPage;

 private int totalNumber;

 private int listNumber = 10;

 private String upPage = "上一页";

 private String downPage = "下一页";

 JdbcInter jdbcInter = new BaseDAO().getJdbc();

 Hashtable hashCourseName = baseFactory.getCourseDaoInter().getResult();

 Hashtable hashChapterName = baseFactory.getChapterDaoInter().getResult();

 Hashtable hashLoreInfor = baseFactory.getLoreDaoInter().getResult();

 Hashtable hashThemeTye = baseFactory.getThemeTypeDaoInter().getResult();

 Hashtable hashStuClass = baseFactory.getClassDaoInter().getResult();

 Hashtable hashStuGrade = baseFactory.getGradeDaoInter().getResult();

 public ArrayList getResult(String table, String sql, String strCurrentPage) {

  ResultSet rs = null;
  ArrayList list = new ArrayList();
  try {
   this.currentPage = new Integer(strCurrentPage).intValue();
   if (this.currentPage < 1) {
    this.currentPage = 1;
   }
  } catch (java.lang.NumberFormatException e) {
   System.out.println("the input not a number!");
   this.currentPage = 1;
  }
  try {
   rs = jdbcInter.getConnection().createStatement(
     ResultSet.TYPE_SCROLL_INSENSITIVE,
     ResultSet.CONCUR_READ_ONLY).executeQuery(sql);
   if (rs != null && rs.next()) {
    rs.last();
    this.totalNumber = rs.getRow();
    this.totalPage = (int) Math.ceil((float) totalNumber
      / (float) listNumber);
    if (this.currentPage > this.totalPage) {
     this.currentPage = this.totalPage;
    }
    rs.absolute((currentPage - 1) * listNumber + 1);

    int addNum = 0;
    if (table.trim().equals("course")) {
     do {
      CourseForm courseForm = new CourseForm();
      courseForm.setCourseId(rs.getInt("courseId"));
      courseForm.setCourseName(rs.getString("courseName"));
      courseForm.setCourseMark(rs.getString("courseMark"));
      courseForm.setAddUser(rs.getString("addUser"));
      courseForm.setAddTime(BaseUtil.getChangeTime(rs
        .getString("addTime").trim()));

      courseForm
        .setCourseNumber(rs.getString("courseNumber"));
      if (rs.getString("updateTime").trim().equals("")) {
       courseForm.setUpdateTime("未曾修改");
      } else {
       courseForm.setUpdateTime(BaseUtil.getChangeTime(rs
         .getString("updateTime").trim()));

      }
      list.add(courseForm);
      addNum++;
     } while (rs.next() && addNum < listNumber);
    }}
    return list;
   }
  } catch (Exception e) {
   e.printStackTrace();
  } finally {
   try {
    rs.close();
   } catch (SQLException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
   }
  }
  return list;
 }

 public void setListNumber(int listNumber) {
  this.listNumber = listNumber;
 }

 public int getListNumber() {
  return listNumber;
 }

 public int getTotalPage() {
  return this.totalPage;
 }

 public int getCurrent() {
  return this.currentPage;
 }

 public int getTotalNumber() {
  return this.totalNumber;
 }

 public void setTotalNumber(int totalNumber) {
  this.totalNumber = totalNumber;
 }

 public String getTotalPageString() {
  return "总共 " + this.totalPage + "页";
 }

 public String getCurrentPageString() {
  return "当前是第 " + this.currentPage + "页";
 }

 public String getTotalNumbers() {
  return "共" + this.totalNumber + "条记录";
 }

 public String getListNumbers() {
  return "每页" + this.listNumber + "条记录";
 }

 public String getDownPage(String jspPage) {
  String param = "";
  if (this.currentPage < this.totalPage) {
   int curNum = this.currentPage + 1;
   param = "<a href=" + jspPage + "page=" + curNum;
   param += ">" + downPage + "</a>/n";
  } else {
   this.currentPage = this.totalPage;
   param = "<a href=" + jspPage + "page=" + this.totalPage;
   param += ">" + downPage + "</a>/n";
  }
  return param;
 }

 public String getUpPage(String jspPage) {
  String param = "";
  if (this.currentPage > 1) {
   int curNum = this.currentPage - 1;
   param = "<a href=" + jspPage + "page=" + curNum;
   param += ">" + upPage + "</a>/n";
  } else {
   this.currentPage = 1;
   param = "<a href=" + jspPage + "page=" + 1;
   param += ">" + upPage + "</a>/n";
  }
  return param;
 }

 public String getFirstPage(String jspPage) {
  int curNum = 1;
  String ret = "";
  if (this.currentPage > 1) {
   ret = "<a href=" + jspPage + "&page=" + curNum + ">第一页</a>";
  } else {
   this.currentPage = 1;
   ret = "";
  }
  return ret;
 }

 public String getEndPage(String jspPage) {
  int curNum = this.totalPage;
  String ret = "";
  if (totalPage > 1 && this.currentPage < totalPage) {
   ret = "<a href=" + jspPage + "&page=" + curNum + ">尾页</a>";
  } else {
   ret = "";
  }
  return ret;
 }

 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值