Hibernate Restriction Isnotnull Function
In this section, you will learn about Hibernate restrictions isNotNull() or Restrictions.isNotNull() function with running example, code and its output. Here, we will see the hibernate restrictions isNotNull () method functionality discriptions with running example.
Restrictions.isNotNull("field_name"): Hibernate isNotNull() method is used with hibernate Restrictions. The hibernate Restrictions.isNotNull() function takes a parameter as column name or property. It gives you all records which value is not null.
In the following example, isNotNull() function takes a parameter as "empExpences". And it gives you all results which employees haing empExpences.
Now, We will see the running example of Restrictions.isNotNull() or isNotNull() function. The following example match the field_name = "empExpences". It gives you all results which is empExpences column value is not null.
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 RestrictionIsNotNullExample {
/**
* @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.isNotNull("empExpences"));
List<Employee> employees = criteria.list();
System.out.println("Get Employee which
having expences:");
for(Employee emp: employees){
System.out.println(
"Id: " + emp.getEmpId()
+ ", EmpName: " + emp.getEmpName()
);
}
tr.commit();
}catch(Exception ex){
ex.printStackTrace();
}finally{
if(sess != null){
sess.close();
}
}
}
}
|
Download Restriction lsNotNull 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_expences is not null
OutPut:
