一个ssh分页的源代码

package com.foxconn.dao; import java.util.List; import org.apache.commons.logging.Log; import org.apache.commons.logging.LogFactory; import org.hibernate.Criteria; import org.hibernate.LockMode; import org.hibernate.Query; import org.hibernate.Session; import org.hibernate.criterion.Example; import org.hibernate.criterion.MatchMode; import org.hibernate.criterion.Restrictions; import org.springframework.context.ApplicationContext; import org.springframework.orm.hibernate3.support.HibernateDaoSupport; import com.foxconn.bean.Tcustomer; public class TcustomerDAO extends HibernateDaoSupport { private static final Log log = LogFactory.getLog(TcustomerDAO.class); // property constants public static final String CUSTOMERNAME = "customername"; public static final String PWD = "pwd"; public static final String LOGINNAME = "loginname"; public static final String BIRTHDAY = "birthday"; protected void initDao() { // do nothing } public void save(Tcustomer transientInstance) { log.debug("saving Tcustomer instance"); try { getHibernateTemplate().save(transientInstance); log.debug("save successful"); } catch (RuntimeException re) { log.error("save failed", re); throw re; } } public void delete(Tcustomer persistentInstance) { log.debug("deleting Tcustomer instance"); try { getHibernateTemplate().delete(persistentInstance); log.debug("delete successful"); } catch (RuntimeException re) { log.error("delete failed", re); throw re; } } public Tcustomer findById(java.lang.Integer id) { log.debug("getting Tcustomer instance with id: " + id); try { Tcustomer instance = (Tcustomer) getHibernateTemplate().get( "com.foxconn.bean.Tcustomer", id); return instance; } catch (RuntimeException re) { log.error("get failed", re); throw re; } } public List findByExample(Tcustomer instance) { log.debug("finding Tcustomer instance by example"); try { List results = getHibernateTemplate().findByExample(instance); log.debug("find by example successful, result size: " + results.size()); return results; } catch (RuntimeException re) { log.error("find by example failed", re); throw re; } } public List findByProperty(String propertyName, Object value) { log.debug("finding Tcustomer instance with property: " + propertyName + ", value: " + value); try { String queryString = "from Tcustomer as model where model." + propertyName + "= ?"; return getHibernateTemplate().find(queryString, value); } catch (RuntimeException re) { log.error("find by property name failed", re); throw re; } } public List findByCustomername(Object customername) { return findByProperty(CUSTOMERNAME, customername); } public List findByPwd(Object pwd) { return findByProperty(PWD, pwd); } public List findByLoginname(Object loginname) { return findByProperty(LOGINNAME, loginname); } public List findByBirthday(Object birthday) { return findByProperty(BIRTHDAY, birthday); } public List findAll() { log.debug("finding all Tcustomer instances"); try { String queryString = "from Tcustomer"; return getHibernateTemplate().find(queryString); } catch (RuntimeException re) { log.error("find all failed", re); throw re; } } public Tcustomer merge(Tcustomer detachedInstance) { log.debug("merging Tcustomer instance"); try { Tcustomer result = (Tcustomer) getHibernateTemplate().merge( detachedInstance); log.debug("merge successful"); return result; } catch (RuntimeException re) { log.error("merge failed", re); throw re; } } public void attachDirty(Tcustomer instance) { log.debug("attaching dirty Tcustomer instance"); try { getHibernateTemplate().saveOrUpdate(instance); log.debug("attach successful"); } catch (RuntimeException re) { log.error("attach failed", re); throw re; } } public void attachClean(Tcustomer instance) { log.debug("attaching clean Tcustomer instance"); try { getHibernateTemplate().lock(instance, LockMode.NONE); log.debug("attach successful"); } catch (RuntimeException re) { log.error("attach failed", re); throw re; } } 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; } } }