Hibernate Criteria Not In
Posted on: April 9, 2011 at 12:00 AM
In this tutorial you will learn about the hibernate criteria not in example

Hibernate Criteria Not In

It is reverse of the Hibernate Criteria In, It take a argument of list or collections.

Criteria criteria = session.createCriteria(Student.class);
	criteria.add(Restrictions.not(Restrictions.in("name", new String[] {
		"bharat", "Ramesh", "Raman" })));
	List list = criteria.list();

An example is of Not is given below, please consider

CriteriaNotIn.javaADS_TO_REPLACE_1

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 CriteriaNotIn {
	public static void main(String[] args) {
		Session session = HibernateUtil.getSessionFactory().openSession();
		Criteria criteria = session.createCriteria(Student.class);
		criteria.add(Restrictions.not(Restrictions.in("name", new String[] {
				"bharat", "Ramesh", "Raman" })));
		List list = criteria.list();
		Iterator iterator = list.iterator();
		while (iterator.hasNext()) {
			Student student = (Student) iterator.next();
			System.out.println(student.getName());
		}
	}
}


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 not (this_.name in (?, ?, ?))
Aman
Vikash

Download Complete Source Code

Related Tags for Hibernate Criteria Not In:

Advertisements

Ads

 
Advertisement null

Ads