Package javax.persistence

Examples of javax.persistence.Query

54
55
56
57
58
59
60
61
62
63
64
65
66
67
   * org.jrest4guice.persistence.jpa.BaseEntityManager#countByNamedQuery(java
   * .lang.String, java.util.Map)
   */
  public long count(final String qname,
      final Map<String, Object> parameters) {
    final Query query = this.createQuery(this.getFullQueryName(qname,
        BaseEntityManager.COUNT_SUFFIX));
    this.fittingQuery(query, parameters);
    final Object result = query.getSingleResult();
    if (result instanceof BigInteger) {
      return ((BigInteger) result).longValue();
    } else {
      return ((Long) result).longValue();
    }
View Full Code Here
74
75
76
77
78
79
80
81
82
83
84
85
86
87
   * org.jrest4guice.persistence.jpa.BaseEntityManager#countByNamedQuery(java
   * .lang.String, java.lang.Object)
   */
  public long count(final String qname,
      final Object... parameters) {
    final Query query = this.createQuery(this.getFullQueryName(qname,
        BaseEntityManager.COUNT_SUFFIX));
    this.fittingQuery(query, parameters);
    final Object result = query.getSingleResult();
    if (result instanceof BigInteger) {
      return ((BigInteger) result).longValue();
    } else {
      return ((Long) result).longValue();
    }
View Full Code Here
186
187
188
189
190
191
192
193
194
195
   * org.jrest4guice.persistence.jpa.BaseEntityManager#listByNamedQuery(java
   * .lang.String, java.util.Map)
   */
  public List<E> list(final String qname,
      final Map<String, Object> parameters) {
    final Query query = this.createQuery(this.getFullQueryName(qname,
        BaseEntityManager.FIND_SUFFIX));
    this.fittingQuery(query, parameters);
    return query.getResultList();
  }
View Full Code Here
201
202
203
204
205
206
207
208
209
210
   * org.jrest4guice.persistence.jpa.BaseEntityManager#listByNamedQuery(java
   * .lang.String, java.lang.Object)
   */
  public List<E> list(final String qname,
      final Object... parameters) {
    final Query query = this.createQuery(this.getFullQueryName(qname,
        BaseEntityManager.FIND_SUFFIX));
    this.fittingQuery(query, parameters);
    return query.getResultList();
  }
View Full Code Here
217
218
219
220
221
222
223
224
225
226
227
   * .lang.String, org.jrest4guice.client.Pagination, java.util.Map)
   */
  public List<E> list(final String qname,
      final Pagination pagination,
      final Map<String, Object> parameters) {
    final Query query = this.createQuery(this.getFullQueryName(qname,
        BaseEntityManager.FIND_SUFFIX));
    this.fittingQuery(query, parameters);
    this.pagingQuery(query, pagination);
    return query.getResultList();
  }
View Full Code Here
233
234
235
236
237
238
239
240
241
242
243
   * org.jrest4guice.persistence.jpa.BaseEntityManager#listByNamedQuery(java
   * .lang.String, org.jrest4guice.client.Pagination, java.lang.Object)
   */
  public List<E> list(final String qname,
      final Pagination pagination, final Object... parameters) {
    final Query query = this.createQuery(this.getFullQueryName(qname,
        BaseEntityManager.FIND_SUFFIX));
    this.fittingQuery(query, parameters);
    this.pagingQuery(query, pagination);
    return query.getResultList();
  }
View Full Code Here
267
268
269
270
271
272
273
274
275
276
277
278
279
280
   * org.jrest4guice.persistence.jpa.BaseEntityManager#loadByNamedQuery(java
   * .lang.String, java.util.Map)
   */
  public E load(final String qname,
      final Map<String, Object> parameters) {
    final Query query = this.createQuery(this.getFullQueryName(qname,
        BaseEntityManager.LOAD_SUFFIX));
    this.fittingQuery(query, parameters);
    try {
      return (E) query.getSingleResult();
    } catch (Exception e) {
      return null;
    }
  }
View Full Code Here
285
286
287
288
289
290
291
292
293
294
295
296
297
298
   * @see
   * org.jrest4guice.persistence.jpa.BaseEntityManager#loadByNamedQuery(java
   * .lang.String, java.lang.Object)
   */
  public E load(final String qname, final Object... parameters) {
    final Query query = this.createQuery(this.getFullQueryName(qname,
        BaseEntityManager.LOAD_SUFFIX));
    this.fittingQuery(query, parameters);
    try {
      return (E) query.getSingleResult();
    } catch (Exception e) {
      return null;
    }
  }
View Full Code Here
555
556
557
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
588
589
590
591
592
593
   * @return
   */
  private List doDynamicQuery(final Pagination pagination,
      final Map parameters, final int scope) {
    try {
      Query query = null;

      // 是否需要分页
      final boolean needToPage = pagination != null;
      int recordAmount = 0;
      if (needToPage) {// 初始化分页信息
        // 构造动态查询的统计SQL语句
        query = this.em.createQuery(this.buildDynamicSQL(parameters, true,
            scope));
        // 处理参数
        this.fittingQuery(query, parameters);
        // 获取记录总数
        recordAmount = Integer.parseInt(query.getSingleResult().toString());
      }

      // 构造动态查询的统计SQL语句
      query = this.em.createQuery(this.buildDynamicSQL(parameters, false,
          scope));

      // 数据分页处理
      if (needToPage) {
        this.pagingQuery(query, pagination);
      }

      // 处理参数
      this.fittingQuery(query, parameters);

      // 获取查询结果
      final List result = query.getResultList();

      // 返回查询结果
      if (needToPage) {
        Page<E> page = null;
        if (recordAmount == 0) {
View Full Code Here
84
85
86
87
88
89
90
91
    }

    @SuppressWarnings("unchecked")
    @Transactional(propagation = Propagation.REQUIRED, readOnly = true)
    @Override public List<Role> findAuthorities() {
        Query query = entityManager.createQuery("SELECT r FROM " + roleClass.getSimpleName() + " r");
        return query.getResultList();
    }
View Full Code Here
TOP

Related Classes of javax.persistence.Query

  • $.IndexAndSearchTest
  • ch.hortis.sonar.core.MeasuresCalculatorJob
  • ch.hortis.sonar.core.MeasuresPurgeJob
  • com.dyuproject.ext.jpa.DefaultDao
  • com.emc.plants.service.impl.BackOrderStockBean
  • com.emc.plants.service.impl.CatalogBean
  • com.mobius.controllers.PatientController
  • com.mobius.controllers.PatientListController
  • com.mobius.controllers.TemplateController
  • com.oltpbenchmark.benchmarks.jpab.tests.Test
    • 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.