I 'm testing :
..........

if (a!=null){
criteria.add(Restrictions.eq("a",a);
}
if (b!=null){
criteria.add(Restrictions.eq("b",b);
}
if (c!=null){
criteria.add(Restrictions.eq("c",c);
}
But the result it's very strict ;becouse only return an existent object only if you fill all fields of the object.
eg if I let in blank the form in the fields b,c just resturn an existent object with b,c null.
How can I do in the restrictions for several conditions??
I want make search of several conditions ,a could be null,or b ,If I put a and c I want to get a list of every object with a and c properties.

Check out Example Queries, Hibernate reference doc 15.6.

Jayehs,I tried with :
x po=new x();
Criteria crit=hibernateTemplate.createCriteria(x.class);
crit.add((Example.create(po)).excludeNone());
if (a!=null){
criteria.add(Restrictions.eq("a",a);
}
if (b!=null){
criteria.add(Restrictions.eq("b",b);
}
if (c!=null){
criteria.add(Restrictions.eq("c",c);
}

but now I get an empty list ,could you please put an example of using criteria with several conditions and how to use the restrictions under Example class.
Thanks.

I was thinking more along the following lines:



By default null values set in po will not be considered as part of the criteria.

So e.g. if the values for a, b, c are null, b, c respectively.

Then only x(s) which match b and c would be returned. Since 'a' is null (could be equivalent to not filling in) it would be ignored and not included as part of the criteria.


The result would be similar to your code with null checks.



I do not agree with your above comments. It seems to me that your code (first post) should also have worked just fine. If a particular property is null then it is not added to the criteria. So the query should not include the property as part of the search.

It could be that when you do not fill in the field it may not be null but for e.g. an empty string "" or " ".

Check the query that is being generated and the value for the fields being left empty.

thanks Jayeshj the problem was:
"It could be that when you do not fill in the field it may not be null but for e.g. an empty string "" or " ". "
like you well say the field not filled had an empty string "".
I put in the logic also !(a.length()<1);
now work perfectly.
Thank you very much for your help.