hibernate分页的限制
- 作者: 嶵惡濤兲
- 来源: 51数据库
- 2021-01-26
select * from
(select rownum(cid) from student) s
where s.cid<10;
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(length);
(select rownum(cid) from student) s
where s.cid<10;
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(length);
推荐阅读
