Hibernate Criteria Lower
Posted on: April 9, 2011 at 12:00 AM
In this tutorial you will learn about the hibernate Criteria lower case example

Hibernate Criteria Lower

The Hibernate Criteria Lower Ignore a the case. You can use ilike() method or ignoreCase() method as

criteria.add(Restrictions.ilike("name", "%v%"));


criteria.add(Restrictions.eq("name", "vikash").ignoreCase());

Both can be used

An example is given below, please consider


package net.roseindia.main;

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

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

import org.hibernate.Criteria;
import org.hibernate.Session;
import org.hibernate.criterion.Restrictions;

public class LowerCase {
	public static void main(String[] args) {
		Session session = HibernateUtil.getSessionFactory().openSession();
		Criteria criteria = session.createCriteria(Student.class);
		criteria.add(Restrictions.ilike("name", "%v%"));
		List results = criteria.list();
		Iterator iterator = results.iterator();
		while (iterator.hasNext()) {
			Student student = (Student) iterator.next();

When you run this application it will display message as shown below:

Hibernate: select this_.roll_no as roll1_0_0_, this_.name as name0_0_, this_.course as course0_0_, this_.address as address0_0_ from student this_ where lower(this_.name) like ?

Download Complete Source Code

Related Tags for Hibernate Criteria Lower:



Advertisement null