代码实现
# -*-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)
Pyinstaller打包成exe
pyinstaller -F 文件名.py
参考教程
2个技巧,学会Pyinstaller打包的高级用法