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

The following example shows using HQL when expression. Refer first example for the configuration and mapping.

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


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



import java.util.Arrays;

import java.util.Iterator;

import java.util.List;

import org.hibernate.Query;

import org.hibernate.Session;

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



public class HQLWhenCaseTest2 {



  /**

   * @param args

   */

  public static void main(String[] args) {



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

    session.beginTransaction();

    

    String HQL_QUERY = "select comp.name, comp.projectCount, " + 

        "case " +

          "when comp.projectCount < 300 " +

          "then 'Very Small Company' " +

          

          "when comp.projectCount < 500 " +

          "then 'Small Company' " +

          

          "when comp.projectCount < 1000 " +

          "then 'Big Company' " +

          

          "else 'Very Big Company' " +

        "end" + 

        " from Company comp";

    

    Query query = session.createQuery(HQL_QUERY);

    

    List<?> rows = query.list();    

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

    Object [] row = null;

    

    while (rowsIt.hasNext()) {

      row = (Object []) rowsIt.next();

      System.out.println(Arrays.toString(row));

    }

    

    session.getTransaction().commit();

    session.close();

    

  }



}

When Complex Expression