Hibernate Restriction LeProperty Function
In this section, you will learn about Hibernate restriction leProperty() or Restrictions.leProperty() function with running example, code and its related output. Here, we will see the hibernate restrictions leProperty () method description and its running example.
leProperty(): Hibernate criteria restriction leProperty() method is used with Restrictions. The hibernate Restrictions.leProperty() function matched values to specified fields (table's column name) to each other. It gives you all results which is matched the value to empSal is less or equal to empExpences.
Restrictions.leProperty("field_name","field_name"): Hibernate Restrictions.leProperty() function takes two parameters as fields, which are table's column name. It gives you all records which empSal is less or equal to empExpences.
Now, We will see the running example of Restrictions.leProperty() or leProperty() function. The following example match the field_name = "empSal" and field_name = "empExpences". It gives you all results which having empSal are less or 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 RestrictionLePropertyExample {
/**
* @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.leProperty(
"empSal", "empExpences"));
List<Employee> employees = criteria.list();
System.out.println("Get Employee which
salary is less and 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 leProperty 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:
