ResultSetExtractor for quickly logging a ResultSet

gistfile1.txt

		jdbc.query(sql, singletonMap("id", aggregate.id), new ResultSetExtractor<Object>() {
			@Override
			public Object extractData(ResultSet rs) throws SQLException, DataAccessException {

				int columns = rs.getMetaData().getColumnCount();
				for (int i = 1; i <= columns; i++) {
					if (i > 1) {
						System.out.print(", ");
					}
					System.out.print(rs.getMetaData().getColumnLabel(i));
				}
				System.out.println();

				while (rs.next()) {
					for (int i = 1; i <= columns; i++) {
						if (i > 1) {
							System.out.print(", ");
						}
						System.out.print(rs.getString(i));
					}
					System.out.println();
				}

				return null;
			}
		});
	}