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

    int i=0;
    for(;i<ids.size();i++){
      hql.append("?,");
    }
    hql.append("?) ORDER BY m.id DESC");      
    Query q = ssn.createQuery(hql.toString());
    for(i=0;i<ids.size();i++){
      int id = ((Number)ids.get(i)).intValue();
      q.setInteger(i, id);
    }
    q.setInteger(i, -1);
    return q.list();
  }

View Full Code Here

   * @param key
   * @return
   */
  public static List search(String key){
    Session ssn = getSession();
    Query q = ssn.getNamedQuery("SEARCH_MUSIC");
    String pattern = '%' + key + '%';
    q.setString("key", pattern);
    q.setMaxResults(20);
    List res = q.list();
    List songs = new ArrayList();
    for(int i=0;res!=null&&i<res.size();i++){
      Object[] objs = (Object[])res.get(i);
      MusicBean mbean = new MusicBean();
      mbean.setTitle((String)objs[0]);

View Full Code Here

        hql.append("?,");
        hql2.append("?,");
      }
      hql.append("?)");  
      hql2.append("?)");      
      Query q = ssn.createQuery(hql.toString());
      q.setInteger(0, siteid);
      i=0;
      for(;i<ids.length;i++){
        q.setInteger(i+1, ids[i]);
      }
      q.setInteger(i+1, ids[0]);
      List musics = q.list();
      if(musics.size()>0){
        beginTransaction();
        //����ռ��жԸ����ֵ�����
        Query q2 = ssn.createQuery(hql2.toString());
        i=0;
        q2.setParameter(0, null);
        for(;i<ids.length;i++){
          q2.setInteger(i+1, ids[i]);
        }
        q2.setInteger(i+1, ids[0]);
        q2.executeUpdate();
        //ɾ������
        for(i=0;i<musics.size();i++){
          MusicBean mbean = (MusicBean)musics.get(i);
          if(mbean.getMusicBox()!=null)
            mbean.getMusicBox().incMusicCount(-1);

View Full Code Here

      hql.append(" AND p.album.id=:album");
    }
    hql.append(" ORDER BY p.id DESC");
    Session ssn = getSession();
    try{
      Query q = ssn.createQuery(hql.toString());
      q.setInteger("photo_status", PhotoBean.STATUS_NORMAL);
      q.setInteger("site", site.getId());
      q.setInteger("photo", photo_id);
      if(album_id > 0)
        q.setInteger("album", album_id);
      if(!is_owner)
        q.setInteger("album_type", AlbumBean.TYPE_PUBLIC);      
      q.setMaxResults(1);
      return (PhotoOutlineBean)q.uniqueResult();
    }finally{
      hql = null;
    }
  }

View Full Code Here

      hql.append(" AND p.album.id=:album");
    }
    hql.append(" ORDER BY p.id ASC");
    Session ssn = getSession();
    try{
      Query q = ssn.createQuery(hql.toString());
      q.setInteger("photo_status", PhotoBean.STATUS_NORMAL);
      q.setInteger("site", site.getId());
      q.setInteger("photo", photo_id);
      if(album_id > 0)
        q.setInteger("album", album_id);
      if(!site.isOwner(user))
        q.setInteger("album_type", AlbumBean.TYPE_PUBLIC);      
      q.setMaxResults(1);
      return (PhotoOutlineBean)q.uniqueResult();
    }finally{
      hql = null;
    }
  }

View Full Code Here

      hql.append(" AND p.date=:date");
    }
    hql.append(" ORDER BY p.id DESC");
    Session ssn = getSession();
    try{
      Query q = ssn.createQuery(hql.toString());
      q.setInteger("site", site.getId());
      if(album_id > 0)
        q.setInteger("album", album_id);
      if(month_stamp > 190000 && month_stamp < 209912){
        q.setInteger("year", month_stamp / 100);
        q.setInteger("month", month_stamp % 100);
      }
      if(user==null || site.getOwner().getId()!=user.getId()){
        q.setInteger("hidden_status", PhotoBean.STATUS_PRIVATE);
        q.setInteger("owner_album", AlbumBean.TYPE_PUBLIC);
      }
      if(date>0){
        q.setInteger("date", date);
      }
      q.setFirstResult(fromIdx);
      q.setMaxResults(count);
      return q.list();
    }finally{
      hql = null;
    }
  }

View Full Code Here

   * @param fromIdx
   * @param count
   * @return
   */
  public static List listPhotos(AlbumBean album, int fromIdx, int count){
    Query q = getSession().getNamedQuery("PHOTOS_OF_ALBUM");
    q.setInteger("album", album.getId());
    //q.setInteger("hidden_status", PhotoBean.STATUS_PRIVATE);
    if(fromIdx > 0)
      q.setFirstResult(fromIdx);
    if(count > 0)
      q.setMaxResults(count);
    return q.list();
  }

View Full Code Here

      hql.append(" AND p.date=:date");
    }
    hql.append(" AND p.site.status=:site_status ORDER BY p.id DESC");
    Session ssn = getSession();
    try{
      Query q = ssn.createQuery(hql.toString());
      if(album_id > 0)
        q.setInteger("album", album_id);
      if(month_stamp > 190000 && month_stamp < 209912){
        q.setInteger("year", month_stamp / 100);
        q.setInteger("month", month_stamp % 100);
      }
      q.setInteger("hidden_status", PhotoBean.STATUS_PRIVATE);
      q.setInteger("owner_album", AlbumBean.TYPE_PUBLIC);
      if(date>0){
        q.setInteger("date", date);
      }
      q.setInteger("site_status", SiteBean.STATUS_NORMAL);
      q.setFirstResult(fromIdx);
      q.setMaxResults(count);
      return q.list();
    }finally{
      hql = null;
    }
  }

View Full Code Here

    if(date>0){
      hql.append(" AND p.date=:date");
    }
    Session ssn = getSession();
    try{
      Query q = ssn.createQuery(hql.toString());
      q.setInteger("site", site.getId());
      if(album_id > 0)
        q.setInteger("album", album_id);
      if(month_stamp > 190000 && month_stamp < 209912){
        q.setInteger("year", month_stamp / 100);
        q.setInteger("month", month_stamp % 100);
      }
      if(!is_owner){
        q.setInteger("normal_status", PhotoBean.STATUS_NORMAL);
        q.setInteger("public_album", AlbumBean.TYPE_PUBLIC);
      }
      if(date>0){
        q.setInteger("date", date);
      }
      return ((Number)q.uniqueResult()).intValue();
    }finally{
      hql = null;
    }
  }

View Full Code Here

      return -1;
    StringBuffer hql = new StringBuffer("SELECT SUM(p.photoInfo.size) FROM PhotoBean AS p WHERE p.site.id=?");
    if(album_id > 0)
      hql.append(" AND p.album.id=?");
    Session ssn = getSession();
    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

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.