import oracledb

# 初始化 Oracle 客户端（Thick 模式）
oracledb.init_oracle_client(lib_dir="/usr/lib/oracle/client64/lib")

# 配置 Oracle 数据库连接信息
username = "scott"  # Oracle 用户名
password = "Yahua3585668"  # Oracle 密码
dsn = "192.168.81.8:1521/orcl"  # 数据库的连接描述符，例如"localhost:1521/orclpdb1"

try:
    # 连接到 Oracle 数据库
    connection = oracledb.connect(user=username, password=password, dsn=dsn)
    print("Connected to Oracle Database")

    # 执行查询
    with connection.cursor() as cursor:
        cursor.execute("SELECT * FROM DEPT")
        for row in cursor:
            print(row)

except oracledb.DatabaseError as e:
    print(f"Error connecting to Oracle Database: {e}")

finally:
    if connection:
        connection.close()