|
from tkinter import *
mygui=Tk()
text=Text(width=30,height=3)
text1=Text(width=30,height=3)
text2=Text(width=30,height=3)
text.pack()
text1.pack()
text2.pack()
import pymysql
# 打开数据库连接
def insert():
db = pymysql.connect("localhost","root","123123","qac" )
# 使用cursor()方法获取操作游标
cursor = db.cursor()
# SQL 插入语句
sql = """INSERT INTO user(name,
Password,tele)
VALUES (text,text1,text2)"""
cursor.execute(sql)
db.commit()
db.close()
# 点击鼠标将文本内容插入SQL库
btn1 = Button(text='插入', command=insert)
btn1.place(relx=0.1, rely=0.2, relwidth=0.3, relheight=0.1)
btn1.pack
mainloop()
求大神给修改下
|
|