错了,应该是这样
Select name,sex from (select * from usertable order by id,user) where user='asdf' and rownum<=5这个sql我怎么用hibernate写出来啊????
Select name,sex from (select * from usertable order by id,user) where user='asdf' and rownum<=5这个sql我怎么用hibernate写出来啊????
然后
String queryString="Select u.name,u.sex from usertable u where user='asdf' order by id,user";
Query query=null;
List messageList=null;
Session session=this.getSession();
query=session.createQuery(queryString.toString());
query.setFirstResult(startRow);
query.setMaxResults(rows);
messageList=query.list();startRow定义起始行数,rows定义一页多少行.
messageList就是usertable 对象列表.