Python Tkinter 实现民警信息查询 - 北京市朝阳区

def zonghechaxunwindow():
    def select1():
        tree = ttk.treeview(zonghechaxunwindow)
        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()
        
    select_button1 = tk.Button(zonghechaxunwindow, bg='pink', text='查询家在北京朝阳区的民警', font=("微软雅黑 -20"), width=40, hight=1, command=select1)
    select_button1.place(x=10, y=370)