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

    }
    hql.append("?)");
    Session ssn = getSession();
    try{
      beginTransaction();
      Query q = ssn.createQuery(hql.toString());
      q.setInteger(0, ownerId);
      int i=0;
      for(;i<bookmarkIds.length;i++){
        String s_id = (String)bookmarkIds[i];
        int id = -1;
        try{
          id = Integer.parseInt(s_id);
        }catch(Exception e){}
        q.setInteger(i+1, id);
      }
      q.setInteger(i+1, -1);
      int er = q.executeUpdate();
      commit();
      return er;
    }catch(HibernateException e){
      rollback();
      throw e;

View Full Code Here

  protected final static Log log = LogFactory.getLog(FindAction.class);


  @SuppressWarnings("unchecked")
  @Override
  public Object execute(Object[] parameters) {
    Query query = getQuery();
    QueryParameters queryPara = new QueryParameters(parameters, method.getParameterAnnotations());
    fittingQuery(query, queryPara);
    Find find = getAnnotation();
    if (!find.resultClass().equals(void.class))
      return toProjectionalList(find.resultClass(), query.list());
    return query.list();
  }

View Full Code Here

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

View Full Code Here

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

View Full Code Here

   * 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.list();
  }

View Full Code Here

   * 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.list();
  }

View Full Code Here

   * .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.list();
  }

View Full Code Here

   * 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.list();
  }

View Full Code Here

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

View Full Code Here

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

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.