一、准备工作:
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':