jsf+spring+hibernate分页

package com.wang.test.model.dao; import java.sql.SQLException; import java.util.List; import org.apache.commons.logging.Log; import org.apache.commons.logging.LogFactory; import org.hibernate.Criteria; import org.hibernate.HibernateException; import org.hibernate.LockMode; import org.hibernate.Query; import org.hibernate.Session; import org.hibernate.criterion.Restrictions; import org.springframework.context.ApplicationContext; import org.springframework.orm.hibernate3.HibernateCallback; import org.springframework.orm.hibernate3.support.HibernateDaoSupport; import com.wang.test.model.hibernate.TBook; /** * A data access object (DAO) providing persistence and search support for TBook * 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.wang.test.model.hibernate.TBook * @author MyEclipse Persistence Tools */ public class TBookDAO extends HibernateDaoSupport implements ITBookDAO{ private int totalCount; private static final Log log = LogFactory.getLog(TBookDAO.class); // property constants public static final String BOOK_NAME = "bookName"; public static final String PRODUCTE = "producte"; public static final String PRICE = "price"; protected void initDao() { // do nothing } public void save(TBook tBook) { log.debug("saving TBook instance"); try { getHibernateTemplate().save(tBook); log.debug("save successful"); } catch (RuntimeException re) { log.error("save failed", re); throw re; } } public void delete(TBook tBook) { log.debug("deleting TBook instance"); try { getHibernateTemplate().delete(tBook); log.debug("delete successful"); } catch (RuntimeException re) { log.error("delete failed", re); throw re; } } public TBook findById(java.lang.Integer id) { log.debug("getting TBook instance with id: " + id); try { TBook instance = (TBook) getHibernateTemplate().get( "com.wang.test.model.hibernate.TBook", id); return instance; } catch (RuntimeException re) { log.error("get failed", re); throw re; } } public List findByExample(TBook instance) { log.debug("finding TBook 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 TBook instance with property: " + propertyName + ", value: " + value); try { String queryString = "from TBook 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 findByBookName(Object bookName) { return findByProperty(BOOK_NAME, bookName); } public List findByProducte(Object producte) { return findByProperty(PRODUCTE, producte); } public List findByPrice(Object price) { return findByProperty(PRICE, price); } public List findAll() { log.debug("finding all TBook instances"); try { String queryString = "from TBook"; return getHibernateTemplate().find(queryString); } catch (RuntimeException re) { log.error("find all failed", re); throw re; } } public TBook merge(TBook detachedInstance) { log.debug("merging TBook instance"); try { TBook result = (TBook) getHibernateTemplate().merge( detachedInstance); log.debug("merge successful"); return result; } catch (RuntimeException re) { log.error("merge failed", re); throw re; } } public void attachDirty(TBook instance) { log.debug("attaching dirty TBook instance"); try { getHibernateTemplate().saveOrUpdate(instance); log.debug("attach successful"); } catch (RuntimeException re) { log.error("attach failed", re); throw re; } } public void attachClean(TBook instance) { log.debug("attaching clean TBook instance"); try { getHibernateTemplate().lock(instance, LockMode.NONE); log.debug("attach successful"); } catch (RuntimeException re) { log.error("attach failed", re); throw re; } } public static TBookDAO getFromApplicationContext(ApplicationContext ctx) { return (TBookDAO) ctx.getBean("TBookDAO"); } public void update(TBook book) { // TODO Auto-generated method stub log.debug("修改一本书的记录"); try { getHibernateTemplate().update(book); } catch(RuntimeException re) { log.error("修改失败!",re); throw re; } } public void setTotalCount(int totalCount) { this.totalCount = totalCount; } public int getTotalCount(TBook book) { StringBuffer sb = new StringBuffer("select count(*) from TBook "); if ("".equals(book.getBookName()) || book.getBookName()==null) {} else { sb.append(" where bookName='"); sb.append(book.getBookName()); sb.append("'"); } return new Integer(getHibernateTemplate().find(sb.toString()).get(0).toString()); //System.out.println("tiao jian count:"+totalCount); // TODO Auto-generated method stub //return this.totalCount; } public List<TBook> findByBook(TBook book, int startRow,int pageSize) { // TODO Auto-generated method stub StringBuffer sb = new StringBuffer(" from TBook"); if ("".equals(book.getBookName()) || book.getBookName()==null) {} else { sb.append(" where bookName='"); sb.append(book.getBookName()); sb.append("'"); } if ("".equals(book.getProducte()) || book.getProducte() == null) {} else { sb.append(" producte='"); sb.append(book.getProducte()); sb.append("'"); } sb.append(" order by bookName"); Query query = getHibernateTemplate().getSessionFactory().openSession().createQuery(sb.toString()); query.setFirstResult(startRow); query.setMaxResults(pageSize); List<TBook> books = query.list(); getHibernateTemplate().getSessionFactory().close(); return books; /*return (List<TBook>)getHibernateTemplate().execute(new HibernateCallback() { public Object doInHibernate(final Session session) throws HibernateException, SQLException { // TODO Auto-generated method stub Criteria criteria = session.createCriteria(TBook.class); if ("".equals(book.getBookName()) || book.getBookName()==null) {} else criteria = criteria.add(Restrictions.like("bookName",book.getBookName()+"%")); System.out.println("bookName:" + book.getBookName()); setTotalCount(criteria.list().size()); System.out.println("tiao jian count:"+getTotalCount()); criteria.setFirstResult(startRow); criteria.setMaxResults(pageSize); return criteria.list(); } });*/ } public List<TBook> findByPage(final int startRow, final int pageSize) { // TODO Auto-generated method stub return (List<TBook>)getHibernateTemplate().execute(new HibernateCallback() { public Object doInHibernate(final Session session) throws HibernateException, SQLException { // TODO Auto-generated method stub Criteria criteria = session.createCriteria(TBook.class); setTotalCount(criteria.list().size()); criteria.setFirstResult(startRow); criteria.setMaxResults(pageSize); return criteria.list(); } }); } }