python之cx_Oracle实现本地exe连接oracle数据库执行命令-526互联

代码实现

# -*-coding:GBK -*-
import os

import cx_Oracle  # 导入cx_Oracle模块
import time


def getData():
    conn = cx_Oracle.connect('username/password@ip:port/orcl')
    cur = conn.cursor()
    sql = "SELECT * from USER where USER_ID = \'12315\'"
    try:
        cur.execute(sql)
        data = cur.fetchall()
        print(data)
        print("----------------------------------------------------")
        print("查询成功")
    except:
        print("查询失败")
    cur.close()  # 关闭游标
    conn.close()  # 断开连接


def updateData():
    conn = cx_Oracle.connect('username/password@ip:port/orcl')
    cur = conn.cursor()
    sql = "update user set state=1"
    try:
        cur.execute(sql)
        conn.commit()  # 必须提交数据
        print("执行 \'update user set state=1\'语句中...")

    except:
        conn.rollback()
        print('执行失败！')
    cur.close()  # 关闭游标
    conn.close()  # 关闭连接


updateData()
print('成功修改数据！请等待3秒，自动退出窗口')
time.sleep(3)