Python cx_Oracle模块连接本地数据库

 初步了解cx_Oracle之连接本地数据库。

cx-Oracle版本号：8.3.0

import cx_Oracle


def connOra():
    # 设置Oracle数据源名称（DSN）
    #dsn = cx_Oracle.makedsn('localhost', '1521', 'orcl')

    # 创建数据库连接
    #connection = cx_Oracle.connect(user='myora', password='myora', dsn=dsn) #写法一
    #connection = cx_Oracle.connect('myora/myora@localhost:1521/orcl') #写法二
    #connection = cx_Oracle.connect('myora/myora@orcl') #写法三
    connection = cx_Oracle.connect('myora', 'myora', 'localhost:1521/orcl')  #写法四

    # 创建游标对象
    cursor = connection.cursor()

    # 执行SQL查询
    cursor.execute("SELECT * FROM all_all_tables where rownum <=6")

    # 获取查询结果
    rows = cursor.fetchall()
    for row in rows:
        print(row)

    # 关闭游标和连接
    cursor.close()
    connection.close()

if __name__ == '__main__':
    connOra()