If I understand your issue, I think you might want to consider using simpleJdbcDaoSupport. The method Query(
String sql, ParameterizedRowMapper<T>, Object... args) should do the trick for you. Use the ParameterizedRowMapper to add the results to your list.
Something like this
If you have to use JdbcTemplate, I would use the method query(String sql, RowMapper mapper). Then you could use the singleColumnRowMapper to map the rows to your list.
I imagine a ParameterizedSingleColumnRowMapper would do the same.
Hope this helps!