jsp连接服务器上的数据库

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

<%
    // 导入数据库驱动程序
    Class.forName("com.mysql.jdbc.Driver");

    // 建立数据库连接
    String url = "jdbc:mysql://localhost:3306/mydatabase";
    String username = "root";
    String password = "password";
    Connection conn = DriverManager.getConnection(url, username, password);

    // 执行数据库操作
    Statement stmt = conn.createStatement();
    String sql = "SELECT * FROM mytable";
    ResultSet rs = stmt.executeQuery(sql);

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

    // 关闭数据库连接
    rs.close();
    stmt.close();
    conn.close();
%>