jsp如何加入mysql数据库

<%@ page import="java.sql.*" %>
<%
   Connection conn = null;
   String url = "jdbc:mysql://localhost:3306/mydatabase";
   String username = "your-username";
   String password = "your-password";
   
   try {
      Class.forName("com.mysql.jdbc.Driver");
      conn = DriverManager.getConnection(url, username, password);
      
      // 连接成功后可以执行数据库操作
      // ...
      
   } catch (Exception e) {
      e.printStackTrace();
   } finally {
      if (conn != null) {
         try {
            conn.close();
         } catch (SQLException e) {
            e.printStackTrace();
         }
      }
   }
%>

<%
   Statement stmt = null;
   ResultSet rs = null;
   
   try {
      stmt = conn.createStatement();
      rs = stmt.executeQuery("SELECT * FROM mytable");
      
      while (rs.next()) {
         // 处理查询结果
         // ...
      }
      
   } catch (SQLException e) {
      e.printStackTrace();
   } finally {
      if (rs != null) {
         try {
            rs.close();
         } catch (SQLException e) {
            e.printStackTrace();
         }
      }
      
      if (stmt != null) {
         try {
            stmt.close();
         } catch (SQLException e) {
            e.printStackTrace();
         }
      }
   }
%>