BE THE CODER > Hibernate > Hibernate Query Language (HQL)

The following example shows accessing individual properties of entity as an object. Each row with matching condition will be returned as an instance of specified class. This class should have a constructor with same parameters as the properties in the query. Refer first example for the configuration and mapping.

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


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



import java.util.Iterator;

import java.util.List;

import org.hibernate.Session;

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

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



public class HQLAccessPropsAsObjectTest {



  /**

   * @param args

   */

  public static void main(String[] args) {



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

    session.beginTransaction();

    

    String HQL_QUERY = 

      "select new com.bethecoder.tutorials.hibernate.basic.CompanyShortInfo(comp.id, comp.name)" + 

      " from Company comp where comp.employeeCount >= 23430";

    

    List<CompanyShortInfo> rows = (List<CompanyShortInfo>) session.createQuery(HQL_QUERY).list();    

    

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

    Iterator<CompanyShortInfo> rowsIt = rows.iterator();

    

    while (rowsIt.hasNext()) {

      System.out.println(rowsIt.next());

    }

    

    session.getTransaction().commit();

    session.close();

  }



}

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


package com.bethecoder.tutorials.hibernate.basic;



public class CompanyShortInfo {



  private int id;

  private String name;

  

  public CompanyShortInfo(int id, String name) {

    super();

    this.id = id;

    this.name = name;

  }

  

  public int getId() {

    return id;

  }

  public void setId(int id) {

    this.id = id;

  }

  public String getName() {

    return name;

  }

  public void setName(String name) {

    this.name = name;

  }

  public String toString() {

    return "CompanyShortInfo[" + id + ", " + name + "]";

  }

}

Access Properties As Object