Sometimes you want to hold a ResultSet in a Collection and keep it as light as possible. Here's a way to do it as a List of List. Add the jar to your project and call DbUtils.resultSetToNestedList. The jar, including source code, is HERE
public static List<List<Object>> resultSetToNestedList(ResultSet rs, boolean includeColumnNames) {
try {
// To contain all rows.
List<List<Object>> rows = new ArrayList<List<Object>>();
ResultSetMetaData metaData = rs.getMetaData();
int numberOfColumns = metaData.getColumnCount();
// Include column headers as first row if required
if (includeColumnNames) {
List<Object> columnNames = new ArrayList<Object>();
// Get the column names
for (int column = 0; column < numberOfColumns; column++) {
columnNames.add(metaData.getColumnLabel(column + 1));
}
rows.add(columnNames);
}
// Get the data
while (rs.next()) {
List<Object> newRow = new ArrayList<Object>();
for (int i = 1; i <= numberOfColumns; i++) {
newRow.add(rs.getObject(i));
}
rows.add(newRow);
}
return rows;
} catch (Exception e) {
e.printStackTrace();
return null;
}
}
