Examples of net.sf.hibernate.Query

net.sf.hibernate.Query

   */
  public List getMostRecent(final int count) {
    return (List) getHibernateTemplate().execute(new HibernateCallback() {


      public Object doInHibernate(Session session) throws HibernateException, SQLException {
        Query query = session.createQuery("from Entry");
        query.setMaxResults(count);
        return query.list();
      }
      
    });
  }

View Full Code Here

      }
      if (LOGGER.isDebugEnabled())
      {
         LOGGER.debug("The final query is " + hql);
      }
      Query query = session.createQuery(hql.toString());
      // Now set all the patameters on the statement.


      if (setters == null)
      {
         for (Iterator keys = arguments.keySet().iterator(); keys.hasNext();)
         {
            String key = (String) keys.next();
            Object value = arguments.get(key);
            if (value instanceof List)
            {
               if (LOGGER.isDebugEnabled())
               {
                  LOGGER.debug("Setting a paremeterList to the query.");
               }
               query.setParameterList(key, ((List) value).toArray());
            }
            else
            {
               if (LOGGER.isDebugEnabled())
               {

View Full Code Here

                            hql += " order by " + order;
                        }
                    } else {
                        hql = getBodyContent().getString();
                    }
                    Query query = session.createQuery(hql);
                    objects = bindParametersAndExecute(query);
                } else {
                    objects = new ArrayList();
                    String[] queryNames = qname.split(",");
                    for (int i = 0; i < queryNames.length; i++) {

View Full Code Here

      }


      Session session = SessionFactoryUtils.getSession(getSessionFactory(), allowCreate);
      try
      {
         Query query;


         boolean doFocus = ((getAdapterType() & DO_FOCUS) == 0) && info.isFocusEnabled() && info.isDoFocus() && (namedQuery == null);


         if (doFocus)
         {
            if (LOGGER.isDebugEnabled())
            {
               LOGGER.debug("Start to focusing adapterName '" + name + "', ValueListInfo info = " + info + "'");
            }
            ScrollableResults results = getScrollableResults(getQueryForFocus(info, session), info);
            results.beforeFirst();
            doFocusFor(info, results);


            if (LOGGER.isDebugEnabled())
            {
               LOGGER.debug("Focusing finished for adapterName '" + name + "', ValueListInfo info '" + info + "'");
            }
         }


         query = getQuery(info, session);


         boolean doPaging = ((getAdapterType() & DO_PAGE) == 0);


         List list;


         if (doPaging)
         {
            if (LOGGER.isDebugEnabled())
            {
               LOGGER.debug("getValueList(String adapterName = " + name + ", ValueListInfo info = " + info
                     + ") - Start to paging result set");
            }


            list = new ArrayList(numberPerPage);
            ScrollableResults results = getScrollableResults(query, info);


            results.last();
            int lastRowNumber = results.getRowNumber();
            info.setTotalNumberOfEntries(lastRowNumber + 1);


            if (numberPerPage == 0)
            {
               numberPerPage = getDefaultNumberPerPage();
            }


            int pageNumber = info.getPagingPage();
            boolean isResult;
            if (pageNumber > 1)
            {
               if ((pageNumber - 1) * numberPerPage > lastRowNumber)
               {
                  pageNumber = (lastRowNumber / numberPerPage) + 1;
                  info.setPagingPage(pageNumber);
               }
            }
            if (pageNumber > 1)
            {
               isResult = results.scroll((pageNumber - 1) * numberPerPage - lastRowNumber);
            }
            else
            {
               isResult = results.first();
            }


            for (int i = 0; i < numberPerPage && isResult; i++)
            {
               list.add(results.get(0));
               isResult = results.next();
            }


            LOGGER.debug("Sorting finished.");


         }
         else
         {


            LOGGER.debug("Retrieving a list directly from the query.");


            list = query.list();
            info.setTotalNumberOfEntries(list.size());
         }


         ValueList returnValueList = getListBackedValueList(info, list);
         if (LOGGER.isDebugEnabled())

View Full Code Here

0 1

TOP

Related Classes of net.sf.hibernate.Query

au.edu.qut.yawl.engine.YEngine

au.edu.qut.yawl.logging.YawlLogServletInterface

com.apress.prospring.data.hibernate.HibernateEntryDao

net.mlw.vlh.adapter.hibernate.Hibernate20Adapter

net.mlw.vlh.adapter.hibernate.util.StatementBuilder

org.nxplanner.tags.db.UseBeansTag

org.springframework.orm.hibernate.HibernateTemplate

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.