对JdbcTemplate分页的一点理解

  众所周知用jdbc查询比用Hibernate的快，但jdbc没有Hibernate的setFirstResult和setMaxResults方法，所以要想用jdbc写查询方法恐怕只能在sql中加入分页的条件，如Oracle 10g的：

public class JdbcProjectDAOImpl extends JdbcDaoSupport implements IprojectDAO<Object> {

	class XiangmuRowMapper implements RowMapper{
		public Object mapRow(ResultSet rs, int rowNum) throws SQLException {
			
			Xiangmu xiangmu = new Xiangmu();
			xiangmu.setXmid(rs.getString("xmid"));
			……
			return xiangmu;
		}
	}
/*
*hql为没有分页功能的查询语句，只需包在2个字符串中间即可实现分页
*/
		public List findPageList(String hql, int firstResult, int maxResults, Object[] values) {
		
		if(firstResult == 0){
			hql = "select * from ( " + hql +" ) where rownum <= " + maxResults;
		}else{
			hql= "select * from (select row_.*,rownum rownum_ from ( "+hql+" ) row_ where rownum <= "+maxResults+" ) where rownum_ > "+firstResult;
		}

		return getJdbcTemplate().query(hql, values, new XiangmuRowMapper());
	}