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

   1 /**
   2  * Berlin Brown
   3  * Nov 9, 2006
   4  */
   5
   6 package org.spirit.dao.impl;
   7
   8 import java.util.Iterator;
   9 import java.util.List;
  10
  11 import org.hibernate.HibernateException;
  12 import org.hibernate.Query;
  13 import org.hibernate.Session;
  14 import org.spirit.bean.impl.BotListCatLinkGroups;
  15 import org.spirit.dao.BotListCatLinkGroupsDAO;
  16 import org.springframework.orm.hibernate3.HibernateCallback;
  17 import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
  18
  19 /**
  20  * This is class is used by botverse.
  21  *
  22  * @author Berlin Brown
  23  */
  24
  25 public class BotListCatLinkGroupsDAOImpl extends HibernateDaoSupport implements BotListCatLinkGroupsDAO {
  26
  27         /**
  28          * List the Entity Links including paging the results
  29          */
  30         public BotListCatLinkGroups readGroup(final String group) {
  31                 return (BotListCatLinkGroups) getHibernateTemplate().execute(
  32                                 new HibernateCallback() {
  33                                         public Object doInHibernate(Session session) throws HibernateException {
  34                                                 Query query = session.createQuery("from org.spirit.bean.impl.BotListCatLinkGroups groups where groups.categoryName = :group");
  35                                                 query.setMaxResults(1);
  36                                                 query.setString("group", group);
  37                                                 BotListCatLinkGroups groups = (BotListCatLinkGroups) query.uniqueResult();
  38                                                 if (groups != null) {
  39                                                         List list = groups.getTerms();
  40                                                         // Ensure lazy - load is initialized
  41                                                         for (Iterator it = list.iterator(); it.hasNext();) {
  42                                                                 it.next();
  43                                                         }
  44                                                 }
  45                                                 return groups;
  46                                         }
  47                                 });
  48         }
  49         public List readGroups() {
  50                 return getHibernateTemplate().executeFind(
  51                                 new HibernateCallback() {
  52                                         public Object doInHibernate(Session session) throws HibernateException {
  53                                                 Query query = session.createQuery("from org.spirit.bean.impl.BotListCatLinkGroups groups");
  54                                                 query.setMaxResults(100);
  55                                                 return query.list();
  56                                         }
  57                                 });
  58         }
  59
  60         public List listTerms(final BotListCatLinkGroups group) {
  61                 return getHibernateTemplate().executeFind(
  62                                 new HibernateCallback() {
  63                                         public Object doInHibernate(Session session) throws HibernateException {
  64                                                 Query query = session.createQuery("from org.spirit.bean.impl.BotListCatGroupTerms terms where terms.category_name = :group");
  65                                                 query.setParameter("group", group);
  66                                                 return query.list();
  67                                         }
  68                                 });
  69         }
  70
  71
  72 }