Java JDBC resultset to List?

[nick2price2003]

I am trying to put my resultset into a list. Problem is that i want my list to be of type Integer, and the getInteger method takes as a parameter a system property, which i have no idea what this is. This is my code.
String SELECT_TOP_TIMES =
"select TOP 3 r.result " +
"from tblResults as r " +
"where r.Event_ID = " +
"(select e.ID " +
"from tblEvent as e " +
"where e.Event_Name = '100M Run') " +
"and r.Round_ID = " +
"(select ro.ID " +
"from tblRound as ro " +
"where ro.Round_Number = 'Round_1') " +
"order by r.result";


PreparedStatement ps = null;
ResultSet rs = null;
List<Integer> topTimes = new ArrayList<Integer>();

try
{
con = DatabaseUtils.connect(DRIVER, URL);
ps = con.prepareStatement(SELECT_TOP_TIMES);
rs = ps.executeQuery();
while (rs.next())
{
int result = rs.getInteger(1);
topTimes.add(result);
}

System.out.println(topTimes);

}

Any help would be appreciated in getting this to create a list of Integer value.

[?Neeraj Yadav?]

You can either write a data transfer object that encapsulates all those columns, OR you can save them in a List of Maps, where each Map represents one row and the keys are the column names. Here's a method that will do it for you:

/**
* Helper method that converts a ResultSet into a list of maps, one per row
* @param query ResultSet
* @return list of maps, one per row, with column name as the key
* @throws SQLException if the connection fails
*/
public static final List toList(ResultSet rs) throws SQLException
{
List wantedColumnNames = ResultSetMapper.getColumnNames(rs);

return ResultSetMapper.toList(rs, wantedColumnNames);
}
/**
* Helper method that maps a ResultSet into a list of maps, one per row
* @param query ResultSet
* @param list of columns names to include in the result map
* @return list of maps, one per column row, with column names as keys
* @throws SQLException if the connection fails
*/
public static final List toList(ResultSet rs, List wantedColumnNames) throws SQLException
{
List rows = new ArrayList();

int numWantedColumns = wantedColumnNames.size();
while (rs.next())
{
Map row = new TreeMap();

for (int i = 0; i < numWantedColumns; ++i)
{
String columnName = (String)wantedColumnNames.get(i);
Object value = rs.getObject(columnName);
row.put(columnName, value);
}

rows.add(row);
}

return rows;
}




/**
* Return all column names as a list of strings
* @param database query result set
* @return list of column name strings
* @throws SQLException if the query fails
*/
public static final List getColumnNames(ResultSet rs) throws SQLException
{
List columnNames = new ArrayList();

ResultSetMetaData meta = rs.getMetaData();

int numColumns = meta.getColumnCount();
for (int i = 1; i <= numColumns; ++i)
{
columnNames.add(meta.getColumnName(i));
}

return columnNames;
}


Hope this will help
Cheers