Hibernate Restrictions ne Function
In this section, you will learn about Hibernate restriction ne() or Restrictions.ne() function with running example, code and its output. Here, we will see the hibernate restrictions ne () method descriptions and its running example.
Restrictions.ne("field_name", value): Hibernate Restrictions.ne() function takes two parameters. First is filedName as table's column name and other one is value which you want to match. It gives you all records which empSal is not equal to given value.
Now, We will see the running example of Restrictions.ne() or ne() function. The following example match the field_name = "empSal" and value = 12000 . It gives you all records which empSal is not qual to 12000.
package developerhelpway.hibernate.criteria.restriction;
import java.util.List;
import org.hibernate.Criteria;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import org.hibernate.criterion.Restrictions;
import developerhelpway.hibernate.Employee;
public class RestrictionNeExample {
/**
* @param args
*/
public static void main(String[] args) {
Session sess = null;
try{
SessionFactory sf = new Configuration().
configure().buildSessionFactory();
sess = sf.openSession();
Transaction tr = sess.beginTransaction();
Criteria criteria = sess.createCriteria(
Employee.class);
criteria.add(Restrictions.ne("empSal", 12000.0));
List<Employee> employees = criteria.list();
System.out.println("Get Employee which
salary is not equal to 12000.0:");
for(Employee emp: employees){
System.out.println(
"Id: " + emp.getEmpId()
+ ", EmpName: " + emp.getEmpName()
+ ", EmpSal: " + emp.getEmpSal()
+ ", EmpExpences: " + (emp.getEmpExpences()
!= null ? emp.getEmpExpences() : 0.0)
);
}
tr.commit();
}catch(Exception ex){
ex.printStackTrace();
}finally{
if(sess != null){
sess.close();
}
}
}
}
|
Download Restriction ne function Example
After running this example you will see the following output and SQL query which is generated by hibernate:
Hibernate: select this_.emp_id as emp1_0_0_, this_.emp_name as emp2_0_0_, this_.emp_sal as emp3_0_0_, this_.emp_expences as emp4_0_0_ from employee this_ where this_.emp_sal<>?
OutPut:
