Home Hibernate Hibernate Like Query
Questions:Ask|Latest

 
 

Share on Google+Share on Google+

Hibernate Like Query

Advertisement
This section illustrate hibernate like query with example.

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

Advertisement

If you enjoyed this post then why not add us on Google+? Add us to your Circles



Liked it!  Share this Tutorial


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: July 20, 2012

Related Tutorials

Ask Questions?    Discuss: Hibernate Like Query  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments
DMCA.com