Java ResultSet轉為List

Java將JDBC資料庫查詢結果java.sql.ResultSet轉為java.util.List的方式如下。

private List<Map<String, Object>> toList(ResultSet rs) throws SQLException {
    List<Map<String, Object>> rowList = new ArrayList<>();
    ResultSetMetaData md = rs.getMetaData();
    int c = md.getColumnCount();
    while(rs.next()) {
        Map<String, Object> row = new HashMap<>();
        for (int i = 1; i <= c; i++) {
            row.put(md.getColumnLabel(i).toLowerCase(), rs.getObject(i)); // lower case key
        }
        rowList.add(row);
    }
    return rowList;
}

• Efficient way to Handle ResultSet in Java