tkinte 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()
#--------------------------------------------------------