ajax分页查询完美示例

package com.finegold2.common.impl; import java.sql.SQLException; import java.util.List; import org.hibernate.HibernateException; import org.hibernate.Session; import org.springframework.dao.DataAccessException; import org.springframework.orm.hibernate3.HibernateCallback; import org.springframework.orm.hibernate3.support.HibernateDaoSupport; import com.aptech.query.HibernateQueryHql; import com.aptech.query.HqlExecute; import com.aptech.query.QueryException; import com.finegold2.common.ICommon; import com.finegold2.exception.CommonException; public class Common<POJO> extends HibernateDaoSupport implements ICommon<POJO>{ /* (non-Javadoc) * @see com.finegold2.common.impl.ICommon#insert(POJO) */ public void insert(POJO pojo)throws CommonException{ try { this.getHibernateTemplate().save(pojo); } catch (DataAccessException e) { e.printStackTrace(); throw new CommonException(e); } } /* (non-Javadoc) * @see com.finegold2.common.impl.ICommon#delete(java.lang.Class, int) */ public void delete(Class clazz,int id)throws CommonException{ try { POJO pojo=(POJO) this.getHibernateTemplate().load(clazz, id); this.getHibernateTemplate().delete(pojo); } catch (DataAccessException e) { e.printStackTrace(); throw new CommonException(e); } } /* (non-Javadoc) * @see com.finegold2.common.impl.ICommon#update(POJO) */ public void update(POJO pojo)throws CommonException{ try { this.getHibernateTemplate().update(pojo); } catch (DataAccessException e) { e.printStackTrace(); throw new CommonException(e); } } /* (non-Javadoc) * @see com.finegold2.common.impl.ICommon#getfindByid(java.lang.Class, int) */ public POJO getfindByid(Class clazz,int id)throws CommonException{ try { POJO pojo=(POJO) this.getHibernateTemplate().get(clazz, id); return pojo; } catch (DataAccessException e) { e.printStackTrace(); throw new CommonException(e); } } /* (non-Javadoc) * @see com.finegold2.common.impl.ICommon#loadfindByid(java.lang.Class, int) */ public POJO loadfindByid(Class clazz,int id)throws CommonException{ try { POJO pojo=(POJO)this.getHibernateTemplate().load(clazz, id); return pojo; } catch (DataAccessException e) { e.printStackTrace(); throw new CommonException(e); } } /* (non-Javadoc) * @see com.finegold2.common.impl.ICommon#queryPojo(java.lang.Class) */ public List queryPojo(final Class clazz)throws CommonException{ try { return this.getHibernateTemplate().executeFind(new HibernateCallback(){ public Object doInHibernate(Session session) throws HibernateException, SQLException { return session.createQuery("form "+clazz.getSimpleName()).list(); }}); } catch (DataAccessException e) { e.printStackTrace(); throw new CommonException(e); } } /* (non-Javadoc) * @see com.finegold2.common.impl.ICommon#currencyQuery(com.aptech.query.HqlExecute) */ public List currencyQuery(final HqlExecute hqlexe) throws CommonException { try { return this.getHibernateTemplate().executeFind( new HibernateCallback() { public Object doInHibernate(Session session) throws HibernateException, SQLException { try { return hqlexe.execute(session); } catch (QueryException e) { e.printStackTrace(); return null; } } }); } catch (DataAccessException e) { e.printStackTrace(); throw new CommonException(e); } } /* (non-Javadoc) * @see com.finegold2.common.impl.ICommon#getSizeUnCondition(java.lang.Class) */ public int getSizeUnCondition(final Class clazz) throws CommonException { return Integer.parseInt(this.getHibernateTemplate().execute( new HibernateCallback() { public Object doInHibernate(Session session) throws HibernateException, SQLException { HibernateQueryHql hql = new HibernateQueryHql(); try { hql.addEntity(clazz, "a"); hql.setSelect("count(*)"); HqlExecute hqlexe = new HqlExecute(hql); List lst = hqlexe.execute(session); return lst.get(0); } catch (QueryException e) { e.printStackTrace(); throw new HibernateException(e); } } }).toString()); } /* (non-Javadoc) * @see com.finegold2.common.impl.ICommon#getPageSize(java.lang.Class, int) */ public int[] getPageSize(Class clazz, int pagesize) throws CommonException { int size = this.getSizeUnCondition(clazz); return new int[] { size % pagesize == 0 ? size / pagesize : size / pagesize + 1, size }; } }