Examples of org.hibernate.Criteria

org.hibernate.Criteria
Criteria is a simplified API for retrieving entities by composing Criterion objects. This is a very convenient approach for functionality like "search" screens where there is a variable number of conditions to be placed upon the result set.

The Session is a factory for Criteria. Criterion instances are usually obtained via the factory methods on Restrictions. eg.
```
 List cats = session.createCriteria(Cat.class) .add( Restrictions.like("name", "Iz%") ) .add( Restrictions.gt( "weight", new Float(minWeight) ) ) .addOrder( Order.asc("age") ) .list(); 
```
You may navigate associations using createAlias() or createCriteria().
```
 List cats = session.createCriteria(Cat.class) .createCriteria("kittens") .add( Restrictions.like("name", "Iz%") ) .list(); 
```
```
 List cats = session.createCriteria(Cat.class) .createAlias("kittens", "kit") .add( Restrictions.like("kit.name", "Iz%") ) .list(); 
```
You may specify projection and aggregation using Projection instances obtained via the factory methods on Projections.
```
 List cats = session.createCriteria(Cat.class) .setProjection( Projections.projectionList() .add( Projections.rowCount() ) .add( Projections.avg("weight") ) .add( Projections.max("weight") ) .add( Projections.min("weight") ) .add( Projections.groupProperty("color") ) ) .addOrder( Order.asc("color") ) .list(); 
```
@see Session#createCriteria(java.lang.Class) @see org.hibernate.criterion.Restrictions @see org.hibernate.criterion.Projections @see org.hibernate.criterion.Order @see org.hibernate.criterion.Criterion @see org.hibernate.criterion.Projection @see org.hibernate.criterion.DetachedCriteria a disconnected version of this API @author Gavin King

      final String orderBy, final ProductArea productArea) {
    return (List<Order>) getHibernateTemplate().execute(
        new HibernateCallback() {


          public Object doInHibernate(final Session session) {
            Criteria crit = session
                .createCriteria(Order.class)
                .add(Restrictions.isNull("sent"))
                .add(Restrictions
                    .eq("productArea", productArea));


            if (criteria != null) {
              crit = crit.createCriteria(criteria);
            }
            if (orderBy != null) {
              crit.addOrder(org.hibernate.criterion.Order
                  .asc(orderBy));
            }
            return crit.list();


          }


        });
  }

View Full Code Here

      final String productAreaName) {
    return (List<Order>) getHibernateTemplate().execute(
        new HibernateCallback() {


          public Object doInHibernate(final Session session) {
            Criteria criteria = session
                .createCriteria(Order.class)
                .add(Expression.sql(
                    "datepart(year,agreement_date)=?",
                    year, Hibernate.INTEGER))
                .add(Expression
                    .sql("dbo.GetISOWeekNumberFromDate(agreement_date) between ? and ?",
                        new Object[] { weekFrom, weekTo },
                        new Type[] { Hibernate.INTEGER,
                            Hibernate.INTEGER }))
                .addOrder(
                    org.hibernate.criterion.Order
                        .asc("salesman"))
                .createCriteria("constructionType")
                .add(Restrictions.not(Restrictions.ilike(
                    "name", "%tilleggsordre%")));
            if (productAreaName != null) {
              criteria.createCriteria("productArea").add(
                  Restrictions.eq("productArea",
                      productAreaName));
            }
            return criteria.list();
          }


        });
  }

View Full Code Here

      final ProductAreaGroup productAreaGroup) {
    return (List<Order>) getHibernateTemplate().execute(
        new HibernateCallback() {


          public Object doInHibernate(final Session session) {
            Criteria criteria = session
                .createCriteria(Order.class)
                .add(Expression.sql(
                    "datepart(year,agreement_date)=?",
                    year, Hibernate.INTEGER))
                .add(Expression
                    .sql("dbo.GetISOWeekNumberFromDate(agreement_date) between ? and ?",
                        new Object[] { weekFrom, weekTo },
                        new Type[] { Hibernate.INTEGER,
                            Hibernate.INTEGER }))
                .addOrder(
                    org.hibernate.criterion.Order
                        .asc("salesman"));
            if (productAreaGroup != null) {
              criteria.createCriteria("productArea").add(
                  Restrictions.eq("productAreaGroup",
                      productAreaGroup));
            }
            return criteria.list();
          }


        });
  }

View Full Code Here

        new HibernateCallback() {


          @SuppressWarnings("unchecked")
          public Object doInHibernate(Session session)
              throws HibernateException {
            Criteria criteria = session.createCriteria(
                TakstolProductionV.class).add(
                Restrictions.eq("customerNr", customerNr));
            if (productAreaGroup != null
                && !productAreaGroup.getProductAreaGroupName()
                    .equalsIgnoreCase("Alle")) {
              criteria.add(Restrictions.eq(
                  "productAreaGroupName", productAreaGroup
                      .getProductAreaGroupName()));
            }


            criteria.addOrder(Order.asc("orderNr")).addOrder(
                Order.asc("defaultArticle")).addOrder(
                Order.desc("numberOfItems")).addOrder(
                Order.asc("orderLineId"));
            return criteria.list();
          }


        });
  }

View Full Code Here

        new HibernateCallback() {


          @SuppressWarnings("unchecked")
          public Object doInHibernate(Session session)
              throws HibernateException {
            Criteria criteria = session.createCriteria(


            TakstolProductionV.class).add(
                Restrictions.eq("orderNr", orderNr));
            if (productAreaGroup != null
                && !productAreaGroup.getProductAreaGroupName()
                    .equalsIgnoreCase("Alle")) {
              criteria.add(Restrictions.eq(
                  "productAreaGroupName", productAreaGroup
                      .getProductAreaGroupName()));
            }
            criteria.addOrder(Order.asc("orderNr")).addOrder(
                Order.asc("defaultArticle")).addOrder(
                Order.desc("numberOfItems")).addOrder(
                Order.asc("orderLineId"));


            return criteria.list();
          }


        });
  }

View Full Code Here

    
    
    SessionFactory sf=new Configuration().configure().buildSessionFactory();
    Session session=sf.openSession();
    
    Criteria c1=session.createCriteria(process.class);
    // c1.add(Restrictions.and(Restrictions.eq("id", new Integer(0)),Restrictions.like("username","vipul")));
          //      c1.addOrder(Order.desc("id"));
          //      c1.setProjection(Projections.property("username"));
          //      c1.setProjection(Projections.property("address"));
    int len=s.length;
    System.out.println(len);
    
    ProjectionList p1=Projections.projectionList();         
    for(int i=0; i<len; i++)
    {
                 p1.add(Projections.property(s[i]));
                 System.out.println(s[i]);
                 
          //        p1.add(Projections.property("address"));
    }           
                  
          c1.setProjection(p1);
                   List l1 = (List) c1.list();
                 // Iterator i =l1.iterator();
                 // while(i.hasNext())
                  //{
       //                   Object o[]=(Object [])i.next();
       //                   System.out.println(o[0] + "==" + o[1]);

View Full Code Here

  @SuppressWarnings("unchecked")
  public Collection<Role> getRolesSistema() {
    Session session = HibernateUtil.getSessionFactory().getCurrentSession();
    session.beginTransaction();
    
    Criteria criteria = session.createCriteria(Role.class)
    .add(Restrictions.eq("tipo", "Sistema"));
    
    List<Role> roles = criteria.list();
    
    session.close();
    
    return roles;
  }

View Full Code Here

  @SuppressWarnings("unchecked")
  public Collection<Role> getRolesProyecto() {
    Session session = HibernateUtil.getSessionFactory().getCurrentSession();
    session.beginTransaction();
    
    Criteria criteria = session.createCriteria(Role.class)
    .add(Restrictions.eq("tipo", "Proyecto"));
    
    List<Role> roles = criteria.list();
    
    session.close();
    
    return roles;
  }

View Full Code Here

  public Collection<Usuario> getUsuarios() {
    
    Session session = HibernateUtil.getSessionFactory().getCurrentSession();
    session.beginTransaction();
    
    Criteria criteria = session.createCriteria(Role.class)
    .add(Restrictions.eq("tipo", "Sistema"));
    
    List<Role> roles = criteria.list();
    
    criteria = session.createCriteria(Usuario.class)
    .add(Restrictions.in("role", roles));
        
    usuarios = (Collection<Usuario>) criteria.list();
    
    session.close();
    
    return usuarios;
  }

View Full Code Here

  @SuppressWarnings("unchecked")
    public Collection<TipoItem> getTiposItems(Proyecto proyecto){
    Session session = HibernateUtil.getSessionFactory().getCurrentSession();
    session.beginTransaction();


    Criteria criteria = session.createCriteria(TipoItem.class)
    .add(Restrictions.eq("proyecto", proyecto));
    
    List<TipoItem> tipoItems = criteria.list();
    
    session.close();


    return tipoItems;

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.hibernate.Criteria

br.com.flexait.core.AbstractDao

br.facet.tcc.impl.dao.DaoConfiguration

calendar.dao.Dao

com.abiquo.server.core.appslibrary.VirtualImageConversionDAO

com.abiquo.server.core.appslibrary.VirtualMachineTemplateDAO

com.abiquo.server.core.cloud.NodeVirtualImageDAO

com.abiquo.server.core.cloud.VirtualDatacenterDAO

com.abiquo.server.core.cloud.VirtualMachineDAO

com.abiquo.server.core.common.persistence.DefaultDAOBase

com.abiquo.server.core.config.SystemPropertyDAO

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.