python 连接oceanbase语句，查询一行举例

import jaydebeapi

class OceanBase(object):
    def __init__(self,url,user,password):
        driver= 'com.oceanbase.jdbc.Driver'
        jarFile='oceanbase-client-2.2.10.1.jar'
        self.connection=jaydebeapi.connect(driver,url,[user,password],jarFile)

    def fetch_one(self,sql):
        """
        :param sql:
        :return:
        """
        try:
            conn=self.connection
            cursor=conn.cursor()
            cursor.execute(sql)
            result=cursor.fetchall()
        except Exception as e:
            cursor.close()
            conn.close()
            print('EXECUTE SQL{0} is error {1}'.format(sql,e))
        return result




if __name__ == '__main__':
    url=''
    user=''
    password=''
    sql='select * from dual'
    ob=OceanBase(url,user,password)
    print(ob.fetch_one(sql))