oracle关联工具

最新推荐文章于 2024-07-22 15:27:09 发布

新垣野结衣

最新推荐文章于 2024-07-22 15:27:09 发布

阅读量164

点赞数

分类专栏： python

本文链接：https://blog.csdn.net/weixin_42162306/article/details/105459499

版权

python 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

用tkinter和cx_oracle，查出数据并进行增删改查。

源码

from tkinter import *
from tkinter import messagebox
import cx_Oracle

app=Tk()
app.title('Database')
app.geometry('500x500+1000+400')
app.canvas = Canvas(app, height=500, width=500)
app.image_file = PhotoImage(file="D:/work/text/lyf3.gif")
app.image = app.canvas.create_image(0, 0, anchor='nw', image=app.image_file)
app.canvas.grid(rowspan=25, columnspan=3)
def bdcdyh_cx():
    conn=cx_Oracle.connect('用户名','密码','IP:端口号/sid')
    cursor=conn.cursor()
    print('connect success')
    sql="sql  "+"'"+entry3.get()+"'sql"
    if entry3.get() =="":
        messagebox.showinfo('error','please input sql')
    else:
        print(sql)
        cursor.execute(sql)
        # colsname=cursor.description#显示列名
        # print(colsname)
        rs=cursor.fetchall()
        for i in rs:
            print(i)
        getsql.set(rs)
        cursor.close()
def zl_cx():
    conn=cx_Oracle.connect('用户名','密码','IP:端口号/sid')
    cursor=conn.cursor()
    print('connect success')
    sql="sql "+"'"+entry3.get()+"'sql"
    # sql=entry.get()
    if entry3.get() =="":
        messagebox.showinfo('error','please input sql')
    else:
        print(sql)
        cursor.execute(sql)
        rs=cursor.fetchall()
        # print(rs)
        for i in rs:
            print(i)
        getsql.set(rs)
        cursor.close()
def qlr_cx():
    conn=cx_Oracle.connect('用户名','密码','IP:端口号/sid')
    cursor=conn.cursor()
    print('connect success')
    sql="sql"+"'%"+entry1.get()+"%'"
    if entry1.get() =="":
        messagebox.showinfo('error','please input sql')
    else:
        print(sql)
        cursor.execute(sql)
        rs=cursor.fetchall()
        for i in rs:
            print(i)
        getsql.set(rs)
        cursor.close()

def qlr():
    write=input()
def zl():
    write1=input()
def bdcdyh():
    write2=input()

getsql=StringVar()
write=StringVar()
write1=StringVar()
write2=StringVar()
button=Button(app,text='查询3',command=bdcdyh_cx)
button.grid(row=0,column=2)
button1=Button(app,text='查询1',command=qlr_cx)
button1.grid(row=0,column=0)
button2=Button(app,text='查询2',command=zl_cx)
button2.grid(row=0,column=1)
button3=Button(app,text='执行')
button3.grid(rowspan=1,column=3)
message=Message(app,bg='black',foreground='white',width=450,textvariable=getsql)
message.grid(row=2,columnspan=3)


entry1=Entry(app,textvariable=write)
entry1.grid(row=1,column=0)

entry2=Entry(app,textvariable=write1)
entry2.grid(row=1,column=1)

entry3=Entry(app,textvariable=write2)
entry3.grid(row=1,column=2)

app.mainloop()