I define a named native SQL. But the where condition is not static. It must dynamic add according input parameter. How can I do?
Named native SQL is:

<sql-query name="test">
select name, age
from student
where age > 30
</sql-query>

If user input name parameter, the sql will become:

select name, age
from student
where age > 30
and name='Mike';

In other word, add name condition to the sql.

If name paramter is null, don't add name condition.
How can I do?

In program, I write code for example:

SQLQuery q = session.getNamedQuery("test");

But I can't add new condition to this sql query. How Can I do?

Hi,
Do Criteria Queries help you ?
They can be used to build queries at run-time.

Thank you very much. But I want to use native SQL. Can I get the native SQL and then add codition at runtime?

You can try this...

SQLQuery query = (SQLQuery)session.getNamedQuery("test").getQueryString()+" and name='Mike' "

... but be carefull if you are ordering or grouping...
Using Criteria would be the best way to do it.