Hibernate Restriction Ge Function
In this section, you will learn about Hibernate restriction ge() function with running example, code and its output. Here, we will see the hibernate Restrictions.ge() method uses and its implementation throuth the help of example.
ge(): Hibernate Restrictions.ge() method is used with Restrictions. The ge() function gives you the result which is greatter and equal to added fieldName and its value. ge() method return list of result which is greatter and equal to given conditions.
Restriction.ge("field_name",value): Hibernate ge() function takes two parameters, one is field_name and other one is value which is add the conditions with given property.
Now, We will see the running example of Restrictions.ge() or ge() function. The following example matched the field_name = "empSal" and value = 8000.0 . It gives you all results which greatter and equal to added in criteria.
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 RestrictionGeExample {
/**
* @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.ge("empSal", 8000.0));
List<Employee> employees = criteria.list();
System.out.println("Get Employee which salary is
gretter and equal to 8000.0:");
for(Employee emp: employees){
System.out.println(
"Id: " + emp.getEmpId()
+ ", EmpName: " + emp.getEmpName()
+ ", EmpSal: " + emp.getEmpSal()
);
}
tr.commit();
}catch(Exception ex){
ex.printStackTrace();
}finally{
if(sess != null){
sess.close();
}
}
}
}
|
Download Restriction ge 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:
