jdbc-query(new PreparedStatementCreator(),new RowCallbackHandler())

 public List query(){
    final String sql="select *from users";
    final List result = new ArrayList();  
    result.clear();
    jdbcTemplate.query(new PreparedStatementCreator(){


@Override
public PreparedStatement createPreparedStatement(Connection conn)
throws SQLException {
// TODO Auto-generated method stub
return conn.prepareStatement(sql);
}
   
    },new RowCallbackHandler(){


@Override
public void processRow(ResultSet rs) throws SQLException {
// TODO Auto-generated method stub
while(rs.next()){
Map map=new HashMap();
map.put(rs.getInt("id"), rs.getString("name"));
result.add(map);
}

}
   
    });
    return result;
    }