最近学习框架做了一个小网站,基本功能都实现了但是分页没办法用框架思想实现,查了资料找到一个不错的,修改了下分享下

本文介绍了一种在SQLServer2005中实现分页查询的方法，利用row_number()函数结合Hibernate框架，实现了动态生成SQL语句的功能。该方法能够有效地处理大量数据，并通过Struts2框架将查询结果展示到前端页面。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

里边的一些方法我也理解,核心思想就是把你传入的hql语句进行拆分重组成SQLserver2005的新分页函数row_number() over(order by id)最后将结果返回字符串,作为将来要传入hibernate的sql语句.测试返回的语句为select * from (,ROW_NUMBER() OVER(order by Book.bookid as book) as _page_row_num_hb from Book as book ) temp where _page_row_num_hb BETWEEN 11 and 20.可以使用.之后返回的list通过struts2 配置antion中的方法放到一个session中然后在jsp页面通过传入不同的参数实现分页这些代码就不演示了.

public class Spage extends SQLServerDialect{
	
	public static void main(String[] args) {
		Spage sp=new Spage();
		String sql=sp.getLimitString("from Book as book order by Book.bookid as book", 10, 20);
		System.out.println(sql);
	}
	 public static int getLastIndexOfOrderBy(String sql){
	        return sql.toLowerCase().lastIndexOf("order by");
	    }
	    
	    public  String getLimitString(String querySelect, int offset, int limit ){
	        int lastIndexOfOrderBy = getLastIndexOfOrderBy(querySelect);
	        //　没有 order by 或第一页的情况下
	        if(lastIndexOfOrderBy<0 || querySelect.endsWith(")") || offset==0)
	            return super.getLimitString(querySelect, 0, limit);
	        else {
	            //取出 order by 语句
	            String orderby = querySelect.substring(lastIndexOfOrderBy, querySelect.length());
	            //取出 from 前的内容
	            int indexOfFrom = querySelect.toLowerCase().indexOf("from");
	            String selectFld = querySelect.substring(0,indexOfFrom);
	            //取出 from 语句后的内容
	            String selectFromTableAndWhere = querySelect.substring(indexOfFrom, lastIndexOfOrderBy);
	            StringBuffer sql = new StringBuffer(querySelect.length()+100);
	            sql.append("select * from (")
	                .append(selectFld)
	                .append(",ROW_NUMBER() OVER(").append(orderby).append(") as _page_row_num_hb ")
	                .append(selectFromTableAndWhere).append(" ) temp ")
	                .append(" where  _page_row_num_hb BETWEEN  ")
	                .append(offset+1).append(" and ").append(limit);
	            return sql.toString();
	        }
	    }
	    //使offset 参数生效
	    public boolean supportsLimitOffset(){
	        return true;
	    }
}