how to query for a list<String> in jdbctemplate

java jdbc jdbctemplate spring-jdbc
birdy picture birdy · Nov 13, 2012 · Viewed 99.2k times · Source

I'm using springs jdbctemplate and running a query like below:

SELECT COLNAME FROM TABLEA GROUP BY COLNAME

There are no named parameters being passed, however, column name, COLNAME, will be passed by the user.

Questions

  1. Is there a way to have placeholders, like ? for column names? For example SELECT ? FROM TABLEA GROUP BY ?

  2. If I want to simply run the above query and get a List<String> what is the best way?

Currently I'm doing:

List <Map<String, Object>> data = getJdbcTemplate().queryForList(query);
for (Map m : data)
  System.out.println(m.get("COLNAME"));

Answer

Ashwinie picture Ashwinie · Nov 4, 2016

To populate a List of String, you need not use custom row mapper. Implement it using queryForList.

List<String>data=jdbcTemplate.queryForList(query,String.class)

Related questions

java.sql.SQLException: Invalid column name

I cannot figure out why I am getting "Invalid column name" here. We have tried a variant of the sql directly in Oracle, and it works fine, but when I try it using jdbcTemplate then something is wrong. List<…

Read More
NamedParameterJdbcTemplate vs JdbcTemplate

I'm a beginner to Spring3.x , I'm learning Spring DAO support. I want to know the difference between NamedParameterJdbcTemplate and JdbcTemplate. Which one is the best by means of performance. And when to go for NamedParameterJdbcTemplate and when to go …

Read More
multiple one-to-many relations ResultSetExtractor

Let's say I have an object with two different one-to-many relations. Much like: Customer 1<->M Brands and Customer 1<->M Orders And let's say that the my object Customer has two lists related to those …

Read More