Skip to content

Instantly share code, notes, and snippets.

@ckzgraphics
Forked from rrguntaka/resultset_to_map.java
Last active April 23, 2020 17:02
Show Gist options
  • Save ckzgraphics/a4165ec18cc423da6a4318b7cc4e5b3a to your computer and use it in GitHub Desktop.
Save ckzgraphics/a4165ec18cc423da6a4318b7cc4e5b3a to your computer and use it in GitHub Desktop.
JDBC Result set to Java HashMap
try {
Class.forName(driver);
Connection con = DriverManager.getConnection(url + db, user, pass);
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(query);
ResultSetMetaData rsmd = rs.getMetaData();
List<String> columns = new ArrayList<String>(rsmd.getColumnCount());
for(int i = 1; i <= rsmd.getColumnCount(); i++){
columns.add(rsmd.getColumnName(i));
}
List<Map<String,Object>> data = new ArrayList<Map<String,Object>>();
while(rs.next()){
Map<String,Object> row = new LinkedHashMap<String, Object>(columns.size());
for(String col : columns) {
row.put(col, rs.getString(col));
}
data.add(row);
}
System.out.println(data);
rs.close();
stmt.close();
con.close();
} catch (Exception e) {
System.out.println(e);
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment