用jsp连接mysql数据库

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" %>

<%
  // 定义数据库连接信息
  String url = "jdbc:mysql://localhost:3306/mydatabase";
  String username = "root";
  String password = "password";

  // 声明数据库连接对象
  Connection conn = null;

  try {
    // 加载MySQL驱动程序
    Class.forName("com.mysql.jdbc.Driver");

    // 建立数据库连接
    conn = DriverManager.getConnection(url, username, password);

    // 执行SQL语句示例：查询表中所有数据
    String sql = "SELECT * FROM mytable";
    Statement stmt = conn.createStatement();
    ResultSet rs = stmt.executeQuery(sql);

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

    // 关闭结果集、Statement和连接
    rs.close();
    stmt.close();
    conn.close();
  } catch (Exception e) {
    e.printStackTrace();
  }
%>