Hibernate Like Query

This section illustrate hibernate like query with example.

Ads

Tutorials   
How properties of a class are mapped to the columns of a database table in Hibernate? Hibernate 5 Annotations Maven dependency Hibernate 5 annotationconfiguration Doctype Hibernate-configuration 5 Hibernate 5 Dialect Hibernate 5 configuration dtd Hibernate 5 Hello World Getting started with Hibernate 5 Hibernate 5.2.10 jar Download Hibernate 5.2.10 Maven Dependency Hibernate 5 Maven Dependency Hibernate 5 native query example Hibernate 5 query deprecated When should you use Hibernate? What's new in Hibernate 5? How much time it takes to learn Hibernate? Hibernate envers custom revinfo table Hibernate 5 Envers Hibernate Envers get all revisions Hibernate Examples Hibernate 5 build SessionFactory Example Hibernate 5 SessionFactory Example Hibernate 5 Annotation Example How to download Hibernate 5.x? Hibernate 5 Features Hibernate 5 Tutorials Learning Hibernate ORM - Free Training/Tutorial videos of Hibernate ORM with Java How to write hello world example program in Hibernate? How to create one to one relationship in Hibernate 4 with Annotation? How to calculate minimum in Hibernate using the min() Function Hibernate ORM 4.2.21.Final Released - Create CURD application in latest Hibernate Hibernate ORM 4.2.21 Tutorial - Learn Hibernate ORM Framework Hibernate Error: Failed to create sessionFactory object.java.lang.NoClassDefFoundError How to create Hibernate Project in Eclipse? Examples of Hibernate Criteria Query Hibernate ORM 4.3.6.Final released Hibernate ORM 4.2.14.Final released Hibernate 4.3.4 Released: Hibernate 4.3.4.Final Maven dependency Hibernate association and join example Learn Hibernate programming with Examples

Hibernate Like Query

This section illustrate hibernate like query with example.

Like Query:

Like operator is used for string pattern matching. The percent character(%) is used before, after, or in a string.
It is used for matching a substring using wildcard.

Example :In the following example we are displaying such student record whose name starts from 'R' character. We are writing query in HQL.

Here is main class code-

package net.roseindia.apps;

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

import net.roseindia.table.Student;
import net.roseindia.util.HibernateUtil;

import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;

public class MyApps {
public static void main(String []args){
Session session=HibernateUtil.getSessionFactory().openSession();
try{
String hql="SELECT stud FROM Student stud WHERE stud.name like 'R%'";

Query query=session.createQuery(hql);

List list = query.list();
Iterator iterator = list.iterator();
System.out.println("RollNo.\tName\tCourse");
System.out.println("-------------------------");
while(iterator.hasNext()){ 
Student stud = (Student) iterator.next();
System.out.print(stud.getRoll());
System.out.print("\t"+stud.getName());
System.out.print("\t"+stud.getCourse());
System.out.println();
}


}catch(HibernateException e){
e.printStackTrace();
}
}
}

Output:

Hibernate: select student0_.roll_no as roll1_0_, student0_.course as course0_, student0_.name as name0_ from student student0_ where student0_.name like 'R%'
RollNo.  Name      Course
-------------------------
1        Rondy     java
4        Roxi      Hibernate

Click here to download complete code

Advertisements

Ads

 

We have 1000s of tutorials on our website. Search Tutorials tutorials on our website.

Share on Google+Share on Google+

Hibernate Like Query

Posted on: July 20, 2012 If you enjoyed this post then why not add us on Google+? Add us to your Circles

Advertisements

 

Discuss: Hibernate Like Query  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments:0

Ads

 

Ads