ssh.zip_SSH 数据分页_ssh分页实现

package com.woniuxy.ssh.po; import java.util.List; import org.apache.commons.logging.Log; import org.apache.commons.logging.LogFactory; import org.hibernate.CacheMode; import org.hibernate.LockMode; import org.hibernate.Query; import org.hibernate.Session; import org.springframework.context.ApplicationContext; import org.springframework.orm.hibernate3.HibernateTemplate; import org.springframework.orm.hibernate3.support.HibernateDaoSupport; /** * A data access object (DAO) providing persistence and search support for * Person entities. Transaction control of the save(), update() and delete() * operations can directly support Spring container-managed transactions or they * can be augmented to handle user-managed Spring transactions. Each of these * methods provides additional information for how to configure it for the * desired type of transaction control. * * @see com.woniuxy.ssh.po.Person * @author MyEclipse Persistence Tools */ public class PersonDAO extends HibernateDaoSupport { private static final Log log = LogFactory.getLog(PersonDAO.class); // property constants public static final String AGE = "age"; public static final String ADDRESS = "address"; public static final String NAME = "name"; protected void initDao() { // do nothing } public void save(Person transientInstance) { log.debug("saving Person instance"); try { getHibernateTemplate().save(transientInstance); log.debug("save successful"); } catch (RuntimeException re) { log.error("save failed", re); throw re; } } public void delete(Person persistentInstance) { log.debug("deleting Person instance"); try { getHibernateTemplate().delete(persistentInstance); log.debug("delete successful"); } catch (RuntimeException re) { log.error("delete failed", re); throw re; } } public Person findById(java.lang.Integer id) { log.debug("getting Person instance with id: " + id); try { Person instance = (Person) getHibernateTemplate().get("com.woniuxy.ssh.po.Person", id); return instance; } catch (RuntimeException re) { log.error("get failed", re); throw re; } } public List findByExample(Person instance) { log.debug("finding Person 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 Person instance with property: " + propertyName + ", value: " + value); try { String queryString = "from Person 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 findByAge(Object age) { return findByProperty(AGE, age); } public List findByAddress(Object address) { return findByProperty(ADDRESS, address); } public List findByName(Object name) { return findByProperty(NAME, name); } public List findAll() { log.debug("finding all Person instances"); try { Session session = this.getSession(); String queryString = "from Person"; return getHibernateTemplate().find(queryString); } catch (RuntimeException re) { log.error("find all failed", re); throw re; } } public List findAll(int page) { log.debug("finding all Person instances"); try { Session session = this.getSession(); String queryString = "from Person"; Query query = session.createQuery(queryString); query.setFirstResult((page-1)*5); query.setMaxResults(5); // query.setCacheable(true); // query.setCacheMode(CacheMode.parse("demo")); List<Person> list = query.list(); // session.close(); return list; } catch (RuntimeException re) { log.error("find all failed", re); throw re; } } public Person merge(Person detachedInstance) { log.debug("merging Person instance"); try { Person result = (Person) getHibernateTemplate().merge(detachedInstance); log.debug("merge successful"); return result; } catch (RuntimeException re) { log.error("merge failed", re); throw re; } } public void attachDirty(Person instance) { log.debug("attaching dirty Person instance"); try { getHibernateTemplate().saveOrUpdate(instance); log.debug("attach successful"); } catch (RuntimeException re) { log.error("attach failed", re); throw re; } } public void attachClean(Person instance) { log.debug("attaching clean Person instance"); try { getHibernateTemplate().lock(instance, LockMode.NONE); log.debug("attach successful"); } catch (RuntimeException re) { log.error("attach failed", re); throw re; } } public List<Long> count() { log.debug("count Person"); try { String queryString = "SELECT COUNT(*) FROM Person"; HibernateTemplate ht = this.getHibernateTemplate(); List<Long> list = ht.find(queryString); ht.setCacheQueries(true); return list; } catch (RuntimeException re) { log.error("find by property name failed", re); throw re; } } public static PersonDAO getFromApplicationContext(ApplicationContext ctx) { return (PersonDAO) ctx.getBean("PersonDAO"); } }