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; }
}
