Hi everyone:

There is a search function in my web application.I want to implement the function using hibernate. But the problem is that the query parameter is too much. There are 10 parameter in this site search function. So I think it has a problem. For example:

search according the following condition:

name: age: email: address: cell_phone:
home_phone: phone: country: ... ... etc...

If the client don't input any things my method will get a "null" value or a blank value. The function will not work property. But the fact is that if user don't input anything the condition will be all. I mean that if user don't input the name parameter,the function will query all name's data.

For example:
if the input info is this:
name: yashnoo. email:yashnoo@yahoo.com

the query will be :

if the input info is this:

name: (not input anything) email:yashnoo@yahoo.com

the query will be:

Not this:

The later will query nothing obviously.

Could hibernate has any query method that can ignore null value? THks

No, I think it hasn't. Try a generic solution with the criteria API.

Reto

The method :

also don't work property and achieve my goal. You think need I have to check the parameter in my java code manually?

Are you aware of the "query by example" functionality?
This might be useful in your situation.

http://www.hibernate.org/hib_docs/reference/en/html/querycriteria.html#querycriteria-examples

No,NO. It is not this means. I means that I want to insert or update data to database ,not load data from database.

For example.

I use the query

I mean that if I get the parameter is null ,it will query all the cat object from database , it equals this:


This is common problem when we design a query system. User maybe input Null value,but it means that he want to query all the object not NULL.

Huh? Sure sounds like your trying to load data from the database to me.

Query-by-example, as Bart mentioned, has the capabilities to do what you want.

Otherwise, yes you will need to handle this in your java code. Typically you'd manually build up an HQL string and only include restrictions based on values the user actually entered.

Thank you. It seems that I will implement it using "if else". Hibernate don't support this function . :-(

Sure it does; QBE supports it. Of course if you see a deficiency you can always open a jira case. And of course patches are always welcome.