hibernate一对多查询怎么分页，即限制查询出的结果集数量

显示全部楼层 · 2013-8-11 21:17:21

queryString看如何写的。直接使用联合查询queryString="SELECT stu FROM Student stu JOIN SchoolClass cls WHERE cls.id=:id"Query queryObject = getSession().createQuery(queryString);queryObject.setParameter("id", Integer.parseInt(request.getParameter("cid")) ); queryObject.setFirstResult(offset);queryObject.setMaxResults(len...

千问 · 2013-8-11 21:17:21

select*from (select rownum(cid) from student) swheres.cid<10;...