Home Answers Viewqa Hibernate Hibernate criteria disjunction.

 
 


ratna rathor
Hibernate criteria disjunction.
1 Answer(s)      a year ago
Posted in : Hibernate

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 Pages:
Hibernate criteria disjunction.
Hibernate criteria disjunction.  What is criteria disjunction in hibernate
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 Disjunction.
This section contains explanation of Hibernate disjunction with example
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
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 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
criteria
criteria in hibernate?   Here is a code that finds the maximum salary among the employees from the database using Hibernate Criteria. Criteria criteria...(Projections.max("salary")); For more information, visit the following link: Hibernate
Hibernate Criteria Expression (or)
Hibernate Criteria Expression (or)   ... the disjunction of the two expressions. You can also build the nested expressions using 'and' and 'or'.  Expressions: The Hibernate Criteria API supports a rich set
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 Or
In this section we are going to discuss Hibernate Criteria Or with example
Hibernate Criteria
In this tutorial we are going to discuss Hibernate Criteria 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 Restrictions
Hibernate Criteria Restrictions In this tutorial you will learn about to add the Restrictions in Criteria query. In Hibernate there is an elegant way to execute the dynamically written query for this Hibernate provides Criteria API
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 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 Detached Criteria
This section is good discussion about hibernate detached criteria
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
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 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 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 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
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...().openSession(); Criteria criteria = session.createCriteria(Student.class
Hibernate criteria for date.
Hibernate criteria for date. In this example, you will see how to create criteria for date. This example will access record from data, that is  greater...(); Criteria criteria = session.createCriteria
Hibernate criteria restrictions.or
Hibernate criteria restrictions.or In this tutorial, you will see the use... in org.hibernate.criteria package.  Syntax : Criteria crit...(); Criteria criteria = session.createCriteria(EmpInfo.class).add
Hibernate criteria sqlRestriction.
Hibernate criteria sqlRestriction. In this tutorial, we will introduce you to about the sqlRestriction() of Restrictions class.  Syntax : Criteria criteria = session.createCriteria(StudentBean.class); criteria.add
Hibernate Criteria And Or
Hibernate Criteria And Or The Hibernate Criteria And Or is same... 'Or' you can write as follows. Criteria Or operation Criteria criteria = session.createCriteria(Student.class); Criterion roll = Restrictions.eq
Hibernate criteria conjunction..
Hibernate criteria conjunction..  What is criteria conjunction in Hibernate?    In Hibernate, Criteria Conjunction works as logical... of bellow example- Steps- 1.Copy library (jar file) of hibernate into your lib folder
.When to use detached criteria in hibernate?
.When to use detached criteria in hibernate?  When to use detached criteria in hibernate?   Detached Criteria query is a facility provide by Hibernate to write criteria queries in detached mode, where hibernate session
Hibernate criteria setMaxResult.
Hibernate criteria setMaxResult. In this tutorial, you will see the use of setMaxResult() method of criteria class. It specifies to total number of result which will be access. Syntax : Criteria criteria=session.createCriteria
Hibernate criteria restrictions.between
Hibernate criteria restrictions.between In this tutorial, you will see... in org.hibernate.criteria package.  Syntax : Criteria crit...(); Criteria criteria = session.createCriteria(EmpInfo.class).add
Hibernate criteria restrictions.in
Hibernate criteria restrictions.in In this example, you will see the use... database. Here, you will see the use of in constraint. Syntax : Criteria... = sessionFactory.openSession(); Criteria criteria = session.createCriteria
Hibernate criteria sort.
Hibernate criteria sort. In this tutorial, we will introduce to you how to sort values in using criteria in hibernate. The Criteria is class, which is available in org.hibernate.criteria package. Syntax : Criteria criteria
Hibernate criteria to sql.
Hibernate criteria to sql. In this tutorial, you will see the use of sql...().openSession(); Criteria criteria = session.createCriteria(StudentBean.class).add...: Hibernate: select this_.id as id0_0_, this_.name as name0_0
Hibernate Criteria
Hibernate Criteria org.hibernate.Criteria is an interface which is very.... It is used where search on multi criteria required, becouse Hibernate Query... the first criteria to include the WHERE sysntax. Hibernate Criteria is very convenient
Best Practice in Criteria handling? - Hibernate
Best Practice in Criteria handling?  Please explain best Practices in Hibernate Criteria handling?  Hi friend, i am sending hibernate link, you will get more information about Criteria handling , Read for more
Hibernate: ORDER BY using Criteria API.
Hibernate: ORDER BY using Criteria API.  How to display record in order using Criteria API?   Hibernate Criteria API provides an easy way of building dynamic query on the persistence database. The hibernate criteria
Hibernate Criteria API
Hibernate Criteria API The API (Application Programming Interface) of Hibernate Criteria provides an elegant way of building dynamic query on the persistence database. The hibernate criteria API is very Simplified API for fetching
Hibernate Detached Criteria Subquery
In this section we will discuss how to write subqueries using Detached Criteria in Hibernate
Hibernate Criteria Projection
In this tutorial we are going to discuss about Hibernate Criteria Projection with example
Hibernate Criteria :Ordering the results
In this section, you will learn about ordering the results using Hibernate Criteria query
Hibernate Criteria isNull
Hibernate Criteria isNull The Hibernate Criteria Is Null value is used to check whether the given value is null. Criteria criteria... = criteria.list(); An example based on Hibernate Criteria isNull is given below
Hibernate criteria query using Max()
Hibernate criteria query using Max()  What is Hibernate criteria query using Max()?   You can find out maximum value in hibernate criteria... in ?org.hibernate.criterion?. For using Projection object in our Criteria, we have to call
Hibernate criteria query using Min().
Hibernate criteria query using Min().  How to find minimum value in Hibernate criteria query using Projection?   You can find out minimum value in hibernate criteria by using projection. Projection is an interface
Hibernate criteria query using avg()
Hibernate criteria query using avg()  How to calculate average in Hibernate criteria query using Projection?   You can calculate average of any numeric values in hibernate criteria by using projection. Projection
Hibernate Criteria isNotNull
Hibernate Criteria isNotNull The Hibernate Criteria isNotNull value is used to check whether the given value is not null Criteria criteria...(); Criteria criteria = session.createCriteria(Student.class); criteria.add