cworks

/**
 * 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>>();