如何在jsp页面中连接mysql数据库

<%
    // 数据库连接参数
    String url = "jdbc:mysql://localhost:3306/your_database_name";
    String username = "your_username";
    String password = "your_password";

    // 创建数据库连接
    Connection conn = null;
    try {
        Class.forName("com.mysql.jdbc.Driver"); // 加载MySQL驱动程序
        conn = DriverManager.getConnection(url, username, password);
        out.println("数据库连接成功！");
    } catch (Exception e) {
        e.printStackTrace();
        out.println("数据库连接失败！");
    } finally {
        if (conn != null) {
            try {
                conn.close();
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
    }
%>

<%
    try {
        Statement stmt = conn.createStatement(); // 创建Statement对象
        String sql = "SELECT * FROM your_table_name";
        ResultSet rs = stmt.executeQuery(sql); // 执行SQL查询语句

        // 处理查询结果
        while (rs.next()) {
            String column1 = rs.getString("column1");
            int column2 = rs.getInt("column2");
            // ...
        }

        rs.close();
        stmt.close();
    } catch (Exception e) {
        e.printStackTrace();
    }
%>