ResultSet to ArrayList conversion example

public ArrayList<ArrayList<Object>> resultSetToArrayList(ResultSet rs) throws SQLException { ResultSetMetaData metaData = rs.getMetaData(); int columns = metaData.getColumnCount(); ArrayList<ArrayList<Object>> al = new ArrayList<ArrayList<Object>>(); while (rs.next()) { ArrayList<Object> record = new ArrayList<Object>(); for (int i = 1; i <= columns; i++) { Object value = rs.getObject(i); record.add(value); } al.add(record); } return al; }