Multi query using criteria

afufu · **Joined:** Mon May 26, 2008 7:03 am **Posts:** 2

I am writing a web app using hibernate java struts. I have a piece of code for a search bar that follows:

List listofsome = session.createCriteria(some.class)
.add(Restrictions.like("firstName", searchString+"%")).list();

this works but only searches for the string on one column of my database.

My question is can i incorporate another line of code into this to query another column? or do i have to do it another way if so how?

all help appreciated

Thank you

Danny

SIau_Tie · **Posted:** Mon May 26, 2008 9:40 am

Code:

Criteria criteria = session.createCriteria(someClass);
Disjunction disj = Restrictions.disjunction();
disj.add(Restrictions.ilike(column1, value, MatchMode.ANYWHERE);
disj.add(Restrictions.ilike(column2, value, MatchMode.ANYWHERE);
criteria.add(disj);
List list = criteria.list();

afufu · **Joined:** Mon May 26, 2008 7:03 am **Posts:** 2

Thanks very much mate, works a treat.

Cameron McKenzie · **Posted:** Mon May 26, 2008 12:46 pm

Certainly you can just keep adding in criteria queries like crazy. That's the beauty of the Hibernate Critieria API.

Code:

public static void main(String args[]) {
  Session session = HibernateUtil.beginTransaction();
  Criterion c1 = Restrictions.gt("id", (long)2);
  Criterion c2 = Restrictions.lt("id", (long)8);
  Criterion c3 = Restrictions.isNotNull("emailAddress");
  User user = new User();
  user.setEmailAddress(".com");
  Example c4 = Example.create(user);
  c4.enableLike(MatchMode.END);
  c4.ignoreCase();
  Criteria criteria = session.createCriteria(User.class);
  criteria.add(c1);
  criteria.add(c2);
  criteria.add(c3);
  criteria.add(c4);
  List results = criteria.list();
  HibernateUtil.commitTransaction();
  for (int i = 0; i<results.size(); i++) {
    System.out.println(results.get(i).toString());
  }
}

The code above uses a disjunction, which provides an OR type of query=. Without using the disjunction, you'll default to the and query.

Here's a friendly little tutorial on how to use the Hibernate Criteria API, along with some Hibernte code snippets and Hibernate examples:

http://www.hibernatemadeeasy.com/HiberBookWeb/learn.jsp?tutorial=09howtousethecriteriaapi