hibenate问题?

用hibenate什么查询来执行:
select top 4 * from Cjj order by date desc
这个语句了?
HQL查询不行?
----------------解决方案--------------------------------------------------------

createSQLQuery("SQL......").HQL没SQL功能大.

[此贴子已经被作者于2007-8-30 15:31:44编辑过]

----------------解决方案--------------------------------------------------------
我用过了,能写完整吗?
----------------解决方案--------------------------------------------------------
String hql="select top 4 * from Cjj order by date desc";
Query q=this.session.createSQLQuery(hql);
我写的是这样的!
----------------解决方案--------------------------------------------------------
String hql="select top 4 * from Cjj order by date desc";
Query q=this.session.createSQLQuery(hql);
q.addEntity(Cjj.Class);
Iterator it=q.list().iteraor();
tx.commit();
while(it.hasNext()){
Cjj cjj=(Cjj)it.next();
.
.
}
----------------解决方案--------------------------------------------------------
q.addEntity(Cjj.Class);这句有错啊
----------------解决方案--------------------------------------------------------
q.addEntity(Cjj.class);
----------------解决方案--------------------------------------------------------
Query类,没有这个addEntity这个方法啊
----------------解决方案--------------------------------------------------------