choicecategoryhibernatedao.java

一个jsp写的bbs

package com.laoer.bbscs.dao.hibernate;

import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import com.laoer.bbscs.dao.ChoiceCategoryDAO;
import com.laoer.bbscs.bean.ChoiceCategory;
import java.util.List;
import org.hibernate.criterion.Order;
import com.laoer.bbscs.bean.Forum;
import org.apache.commons.lang.StringUtils;
import org.hibernate.criterion.Restrictions;
import org.hibernate.Session;
import org.hibernate.Criteria;
import org.hibernate.HibernateException;
import com.laoer.bbscs.comm.Constant;
import org.springframework.orm.hibernate3.HibernateCallback;

/**
 * <p>Title: TianyiBBS</p>
 *
 * <p>Description: BBSCS</p>
 *
 * <p>Copyright: Copyright (c) 2006</p>
 *
 * <p>Company: Laoer.com</p>
 *
 * @author Laoer
 * @version 7.0
 */
public class ChoiceCategoryHibernateDAO
    extends HibernateDaoSupport implements ChoiceCategoryDAO {

  private static final String LOADS_BY_BID =
      "from ChoiceCategory where boardID = ? and useStat = ? order by orders";

  public ChoiceCategoryHibernateDAO() {
    super();
  }

  /**
   *
   * @param choiceCategory ChoiceCategory
   * @return ChoiceCategory
   * @todo Implement this com.laoer.bbscs.dao.ChoiceCategoryDAO method
   */
  public ChoiceCategory saveChoiceCategory(ChoiceCategory choiceCategory) {
    this.getHibernateTemplate().saveOrUpdate(choiceCategory);
    return choiceCategory;
  }

  /**
   *
   * @param id String
   * @return ChoiceCategory
   * @todo Implement this com.laoer.bbscs.dao.ChoiceCategoryDAO method
   */
  public ChoiceCategory findChoiceCategoryById(String id) {
    return (ChoiceCategory)this.getHibernateTemplate().get(ChoiceCategory.class, id);
  }

  /**
   *
   * @param bid long
   * @param usestat int
   * @return List
   * @todo Implement this com.laoer.bbscs.dao.ChoiceCategoryDAO method
   */
  public List findChoiceCategorysByBoardId(final long bid, final int usestat) {
    //Object[] o = {new Long(bid), new Integer(usestat)};
    //return this.getHibernateTemplate().find(LOADS_BY_BID, o);
    return getHibernateTemplate().executeFind(new HibernateCallback() {
      public Object doInHibernate(Session s) throws HibernateException {
        Criteria c = s.createCriteria(ChoiceCategory.class);
        c.add(Restrictions.eq("boardID", new Long(bid)));
        if (usestat != -1) {
          c.add(Restrictions.eq("useStat", new Integer(usestat)));
        }
        c.addOrder(Order.asc("orders"));
        return c.list();
      }
    });

  }

  /**
   *
   * @param choiceCategory ChoiceCategory
   * @todo Implement this com.laoer.bbscs.dao.ChoiceCategoryDAO method
   */
  public void removeChoiceCategory(ChoiceCategory choiceCategory) {
    this.getHibernateTemplate().delete(choiceCategory);
  }
}