how to query for a list String in jdbctemplate

Question

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   Is there a way to have placeholders  like   for column names  For example SELECT   FROM TABLEA GROUP BY    If I want to simply run the above query and get a List lt String gt  what is the best way    Currently I m doing   List  lt Map lt String  Object gt  gt  data   getJdbcTemplate   queryForList query   for  Map m   data    System out println m get  COLNAME

User · Answer

To populate a List of String  you need not use custom row mapper  Implement it using queryForList   List lt String gt data jdbcTemplate queryForList query String class

User · Answer

You can t use placeholders for column names  table names  data type names  or basically anything that isn t data

User · Answer

Is there a way to have placeholders  like   for column names  For example SELECT   FROM TABLEA GROUP BY     Use dynamic query as below   String queryString    SELECT    colName    FROM TABLEA GROUP BY    colName       If I want to simply run the above query and get a List what is the best way    List lt String gt  data   getJdbcTemplate   query query  new RowMapper lt String gt                                 public String mapRow ResultSet rs  int rowNum                                                            throws SQLException                                       return rs getString 1                                                              EDIT  To Stop SQL Injection  check for non word characters in the colName as              Pattern pattern   Pattern compile    W              if pattern matcher str  find                      throw exception as invalid column name

User · Answer

Use following code  List data   getJdbcTemplate   queryForList query String class

[java] how to query for a list<String> in jdbctemplate

Examples related to java

Examples related to jdbc

Examples related to jdbctemplate

Examples related to spring-jdbc