python使用jardebeiapi连接多种数据库

Mysql

	conn = jaydebeapi.connect('com.mysql.jdbc.Driver',self.MySqlUrl+'?useSSL=false', [self.MySqlUser, self.MySqlPwd], './mysql-connector-java-5.1.46.jar')
        curs = conn.cursor()

Hive

jarFiles =['./commons-httpclient-3.0.1-sources.jar'
                  ,'./commons-logging-1.3.jar'
                  ,'./curator-client-2.2.0-incubating.jar'
                  ,'./curator-framework-2.6.0.jar'
                  ,'./hadoop-auth-2.7.3.jar'
                  ,'./hadoop-common-2.7.3.jar'
                  ,'./hive-exec-1.2.2.jar'
                  ,'./hive-jdbc-1.2.2.jar'
                  ,'./hive-metastore-1.2.2.jar'
                  ,'./hive-service-1.2.2.jar'
                  ,'./httpclient-4.4.jar'
                  ,'./httpcore-4.4.jar'
                  ,'./slf4j-api-1.7.5.jar'
                  ,'./zookeeper-3.4.6.jar'
                  ,'./hive-common-1.2.2.jar']
        conn = jaydebeapi.connect('org.apache.hive.jdbc.HiveDriver','jdbc:hive2://bigdatasit02.efivestar.com:10000',['hive', ''],jarFiles)
        curs = conn.cursor()

Phoenix

 jarFiles ='./phoenix-5.0.0-HBase-2.0-client.jar'
            params = {'phoenix.schema.isNamespaceMappingEnabled': 'true'}
            conn=jaydebeapi.connect('org.apache.phoenix.jdbc.PhoenixDriver',self.PX_URL,params,jarFiles) 
  params 为设置环境变量

sybase

   jarFiles=['./jtds-1.3.1.jar','./jtds-license.txt','./jtds-win-auth.jar']
        conn = jaydebeapi.connect('net.sourceforge.jtds.jdbc.Driver',self.SybaseUrl,[self.SybaseUser,self.SybasePwd],jarFiles)
        cursor = conn.cursor()

clickhouse

 jarFlies = ['./clickhouse-jdbc-0.1.50d.jar','./clickhouse-license.txt']
        conn = jaydebeapi.connect('ru.yandex.clickhouse.ClickHouseDriver',self.CK_URL,[self.CK_USER,self.CK_PWD],jarFlies)
        cursor = conn.cursor()