Examples of org.hibernate.Query

org.hibernate.Query
An object-oriented representation of a Hibernate query. A Query instance is obtained by calling Session.createQuery(). This interface exposes some extra functionality beyond that provided by Session.iterate() and Session.find():
- a particular page of the result set may be selected by calling setMaxResults(), setFirstResult()
- named query parameters may be used
- the results may be returned as an instance of ScrollableResults
Named query parameters are tokens of the form :name in the query string. A value is bound to the integer parameter :foo by calling

setParameter("foo", foo, Hibernate.INTEGER);

for example. A name may appear multiple times in the query string.

JDBC-style ? parameters are also supported. To bind a value to a JDBC-style parameter use a set method that accepts an int positional argument (numbered from zero, contrary to JDBC).

You may not mix and match JDBC-style parameters and named parameters in the same query.

Queries are executed by calling list(), scroll() or iterate(). A query may be re-executed by subsequent invocations. Its lifespan is, however, bounded by the lifespan of the Session that created it.

Implementors are not intended to be threadsafe. @see org.hibernate.Session#createQuery(java.lang.String) @see org.hibernate.ScrollableResults @author Gavin King

   * @param parameters
   * @return
   */
  private List doDynamicQuery(final Pagination pagination,
      final Map parameters, final int scope) {
    Query query = null;


    // 是否需要分页
    final boolean needToPage = pagination != null;
    int recordAmount = 0;
    if (needToPage) {// 初始化分页信息
      // 构造动态查询的统计SQL语句
      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));


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


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


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


    // 返回查询结果
    if (needToPage) {
      Page<E> page = null;
      if (recordAmount == 0) {

View Full Code Here

      super();
    }


    private static Query buildHibernateQuery(org.beangle.model.query.Query<?> bquery,
        final Session hibernateSession) {
      Query hibernateQuery = null;
      if (bquery.getLang().equals(org.beangle.model.query.Lang.HQL)) {
        hibernateQuery = hibernateSession.createQuery(bquery.getStatement());
      } else {
        hibernateQuery = hibernateSession.createSQLQuery(bquery.getStatement());
      }
      if (bquery.isCacheable()) {
        hibernateQuery.setCacheable(bquery.isCacheable());
      }
      setParameter(hibernateQuery, bquery.getParams());
      return hibernateQuery;
    }

View Full Code Here

     */
    public static int count(final org.beangle.model.query.LimitQuery<?> limitQuery,
        final Session hibernateSession) {
      final org.beangle.model.query.Query<?> cntQuery = limitQuery.getCountQuery();
      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

    @SuppressWarnings("unchecked")
    public static <T> List<T> find(final org.beangle.model.query.Query<T> query,
        final Session hibernateSession) {
      if (query instanceof LimitQuery<?>) {
        LimitQuery<T> limitQuery = (LimitQuery<T>) query;
        Query hibernateQuery = buildHibernateQuery(limitQuery, hibernateSession);
        if (null == limitQuery.getLimit()) {
          return hibernateQuery.list();
        } else {
          final PageLimit limit = limitQuery.getLimit();
          hibernateQuery.setFirstResult((limit.getPageNo() - 1) * limit.getPageSize())
              .setMaxResults(limit.getPageSize());
          return hibernateQuery.list();
        }
      } else {
        return buildHibernateQuery(query, hibernateSession).list();
      }
    }

View Full Code Here

    query.setFirstResult((limit.getPageNo() - 1) * limit.getPageSize())
        .setMaxResults(limit.getPageSize());
    List<T> targetList = query.list();


    String queryStr = buildCountQueryStr(query);
    Query countQuery = null;
    if (query instanceof SQLQuery) {
      countQuery = getSession().createSQLQuery(queryStr);
    } else {
      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

  public <T> T get(String entityName, Serializable id) {
    if (StringUtils.contains(entityName, '.')) {
      return (T) getHibernateTemplate().get(entityName, id);
    } else {
      String hql = "from " + entityName + " where id =:id";
      Query query = getSession().createQuery(hql);
      query.setParameter("id", id);
      List<?> rs = query.list();
      if (rs.isEmpty()) {
        return null;
      } else {
        return (T) rs.get(0);
      }

View Full Code Here

  }


  @SuppressWarnings("unchecked")
  public <T> List<T> getAll(Class<T> clazz) {
    String hql = "from " + Model.getEntityType(clazz).getEntityName();
    Query query = getSession().createQuery(hql);
    query.setCacheable(true);
    return query.list();
  }

View Full Code Here

    }
  }


  @SuppressWarnings("unchecked")
  public <T> List<T> searchNamedQuery(final String queryName, final Map<String, Object> params) {
    Query query = this.getSession().getNamedQuery(queryName);
    return QuerySupport.setParameter(query, params).list();
  }

View Full Code Here

  }


  @SuppressWarnings("unchecked")
  public <T> List<T> searchNamedQuery(final String queryName, final Map<String, Object> params,
      boolean cacheable) {
    Query query = getSession().getNamedQuery(queryName);
    query.setCacheable(cacheable);
    return QuerySupport.setParameter(query, params).list();
  }

View Full Code Here

    return QuerySupport.setParameter(query, params).list();
  }


  @SuppressWarnings("unchecked")
  public <T> List<T> searchNamedQuery(String queryName, Object... params) {
    Query query = getSession().getNamedQuery(queryName);
    return QuerySupport.setParameter(query, params).list();
  }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.hibernate.Query

br.com.buyFast.integration.dao.daoImpl.GenericDaoImpl

br.gov.serpro.ouvidoria.dao.hibernate.HibernateDao

com.architecture.core.dao.BaseDAO

com.github.dactiv.orm.core.hibernate.support.BasicHibernateDao

com.github.dactiv.orm.core.hibernate.support.HibernateSupportDao

com.hdfs.file.daoImpl.fileImpl

com.hdfs.user.daoImpl.userImpl

com.mustafaiev.tair.cts.dao.jpa.PayerDAO

com.tap5.hotelbooking.dal.HibernateCrudServiceDAO

com.tumivn.sample.business.entities.repositories.BookRepositoryImpl

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.