-
-
Save sahilpaudel/94b506b8408709caabc956ab3b209a3e to your computer and use it in GitHub Desktop.
Java - Convert a ResultSet to a List of Maps, where each Map is a row of data
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/** | |
* Convert the ResultSet to a List of Maps, where each Map represents a row with columnNames and columValues | |
* @param rs | |
* @return | |
* @throws SQLException | |
*/ | |
private List<Map<String, Object>> resultSetToList(ResultSet rs) throws SQLException { | |
ResultSetMetaData md = rs.getMetaData(); | |
int columns = md.getColumnCount(); | |
List<Map<String, Object>> rows = new ArrayList<Map<String, Object>>(); | |
while (rs.next()){ | |
Map<String, Object> row = new HashMap<String, Object>(columns); | |
for(int i = 1; i <= columns; ++i){ | |
row.put(md.getColumnName(i), rs.getObject(i)); | |
} | |
rows.add(row); | |
} | |
return rows; | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment