How to map multiple rows into one object?

[aug828]

Using RowMapper, we can map one row into one object (or more, though a little weird).
But how to use RowMapper to map multiple rows into one object?
For example,

rows from database:

id      value	catagory
1        spring	  season
1        warm 	  temperature
2        summer	  season
2        hot	  temperature

Mapped into two objects:

Season spring = new Season("spring", "warm");
Season summer = new Season("summer", "hot");

public class Season{
       private String name;
       private String temperature;
       ....
}