Passing object to RowMapper

[Some_One]

From what I've seen so far, everytime one creates a RowMapper class to pass to a JdbcTemplate, the implemented mapRow method creates a new object with which to fill from the resultset. Is it possible though, to use an existing object, which may have some data already? Maybe pass it to the inner RowMapper class?

Thanks

[Mike Bingham]

You could potentially construct your RowMapper object with an instance of an object which has some initial state, and add to it in the mapRow method, but depending on your needs, you could also consider using a ResultSetExtractor instead of a RowMapper:

http://www.springframework.org/docs/...Extractor.html

A ResultSetExtractor receives only one callback, leaving it up to you to iterate through the ResultSet and construct an object as appropriate.

[Some_One]

How would I pass an object to my RowMapper object for it to be used inside mapRow(..)?

Thanks

[Mike Bingham]

One example might be something like:

private class MyRowMapper implements RowMapper {
  private Object myObject;

  public MyRowMapper(Object myObject) {
    this.myObject = myObject;
  }

  public Object mapRow(ResultSet rs, int rowNum) throws SQLException {
    //use myObject here
   ...
  }
}

...

jdbcTemplate.query(sql, new MyRowMapper(myObject));

...