Hibernate HQL Syntax with code examples

HQL stands for Hibernate Query language. It is similar to SQL, but instead of the database table and column names, it uses the class and field names. So whenever we need to query the database, we write HQL queries in Hibernate. Based on the underlying database, Hibernate automatically converts HQL into equivalent SQLs statements. HQL has a very rich syntax and I will be covering the Hibernate HQL syntax in detail in this article.

 

From Clause

The from clause consists of the from keyword followed by an entity name.  It specifies the entity from which Hibernate needs to retrieve data. So if we have a Person entity, we can specify the from clause as follows:

String queryStr = "from Person";Query<Person> query = session.createQuery(queryStr);List<Person> books = query.getResultList();

Select Clause

The select clause can also be used to retrieve data from the database. The select clause is more powerful than the from clause. It provides more control over the resultset. It allows you to select only a few fields from the database. You can do this by specifying the field names that you want to retrieve.

The following code demonstrates this:

String queryStr = "select name from Person";Query<String> query = session.createQuery(queryStr);List<String> names = query.getResultList();

As Clause

Hibernate allows us to assign a name to a class in a query using the “AS” clause. Such a name given to a class is called an alias.  Aliases are specified just for ease of use and are optional although it is a good practice to use them. If you have long queries, using an alias makes the query more readable.

The following code demonstrates this:

String queryStr = "from Person as person"; Query<Person> query = session.createQuery(queryStr);List<Person> books = query.getResultList();

Where Clause

The where clause is used to limit the results obtained in a query. It can be used in a from clause or a select clause. In addition, it can also be used with the update and delete clause to limit the scope of the update or delete.

The following code demonstrates this:

String queryStr = " from Person where age > 21Query<Person> query = session.createQuery(queryStr);List<Person> books = query.getResultList();

Order by

The Order by clause is used to sort the results obtained from a query. You can order the results by any field of the class which is present in the result set either in ascending (ASC) or descending (DESC) order.

The following code demonstrates this:

String queryStr = "from Person order by age";Query<Person> query = session.createQuery(queryStr); List<Person> books = query.getResultList();

Edit

Further Learning

Master JPA and Hibernate with Spring Boot
Spring Data JPA with Hibernate
Hibernate and JPA Fundamentals

Conclusion

So in this article, we took a look at the Hibernate HQL syntax and the various clauses supported by HQL.

Comments

Post a Comment

Popular posts from this blog

How to use logging in SpringBoot with code samples

Image
In this article, we will learn how to use logging in SpringBoot. Introduction There are several Java logging frameworks like logback, log4j, and so on. Spring Boot supports out-of-the-box support for logback. Let us learn how to use logging in SpringBoot with logback. Step 1 – Create a New Maven Project Create a new Maven project. (Refer to  this  blog post). This will create a project in Eclipse as follows:   Step 2 – Add the Spring Boot Dependencies Add the spring-boot-starter-web dependency to the pom.xml . So, the pom.xml should look as follows: <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>com.learnjava</groupId> <artifactId>learnjava-springboot-logging-example</artifactId> <version>0.0.1-SNAPSHOT&
Read more

Python While Loop with code samples

Much like a Java while loop, you can use a Python while loop to repeatedly execute a block of code as long as a condition is true. In this article, we will learn more about the Python while loop. Python While loop Syntax A while loop in Python has the following syntax: while <condition>: loop body The while keyword is followed by a condition. If the condition evaluates to true, the body of the loop is executed. Once the body of the loop is completed, the condition is checked again and this is repeated until the condition evaluates to false at which point the loop is exited. While loop Sample Code The following code demonstrates how you can use the while loop: num=10counter=1total=0while counter<=num: total += counter counter+=1print("sum of first 10 numbers is",total) This code adds the numbers from 1 to 10 and prints the sum. It uses a while loop to iterate from 1 to 10. The while loop checks the condition counter <= num and if so adds the current value of count
Read more

How to convert a List to a Set

In this blog post ,I will be showing you how you can convert a List to a Set. Consider the following code snippet: public class ListToSetDemo {public static void main(String[] args) {List<Integer> list = Arrays.asList(5,3,11,15,9);//Method 1Set<Integer> set = new HashSet<Integer>(list);System.out.println("Set is "+set);//method 2Set<Integer> set2 = new HashSet<Integer>();set2.addAll(list);System.out.println("Set is "+set2);}} This code demonstrates two ways to convert a List to a Set. Method 1 Here, we are creating a new HashSet . We are invoking the constructor that accepts a Collection object. Here, we are passing in the input list to this constructor.   Method 2 Here again, we are creating a new HashSet . However, we are using the default constructor. We are then invoking the addAll method and passing in the input list.   When you run this code, it will print the following output: Set is [3, 5, 9, 11, 15]Set is [3, 5, 9, 11, 15] No
Read more