ssh jsp页面连接数据库

<%@ page import="java.sql.*" %>
<%@ page import="com.jcraft.jsch.*" %>

<%
    try {
        // 加载JDBC驱动
        Class.forName("com.mysql.jdbc.Driver");

        // 配置SSH隧道
        JSch jsch = new JSch();
        Session session = jsch.getSession("username", "remote_host", 22);
        session.setPassword("password");
        session.setConfig("StrictHostKeyChecking", "no");
        session.connect();

        // 建立本地端口转发
        int assignedPort = session.setPortForwardingL(3307, "localhost", 3306);
        System.out.println("SSH Tunnel Established. Forwarding port: " + assignedPort);

        // 连接数据库
        String url = "jdbc:mysql://localhost:" + assignedPort + "/mydatabase";
        String dbUser = "dbusername";
        String dbPassword = "dbpassword";
        Connection conn = DriverManager.getConnection(url, dbUser, dbPassword);

        // 执行查询
        Statement stmt = conn.createStatement();
        ResultSet rs = stmt.executeQuery("SELECT * FROM mytable");

        // 显示结果
        while (rs.next()) {
            out.println(rs.getString("columnName"));
        }

        // 关闭连接
        rs.close();
        stmt.close();
        conn.close();
        session.disconnect();
    } catch (Exception e) {
        out.println("Error: " + e.getMessage());
    }
%>