title: Using queryForList method of JdbcTemplate
body: <p>I need to use the following query.</p>
  
  <pre><code>SELECT m.member_id, cardflag FROM member m, member_attribute ma WHERE m.member_number=:memberNumber AND m.ref_club_status IN ('A','S') AND m.member_id=ma.member_id
  </code></pre>
  
  <p>The datatype of <code>member_id</code> is byte array, and that of <code>cardflag</code> is varchar.</p>
  
  <p>I need to use this query in my code, and looking at the options in jdbctemplate documentation, queryForList seems to be the best choice. I have been trying, but couldnt make out much as to how to pass the parameter to my query and also as to how to handle the return type.</p>
  
  <p>Can anyone please help? </p>
  
  <p>Thanks a lot in advance.</p>