如何在我的jsp中提供Java ResultSet？

<%@ page import="java.sql.DriverManager" %>
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.Statement" %>
<%@ page import="java.sql.ResultSet" %>

<%
    // 加载JDBC驱动程序
    Class.forName("com.mysql.jdbc.Driver");

    // 建立数据库连接
    Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydatabase", "username", "password");

    // 创建Statement对象
    Statement statement = connection.createStatement();

    // 执行SQL查询
    ResultSet resultSet = statement.executeQuery("SELECT * FROM mytable");

    // 遍历结果集并显示数据
    while (resultSet.next()) {
        out.println("ID: " + resultSet.getInt("id") + ", Name: " + resultSet.getString("name") + "<br>");
    }

    // 关闭结果集、Statement和连接
    resultSet.close();
    statement.close();
    connection.close();
%>