Skip to content

Instantly share code, notes, and snippets.

@rrguntaka
rrguntaka / resultset_to_map.java
Created August 15, 2012 15:27
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));
}