java code inside sql functions?

[rish obe]

I am running a sql query which uses some sql functions like date_add() or max()

Query is something like : delete from <tablename> where date=date_add(<date>,interval <expression> unit)

I wish to write the above query in java code
The problem is i am not able to pass the parameters to the sql functions in java code.

"delete from student where date=date_add("+date_variable+","+parameter_@+")"

How can this be done.
Any inputs?

Many thanks!

[Scott Selikoff]

Can you post your java code? It's hard to know what you're doing wrong without see the JDBC code.

[Avi Abrami]

Rish,
The usual way to achieve your aim is to use a PreparedStatement.

Good Luck,
Avi.