hibernate hql 查询前N条数据 和后N条数据

hql 查询前10条数据 ，默认为asc 升序

public List<MetaData> findTop10Metadata(){
		return (List<MetaData>)this.getHibernateTemplate().execute(new HibernateCallback(){
			public Object doInHibernate(Session session) throws HibernateException, SQLException {
				String hql = "from MetaData order by id asc";
				Query query = session.createQuery(hql);
				query.setMaxResults(10);
				List<MetaData> MetaData=(List<MetaData>)query.list();
				return MetaData;
			}});
	}

hql 查询后10条数据 ，desc为降序

public List<MetaData> findTop10Metadata(){
		return (List<MetaData>)this.getHibernateTemplate().execute(new HibernateCallback(){
			public Object doInHibernate(Session session) throws HibernateException, SQLException {
				String hql = "from MetaData order by id desc";
				Query query = session.createQuery(hql);
				query.setMaxResults(10);
				List<MetaData> MetaData=(List<MetaData>)query.list();
				return MetaData;
			}});
	}