struts2+hibernate(分页).docx

操作数据: PageDao.javapackage?com.enorth.lichen.youth.dao;import?java.util.ArrayList;import?java.util.List;import?org.hibernate.Session;import?com.enorth.lichen.youth.hi.HibernateUtils;public?class?PageDao?{?public?List?pageQuery(int?pageSize,?int?pageNow){??List?list=new?ArrayList();?Session?session?=?null;?try?{?session?=?HibernateUtils.getSession();?session.beginTransaction();??//得到每页显示的LevTwoInFuUser的对象的集合list?list?=?session.createQuery(from?LevTwoInFuUser?l2if?where?l2if.permission?=?201?order?by?l2if.l2infid)?.setFirstResult(pageNow*pageSizeSize)?.setMaxResults(pageSize)?.list();?session.getTransaction().commit();?}catch(Exception?e)?{?e.printStackTrace();?session.getTransaction().rollback();?}finally?{?HibernateUtils.closeSession(session);?}?return?list;?}???public?int?pageTotle(int?pageSize,?int?pageNow){??int?i=0;?Session?session?=?null;?try?{?session?=?HibernateUtils.getSession();?session.beginTransaction();??//i是查询结果条数?i?=?session.createQuery(from?LevTwoInFuUser?l2if?where?l2if.permission?=?201?order?by?l2if.l2infid)?.list()?.size();??//用总的结果条数对每页显示的条数取余,得到总页数?i=i%pageSize==0?i/pageSize:i/pageSize+1?;??session.getTransaction().commit();}catch(Exception?e)?{? ?e.printStackTrace();? ?session.getTransaction().rollback();? ?}finally?{? ?HibernateUtils.closeSession(session);? ?}? ?return?i;? ?}? }???Action处理: PageQueryAction.java?package?com.enorth.lichen.youth.act;import?java.util.List;import?java.util.Map;import?javax.servlet.http.HttpServletRequest;import?erceptor.ServletRequestAware;import?erceptor.SessionAware;import?com.enorth.lichen.youth.dao.PageDao;import?com.opensymphony.xwork2.ActionSupport;public?class?PageQueryAction?extends?ActionSupport?implements?ServletRequestAware,SessionAware{?private?HttpServletRequest?request;?private?List?list;?private?int?pageNow?=?1?;?//初始化为1,默认从第一页开始显示?private?int?pageSize?=?3?;?//每页显示3条记录?private?int?pageTotle=?1?;//总页数?private?PageDao?pageDao?=?new?PageDao?()?;??public?List?getList()?{?return?list;?}?public?void?setList(