一个通用分页查询方法

/**  * HQL分页查询,可以指定具体的模式,  * 采用getCount方式,须在此层完成hsql的转换与查询。  * 注意参数Object...args的应用,可以在查询的设置查询条件用的(JDK5.0语法)  */  public Page pagedQuery(String hql, int pageNo, int pageSize, Object... args) {      Assert.hasText(hql);      Query query = getSession().createQuery(hql);      for (int i = 0; i < args.length; i++) {          query.setParameter(i, args[i]);      }          String countQueryString = " select count (*) " + removeSelect(removeOrders(hql));          List countlist = getHibernateTemplate().find(countQueryString, args);          int totalCount = (Integer) countlist.get(0);          return HqlPage.getPageInstanceByCount(query, pageNo, pageSize, totalCount);  }    /**  * 去除select 子句，未考虑union的情况  */  private static String removeSelect(String hql) {      Assert.hasText(hql);      int beginPos = hql.toLowerCase().indexOf("from");      Assert.isTrue(beginPos != -1, " hql : " + hql + " must has a keyword 'from'");      return hql.substring(beginPos);  }    /**  * 去除orderby 子句  */  private static String removeOrders(String hql) {      Assert.hasText(hql);      Pattern p = Pattern.compile("order\\s*by[\\w|\\W|\\s|\\S]*", Pattern.CASE_INSENSITIVE);      Matcher m = p.matcher(hql);      StringBuffer sb = new StringBuffer();      while (m.find()) {          m.appendReplacement(sb, "");      }      m.appendTail(sb);      return sb.toString();  }