python+tkinter+mysql做简单数据库查询界面-木庄网络博客

本文整理自网络，侵删。

一、准备工作：

1、安装mysql3.7，创建一个test数据库，创建student表，创建列：（列名看代码），创建几条数据

（以上工作直接用navicat for mysql工具完成)

二、代码：

import sys
import tkinter as tk
import mysql.connector as sql

#--------------------查询函数---------------------------
def sql_connect():
? ? listbox_show.delete(0,'end') #初始化清空显示区
? ? m = listbox_name.curselection()[0]
? ? print('m=',m)
? ? list_name = listbox_name.get(m)[0]
? ? varlue = entry_varlue.get()
? ? print('list_name=',list_name)
? ? print('var=',varlue)

? ? while list_name == 'Student_ID':
? ? ? ? sql_sr = "select * from Student where student.student_id = " + "'" + varlue +"'"
? ? ? ? print(sql_sr)
? ? ? ? break
? ? while list_name == 'Name':
? ? ? ? sql_sr = "select * from Student where student.name = " + "'" + varlue +"'"
? ? ? ? print(sql_sr)
? ? ? ? break

? ? while list_name == 'Age':
? ? ? ? sql_sr = "select * from Student where student.age = " + "'" + varlue +"'"
? ? ? ? print(sql_sr)
? ? ? ? break
? ? while list_name == 'Sex':
? ? ? ? sql_sr = "select * from Student where student.sex = " + "'" + varlue +"'"
? ? ? ? print(sql_sr)
? ? ? ? break
? ? while list_name == 'Class':
? ? ? ? sql_sr = "select * from Student where student.class = " + "'" + varlue +"'"
? ? ? ? print(sql_sr)
? ? ? ? break

? ? mydb = sql.connect(host='localhost',user='root',passwd='123456',database='test')
? ? mycursor = mydb.cursor()
? ? mycursor.execute(sql_sr)
? ? myresult = mycursor.fetchall()
? ? for x in myresult:
? ? ? ? print (x)
? ? ? ? listbox_show.insert('end',x)
#--------------------------------------------------------


#------------界面初始化时加载选项列表--------------------
sql_n = "SELECT COLUMN_NAME FROM information_schema.COLUMNS \
WHERE TABLE_SCHEMA = 'test' AND TABLE_NAME = 'student'"
mydb = sql.connect(host='localhost',user='root',passwd='123456',database='test')
mycursor = mydb.cursor()
mycursor.execute(sql_n)
myresult = mycursor.fetchall()

#--------------------------------------------------------

#----------窗体部分--------------------------------------
entry_list_name = tk.Entry()
entry_list_name.pack()

listbox_name = tk.Listbox()
listbox_name.pack()
for i in myresult:
? ? listbox_name.insert('end',i) #加载选项列表

entry_varlue = tk.Entry()
entry_varlue.pack()

button_select = tk.Button(text = '查找',command = sql_connect)
button_select.pack()

listbox_show = tk.Listbox()
listbox_show.pack()


root.mainloop()
#--------------------------------------------------------