警务管理系统 - 综合查询 - 查询家在北京朝阳区的民警

import tkinter as tk from tkinter import ttk import pymysql as py

def zonghechaxunwindow(): def select1(): tree=ttk.Treeview(window) tree['columns']=('id','name','gender','phone','address','remark') tree.column('id',width=90) tree.column('name',width=90) tree.column('gender',width=90) tree.column('phone',width=90) tree.column('address',width=90) tree.column('remark',width=90) tree.heading('id',text='身份证号') tree.heading('name',text='姓名') tree.heading('gender',text='性别') tree.heading('phone',text='联系电话') tree.heading('address',text='家庭住址') tree.heading('remark',text='职位')

    tree.grid(column=0,row=1,sticky='NSEW')
    
    conn=py.connect(host='localhost',user='root',password='houyushan1022',db='police')
    cursor=conn.cursor()
    cursor.execute("select * from person_info where 家庭住址='北京市朝阳区'" )
    list_result=cursor.fetchall()
    x=tree.get_children()
    for item in x:
        tree.delete(item)
    for i in range(len(list_result)):
        tree.insert("",i,text=str(i),values=(list_result[i][0],list_result[i][1],list_result[i][2],list_result[i][3],list_result[i][4],list_result[i][5]))

    conn.commit()
    conn.close()
    
window = tk.Toplevel()
window.title('综合查询')
window.geometry('800x500')
window.resizable(width=False,height=False)

select_button1=tk.Button(window,bg='pink',text='查询家在北京朝阳区的民警',font=("微软雅黑 -20"),width=40,height=1,command=select1)
select_button1.place(x=10,y=370)

window.mainloop()

def zonghechaxun(): zonghechaxunwindow()

root=tk.Tk() root.title('警务管理系统') root.geometry('800x500') root.resizable(width=False,height=False)

zonghe_button=tk.Button(root,bg='pink',text='综合查询',font=("微软雅黑 -20"),width=40,height=2,command=zonghechaxun) zonghe_button.place(x=10,y=200)

root.mainloop()