Package com.liferay.portal.kernel.dao.orm

Examples of com.liferay.portal.kernel.dao.orm.Query


      Session session = null;

      try {
        session = openSession();

        Query q = session.createQuery(_SQL_COUNT_WALLENTRY);

        count = (Long)q.uniqueResult();
      }
      catch (Exception e) {
        throw processException(e);
      }
      finally {
View Full Code Here


          query.append(MeetupsEntryModelImpl.ORDER_BY_JPQL);
        }

        String sql = query.toString();

        Query q = session.createQuery(sql);

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(companyId);
View Full Code Here

      query.append(MeetupsEntryModelImpl.ORDER_BY_JPQL);
    }

    String sql = query.toString();

    Query q = session.createQuery(sql);

    q.setFirstResult(0);
    q.setMaxResults(2);

    QueryPos qPos = QueryPos.getInstance(q);

    qPos.add(companyId);

    if (orderByComparator != null) {
      Object[] values = orderByComparator.getOrderByValues(meetupsEntry);

      for (Object value : values) {
        qPos.add(value);
      }
    }

    List<MeetupsEntry> list = q.list();

    if (list.size() == 2) {
      return list.get(1);
    }
    else {
View Full Code Here

          query.append(MeetupsEntryModelImpl.ORDER_BY_JPQL);
        }

        String sql = query.toString();

        Query q = session.createQuery(sql);

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(userId);
View Full Code Here

      query.append(MeetupsEntryModelImpl.ORDER_BY_JPQL);
    }

    String sql = query.toString();

    Query q = session.createQuery(sql);

    q.setFirstResult(0);
    q.setMaxResults(2);

    QueryPos qPos = QueryPos.getInstance(q);

    qPos.add(userId);

    if (orderByComparator != null) {
      Object[] values = orderByComparator.getOrderByValues(meetupsEntry);

      for (Object value : values) {
        qPos.add(value);
      }
    }

    List<MeetupsEntry> list = q.list();

    if (list.size() == 2) {
      return list.get(1);
    }
    else {
View Full Code Here

        }
        else {
          sql = _SQL_SELECT_MEETUPSENTRY.concat(MeetupsEntryModelImpl.ORDER_BY_JPQL);
        }

        Query q = session.createQuery(sql);

        if (orderByComparator == null) {
          list = (List<MeetupsEntry>)QueryUtil.list(q, getDialect(),
              start, end, false);
View Full Code Here

        query.append(_FINDER_COLUMN_COMPANYID_COMPANYID_2);

        String sql = query.toString();

        Query q = session.createQuery(sql);

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(companyId);

        count = (Long)q.uniqueResult();
      }
      catch (Exception e) {
        throw processException(e);
      }
      finally {
View Full Code Here

        query.append(_FINDER_COLUMN_USERID_USERID_2);

        String sql = query.toString();

        Query q = session.createQuery(sql);

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(userId);

        count = (Long)q.uniqueResult();
      }
      catch (Exception e) {
        throw processException(e);
      }
      finally {
View Full Code Here

      Session session = null;

      try {
        session = openSession();

        Query q = session.createQuery(_SQL_COUNT_MEETUPSENTRY);

        count = (Long)q.uniqueResult();
      }
      catch (Exception e) {
        throw processException(e);
      }
      finally {
View Full Code Here

          query.append(MeetupsRegistrationModelImpl.ORDER_BY_JPQL);
        }

        String sql = query.toString();

        Query q = session.createQuery(sql);

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(meetupsEntryId);
View Full Code Here

TOP

Related Classes of com.liferay.portal.kernel.dao.orm.Query

Copyright © 2018 www.massapicom. All rights reserved.
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.