Could hibernate ignore null value if it have many parameter?

Yashnoo · **Joined:** Wed Dec 17, 2003 4:24 am **Posts:** 188

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:[email protected]

the query will be :

Code:

from mytable where name=yashnoo and [email protected]

if the input info is this:

name: (not input anything) email:[email protected]

the query will be:

Code:

from mytable where [email protected]

Not this:

Code:

from mytable where name=null and [email protected]

The later will query nothing obviously.

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

Reto · **Posted:** Fri Sep 10, 2004 2:56 am

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

Reto

Yashnoo · **Joined:** Wed Dec 17, 2003 4:24 am **Posts:** 188

The method :

Code:

session.createCriteria(Expression.between("name",null,null));

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

Bart Sawyer · **Posted:** Fri Sep 10, 2004 7:08 am

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

Yashnoo · **Joined:** Wed Dec 17, 2003 4:24 am **Posts:** 188

Bart Sawyer wrote:

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.

Yashnoo · **Joined:** Wed Dec 17, 2003 4:24 am **Posts:** 188

For example.

I use the query

Code:

"from cat as c where c.name="+request.getParameter("name");

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

Code:

from cat as c

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.

steve · **Posted:** Thu Sep 23, 2004 12:17 am

Quote:

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

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.

Yashnoo · **Joined:** Wed Dec 17, 2003 4:24 am **Posts:** 188

steve wrote:

Quote:

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

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 . :-(

steve · **Posted:** Thu Sep 23, 2004 9:53 am

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.