need help on SimpleJdbcTemplate

[asanjayareddy]

i need to get the list of email ids from the table by using the below query.
"SELECT email_address FROM qtel_switch_ebill WHERE process_status='NO' AND (ebill_date+14)<=SYSDATE"
In my project we are using simplejdbctemplate. Which method i need to use to execute this query.

Thanks in advance.

Regards,
Sanjay

[asanjayareddy]

pls anyone respond to this thread ..

[balteo]

Have a look at the queryForList method.

jdbcTemplate.queryForList("select * from mytable");

Regards,

J.

[asanjayareddy]

but in my project , we are using SimpleJdbcTemplate ..

[balteo]

but in my project , we are using SimpleJdbcTemplate ..

You do have this method defined on the SimpleJdbcTemplate class: see here:documentation

[asanjayareddy]

Thank you for the response Balteo,

those are methods are taking two parameters( sqlQuery and args), but in my case , i dont need any aarguments for the query.

[balteo]

This method: see here takes a varargs as a second argument which means from 0 to n arguments. Therefore you can use it.

[asanjayareddy]

ohhhhhhhhh.. Thank you so muchhh balteo

[balteo]

You're welcome.

[asanjayareddy]

Hi balteo,

i am getting "org.springframework.jdbc.UncategorizedSQLExceptio n". please help me out.

for more details:

http://forum.springsource.org/showth...se-help-me-out