Created
November 30, 2012 14:07
-
-
Save cworks/4175942 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; | |
} |
dhruvr
commented
Jun 30, 2021
•
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment