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