python制作一个简单的制作一个简单的gui 数据库查询界面数据库查询界面
一、准备工作:一、准备工作:
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()
评论1