如何在jsp页面中获取mysql查询结果？

<%@ page import="java.sql.*" %>
<%@ page import="javax.sql.*" %>

<%
    // 建立与MySQL数据库的连接
    String url = "jdbc:mysql://localhost:3306/mydatabase";
    String username = "root";
    String password = "password";
    Connection connection = DriverManager.getConnection(url, username, password);

    // 执行查询语句
    String query = "SELECT * FROM mytable";
    Statement statement = connection.createStatement();
    ResultSet resultSet = statement.executeQuery(query);

    // 遍历查询结果并展示在页面上
    while (resultSet.next()) {
        String column1 = resultSet.getString("column1");
        String column2 = resultSet.getString("column2");
        // 其他字段...

        // 在页面上展示查询结果
        out.println("Column 1: " + column1 + "<br>");
        out.println("Column 2: " + column2 + "<br>");
        // 其他字段...
    }

    // 关闭数据库连接
    resultSet.close();
    statement.close();
    connection.close();
%>