Home » » How TO Use OR Condition(in Criteria Query) In Hibernate?

How TO Use OR Condition(in Criteria Query) In Hibernate?

Rendyon | 12:30 AM | 0 comments

Suppose you want to fetch a mobile list from mobileList table where mobile status is either 1 or 5 (in status column of mobileList  table). We can fetch easily using Criteria Query and Restrictions API of Hibernate.

Here is the example:
  final Integer status=1;
final Integer statusSec = 5;
final Session session=this.getSession();
final Criteria criteria=session.createCriteria(MobileList.class);
criteria.add(Restrictions.or(Restrictions.eq("status",status), Restrictions.eq("status",statusSec)));

Reference:
http://docs.jboss.org/hibernate/orm/3.3/reference/en/html/querycriteria.html
Share this article :

0 comments:

 
Copyright © 2011. Find Updates - All Rights Reserved
Template Modify by Creating Website
Proudly powered by Blogger