Python连接Oracle的多种方式小结

目录

• 前言
• 1. SQLAlchemy
• 2. oracledb
• 3. cx_Oracle

import oracledb
oracledb.init_oracle_client(lib_dir=r"D:\instantclient_21_10")

connection = oracledb.connect(user='username', password='password', dsn=dsn)

cursor = connection.cursor()
cursor.execute("SELECT * FROM my_table")
results = cursor.fetchall()

try:
    # 执行操作
    pass
except oracledb.DatabaseError as e:
    print(e)

cursor.close()
connection.close()

import oracledb

# 数据库连接信息
dsn = (
    "(DESCRIPTION="
    "(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.197.0.200)(PORT=1521)))"
    "(CONNECT_DATA=(SERVICE_NAME=prod)))"
)
username = 'root'
password = 'root'
oracledb.init_oracle_client(lib_dir=r"D:\instantclient_21_10")
# 创建连接
connection = oracledb.connect(user=username, password=password, dsn=dsn)

try:
    # 创建一个游标
    cursor = connection.cursor()

    # SQL 查询语句
    sql_query = """
    sql语句
    """

    # 执行查询
    cursor.execute(sql_query)

    # 获取所有结果
    results = cursor.fetchall()

    # 打印结果
    for row in results:
        print(row)
except Exception as e:
    print(e)

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

import cx_Oracle

# 设置 Oracle 客户端库路径
cx_Oracle.init_oracle_client(lib_dir=r"D:\instantclient_21_10")

# 连接数据库
dsn = cx_Oracle.makedsn('10.197.0.200', 1521, service_name='prod')
connection = cx_Oracle.connect(user='root', password='root', dsn=dsn)

# 执行查询
cursor = connection.cursor()
query = """
sql语句
"""
cursor.execute(query)
results = cursor.fetchall()

# 打印结果
for row in results:
    print(row)

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