《Python程序设计案例教程》GUI连接数据库

import tkinter as tk
import pymysql
from tkinter import messagebox as mx
win=tk.Tk()
win.title("登录")
win.geometry("500x300+600+300")
config = {
    "host": "127.0.0.1",
    "port": 3306,
    "user": "root",
    "password": "123456",
    "database": "goods",
    "charset": "utf8"
}
l=tk.Label(win,text="商品信息管理系统",fg="red",font=("楷体",20))
l.pack()
l.place(x=150,y=60)
userlabel=tk.Label(win,text="用户名",font=("楷体",15))
userlabel.pack()
userlabel.place(x=120,y=130)
passlabel=tk.Label(win,text="密码",font=("楷体",15))
passlabel.pack()
passlabel.place(x=120,y=180)
userentry=tk.Entry(win)
userentry.pack()
userentry.place(x=220,y=130)
passentry=tk.Entry(win,show="*")
passentry.pack()
passentry.place(x=220,y=180)
def login():
    con=pymysql.connect(**config)
    cur=con.cursor()
    name=userentry.get()
    password=passentry.get()
    sql="select id,name,password from userinfo where name=%s and password=%s"
    cur.execute(sql,(name,password))
    result =cur.fetchall()
    if result:
        #import demo
        print(result)
    else:
        mx.showinfo("提示", "用户名或密码错误")
    con.commit()
    cur.close()
    con.close()
btn=tk.Button(win,text="登录",width=10,height=1,command=login)
btn.pack()
btn.place(x=200,y=240)

win.mainloop()