python--ssh连接oracle数据库进行操作

一、ssh连接封装

使用python进行ssh远程连接时，需导入paramiko模块
可支持连接、关闭连接、上传、下载、运行命令等操作

import paramiko

class SSHConnection(object):
    def __init__(self, host, port, username, password):
        self._host = host
        self._port = port
        self._username = username
        self._password = password
        self._transport = None
        self._sftp = None
        self._client = None
        self._connect()

    def _connect(self):
        transport = paramiko.Transport(