如何从db中获取多条记录并放入数组或map

import java.sql.*;
import java.util.*;

public class DatabaseExample {
    public static void main(String[] args) {
        // 连接数据库
        Connection conn = null;
        try {
            conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydatabase", "username", "password");
            
            // 执行查询语句
            Statement stmt = conn.createStatement();
            ResultSet rs = stmt.executeQuery("SELECT * FROM mytable");
            
            // 遍历结果集
            List<Map<String, Object>> records = new ArrayList<>();
            while (rs.next()) {
                Map<String, Object> record = new HashMap<>();
                record.put("id", rs.getInt("id"));
                record.put("name", rs.getString("name"));
                // 将记录存入数组或map
                records.add(record);
            }
            
            // 输出结果
            for (Map<String, Object> record : records) {
                System.out.println("ID: " + record.get("id") + ", Name: " + record.get("name"));
            }
            
            // 关闭数据库连接
            rs.close();
            stmt.close();
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            if (conn != null) {
                try {
                    conn.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
        }
    }
}