HQL Select

In this tutorial we will learn how to use HQL Select statement to load the Entity objects.

The HQL Select query is used to load Entity based on certain criteria or load all the entity from the persistence store (database).

Writing HQL Select query:

Here is the simple HQL Select example that loads all the customer.

String HQL_QUERY = "select c from Customer c";

Here is the complete example of HQL Select statement:

 
package net.roseindia.hqlexamples;

import java.util.Iterator;
import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;

import net.roseindia.model.*;

/**
 * HQL Select Example In this example we are selecting all the customers from
 * the datastore
 */

public class HQLSelect {

	public static void main(String[] args) throws Exception {
		/** Getting the Session Factory and session */
		SessionFactory factory = HibernateUtil.getSessionFactory();
		Session session = factory.getCurrentSession();
		/** Starting the Transaction */
		Transaction tx = session.beginTransaction();

		// Create Select Clause HQL
		String HQL_QUERY = "select c from Customer c";
		Query query = session.createQuery(HQL_QUERY);
		List result = query.list();
		for (Iterator it = result.iterator(); it.hasNext();) {
			Customer customer = (Customer) it.next();
			System.out.println("ID: " + customer.getId());
			System.out.println("Name: " + customer.getCustomerName());
			System.out.println("Phone: " + customer.getCustomerPhone());
		}

		/** Closing Session */
		session.close();
	}
}

Here is the output of the example when executed:

Download HQL Select Source Code

Related Tags for SQL Select, HQL Select Example, HQL Select Query: