jsp如何连接到mysql数据库实例

<%@ page import="java.sql.*" %>
<%
   Connection conn = null;
   String url = "jdbc:mysql://数据库实例地址:端口号/数据库名";
   String username = "数据库用户名";
   String password = "数据库密码";

   try {
      Class.forName("com.mysql.jdbc.Driver");
      conn = DriverManager.getConnection(url, username, password);
   } catch (Exception e) {
      e.printStackTrace();
   }
%>

<%
   Statement stmt = null;
   ResultSet rs = null;

   try {
      stmt = conn.createStatement();
      String sql = "SELECT * FROM 表名";
      rs = stmt.executeQuery(sql);

      while (rs.next()) {
         // 处理查询结果
      }
   } catch (Exception e) {
      e.printStackTrace();
   } finally {
      // 关闭连接和释放资源
      if (rs != null) {
         try {
            rs.close();
         } catch (Exception e) {
            e.printStackTrace();
         }
      }

      if (stmt != null) {
         try {
            stmt.close();
         } catch (Exception e) {
            e.printStackTrace();
         }
      }

      if (conn != null) {
         try {
            conn.close();
         } catch (Exception e) {
            e.printStackTrace();
         }
      }
   }
%>