jsp中使用mysql数据库

<%@ page import="java.sql.*" %>
<%
  // 定义数据库连接信息
  String url = "jdbc:mysql://localhost:3306/mydatabase";
  String username = "root";
  String password = "password";
  
  // 建立数据库连接
  Connection conn = null;
  Statement stmt = null;
  ResultSet rs = null;
  try {
    Class.forName("com.mysql.jdbc.Driver");
    conn = DriverManager.getConnection(url, username, password);
  
    // 执行查询语句
    String query = "SELECT * FROM mytable";
    stmt = conn.createStatement();
    rs = stmt.executeQuery(query);
  
    // 处理结果集
    while (rs.next()) {
      String column1 = rs.getString("column1");
      String column2 = rs.getString("column2");
      // 在页面中展示数据
      out.println("Column1: " + column1 + ", Column2: " + column2);
    }
  } catch (Exception e) {
    e.printStackTrace();
  } finally {
    // 关闭连接
    try { rs.close(); } catch (Exception e) {}
    try { stmt.close(); } catch (Exception e) {}
    try { conn.close(); } catch (Exception e) {}
  }
%>