通用的Java DAO類

import java.io.Serializable;
import java.util.Date;
import java.util.List;

import org.hibernate.Criteria;
import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.criterion.MatchMode;
import org.hibernate.criterion.Restrictions;
import org.jb.common.dao.CommonDAO;
import org.jb.common.util.PageResult;
import org.jb.y272.team0.entity.SalaryStandard;
import org.springframework.orm.hibernate3.HibernateCallback;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
public class CommonDAOHibImpl extends HibernateDaoSupport implements CommonDAO {
    /*

 * （非 Javadoc）
 * 
 * @see y2ssh.dlc.chp2.dao.CommonDAO#add(java.lang.Object)
 */
public Serializable add(Object o) {
    Serializable ret = super.getHibernateTemplate().save(o);
    return ret;
}

/*
 * （非 Javadoc）
 * 
 * @see y2ssh.dlc.chp2.dao.CommonDAO#get(java.lang.Class,
 * java.io.Serializable)
 */
public Object get(Class clazz, Serializable id) {
    Object ret = super.getHibernateTemplate().get(clazz, id);
    return ret;
}

/*
 * （非 Javadoc）
 * 
 * @see y2ssh.dlc.chp2.dao.CommonDAO#del(java.lang.Class,
 * java.io.Serializable)
 */
public void del(Class clazz, Serializable id) {
    super.getHibernateTemplate().delete(this.get(clazz, id));
}

/*
 * （非 Javadoc）
 * 
 * @see y2ssh.dlc.chp2.dao.CommonDAO#update(java.lang.Object)
 */
public void update(Object o) {
    super.getHibernateTemplate().update(o);
}

/*
 * （非 Javadoc）
 * 
 * @see y2ssh.dlc.chp2.dao.CommonDAO#search(java.lang.String)
 */
public List list(String hql) {
    List ret = super.getHibernateTemplate().find(hql);
    return ret;
}
public List listOrderBy(String hql)
{
    List ret = super.getHibernateTemplate().find(hql);
    return ret;
}
/*
 * （非 Javadoc）
 * 
 * @see org.jb.common.dao.CommonDAO#listByPage(java.lang.String,
 * org.jb.common.util.PageResult)
 */
@SuppressWarnings("unchecked")
public void listByPage(String hql, PageResult pageResult) {
    if (null == hql) {
        return;
    }
    Query query = this.getSession().createQuery(hql);
    query.setFirstResult(pageResult.getFirstRec());
    query.setMaxResults(pageResult.getPageSize());
    List ret = query.list();
    pageResult.setList(ret);

    String queryString = "";
    if (hql.toUpperCase().indexOf("SELECT") != -1) {
        int i = query.getQueryString().toUpperCase().indexOf("FROM");
        queryString = "Select count(*) " + hql.substring(i, hql.length());
    } else {
        queryString = "Select count(*) " + hql;
    }
    // 去掉ORDER BY 的部分
    int j = queryString.toUpperCase().lastIndexOf("ORDER");
    if (j != -1) {
        queryString = queryString.substring(0, j);
    }
    Query cquery = this.getSession().createQuery(queryString);
    cquery.setCacheable(true);

    if(cquery.iterate().hasNext()){
    int recTotal = ((Integer) cquery.iterate().next()).intValue();
    pageResult.setRecTotal(recTotal);
    }
}

@SuppressWarnings("unchecked")
public List<SalaryStandard> getStandards(final Date beginTime,
        final Date endTime, final SalaryStandard standard) {
    List<SalaryStandard> list = super.getHibernateTemplate().executeFind(
            new HibernateCallback() {
                public Object doInHibernate(Session s)
                        throws HibernateException {
                    Criteria c = s.createCriteria(SalaryStandard.class);
                    if (standard.getStandardId() != null && standard.getStandardId()!="") {
                        c.add(Restrictions.like("standardId", standard
                                .getStandardId(), MatchMode.ANYWHERE));
                    }
                    if (standard.getDesigner() != null && standard.getDesigner()!="") {
                        c.add(Restrictions.like("designer", standard
                                .getDesigner(), MatchMode.ANYWHERE));

                    }
                    if (beginTime != null) {
                        c.add(Restrictions.ge("registTime", beginTime));
                    }
                    if (endTime != null) {
                        c.add(Restrictions.le("registTime", endTime));
                    }
                    return c.list();
                }
            });
    return list;
}


}</pre>