Hibernate Restriction neProperty Function
In this section, you will learn about Hibernate restriction neProperty() or Restrictions.neProperty() function with running example, code and its output. Here, we will see the hibernate restrictions neProperty () method descriptions and its running example.
Restrictions.neProperty("field_name","field_name"): Hibernate Restrictions.neProperty() function takes two parameters as table's column names (property name). It gives you all records which first filed is not qual to second filed.
Now, We will see the running example of Restrictions.neProperty() or neProperty() function. The following example match the field_name = "empSal" and field_name = "empExpences" . It gives you all records which empSal is not equal to empExpences.
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 RestrictionNePropertyExample {
/**
* @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.neProperty(
"empSal", "empExpences"));
List<Employee> employees = criteria.list();
System.out.println("Get Employee which
salary is not equal to expences:");
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 neProperty 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<>this_.emp_expences
OutPut:
