公共类
public List findByHQL(String hql){
List list = null;
try {
session = HibernateFilter.getSession(); //获取Session对象
session.beginTransaction(); //开启事物
list = session.createQuery(hql) //创建Query对象
.list(); //返回结果集
session.getTransaction().commit(); //提交事物
} catch (Exception e) {
e.printStackTrace(); //打印异常信息
session.getTransaction().rollback(); //回滚事物
}
return list;
}调用
CategoryDao dao = new CategoryDao();
List list=dao.findByHQL("from Category where directoryId=1");
request.setAttribute("list", list);
jsp页面显示
<logic:iterate id="ele" name="list" scope="request">
<bean:write name="ele" property="title"/>
</logic:iterate >
Hibernate如何限制显示记录条数?像sql查询一样用top?谢谢!!
------解决思路----------------------
Query q=session.createQuery(""); //查询语句
q.setFirstResult(0); //从第0条开始
q.setMaxResult搜索(10);//一共取10条
------解决思路----------------------
String hql = "你的hql语句';
session = openSession();
Query query = session.createQuery(hql);
query.setFirstResult(firstRowIndex);
query.setMaxResults(maxRow);
List<Object> list = query.list();
session.close();
从方法名字上就可以读懂