/** 在HQL的后面添加分页参数定义的orderBy, 辅助函数. */ protected String setPageRequestToHql(String hql, PageRequest pageRequest) { if (CollectionUtils.isEmpty(pageRequest.getSort())) { return hql; } StringBuilder builder = new StringBuilder(hql); builder.append(" order by"); for (PageRequest.Sort orderBy : pageRequest.getSort()) { builder.append(String.format(" %s %s,", orderBy.getProperty(), orderBy.getDir())); } builder.deleteCharAt(builder.length() - 1); return builder.toString(); }
/** * 设置分页参数到Criteria对象,辅助函数. * * @param c Hibernate Criteria * @param pageRequest 分页请求参数 * @return {@link org.hibernate.Criteria} */ protected Criteria setPageRequestToCriteria(Criteria c, PageRequest pageRequest) { Assert.isTrue(pageRequest.getPageSize() > 0, "分页大小必须大于0"); c.setFirstResult(pageRequest.getOffset()); c.setMaxResults(pageRequest.getPageSize()); if (pageRequest.isOrderBySetted()) { for (PageRequest.Sort sort : pageRequest.getSort()) { Order order = null; if (sort.getDir().equals(PageRequest.Sort.ASC)) { order = Order.asc(sort.getProperty()); } else { order = Order.desc(sort.getProperty()); } c.addOrder(order); } } return c; }