Package javax.persistence

Examples of javax.persistence.EntityManager.createQuery()

71
72
73
74
75
76
77
78
79
80
81
    try {
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session
          .createQuery("select c from States as c where c.state_id = :state_id AND c.deleted <> :deleted");
      query.setParameter("state_id", state_id);
      query.setParameter("deleted", "true");
      List ll = query.getResultList();
      tx.commit();
View Full Code Here
97
98
99
100
101
102
103
104
105
106
107
    try {
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session
          .createQuery("select c from States as c where c.deleted <> :deleted");
      query.setParameter("deleted", "true");
      List<States> ll = query.getResultList();
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
View Full Code Here
83
84
85
86
87
88
89
90
91
92
93
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session.createQuery(hql);
      query.setParameter("privateMessageFolderId", privateMessageFolderId);
     
      PrivateMessageFolder privateMessageFolder = null;
      try {
        privateMessageFolder = (PrivateMessageFolder) query.getSingleResult();
View Full Code Here
109
110
111
112
113
114
115
116
117
118
119
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session.createQuery(hql);
     
      List<PrivateMessageFolder> privateMessageFolders = query.getResultList();
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
     
View Full Code Here
155
156
157
158
159
160
161
162
163
164
165
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session.createQuery(hql);
      query.setParameter("userId", userId);
     
      List<PrivateMessageFolder> privateMessageFolders = query.getResultList();
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
View Full Code Here
415
416
417
418
419
420
421
422
423
424
425
      log.debug("checkUserMail: " + email);
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session.createQuery("select c from Adresses as c where c.email LIKE :email AND c.deleted <> :deleted");
      query.setParameter("email", email);
      query.setParameter("deleted", "true");
      int count = query.getResultList().size();
      log.debug("size: " + count);
      tx.commit();
View Full Code Here
99
100
101
102
103
104
105
106
107
108
109
     
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session.createQuery(hql);
     
      List<PrivateMessages> privateMessages = query.getResultList();
      tx.commit();
      PersistenceSessionUtil.closeSession(idf);
     
View Full Code Here
123
124
125
126
127
128
129
130
131
132
133
     
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session.createQuery(hql);
      query.setParameter("privateMessageId", privateMessageId);
     
      PrivateMessages privateMessage = null;
      try {
        privateMessage = (PrivateMessages) query.getSingleResult();
View Full Code Here
190
191
192
193
194
195
196
197
198
199
200
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session.createQuery(hql);
      query.setParameter("toUserId", toUserId);
      if (search.length() != 0) {
        query.setParameter("search", StringUtils.lowerCase("%"+search+"%"));
      }
      query.setParameter("privateMessageFolderId", privateMessageFolderId);
View Full Code Here
241
242
243
244
245
246
247
248
249
250
251
      Object idf = PersistenceSessionUtil.createSession();
      EntityManager session = PersistenceSessionUtil.getSession();
      EntityTransaction tx = session.getTransaction();
      tx.begin();
      Query query = session.createQuery(hql);
      query.setParameter("toUserId", toUserId);
      query.setParameter("isTrash", false);
      query.setParameter("privateMessageFolderId", privateMessageFolderId);
      if (search.length() != 0) {
        query.setParameter("search", StringUtils.lowerCase("%"+search+"%"));
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.