通用分页

最新推荐文章于 2021-05-26 07:20:34 发布

a274915611

最新推荐文章于 2021-05-26 07:20:34 发布

阅读量534

点赞数

文章标签： javascript list object constants class border

本文链接：https://blog.csdn.net/a274915611/article/details/3206526

版权

========Constants.java

public class Constants {
public final static String USERNAME_KEY = "username";

public final static int pageSize = 25;
public final static int pageNo =1;

}

========Pager.java

public class Pager {

// 页面大小
protected int[] pageSizeList = { 10, 25, 50, 100, 200, 300, 500 };

// 一页显示的记录数
protected int pageSize = Constants.pageSize;

// 当前页码
protected int pageNo = Constants.pageNo;

// 记录总数
protected int rowCount = 0;

// 总页数
protected int pageCount = 1;

// 起始行数
protected int startIndex = 1;

// 结束行数
protected int endIndex = 1;

protected int firstPageNo = 1;
protected int prePageNo = 1;
protected int nextPageNo = 1;
protected int lastPageNo = 1;

// 结果集存放List
protected List resultList;

public Pager(int pageSize, int pageNo, int rowCount, List resultList) {
  this.pageSize = pageSize;
  this.pageNo = pageNo;
  this.rowCount = rowCount;
  this.resultList = resultList;

  if (rowCount % pageSize == 0) {
   this.pageCount = rowCount / pageSize;
  } else {
   this.pageCount = rowCount / pageSize + 1;
  }
  this.startIndex = pageSize * (pageNo - 1);
  this.endIndex = this.startIndex + resultList.size();

  this.lastPageNo = this.pageCount;
  if (this.pageNo > 1) this.prePageNo = this.pageNo -1;
  if (this.pageNo == this.lastPageNo){
   this.nextPageNo = this.lastPageNo;
  } else {
   this.nextPageNo = this.pageNo + 1;
  }
}

public Object[] getPageSizeIndexs() {
  List result = new ArrayList(pageSizeList.length);
  for (int i = 0; i < pageSizeList.length; i++) {
   result.add(String.valueOf(pageSizeList[i]));
  }
  Object[] indexs = (result.toArray());
  return indexs;
}

public Object[] getPageNoIndexs() {
  List result = new ArrayList(pageCount);
  for (int i = 0; i < pageCount; i++) {
   result.add(String.valueOf(i + 1));
  }
  Object[] indexs = (result.toArray());
  return indexs;
}

public int getEndIndex() {
return endIndex;
}

public void setEndIndex(int endIndex) {
this.endIndex = endIndex;
}

public int getPageCount() {
return pageCount;
}

public void setPageCount(int pageCount) {
this.pageCount = pageCount;
}

public int getPageNo() {
return pageNo;
}

public void setPageNo(int pageNo) {
this.pageNo = pageNo;
}

public int getPageSize() {
return pageSize;
}

public void setPageSize(int pageSize) {
this.pageSize = pageSize;
}

public int[] getPageSizeList() {
return pageSizeList;
}

public void setPageSizeList(int[] pageSizeList) {
this.pageSizeList = pageSizeList;
}

public List getResultList() {
return resultList;
}

public void setResultList(List resultList) {
this.resultList = resultList;
}

public int getRowCount() {
return rowCount;
}

public void setRowCount(int rowCount) {
this.rowCount = rowCount;
}

public int getStartIndex() {
return startIndex;
}

public void setStartIndex(int startIndex) {
this.startIndex = startIndex;
}

public int getFirstPageNo() {
return firstPageNo;
}

public void setFirstPageNo(int firstPageNo) {
this.firstPageNo = firstPageNo;
}

public int getLastPageNo() {
return lastPageNo;
}

public void setLastPageNo(int lastPageNo) {
this.lastPageNo = lastPageNo;
}

public int getNextPageNo() {
return nextPageNo;
}

public void setNextPageNo(int nextPageNo) {
this.nextPageNo = nextPageNo;
}

public int getPrePageNo() {
return prePageNo;
}

public void setPrePageNo(int prePageNo) {
this.prePageNo = prePageNo;
}

}

=========index.jsp

<TABLE border="0" width="100%" class="pager">
<TR>
<s:form action="address!list.do" method="post" name="form1">
  <TD align="left"><s:text name="pager.pageSize" />
   <s:select name="pageSize" key="pager.pageSize" list="pager.pageSizeIndexs" value="pager.pageSize" οnchange="document.all.pageNo.value='1';document.all.form1.submit();"/>
  </TD>
  <TD align="center">
  <s:text name="pager.rowCount" /><s:property value="pager.rowCount" />
  </TD>
  <TD align="right">
   <a href="javascript:document.all.pageNo.value='<s:property value="pager.firstPageNo" />';document.all.form1.submit();"><s:text name="pager.firstPageNo" /></a>
   <a href="javascript:document.all.pageNo.value='<s:property value="pager.prePageNo" />';document.all.form1.submit();"><s:text name="pager.prePageNo" /></a>
   <a href="javascript:document.all.pageNo.value='<s:property value="pager.nextPageNo" />';document.all.form1.submit();"><s:text name="pager.nextPageNo" /></a>
   <a href="javascript:document.all.pageNo.value='<s:property value="pager.lastPageNo" />';document.all.form1.submit();"><s:text name="pager.lastPageNo" /></a>
   <s:select name="pageNo" list="pager.pageNoIndexs" value="pager.pageNo" οnchange="document.all.form1.submit();"/>
  </TD>
  <TD width="20"></TD>
</TR>
</TABLE>
</s:form>

=========dao

public Pager findPagerByUsername(final String username, final int pageSize,
   final int pageNo) {
  Session session = getHibernateTemplate().getSessionFactory().openSession();

  // set query condition
  Criteria criteria = session.createCriteria(Address.class);
  criteria.add(Restrictions.eq("username", username));

  // get total count
  int rowCount = ((Integer) criteria.setProjection(
    Projections.rowCount()).uniqueResult()).intValue();
  criteria.setProjection(null);

  // get current page list
  int startIndex = pageSize * (pageNo - 1);
  criteria.addOrder(Order.asc("name"));
  criteria.setFirstResult(startIndex);
  criteria.setMaxResults(pageSize);
  List result = criteria.list();

  session.close();