Hibernate Restriction Between function
In this section, you will learn about Hibernate restrictions between() function with running example, code and its output. Here, we will see the hibernate restriction between () method.
Restriction.between("field_name",min_value, max_value): Hibernate between used with hibernate restrictions. Hibernate between() function takes three parameters, one is field name and other two parameters are values. This function gives you all results which is between the values of given field.
Now, We will see the running example of Restrictions.between() or between() function. The following example match the field_name = "empSal", min_value = 8000.0 and max_value = 55500.0. It gives you all records which empSal are between 8000.0 and 55500.0.
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 RestrictionBetweenExample {
/**
* @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.between(
"empSal", 8000.0, 55500.0));
List<Employee> employees = criteria.list();
System.out.println("Get All Employee
which having salary between 8000 and 55500:");
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 between 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 between ? and ?
OutPut:
