openbotlist/src/org/spirit/dao/impl/BotListAdminMainBannerDAOImpl.java

   1 /**
   2  * Berlin Brown
   3  * Nov 9, 2006
   4  */
   5
   6 package org.spirit.dao.impl;
   7
   8 import org.hibernate.HibernateException;
   9 import org.hibernate.Query;
  10 import org.hibernate.Session;
  11 import org.spirit.bean.impl.BotListAdminMainBanner;
  12 import org.spirit.dao.BotListAdminMainBannerDAO;
  13 import org.springframework.dao.DataAccessException;
  14 import org.springframework.orm.hibernate3.HibernateCallback;
  15 import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
  16
  17 /**
  18  * This is class is used by botverse.
  19  *
  20  * @author Berlin Brown
  21  *
  22  */
  23
  24 public class BotListAdminMainBannerDAOImpl extends HibernateDaoSupport implements BotListAdminMainBannerDAO {
  25
  26         /**
  27          * @see org.spirit.dao.BotListUserLinkDAO#createLink(org.spirit.bean.impl.BotListUserLink)
  28          */
  29         public void createBanner(BotListAdminMainBanner banner) {
  30                 getHibernateTemplate().save(banner);
  31         }
  32
  33         public BotListAdminMainBanner readBanner(final String section) throws DataAccessException {
  34                 return (BotListAdminMainBanner) getHibernateTemplate().execute(
  35                                 new HibernateCallback() {
  36                                         public Object doInHibernate(Session session) throws HibernateException {
  37                                                 //Query query = session.createQuery("from org.spirit.bean.impl.BotListAdminMainBanner banner where banner.section = :section and banner.enabled = 'Y'");
  38                                                 Query query = session.createQuery("from org.spirit.bean.impl.BotListAdminMainBanner banner order by banner.id desc");
  39                                                 //query.setString("section", section);
  40                                                 query.setMaxResults(1);
  41                                                 return query.uniqueResult();
  42                                         }
  43                                 });
  44         }
  45 }