jsp实现数据库连接

<%@ page import="java.sql.*" %>
<%
    String url = "jdbc:mysql://localhost:3306/mydatabase";
    String username = "root";
    String password = "password";

    try {
        // 加载MySQL数据库驱动
        Class.forName("com.mysql.cj.jdbc.Driver");

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

        // 创建Statement对象
        Statement stmt = conn.createStatement();

        // 执行SQL查询语句
        String sql = "SELECT * FROM users";
        ResultSet rs = stmt.executeQuery(sql);

        // 处理查询结果
        while (rs.next()) {
            String name = rs.getString("name");
            int age = rs.getInt("age");
            out.println("Name: " + name + ", Age: " + age + "<br>");
        }

        // 关闭资源
        rs.close();
        stmt.close();
        conn.close();
    } catch (ClassNotFoundException | SQLException e) {
        out.println("Error: " + e.getMessage());
    }
%>