HI,
I have a DB with 3 tables that holds results to some test.
table 1 holds all the static data like location and so on.
table 2 holds all the enviroment data like temperature, time and date for the tests. (One location can have may tests)
Table 3 holds the results sets for the test and has the folowing strucure

Code:
CREATE TABLE results(
	id INTEGER NOT NULL PRIMARY KEY,
	table_1_id INTEGER,
	table_2_id INTEGER,
	n_r INTEGER,
	n_c INTEGER,
	results VARCHAR(10)
);
where n_r is the row number and n_c the collumn

the data originaly comes from a excel table like this where the rows and colums could have a variable length
x, x, x, x, x, x,
x, x, x, x, x, x,

as can be seen below i want to add the results in an ArrayList<ArrayList<String>> to mirror the excel table

using the spring mvc tutorial (http://static.springsource.org/docs/Spring-MVC-step-by-step/part5.html) i have so far been able to adapt it to my needs.

i can populate most of my object which has the following vars

Code:
private int id;
private int measuringFieldNo;
private String location;
private String createdDate;
private String createdTime;
private String temperature;
private ArrayList<ArrayList<String>> results;
at the moment my JdbcMeasuringFieldDao
looks like this

Code:
public List<MeasuringField> getMeasuringFieldList(){
        logger.info("Getting MeasuringFields!");
        String sql = "Using sql satement like
SELECT * FROM table_1, table_2 WHERE table_1.id = table_2.table_1_id";
        List<MeasuringField> measuringFields = getSimpleJdbcTemplate().query(sql, new MeasuringFieldMapper());
        return measuringFields;
    }

and here is the mapper
Code:
private static class MeasuringFieldMapper implements ParameterizedRowMapper<MeasuringField> {
    	ArrayList<ArrayList<String>> results;
    	
    	public MeasuringField mapRow(ResultSet rs, int rowNum) throws SQLException {
        	MeasuringField mf = new MeasuringField();
            mf.setId(rs.getInt("id"));
            mf.setMeasuringFieldNo(rs.getInt("field_no"));
            mf.setLocation(rs.getString("location"));
            mf.setCreatedDate(rs.getString("created_date"));
            mf.setCreatedTime(rs.getString("created_time"));
            mf.setTemperature(rs.getString("temperature"));
            mf.setResults(); //how do i set this
            
            return mf;
        }
        

    }

So here is the actual question:
how can i create my ArrayList with a second query (i know how the sql looks. I just dont know how i can use getSimpleJdbcTemplate().query and a row mapper to make my array. and where do i put it?)
Any help would be great


ps. My tables arnt actually called table 1 2 and 3. Just chanced it for thsake of this question