BE THE CODER > Hibernate > Criteria Queries

The following example shows how to use Hibernate Detached Criteria. It returns the companies having employee count greater than average employee count. Refer first example for the configuration and mapping.

File Name :	com/bethecoder/tutorials/hibernate/basic/criteria/DetachedCriteriaAvgTest.java
Author :	Sudhakar KV
Email :	[email protected]


package com.bethecoder.tutorials.hibernate.basic.criteria;



import java.util.List;



import org.hibernate.Criteria;

import org.hibernate.Session;

import org.hibernate.criterion.DetachedCriteria;

import org.hibernate.criterion.Property;



import com.bethecoder.tutorials.hibernate.basic.Company;

import com.bethecoder.tutorials.hibernate.basic.util.HibernateUtil;



public class DetachedCriteriaAvgTest {



  /**

   * @param args

   */

  public static void main(String[] args) {



    Session session = HibernateUtil.getSessionFactory().openSession();

    session.beginTransaction();

    

    DetachedCriteria avgEmpCnt = 

      DetachedCriteria.forClass(Company.class)

        .setProjection( Property.forName("employeeCount").avg() );

    

    Criteria criteria = session.createCriteria(Company.class);

    criteria.add(Property.forName("employeeCount").gt(avgEmpCnt));

    

    List<Company> companies = criteria.list();    

    System.out.println("Selected row count : " + companies.size());

    

    for (Company company : companies) {

      System.out.println(company);

    }

    

    session.getTransaction().commit();

    session.close();

  }

  

}

Detached Criteria Average