Examples of org.hibernate.Query.uniqueResult()

org.hibernate.Query.uniqueResult()
Convenience method to return a single instance that matches the query, or null if the query returns no results. @return the single result or null @throws NonUniqueResultException if there is more than one matching result

    Query q = ssn.createQuery(hql.toString());
    q.setInteger(0, sid);
    if(album_id > 0)
      q.setInteger(1, album_id);
    try{
      Number size = (Number)q.uniqueResult();
      return (size!=null)?size.intValue():0;
    }finally{
      hql = null;
    }
  }

View Full Code Here

    if(month >= 190001 && month <= 209912){
      q.setInteger("year", month / 100);
      q.setInteger("month", month % 100);
    }
    try{
      Number size = (Number)q.uniqueResult();
      return (size!=null)?size.intValue():0;
    }finally{
      hql = null;
    }
  }

View Full Code Here

  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.uniqueResult();
    if (result instanceof BigInteger) {
      return ((BigInteger) result).longValue();
    } else {
      return ((Long) result).longValue();
    }

View Full Code Here

  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.uniqueResult();
    if (result instanceof BigInteger) {
      return ((BigInteger) result).longValue();
    } else {
      return ((Long) result).longValue();
    }

View Full Code Here

      final Map<String, Object> parameters) {
    final Query query = this.createQuery(this.getFullQueryName(qname,
        BaseEntityManager.LOAD_SUFFIX));
    this.fittingQuery(query, parameters);
    try {
      return (E) query.uniqueResult();
    } catch (Exception e) {
      return null;
    }
  }

View Full Code Here

  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.uniqueResult();
    } catch (Exception e) {
      return null;
    }
  }

View Full Code Here

      query = this.session.createQuery(this.buildDynamicSQL(parameters,
          true, scope));
      // 处理参数
      this.fittingQuery(query, parameters);
      // 获取记录总数
      recordAmount = Integer.parseInt(query.uniqueResult().toString());
    }


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

View Full Code Here

      if (null == cntQuery) {
        Query hibernateQuery = buildHibernateQuery(limitQuery, hibernateSession);
        return hibernateQuery.list().size();
      } else {
        Query hibernateQuery = buildHibernateQuery(cntQuery, hibernateSession);
        final Number count = (Number) (hibernateQuery.uniqueResult());
        if (null == count) {
          return 0;
        } else {
          return count.intValue();
        }

View Full Code Here

      countQuery = getSession().createQuery(queryStr);
    }
    QuerySupport.setParameter(countQuery, params);
    // 返回结果
    return new SinglePage<T>(limit.getPageNo(), limit.getPageSize(),
        ((Number) (countQuery.uniqueResult())).intValue(), targetList);
  }


  /**
   * 构造查询记录数目的查询字符串
   *

View Full Code Here

      countQuery = getSession().createQuery(queryStr);
    }
    QuerySupport.setParameter(countQuery, params);
    // 返回结果
    return new SinglePage<T>(limit.getPageNo(), limit.getPageSize(),
        ((Number) (countQuery.uniqueResult())).intValue(), targetList);
  }


  public void saveOrUpdate(Object... entities) {
    if (null == entities) return;
    for (Object entity : entities) {

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

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.