jsp连接mysql数据库

以下是连接MySQL数据库的JSP代码示例：

<%@ page language="java" import="java.sql.*" %>
<%
    String driver = "com.mysql.jdbc.Driver";
    String url = "jdbc:mysql://localhost:3306/数据库名";
    String user = "用户名";
    String password = "密码";
    Connection conn = null;
    Statement stmt = null;
    ResultSet rs = null;
    try {
        Class.forName(driver);
        conn = DriverManager.getConnection(url, user, password);
        if (conn != null) {
            out.println("数据库连接成功！");
        }
        stmt = conn.createStatement();
        String sql = "SELECT * FROM 表名";
        rs = stmt.executeQuery(sql);
        while (rs.next()) {
            out.println(rs.getString("字段名"));
        }
    } catch (Exception e) {
        e.printStackTrace();
    } finally {
        try {
            if (rs != null) {
                rs.close();
            }
            if (stmt != null) {
                stmt.close();
            }
            if (conn != null) {
                conn.close();
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
%>

请注意，上述代码仅用于演示如何连接MySQL数据库，实际应用中需要根据具体情况进行修改。

--相关问题--:
1. 如何在JSP中执行SQL语句？
2. 如何在JSP中使用PreparedStatement？
3.