package com.laoer.bbscs.dao.hibernate;

import org.springframework.orm.hibernate.support.HibernateDaoSupport;
import com.laoer.bbscs.dao.IVoteItemDAO;
import com.laoer.bbscs.bean.VoteItem;
import org.springframework.dao.*;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import java.util.*;

/**
 * <p>Title: TianYi BBS</p>
 * <p>Description: TianYi BBS System</p>
 * <p>Copyright: Copyright (c) 2004</p>
 * <p>Company: LAOER.COM/TIANYISOFT.NET</p>
 * @author laoer
 * @version 6.0
 */

public class VoteItemHibernateDAO
    extends HibernateDaoSupport
    implements IVoteItemDAO {

  private static final Log logger = LogFactory.getLog(VoteItemHibernateDAO.class);

  private static final String LOAD_BY_VOTEID =
      "from VoteItem vi where vi.voteID = ? order by vi.id";

  public VoteItemHibernateDAO() {
    super();
  }

  /**
   *
   * @param vi VoteItem
   * @return VoteItem
   * @todo Implement this com.laoer.bbscs.dao.IVoteItemDAO method
   */
  public VoteItem saveVoteItem(VoteItem vi) {
    try {
      this.getHibernateTemplate().saveOrUpdate(vi);
      return vi;
    }
    catch (DataAccessException ex) {
      logger.error(ex);
      return null;
    }
  }

  /**
   *
   * @param id long
   * @return VoteItem
   * @todo Implement this com.laoer.bbscs.dao.IVoteItemDAO method
   */
  public VoteItem getVoteItem(long id) {
    try {
      return (VoteItem)this.getHibernateTemplate().get(VoteItem.class,
          new Long(id));
    }
    catch (DataAccessException ex) {
      logger.error(ex);
      return null;
    }
  }

  public List findVoteItemByVoteID(long voteID) {
    return getHibernateTemplate().find(LOAD_BY_VOTEID, new Long(voteID));
  }

}