Hibernate criteria disjunction.

Hibernate criteria disjunction.

What is criteria disjunction in hibernate?

View Answers

May 31, 2012 at 11:38 AM

In Hibernate, Criteria disjunction works as logical OR operator. disjunction() groups the expressions into a single expression. If any one condition is satisfied, it will return true with its result as output. It returns false if all conditions are not satisfied. Take a look of bellow example- Steps-

1)Copy library (jar file) of hibernate into your lib folder.

2)Create hibernate configuration file (hibernate.cfg.xml) and save it in the same folder where you are going to save your source code.

3)Now create Persistent class Employee.java?Hibernate uses the Plain Old Java Object (POJO) classes to map to the database table using annotations.

4)Next create an util class as HibernateUtil.java

5)Here is your MainClass-

package net.roseindia.main;
import java.util.*;
import net.roseindia.table.Employee;
import net.roseindia.util.ConnectionUtil;
import org.hibernate.Criteria;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.criterion.Restrictions;

public class HibernateConjunction{
    public static void main(String []args){
        SessionFactory sessionFactory = ConnectionUtil.getSessionFactory();
        Session session = sessionFactory.openSession();
        Criteria criteria = session.createCriteria(Employee.class);
        criteria.add(Restrictions.disjunction().add(Restrictions.eq("id",2))
            .add(Restrictions.like("name", "R%"))
        );
         List<Employee> employeeList = new ArrayList<Employee>();
        employeeList = criteria.list();
        Iterator it = employeeList.iterator();

        while (it.hasNext()) {
            Employee employee = (Employee) it.next();
            System.out.println(employee.getName());
        }
        session.close();
    }
}

Output :

Hibernate: select this_.emp_id as emp1_0_0_, this_.date_of_join as date2_0_0_, this_.name as name0_0_, this_.salary as salary0_0_ from employee this_ where (this_.emp_id=? or this_.name like ?)
Ron
Som
Roxi

Description: -Employee is table class mapped with employee table. In the example, there are two conditions to check. First id must be equal to 2 or name must be started with 'r' character. Restrictions.disjunction() combinedly check both conditions and return result if any one expression is true.









Related Tutorials/Questions & Answers:
Hibernate criteria disjunction.
Hibernate criteria disjunction.  What is criteria disjunction in hibernate
hibernate criteria disjunction Example
hibernate criteria disjunction Example  I want example of hibernate criteria disjunction. Thanks   Example of hibernate criteria disjunction. Please check the tutorial hibernate criteria disjunction. This tutorial
Advertisements
Hibernate Disjunction.
This section contains explanation of Hibernate disjunction with example
hibernate criteria disjunction
hibernate criteria Disjunction In this Example, We will discuss about hibernate criteria query, In this example we create a criteria instance and implement.... In This example search the result according to disjunction. The disjunction
Hibernate Criteria Examples
Hibernate Criteria Disjunction Hibernate Criteria With Collections Hibernate...Hibernate Criteria Examples In this section we are giving many example of using Hibernate Criteria query. With the help of criteria query you can
Hibernate Criteria Multiple or
Hibernate Criteria Multiple or You can implements multiple or in hibernate criteria Criteria criteria = session.createCriteria(Student.class); Criterion...); Criterion firstName = Restrictions.eq("name", "Ramesh"); Disjunction disjunction
Examples of Hibernate Criteria Query
criteria date between hibernate criteria delete hibernate criteria disjunction...Example code and running projects of Hibernate Criteria Query Here are examples of Criteria Query in Hibernate and all the examples comes with the running
Criteria in Hibernate
Criteria in Hibernate  What is Criteria in Hibernate?   Criteria is a simplified API for retrieving entities by composing Criterion objects. This is a very convenient approach for functionality like "search" screens
Hibernate Criteria And Or Example
Hibernate Criteria And Or Example  Hibernate Criteria And Or Example I want example of Hibernate Criteria And Or in Java Thanks   Example of Hibernate Criteria And Or Criteria Check the tutorial Hibernate Criteria
Hibernate Criteria
In this tutorial we are going to discuss Hibernate Criteria with example
Hibernate Criteria Or
In this section we are going to discuss Hibernate Criteria Or with example
Hibernate-Criteria - Hibernate
Hibernate-Criteria  Hi friends, I am new to hibernate. Im learning it. When im using Criteria im getting exception tht "Criteria cannot... for more information. http://www.roseindia.net/hibernate/hibernate-between
Hibernate criteria by id.
Hibernate criteria by id.  How to display record by using criteria by id in Hibernate
Hibernate criteria delete Example
Hibernate criteria delete Example  How to use the delete criteria in Hibernate? thanks
Hibernate Criteria Count Example
Hibernate Criteria Count Example  Example of Hibernate Criteria Count. Check the tutorial Hibernate Criteria Count. Check the Latest tutorials, articles and examples of Hibernate Framework. Thanks
Hibernate criteria date Example
Hibernate criteria date Example  Example of Hibernate criteria date. Check the tutorial hibernate criteria date. Check the Latest tutorials, articles and examples of Hibernate Framework. Thanks
Hibernate Criteria With Collections Example
Hibernate Criteria With Collections Example  Good code of Hibernate... Hibernate Criteria With Collections in your Java project. Check the tutorial Hibernate Criteria With Collections . Check the Latest tutorials, articles
Hibernate Criteria And Restrictions Example
Hibernate Criteria And Restrictions Example  How to use Criteria And Restrictions in Hibernate? Thanks   I will provide you the example code of Hibernate Criteria And Restrictions. Check the tutorial Hibernate
Hibernate Criteria Wildcard
Hibernate Criteria Wildcard   How to write Criteria Query in Hibernate that uses the Wildcards?   Hello, Check the example Hibernate Criteria Wildcard. Thanks
What are criteria Queries in Hibernate?
What are criteria Queries in Hibernate?  Just explain me what is Criteria Query in Hibernate with examples? Thanks   Criteria queries are very helpful in hibernate for queries based on certain criteria. Check
What is Hibernate Criteria Transformer?
What is Hibernate Criteria Transformer?  Hi, Can anyone explain me about the Hibernate Criteria Transformer? I need good example of Hibernate Criteria Transformer . Thanks   Hi, check the example Hibernate Criteria
Hibernate criteria for date. Example
Hibernate criteria for date. Example  What to use the Hibernate criteria for date in Hibernate based application? I want example of Hibernate criteria for date in Hibernate orm. Thanks   Example of Hibernate criteria
Hibernate Criteria Queries - Hibernate
Hibernate Criteria Queries  Can I use the Hibernate Criteria Query...().buildSessionFactory(); session = sessionFactory.openSession(); Criteria crit... Configuration(); // configuring hibernate SessionFactory
Hibernate criteria average Example
Hibernate criteria average Example   How to find the average in Hibernate? Thanks   Example of finding average on a filed in Hibernate... the tutorial Hibernate criteria avg.. Check the Latest tutorials, articles
Hibernate Criteria Between Example
Hibernate Criteria Between Example  How to use the Between in the Hibernate Query? Share me good example code. Thanks   Example of Hibernate Criteria Between. Check the tutorial Hibernate Criteria Between. Check
Hibernate Detached Criteria Example
Hibernate Detached Criteria Example  How to use Hibernate Detached Criteria in Java program? What is the use of Hibernate Detached Criteria? Explain... Detached Criteria. Check Latest Hibernate Tutorials and Articles
Hibernate Criteria Wildcard Example
Hibernate Criteria Wildcard Example  Hi, How to write Java program to use the Hibernate Criteria Wildcard query and fetch the data from database I want example of Hibernate Criteria Wildcard which is easy to understand
Hibernate Detached Criteria Example
Hibernate Detached Criteria Example  can anyone share me the source code of using detached Criteria in Hibernate? Thanks   Hi, If you are looking for the Example program of using Hibernate Detached Criteria
Criteria Query Examples in Hibernate
Criteria Query Examples in Hibernate  How to use the Criteria Query in Hibernate? How to select the data using Criteria Query of Hibernate? Thanks... Criteria Query in Hibernate with Examples code. Check the tutorial Criteria Query
Hibernate Criteria Transformer Example
Hibernate Criteria Transformer Example  I want example of Hibernate...   Here I am giving you the link of Hibernate Criteria Transforme example program. Check the tutorial Hibernate Criteria Transformer . Check the Latest
Hibernate Criteria Query Example
Hibernate Criteria Query Example  Hi, How to create Hibernate Criteria Query Examples in Java program? Share me the easy to learn example code. Thanks   Hi, Hibernate Criteria Query is used to selectively find
Hibernate Detached Criteria
This section is good discussion about hibernate detached criteria
Hibernate criteria count.
Hibernate criteria count.  How do we count rows using criteria in hibernate?   We can get the rows count using the Projections. My code is like this: Criteria criteria = session.createCriteria(getReferenceClass
Hibernate criteria query
Hibernate criteria query  Hi... I need criteria query like query... a.countryId=c.Chrono and a.groupId=b.Chrono and a.type =1 "); like this in hibernate criteria example. Thanks in advance.   Have a look at the following link
Using sum() in hibernate criteria.
Using sum() in hibernate criteria.  How to calculate sum() in hibernate criteria by using projection?   You can calculate sum of any numeric value in hibernate criteria by using projection. Projection is an interface
Hibernate Criteria
Hibernate Criteria - Learn the Hibernate Criteria API and master the Hibernate framework The Hibernate Criteria query API is used to selectively find... the different ways of using the Criteria Query. The Hibernate Criteria API
Criteria with Multiple Tables - Hibernate
Criteria with Multiple Tables  I am using Hibernates Criteria. How to get Joins using Criteria? e.g. instead of below query i want to use criteria...://www.roseindia.net/hibernate/ Hope that it will be helpful for you. Thanks
Hibernate Criteria Query
Hibernate Criteria Query In this tutorial you will learn about the Hibernate Criteria Query. Hibernate provides an API for writing the dynamic query in an elegant way to execute . Except the use of HQL in Hibernate, Criteria query
Hibernate criteria avg.
Hibernate criteria avg. In this example, you will see the use of avg() method of Criteria class. It returns average value of the given column.  Syntax : Criteria criteria=session.createCriteria(Pojo.class
Hibernate criteria uniqueResult.
Hibernate criteria uniqueResult. Here, we will introduce you to about the uniqueResult() method of Criteria class of hibernate. Hibernate Criteria class... will return a null value. Syntax : Criteria criteria = session.createCriteria
Hibernate Criteria Aggregate Functions Example
Hibernate Criteria Aggregate Functions Example  I need Hibernate... of Hibernate Criteria Aggregate Functions? Can anyone share me the source code and article? Thanks   Example of Hibernate Criteria Aggregate Functions
Hibernate Criteria Query Example Program
Hibernate Criteria Query Example Program  Hi, I am new in Hibernate and learning the Criteria Query. How to use the Hibernate Criteria Query in my...;In the Hibernate Criteria Query Example You will find the source code of using Criteria
Hibernate Criteria Count Distinct Example
Hibernate Criteria Count Distinct Example  I am learning Hibernate... Criteria Count Distinct. Can anyone tell me the best place to learn Hibernate Criteria Count Distinct? Thanks   Here is an example of Hibernate Criteria
Hibernate Criteria Transformer Example code
Hibernate Criteria Transformer Example code  Hello, I am trying to find the example of Hibernate Criteria Transformer. Tell me the good tutorial of Hibernate Criteria Transformer with source code. Thanks   Hi, Check
Hibernate criteria setFirstResult.
Hibernate criteria setFirstResult. In this tutorial, you will see the use of seFirstResult() method of criteria class. The setFirstResult() tell hibernate from which row the data should be read. Syntax : Criteria criteria
Hibernate criteria by id.
Hibernate criteria by id.  How to display record by using criteria by id in Hibernate?   Here is an example - package...(); Session session=sessionFactory.openSession(); Criteria criteria
Hibernate Criteria Not In
Hibernate Criteria Not In It is reverse of the Hibernate Criteria In, It take a argument of list or collections. Criteria criteria... = HibernateUtil.getSessionFactory().openSession(); Criteria criteria = session.createCriteria
Hibernate criteria date between Example
Hibernate criteria date between Example  Hibernate criteria date between Example I want example of hibernate criteria date between with source code. Share me the url. Thanks   Example of Hibernate criteria date
Hibernate criteria count.
Hibernate criteria count.  How do we count rows using criteria in hibernate?   Create hibernate configuration file (hibernate.cfg.xml...(0)); } } Description: Hibernate criteria is used here as alternative to HQL
Hibernate criteria sum.
Hibernate criteria  sum. Here, we will introduce you to about the sum() function . It returns the sum of total value of column. Syntax : Criteria criteria=session.createCriteria(Pojo.class); criteria.setProjection

Ads