# -*-coding:GBK -*-import os
import cx_Oracle # 导入cx_Oracle模块import time
defgetData():
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()# 断开连接defupdateData():
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)