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