title: How can I retrieve/store a result set to an ArrayList?
body: <p>How do I use the JdbcTemplate.query()/queryForList() to run a query using namedParameter and store the result set into a List of 'User's?</p>
  
  <p>User Class:</p>
  
  <pre><code>public class User {
  
      String name = null;
      String id = null;
  
      public String getName() {
          return name;
      }
      public void setName(String name) {
          this.name = name;
      }
  
      public String getId() {
          return name;
      }
      public void setId(String id) {
          this.id = id;
      }
  }
  </code></pre>
  
  <p>Query:</p>
  
  <pre><code>SELECT name, id FROM USERS where email=:email
  </code></pre>
  
  <p>I'm looking for something like:</p>
  
  <pre><code>ArrayList&lt;User&gt; userList = jdbcTemplate.query(sql_query, 
                                                ...some_mapper..., etc);
  </code></pre>