Java ResultSet轉List<Map>

Java SQL查詢結果ResultSet轉List<Map>的方式如下。

/**
 * ResultSet轉{@literal List<Map>}
 * @param rs
 */
private List<Map<String, Object>> toList(ResultSet rs) throws SQLException {
    List<Map<String, Object>> list = new ArrayList<>();
    ResultSetMetaData md = rs.getMetaData();
    int c = md.getColumnCount();
    while(rs.next()) {
        Map<String, Object> rm = new HashMap<>();
        for (int i = 1; i <= c; i++) {
            rm.put(md.getColumnLabel(i), rs.getObject(i));
        }
        list.add(colData);
    }
    return list;
}