//查询用户留言
@Override
public List<LeaveWords> getLeaveWords(String userName) {
Session session = null;
List<LeaveWords> leaveWordsArray = new ArrayList<LeaveWords>();
try{
session = super.getHibernateSessionFactory().getSession();
String hql = "from UserInfo where userName=:userName";
Query query = session.createQuery(hql);
query.setString("userName", userName);
UserInfo userInfo = (UserInfo) query.list().get(0);
Hibernate.initialize(userInfo.getLeaveWords1());
leaveWordsArray.addAll(userInfo.getLeaveWords1());
} catch(HibernateException e) {
throw e;
}finally {
if(session != null) {
session.close();
}
}
return leaveWordsArray;
}这个方法是查询用户留言的信息,通过 Hibernate.initialize(userInfo.getLeaveWords1()); 可以获得用户的留言信息。
但要对留言进行分页查询,这里该如何弄呀!!!急!!!
@Override
public List<LeaveWords> getLeaveWords(String userName) {
Session session = null;
List<LeaveWords> leaveWordsArray = new ArrayList<LeaveWords>();
try{
session = super.getHibernateSessionFactory().getSession();
String hql = "from UserInfo where userName=:userName";
Query query = session.createQuery(hql);
query.setString("userName", userName);
UserInfo userInfo = (UserInfo) query.list().get(0);
Hibernate.initialize(userInfo.getLeaveWords1());
leaveWordsArray.addAll(userInfo.getLeaveWords1());
} catch(HibernateException e) {
throw e;
}finally {
if(session != null) {
session.close();
}
}
return leaveWordsArray;
}这个方法是查询用户留言的信息,通过 Hibernate.initialize(userInfo.getLeaveWords1()); 可以获得用户的留言信息。
但要对留言进行分页查询,这里该如何弄呀!!!急!!!
query.setFirstResult(?);//初始记录
query.setMaxResults(?);//每页显示数
List ret = query.list();//查询出指定页不过对你的留言信息不是很清楚
-
http://developer.51cto.com/art/200906/128331.htm
-
http://www.ineeke.com/archives/hibernatepagerquery/楼主可以参考上面的
没有呀!!!
哪里有那种分页,难道hibernate真的不支持这种分页的吗???
有没有人知道呀!
query.setFirstResult(?);//初始记录
query.setMaxResults(?);//每页显示数
List ret = query.list();//查询出指定页
session.createFilter(userInfo.getLeaveWords1(),"order by xx").setFirstResult(10).setMaxResult(50).list();具体这个createFilter的参数有何作用,请参考API。