hibernate分页显示

public class ProjectDao {
 private static Session session = null;
 private int pagecount1;//最大页号
 private int count;//最大记录数
 private int nowpagenumber=1;//当前页数
 public int getPagecount1() {
  return pagecount1;
 }
 public void setPagecount1(int pagecount1) {
  this.pagecount1 = pagecount1;
 }
 
 public int getNowpagenumber() {
  return nowpagenumber;
 }

/**
  * 分页显示
  * */
 public List pageQuery(int pagecount, int pagesize) {
  List list = null;
  List l = null;
  int maxpagecount = 0;//总页数  
  int nowcount=0;//当前记录数
  try {
   session = HibernateSessionFactory.getSession();
   Transaction tran = session.beginTransaction();
   Query q1 = session.createQuery("select count(*) from Project p, Manager m where p.pmanager=m.pid and p.xdelete=0 ");
   l = q1.list();
   count = Integer.parseInt(l.get(0) + "");//记录总数
   
   maxpagecount = (count - 1) / pagesize + 1;//总页数
   
   if (pagecount > maxpagecount) {
    pagecount = maxpagecount;
   }
   if (pagecount < 0) {
    pagecount = 0;
   }
   pagecount1=maxpagecount;
   nowpagenumber=pagecount;
   nowcount=(pagecount-1)*pagesize;
   Query q = session.createQuery("from Project p, Manager m where p.pmanager=m.pid and p.xdelete=0 ");
   list = q.setFirstResult(nowcount).setMaxResults(pagesize).list();
   
   tran.commit();
   
  } catch (Exception e) {
   
   e.printStackTrace();
  } finally {
   HibernateSessionFactory.closeSession();
   
  }
  System.out.println("in the pagequery");
  return list;
 }

}