Convert resultset object to list of map

Convert the resultset object to list of map


In some cases, while we doing API automation, we need to fetch the value from the DB and have to validate it. in such a case the value which we get can be convert into List of map will be easy to iterate. 

	private List<Map<String, String>> resultsetToMap(ResultSet resultObject) throws SQLException {
	List<Map<String, String>> keyAndFields = new ArrayList<>();
	if (resultObject == null) {
	return null;
	}
	while (resultObject.next()) {
	Map<String, String> columnNameAndFields = new HashMap<>();
	int counter = 1;
	while (counter <= resultObject.getMetaData().getColumnCount()) {
	String columnName = resultObject.getMetaData().getColumnLabel(counter);
	String value = String.valueOf(resultObject.getObject(counter));
	columnNameAndFields.put(columnName, value);
	counter++;
	}
	keyAndFields.add(columnNameAndFields);
	}
	return keyAndFields;
	}

view raw gistfile1.txt hosted with ❤ by GitHub