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

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

558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
            query.append(LFCertificateCourseModelImpl.ORDER_BY_JPQL);
        }

        String sql = query.toString();

        Query q = session.createQuery(sql);

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

        QueryPos qPos = QueryPos.getInstance(q);

        if (certificateID != null) {
            qPos.add(certificateID.longValue());
        }

        if (orderByComparator != null) {
            Object[] values = orderByComparator.getOrderByConditionValues(lfCertificateCourse);

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

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

        if (list.size() == 2) {
            return list.get(1);
        } else {
            return null;
View Full Code Here
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
            Session session = null;

            try {
                session = openSession();

                Query q = session.createQuery(sql);

                QueryPos qPos = QueryPos.getInstance(q);

                if (certificateID != null) {
                    qPos.add(certificateID.longValue());
                }

                count = (Long) q.uniqueResult();

                FinderCacheUtil.putResult(finderPath, finderArgs, count);
            } catch (Exception e) {
                FinderCacheUtil.removeResult(finderPath, finderArgs);
View Full Code Here
770
771
772
773
774
775
776
777
778
779
780
            Session session = null;

            try {
                session = openSession();

                Query q = session.createQuery(sql);

                QueryPos qPos = QueryPos.getInstance(q);

                if (courseID != null) {
                    qPos.add(courseID.longValue());
View Full Code Here
1031
1032
1033
1034
1035
1036
1037
1038
1039
1040
1041
1042
1043
1044
1045
1046
1047
1048
1049
1050
1051
1052
1053
1054
1055
1056
1057
1058
1059
1060
            query.append(LFCertificateCourseModelImpl.ORDER_BY_JPQL);
        }

        String sql = query.toString();

        Query q = session.createQuery(sql);

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

        QueryPos qPos = QueryPos.getInstance(q);

        if (courseID != null) {
            qPos.add(courseID.longValue());
        }

        if (orderByComparator != null) {
            Object[] values = orderByComparator.getOrderByConditionValues(lfCertificateCourse);

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

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

        if (list.size() == 2) {
            return list.get(1);
        } else {
            return null;
View Full Code Here
1107
1108
1109
1110
1111
1112
1113
1114
1115
1116
1117
1118
1119
1120
1121
1122
1123
1124
1125
            Session session = null;

            try {
                session = openSession();

                Query q = session.createQuery(sql);

                QueryPos qPos = QueryPos.getInstance(q);

                if (courseID != null) {
                    qPos.add(courseID.longValue());
                }

                count = (Long) q.uniqueResult();

                FinderCacheUtil.putResult(finderPath, finderArgs, count);
            } catch (Exception e) {
                FinderCacheUtil.removeResult(finderPath, finderArgs);
View Full Code Here
1240
1241
1242
1243
1244
1245
1246
1247
1248
1249
1250
1251
1252
1253
1254
1255
1256
1257
1258
1259
1260
1261
1262
            Session session = null;

            try {
                session = openSession();

                Query q = session.createQuery(sql);

                QueryPos qPos = QueryPos.getInstance(q);

                if (certificateID != null) {
                    qPos.add(certificateID.longValue());
                }

                if (courseID != null) {
                    qPos.add(courseID.longValue());
                }

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

                if (list.isEmpty()) {
                    FinderCacheUtil.putResult(FINDER_PATH_FETCH_BY_CERTIFICATEIDANDCOURSEID,
                        finderArgs, list);
                } else {
View Full Code Here
1354
1355
1356
1357
1358
1359
1360
1361
1362
1363
1364
1365
1366
1367
1368
1369
1370
1371
1372
1373
1374
1375
1376
            Session session = null;

            try {
                session = openSession();

                Query q = session.createQuery(sql);

                QueryPos qPos = QueryPos.getInstance(q);

                if (certificateID != null) {
                    qPos.add(certificateID.longValue());
                }

                if (courseID != null) {
                    qPos.add(courseID.longValue());
                }

                count = (Long) q.uniqueResult();

                FinderCacheUtil.putResult(finderPath, finderArgs, count);
            } catch (Exception e) {
                FinderCacheUtil.removeResult(finderPath, finderArgs);
View Full Code Here
1922
1923
1924
1925
1926
1927
1928
1929
1930
1931
1932
            Session session = null;

            try {
                session = openSession();

                Query q = session.createQuery(sql);

                if (!pagination) {
                    list = (List<LFCertificateCourse>) QueryUtil.list(q,
                            getDialect(), start, end, false);
View Full Code Here
1980
1981
1982
1983
1984
1985
1986
1987
1988
1989
1990
1991
1992
            Session session = null;

            try {
                session = openSession();

                Query q = session.createQuery(_SQL_COUNT_LFCERTIFICATECOURSE);

                count = (Long) q.uniqueResult();

                FinderCacheUtil.putResult(FINDER_PATH_COUNT_ALL,
                    FINDER_ARGS_EMPTY, count);
            } catch (Exception e) {
                FinderCacheUtil.removeResult(FINDER_PATH_COUNT_ALL,
View Full Code Here
310
311
312
313
314
315
316
317
318
319
320
            Session session = null;

            try {
                session = openSession();

                Query q = session.createQuery(sql);

                QueryPos qPos = QueryPos.getInstance(q);

                if (certificateID != null) {
                    qPos.add(certificateID.intValue());
View Full Code Here
TOP

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

  • br.com.thiagomoreira.liferay.plugins.notfound.services.service.persistence.NotFoundPersistenceImpl
  • com.arcusys.learn.persistence.liferay.service.persistence.LFAchievementActivityPersistenceImpl
  • com.arcusys.learn.persistence.liferay.service.persistence.LFAchievementPersistenceImpl
  • com.arcusys.learn.persistence.liferay.service.persistence.LFAchievementUserPersistenceImpl
  • com.arcusys.learn.persistence.liferay.service.persistence.LFActivityDataMapPersistenceImpl
  • com.arcusys.learn.persistence.liferay.service.persistence.LFActivityPersistenceImpl
  • com.arcusys.learn.persistence.liferay.service.persistence.LFActivityStateNodePersistenceImpl
  • com.arcusys.learn.persistence.liferay.service.persistence.LFActivityStatePersistenceImpl
  • com.arcusys.learn.persistence.liferay.service.persistence.LFActivityStateTreePersistenceImpl
  • com.arcusys.learn.persistence.liferay.service.persistence.LFAnswerPersistenceImpl
    • 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.