Hibernate中查询数据分页封装
public <T> List<T> listForPagenate(Criteria criteria,PaginatedListImpl command){ if ( command.getSortCriterion() != null) { if (command.getSortDirection().equals(SortOrderEnum.ASCENDING)) { criteria.addOrder(Order.asc(command.getSortCriterion())); } if (command.getSortDirection().equals(SortOrderEnum.DESCENDING)) { criteria.addOrder(Order.desc(command.getSortCriterion())); } } criteria.setFirstResult(command.getFirstRecordIndex()); criteria.setMaxResults(command.getPageSize()); List<T> list = list(criteria); return list;}public <T> List<T> listForNonPagenate(Criteria criteria,PaginatedListImpl command){ if ( command.getSortCriterion() != null) { if (command.getSortDirection().equals(SortOrderEnum.ASCENDING)) { criteria.addOrder(Order.asc(command.getSortCriterion())); } if (command.getSortDirection().equals(SortOrderEnum.DESCENDING)) { criteria.addOrder(Order.desc(command.getSortCriterion())); } } List<T> list = list(criteria); return list;}public int getRowNumberByCriteria(Criteria criteria){ Projection projection = null;ResultTransformer resultTransformer = null;if( criteria instanceof CriteriaImpl ){projection = ((CriteriaImpl)criteria).getProjection();resultTransformer = ((CriteriaImpl)criteria).getResultTransformer();}Integer count = (Integer)criteria.setProjection(Projections.rowCount()).uniqueResult();criteria.setProjection(projection).setResultTransformer(resultTransformer);return count; }?
dataDictionaryCommand.setTotalNumberOfRows(getRowNumberByCriteria(criteria));List<SystemDictionary> results = listForPagenate(criteria,dataDictionaryCommand);dataDictionaryCommand.setList(results);
?
package com.accor.crm.util;import java.util.List;import javax.servlet.http.HttpServletRequest;import org.displaytag.properties.SortOrderEnum;/** * <code>com.gorti.project.web.ui.action.PaginatedListImpl</code> implemnts * </code>com.gorti.project.web.ui.action.IExtendedPaginatedList</code> This * class can be used for pagination purpose. This class depends upon * HttpServletRequest object. To be used by Controllers in case of Http * requests. * * @author */public class PaginatedListImpl implements ExtendedPaginatedList {private Integer pageInput; /** current page index, starts at 0 */ private int index; /** number of results per page (number of rows per page to be displayed ) */ private int pageSize = 20; /** total number of results (the total number of rows ) */ private int fullListSize; /** list of results (rows found ) in the current page */ @SuppressWarnings("unchecked") private List list; /** default sorting order */ private SortOrderEnum sortDirection = SortOrderEnum.ASCENDING; /** sort criteria (sorting property name) */ private String sortCriterion; /** Http servlet request * */ private HttpServletRequest request; /** default constructor * */ public PaginatedListImpl() { } /** * Create <code>PaginatedListImpl</code> instance using the * <code>HttpServletRequest</code> object. * * @param request * <code>HttpServletRequest</code> object. */ /** * Create <code>PaginatedListImpl</code> instance using the * <code>HttpServletRequest</code> object. * * @param request * <code>HttpServletRequest</code> object. * @param pageSize * the page size - the total number of rows per page. */ public PaginatedListImpl(HttpServletRequest request, int pageSize) { sortCriterion = request .getParameter(ExtendedPaginatedList.IRequestParameters.SORT); sortDirection = ExtendedPaginatedList.IRequestParameters.DESC .equals(request .getParameter(ExtendedPaginatedList.IRequestParameters.DIRECTION)) ? SortOrderEnum.DESCENDING : SortOrderEnum.ASCENDING; pageSize = pageSize != 0 ? pageSize : DEFAULT_PAGE_SIZE; String page = request .getParameter(ExtendedPaginatedList.IRequestParameters.PAGE); index = page == null ? 0 : Integer.parseInt(page) - 1; } /** * Create <code>PaginatedListImpl</code> instance . * * @param pageSize * the page size - the total number of rows per page. * @return <code>ExtendedPaginatedList</code> instance. * @throws Exception - * problem while creating paginatedlist object. */ public ExtendedPaginatedList getPaginatedListObject(int pageSize) throws Exception { if (request == null) { throw new Exception( "Cannot create paginated list. Depends upon HttpServletRequest."); } return new PaginatedListImpl(request, pageSize); } /** * Set the non-null <code>HttpServletRequest</code> object. * * @param request * a <code>HttpServletRequest</code> object. */ public void setRequest(HttpServletRequest request) { this.request = request; } public int getFirstRecordIndex() { return index * pageSize; } public int getIndex() { return index; } public void setIndex(int index) { this.index = index; } public int getPageSize() { return pageSize; } public void setPageSize(int pageSize) { this.pageSize = pageSize; } @SuppressWarnings("unchecked") public List getList() { return list; } @SuppressWarnings("unchecked")public void setList(List results) { this.list = results; } public int getFullListSize() { return fullListSize; } public void setTotalNumberOfRows(int total) { this.fullListSize = total; } public int getTotalPages() { return (int) Math.ceil(((double) fullListSize) / pageSize); } public int getObjectsPerPage() { return pageSize; } public int getPageNumber() { return index + 1; } public String getSearchId() { // Not implemented for now. // This is required, if we want the ID to be included in the paginated // purpose. return null; } public String getSortCriterion() { return sortCriterion; } public SortOrderEnum getSortDirection() { return sortDirection; } public void setSortCriterion(String sortCriterion) { this.sortCriterion = sortCriterion; } public void setSortDirection(SortOrderEnum sortDirection) { this.sortDirection = sortDirection; }public Integer getPageInput() {return pageInput;}public void setPageInput(Integer pageInput) {this.pageInput = pageInput;}}?有时间再进行改进...