Using bind variables in Spring

[J Miller]

I'm doing some testing that involves database access using spring framework. I understand that I can create a query using a single bind variable using the following statement:

int countOfActorsNamedJoe = this.jdbcTemplate.queryForInt(
"select count(*) from t_actor where first_name = ?", "Joe");

I'm trying to use the queryForObject implementation described in the Spring docs (url at bottom). I have two questions about this. First I'm trying a simple implementation like this:

public List<Actor> retrieveActors(String input)
{
    ...
    List<Actor> results = null;
    JdbcTemplate select = new JdbcTemplate(dataSource);	
    results =  select.queryForObject("SELECT * FROM actors WHERE first_name = ?", input, new ActorMapper());
    return results;
}

But it's giving me an error under queryForObject saying

The method queryForObject(String, Object[], RowMapper) in the type JdbcTemplate is not applicable for the arguments (String, String, ActorMapper)

So my first question is how do I get that working?

My second question is how do I use multiple bind variables? Let's say I wanted to say

SELECT * FROM actors WHERE first_name = XXX AND last_name = YYY"

How would I do that?

Thanks

http://static.springsource.org/spring/docs/2.0.x/api/org/springframework/jdbc/core/JdbcTemplate.html#queryForObject%28java.lang.String,%20java.lang.Object[],%20java.lang.Class%29

[Vyas Sanzgiri]

The signature is queryForObject(String, Object[], RowMapper)

So you have to pass

results =  select.queryForObject("SELECT * FROM actors WHERE first_name = ?", new Object[]{ input}, new ActorMapper());  

Multiple variables

results =  select.queryForObject("SELECT * FROM actors WHERE first_name = ? AND last_name = ?", new Object[]{ input1, input2}, new ActorMapper());  

[J Miller]

You were absolutely right, thanks for the help. Another tip that I found is this: I then tried using LIKE rather than = using this:

results =  select.queryForObject("SELECT * FROM actors WHERE first_name LIKE '?%'", new Object[]{input}, new ActorMapper());

This also threw me an error. Apparently you can't use '?%', you have to change it to something like this:

input = input + "%";
results =  select.queryForObject("SELECT * FROM actors WHERE first_name LIKE ?", new Object[]{input}, new ActorMapper());

Thanks for the help!