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

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

49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
    try {
      session = openSession();

      String sql = CustomSQLUtil.get(COUNT_BY_G1_G2_U1_U2);

      SQLQuery q = session.createSQLQuery(sql);

      q.addScalar(COUNT_COLUMN_NAME, Type.LONG);

      QueryPos qPos = QueryPos.getInstance(q);

      qPos.add(groupId1);
      qPos.add(groupId2);
      qPos.add(userId1);
      qPos.add(userId2);

      Iterator<Long> itr = q.list().iterator();

      if (itr.hasNext()) {
        Long count = itr.next();

        if (count != null) {
View Full Code Here
92
93
94
95
96
97
98
99
100
101
102
103
104
    try {
      session = openSession();

      String sql = CustomSQLUtil.get(FIND_BY_G1_G2_U1_U2);

      SQLQuery q = session.createSQLQuery(sql);

      q.addEntity("SN_WallEntry", WallEntryImpl.class);

      QueryPos qPos = QueryPos.getInstance(q);

      qPos.add(groupId1);
      qPos.add(groupId2);
View Full Code Here
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
        connectionManager.closeConnection(connection);
    }

    public void executeUpdate(DBConnection dbConnection, String sql, List params, Map<String, Object> options) throws DBException {
        Session session = (Session) dbConnection.getNativeConnection();
        SQLQuery query = null;

        try {
            query = session.createSQLQuery(sql);
            QueryPos qpos = QueryPos.getInstance(query);
            for (Object item: params) {
                qpos.add(item);
            }
            log.debug(sql + "\n" + params);
            query.executeUpdate();
        } catch (Exception e) {
            throw new DBException(e);
        } finally {
            closeConnection(dbConnection);
        }
View Full Code Here
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
    }

    public List executeQuery(DBConnection dbConnection, String sql, List params,  LinkedHashMap<String, Integer> types) throws DBException {
        List items = new ArrayList();
        Session session = (Session) dbConnection.getNativeConnection();
        SQLQuery query = null;

        try {
            query = session.createSQLQuery(sql);
            QueryPos qpos = QueryPos.getInstance(query);
            for (Object item: params) {
                qpos.add(item);
            }
            log.debug(sql + "\n" + params);
            items = query.list();
//            for (Object item : items) {
//                if (item != null) {
//                    if (item.getClass().isArray()) {
//                        for (Object value : (Object[]) item) {
//                            System.out.println("1111111111 :" + value + " ;;;; type : " + (value != null ? value.getClass() : null));
View Full Code Here
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
        try {
            session = openSession();
            String qString = "SELECT Transaction.id, Book.id, Book.title, max(Transaction.id) AS max_Transaction__id FROM Transaction  RIGHT JOIN Book  ON Book.id = Transaction.bookId  GROUP BY Book.title";
//            String qString = "SELECT Transaction.id, Book.id, Book.title FROM Transaction  RIGHT JOIN Book  ON Book.id = Transaction.bookId";
            SQLQuery query = session.createSQLQuery(qString, true);
            query.addScalar("Book.id", Type.LONG);
            query.addScalar("Transaction.id", Type.LONG);
            query.addScalar("Book.title", Type.STRING);
            query.addScalar("max_Transaction__id", Type.LONG);
            System.out.println(qString);
            result = (List<Long>) QueryUtil.list(query, getDialect(), -1, -1);
        } catch (Exception e) {
            throw new SystemException(e);
        } finally {
View Full Code Here
27
28
29
30
31
32
33
34
35
36
37
38
39
    try {
      session = openSession();

      String sql = CustomSQLUtil.get(FIND_BY_EVENTNAME_EVENTDESCRIPTON_LOCATIONNAME);

      SQLQuery q = session.createSQLQuery(sql);
      q.setCacheable(false);
      q.addEntity("Event_Event", EventImpl.class);

      QueryPos qPos = QueryPos.getInstance(q);
      qPos.add(eventName);
      qPos.add(eventDescription);
      qPos.add(locationName);
View Full Code Here
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
    Session session = null;

    try {
      session = openSession();

      SQLQuery q = session.createSQLQuery(sql);

      if (getDB().isSupportsInlineDistinct()) {
        q.addEntity(_FILTER_ENTITY_ALIAS, EventImpl.class);
      }
      else {
        q.addEntity(_FILTER_ENTITY_TABLE, EventImpl.class);
      }

      QueryPos qPos = QueryPos.getInstance(q);

      qPos.add(groupId);
View Full Code Here
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
    String sql = InlineSQLHelperUtil.replacePermissionCheck(query.toString(),
        Event.class.getName(), _FILTER_ENTITY_TABLE_FILTER_PK_COLUMN,
        groupId);

    SQLQuery q = session.createSQLQuery(sql);

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

    if (getDB().isSupportsInlineDistinct()) {
      q.addEntity(_FILTER_ENTITY_ALIAS, EventImpl.class);
    }
    else {
      q.addEntity(_FILTER_ENTITY_TABLE, EventImpl.class);
    }

    QueryPos qPos = QueryPos.getInstance(q);

    qPos.add(groupId);

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

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

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

    if (list.size() == 2) {
      return list.get(1);
    }
    else {
View Full Code Here
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
    Session session = null;

    try {
      session = openSession();

      SQLQuery q = session.createSQLQuery(sql);

      q.addScalar(COUNT_COLUMN_NAME,
        com.liferay.portal.kernel.dao.orm.Type.LONG);

      QueryPos qPos = QueryPos.getInstance(q);

      qPos.add(groupId);

      Long count = (Long)q.uniqueResult();

      return count.intValue();
    }
    catch (Exception e) {
      throw processException(e);
View Full Code Here
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
    Session session = null;

    try {
      session = openSession();

      SQLQuery q = session.createSQLQuery(sql);

      if (getDB().isSupportsInlineDistinct()) {
        q.addEntity(_FILTER_ENTITY_ALIAS, LocationImpl.class);
      }
      else {
        q.addEntity(_FILTER_ENTITY_TABLE, LocationImpl.class);
      }

      QueryPos qPos = QueryPos.getInstance(q);

      qPos.add(groupId);
View Full Code Here
TOP

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

  • com.jengine.orm.db.adapter.liferay.LiferayAdapter
  • com.jenginetest.builder.service.persistence.TestFinderImpl
  • com.liferay.docs.guestbook.service.persistence.EntryPersistenceImpl
  • com.liferay.docs.guestbook.service.persistence.GuestbookPersistenceImpl
  • com.liferay.socialnetworking.service.persistence.WallEntryFinderImpl
  • com.nosester.portlet.eventlisting.service.persistence.EventFinderImpl
  • com.nosester.portlet.eventlisting.service.persistence.EventPersistenceImpl
  • com.nosester.portlet.eventlisting.service.persistence.LocationPersistenceImpl
  • com.samples.portlet.eventlisting.service.persistence.EventFinderImpl
  • com.samples.portlet.eventlisting.service.persistence.EventPersistenceImpl
    • 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.