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