jsp如何加入mysql数据库

<%@ page import="java.sql.*" %>
<%
    // 数据库连接参数
    String url = "jdbc:mysql://localhost:3306/mydatabase";
    String username = "root";
    String password = "mypassword";

    Connection conn = null;
    Statement stmt = null;
    ResultSet rs = null;

    try {
        // 加载JDBC驱动
        Class.forName("com.mysql.cj.jdbc.Driver");

        // 建立连接
        conn = DriverManager.getConnection(url, username, password);

        // 创建Statement对象
        stmt = conn.createStatement();

        // 执行查询
        String sql = "SELECT id, name FROM users";
        rs = stmt.executeQuery(sql);

        // 遍历结果集并输出
        while (rs.next()) {
            out.println("ID: " + rs.getInt("id") + ", Name: " + rs.getString("name") + "<br>");
        }
    } catch (ClassNotFoundException e) {
        out.println("JDBC驱动加载失败！");
    } catch (SQLException e) {
        out.println("数据库操作失败：" + e.getMessage());
    } finally {
        // 关闭资源
        try {
            if (rs != null) rs.close();
            if (stmt != null) stmt.close();
            if (conn != null) conn.close();
        } catch (SQLException e) {
            out.println("关闭数据库连接失败：" + e.getMessage());
        }
    }
%>