pageIndex, pageSize, 是参数: string hql = null; hql = @" select user from User user "; IQuery q = _session.CreateQuery(hql); q.SetFirstResult(pageIndex * pageSize); q.SetMaxResults(pageSize); IList<User> list = q.List<User>(); hql = @" select count(*) from User user "; q = _session.CreateQuery(hql); int totalCount = Convert.ToInt32(q.UniqueResult()); IPagedList<User> result = new StaticPagedList<User>(list, pageIndex, pageSize, totalCount); return result;
具体找个示例看下就知道了,.NET和那个类似.
string hql = null; hql = @"
select user
from User user
"; IQuery q = _session.CreateQuery(hql);
q.SetFirstResult(pageIndex * pageSize);
q.SetMaxResults(pageSize); IList<User> list = q.List<User>(); hql = @"
select count(*)
from User user
";
q = _session.CreateQuery(hql);
int totalCount = Convert.ToInt32(q.UniqueResult());
IPagedList<User> result = new StaticPagedList<User>(list, pageIndex, pageSize, totalCount); return result;
Nhibernate DEMO另外可去学习李勇京的系列 博客园