java ssh操作数据库

import com.jcraft.jsch.*;
import java.sql.*;

public class SSHTunnelExample {
    public static void main(String[] args) {
        String sshUser = "your_ssh_user";
        String sshHost = "your_ssh_host";
        int sshPort = 22;
        String dbUser = "your_db_user";
        String dbPassword = "your_db_password";
        String dbName = "your_db_name";
        int localPort = 3307;
        int remotePort = 3306;

        try {
            JSch jsch = new JSch();
            Session session = jsch.getSession(sshUser, sshHost, sshPort);
            session.setPassword("your_ssh_password");
            session.setConfig("StrictHostKeyChecking", "no");
            session.connect();

            int assignedPort = session.setPortForwardingL(localPort, "localhost", remotePort);
            System.out.println("SSH Tunnel established, assigned local port: " + assignedPort);

            Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:" + localPort + "/" + dbName, dbUser, dbPassword);
            Statement stmt = conn.createStatement();
            ResultSet rs = stmt.executeQuery("SELECT * FROM your_table");

            while (rs.next()) {
                System.out.println(rs.getString("your_column"));
            }

            rs.close();
            stmt.close();
            conn.close();
            session.disconnect();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}