python使用pymysql模塊操作MySQL
實例一:插入數據
import pymysql import tkinter as tk conn = pymysql.connect(host='localhost', user='root', passwd='root', db='okzl', charset='utf8') master = tk.Tk() master.title("插入供應商信息") master.geometry('350x300') tk.Label(master, text='cName').place(x=30,y=10) tk.Label(master, text='address').place(x=30,y=40) tk.Label(master, text='linkman').place(x=30,y=70) tk.Label(master, text='linkPhone').place(x=30,y=100) tk.Label(master, text='credit').place(x=30,y=130) tk.Label(master, text='remark').place(x=30,y=160) in1=tk.Entry(master, width=30).place(x=100,y=10) in2=tk.Entry(master, width=30).place(x=100,y=40) in3=tk.Entry(master, width=30).place(x=100,y=70) in3=tk.Entry(master, width=30).place(x=100,y=100) in3=tk.Entry(master, width=30).place(x=100,y=130) in3=tk.Entry(master, width=30).place(x=100,y=160) def insert(): cur = conn.cursor() # 伸出手 sql1 = "insert into pro(cName,address,linkman,linkPhone,credit,remark) values(%s,%s,%s,%s,%s,%s)" temp2 = ( ) cur.execute(sql1, temp2) conn.commit() cur.close() tk.Button(master,text='插入',width=8,command=insert).place(x=140,y=220) master.mainloop() conn.close()
成功插入數據
實例二:獲取某個表全部數據
import pymysql conn = pymysql.connect(host='localhost', user='root', passwd='root', db='okzl', charset='utf8') cur = conn.cursor() cur.execute('select * from pro') data = cur.fetchall() cur.close() print(data) conn.close()
實例三:根據cName模糊搜索
import pymysql import tkinter as tk conn = pymysql.connect(host='localhost', user='root', passwd='root', db='okzl', charset='utf8') # 連接數據庫 master = tk.Tk() master.title("搜索某客戶信息") master.geometry('350x300') e = tk.Entry(master) e.pack(padx=20, pady=20) def tosearch(): cur = conn.cursor() temp2 = (e.get(), "%" + e.get() + "%") cur.execute("select * from pro where cName like %s or cName like %s ", temp2) data = cur.fetchall() cur.close() print(data) tk.Button(master, text='搜索', width=8, command=tosearch).pack(padx=20, pady=50) master.mainloop() conn.close()
實例四:修改數據
根據數據庫自動給數據生成的id來確認目標和修改數據
import pymysql import tkinter as tk conn = pymysql.connect(host='localhost', user='root', passwd='root', db='okzl', charset='utf8') master = tk.Tk() master.title("修改供應商信息") master.geometry('350x300') tk.Label(master, text='cName').place(x=30,y=10) tk.Label(master, text='address').place(x=30,y=40) tk.Label(master, text='linkman').place(x=30,y=70) tk.Label(master, text='linkPhone').place(x=30,y=100) tk.Label(master, text='credit').place(x=30,y=130) tk.Label(master, text='remark').place(x=30,y=160) tk.Label(master, text='目標id').place(x=30,y=190) in1=tk.Entry(master, width=30) in1.place(x=100,y=10) in2=tk.Entry(master, width=30) in2.place(x=100,y=40) in3=tk.Entry(master, width=30) in3.place(x=100,y=70) in4=tk.Entry(master, width=30) in4.place(x=100,y=100) in5=tk.Entry(master, width=30) in5.place(x=100,y=130) in6=tk.Entry(master, width=30) in6.place(x=100,y=160) in7=tk.Entry(master, width=30) in7.place(x=100,y=190) def update(): cur = conn.cursor() # 伸出手 sql1 = "update pro set cName=%s, address=%s,linkman=%s,linkPhone=%s,credit=%s,remark=%s where id=%s" temp2 = (in1.get(),in2.get(),in3.get(),in4.get(),in5.get(),in6.get(),in7.get()) cur.execute(sql1, temp2) conn.commit() cur.close() tk.Button(master,text='確認修改',width=8,command=update).place(x=140,y=220) master.mainloop() conn.close()
實例五:刪除數據
這裡是根據id刪除
sql1 = "delete from pro where id=%s" temp1 = str(n) cur.execute(sql1, temp1) conn.commit() cur.close()
上述實例均為基礎實現操作舉例,實際操作中可根據需求更改程序和sql語句實現目標效果
以上就是python使用pymysql模塊操作MySQL的詳細內容,更多關於python 用pymysql操作MySQL的資料請關註WalkonNet其它相關文章!
推薦閱讀:
- Python實戰項目之MySQL tkinter pyinstaller實現學生管理系統
- 詳解Python如何利用pymysql封裝項目通用的連接和查詢
- Python + Tkinter連接本地MySQL數據庫簡單實現註冊登錄
- Python基礎之操作MySQL數據庫
- 教你怎麼用Python操作MySql數據庫