this.getHibernateTemplate().executeFind(new HibernateCallback() { public Object doInHibernate(Session session)
throws HibernateException, SQLException {
Query q = session.createQuery("from User where login=:name")
.setParameter("name", "zhangsan");
q.setFirstResult(从第条开始);
q.setMaxResults(返回最大值);
return q.list();
}
});
throws HibernateException, SQLException {
Query q = session.createQuery("from User where login=:name")
.setParameter("name", "zhangsan");
q.setFirstResult(从第条开始);
q.setMaxResults(返回最大值);
return q.list();
}
});
this.getHibernateTemplate().executeFind(new HibernateCallback() { public Object doInHibernate(Session session)
throws HibernateException, SQLException {
Query q = session.createQuery("from User where login=:name")
.setParameter("name", "zhangsan");
q.setFirstResult(从第条开始);
q.setMaxResults(返回最大值);
return q.list();
}
});
一般使用Query queryObj = this.getSession().createQuery("");
queryObj.setFirstResult();
List list=new ArrayList();
Session session=this.getSession();
try {
tx=session.beginTransaction();
Query q= session.createQuery(HQL语句);
q.setFirstResult(起始数据);
q.setMaxResults(往后查几条);
list =q.list();
tx.commit();
}catch(Exception e){
e.printStackTrace();
tx.rollback();
}finally{
session.close();
}
return list;
用this.getHibernateTemplate().executeFind(new HibernateCallback() 效率的确很低的,没必要用...
myList = this.getHibernateTemplate().find("from MyTable order by status,endtime,id ASC").subList(0,n);
先设置返回的最大记录数:this.getHibernateTemplate().setMaxResults(9);
在return this.getHibernateTemplate().find("from Goods");