python操作oracle 11.2.0.4

python 脚本# -*- coding: utf-8 -*- import oracledb oracledb.init_oracle_client(lib_dir/opt/soft/instantclient_23_26) import traceback # 你的数据库信息 USER test_user PASSWORD ora23Ora23 HOST 192.168.174.145 # 数据库IP PORT 1521 SERVICE_NAME orcl # 服务名关键 # def test_oracle_connection(): try: # 连接数据库重点thin模式 不需要客户端 conn oracledb.connect( userUSER, passwordPASSWORD, hostHOST, portPORT, service_nameSERVICE_NAME ) # 创建游标 cursor conn.cursor() # 1. 查询测试 print( 测试查询数据库当前时间 ) cursor.execute(SELECT sysdate FROM dual) res cursor.fetchone() print(结果, res) # 2. 业务表查询示例 # cursor.execute(SELECT * FROM your_table WHERE id:1, [1001]) # rows cursor.fetchall() # for row in rows: # print(row) # 3. 插入/更新/删除示例 # sql INSERT INTO test(id,name) VALUES (:1, :2) # cursor.execute(sql, [1001, 测试数据]) # conn.commit() # 关闭 cursor.close() conn.close() print(\n✅ oracledb 连接 Oracle 11g 成功) except Exception as e: print(\n❌ 连接失败, e) traceback.print_exc() if __name__ __main__: test_oracle_connection()