分页部分代码

public static TcustomerDAO getFromApplicationContext(ApplicationContext ctx) {
return (TcustomerDAO) ctx.getBean("TcustomerDAO");
}

@SuppressWarnings("unchecked")
public int getUserTotalCount(String customerName){
String hql= "select count(*) from Tcustomer where 1=1";
if ( customerName !=null){
hql += "and customerName like :customerName";
}
Session session = this.getHibernateTemplate().getSessionFactory().openSession();
Query q = session.createQuery(hql);
if ( customerName !=null){
q.setString("customerName", "%"+customerName+"%");
}
List l = q.list();
Integer i = (Integer)l.get(0);
return i;
}

public int getTotalPage(int pageSize ,String customerName){
int totalCount = this.getUserTotalCount(customerName);
int totalPageCount = (totalCount+pageSize-1)/pageSize;
return totalPageCount;
}

@SuppressWarnings("unchecked")
public List findPageAll(int currentPage,int pageSize,Tcustomer instance){
log.debug("分页查找");
try {
if (currentPage == 0){
currentPage =1;}
Criteria criteria = this.getSession().createCriteria(Tcustomer.class);
Example example = Example.create(instance);
if (instance.getCustomername()!= null){
criteria.add(Restrictions.ilike("customerName", instance.getCustomername(),MatchMode.ANYWHERE));
}
criteria.setFirstResult((currentPage-1)*pageSize);
criteria.setMaxResults(pageSize);
return criteria.list();
}catch(RuntimeException re){
log.error("find all failed",re);
throw re;
}
}
}


public class ListMyUsersAction extends Action  {
MyUserPage myUserPage;
public MyUserPage getMyUserPage() {
return myUserPage;
}
public void setMyUserPage(MyUserPage myUserPage) {
this.myUserPage = myUserPage;
}
public ActionForward execute(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response) {
// int pno = (new Integer(request.getParameter("pno"))).intValue();
System.out.println(request.getParameter("pno"));
int pno = 0;
try{if ((request.getParameter("pno").toString()) == "null" ||(request.getParameter("pno") == null)||"".equals(request.getParameter("pno"))){
pno =1;
}else{pno= Integer.parseInt(request.getParameter("pno"));}
}catch(Exception e){
e.printStackTrace();
}
System.out.println(pno);
   String hql = "from Tcustomer";
//    MyUserPage myUserPage = getMyUserPage();
   myUserPage.init(pno, hql);
   Page myUserOnePage = myUserPage.getPage();
   List myUserList = myUserPage.getPage().getList();
   HttpSession session = request.getSession();
   session.setAttribute("myUserOnePage", myUserOnePage);
   session.setAttribute("myUserList", myUserList);
   return mapping.findForward("listmyusers");
}