python基于Tkinter实现人员管理系统

前言

Tkinter是python内置的标准GUI库，基于Tkinter实现了简易人员管理系统，所用数据库为Mongodb

代码

时间宝贵！直接上代码！

from tkinter import *
from tkinter.messagebox import *
from tkinter import ttk
import pymongo
import tkinter as tk
import re
import time
import datetime

import pandas as pd
from tkinter import filedialog
from PIL import ImageTk,Image
import tkinter

#连接数据库
client = pymongo.MongoClient(host="localhost", port=27017)
db = client.sys
col = db.user
#创建窗口
root = Tk()
root.geometry('900x700')
root.title('人员管理系统')
#表头
img =Image.open(r'C:\Users\apple\Desktop\image.jpg')
img = img.resize((900,68),Image.ANTIALIAS)
img = ImageTk.PhotoImage(img)
top=Label(root, text='人员管理系统',image=img,fg='black',font=('楷体', 20),compound='center', bitmap='error')
top.pack(ipady=0,side=TOP, fill='x')
#变量
sid = StringVar()
name = StringVar()
age = StringVar()
salary = StringVar()
phone = StringVar()
birthday = StringVar()

#控制函数

def add():
   global info
   info=Toplevel()
   info.title("添加信息")
   info.geometry('400x400')
   button1=Button(info, text="确认",command=appendInfo,font=("黑体", 12)).place(relx=0.4, rely=0.8, width=100)
   Label(info, text="工号：").place(relx=0.2, rely=0.1, relwidth=0.1)
   Label(info, text="姓名：").place(relx=0.2, rely=0.2, relwidth=0.1)
   Label(info, text="年龄：").place(relx=0.2, rely=0.3, relwidth=0.1)
   Label(info, text="薪资：").place(relx=0.2, rely=0.4, relwidth=0.1)
   Label(info, text="电话：").place(relx=0.2, rely=0.5, relwidth=0.1)
   Label(info, text="生日：").place(relx=0.2, rely=0.6, relwidth=0.1)
   text1=Entry(info, textvariable=sid).place(relx=0.3, rely=0.1, relwidth=0.45, height=25)
   sid.set("")
   text2=Entry(info, textvariable=name).place(relx=0.3, rely=0.2, relwidth=0.45, height=25)
   name.set("")
   text3=Entry(info, textvariable=age).place(relx=0.3, rely=0.3, relwidth=0.45, height=25)
   age.set("")
   text4=Entry(info, textvariable=salary).place(relx=0.3, rely=0.4, relwidth=0.45, height=25)
   salary.set("")
   text5=Entry(info, textvariable=phone).place(relx=0.3, rely=0.5, relwidth=0.45, height=25)
   phone.set("")
   text6=Entry(info, textvariable=birthday).place(relx=0.3, rely=0.6, relwidth=0.45, height=25)
   birthday.set("")
   info.bind('<Return>',pas8)
#     info.bind_all('<KeyPress-Up>',movetriangle)
#     info.bind_all('<KeyPress-Down>',movetriangle)
#     info.bind_all('<KeyPress-Left>',movetriangle)
#     .bind_all('<KeyPress-Right>',movetriangle)

def pitch_on():
   global info
   info=Toplevel()
   info.title("删除信息")
   info.geometry('400x400')
   Label(info, text="是否确定删除以下信息",font=('楷体', 15)).place(relx=0.2, rely=0.01, relwidth=0.6)
   Label(info, text="工号：").place(relx=0.2, rely=0.1, relwidth=0.1)
   Label(info, text="姓名：").place(relx=0.2, rely=0.2, relwidth=0.1)
   Label(info, text="年龄：").place(relx=0.2, rely=0.3, relwidth=0.1)
   Label(info, text="薪资：").place(relx=0.2, rely=0.4, relwidth=0.1)
   Label(info, text="电话：").place(relx=0.2, rely=0.5, relwidth=0.1)
   Label(info, text="生日：").place(relx=0.2, rely=0.6, relwidth=0.1)
   text1=Entry(info, textvariable=sid,state='disable').place(relx=0.3, rely=0.1, relwidth=0.45, height=25)
   sid.set(sf[0])
   text2=Entry(info, textvariable=name,state='disable').place(relx=0.3, rely=0.2, relwidth=0.45, height=25)
   name.set(sf[1])
   text3=Entry(info, textvariable=age,state='disable').place(relx=0.3, rely=0.3, relwidth=0.45, height=25)
   age.set(sf[2])
   text4=Entry(info, textvariable=salary,state='disable').place(relx=0.3, rely=0.4, relwidth=0.45, height=25)
   salary.set(sf[3])
   text5=Entry(info, textvariable=phone,state='disable').place(relx=0.3, rely=0.5, relwidth=0.45, height=25)
   phone.set(sf[4])
   text6=Entry(info, textvariable=birthday,state='disable').place(relx=0.3, rely=0.6, relwidth=0.45, height=25)
   birthday.set(sf[5])
   button1=Button(info, text="确认",command=deleteInfo).place(relx=0.2, rely=0.8, width=100)
   button2=Button(info, text="关闭",command=des).place(relx=0.6, rely=0.8, width=100)
   info.bind('<Return>',pas33)

def information2():
   global info
   info=Toplevel()
   info.title("详细信息")
   info.geometry('400x400')
   button1=Button(info, text="更新信息",command=updateInfo).place(relx=0.4, rely=0.8, width=100)
   Label(info, text="工号：").place(relx=0.2, rely=0.1, relwidth=0.1)
   Label(info, text="姓名：").place(relx=0.2, rely=0.2, relwidth=0.1)
   Label(info, text="年龄：").place(relx=0.2, rely=0.3, relwidth=0.1)
   Label(info, text="薪资：").place(relx=0.2, rely=0.4, relwidth=0.1)
   Label(info, text="电话：").place(relx=0.2, rely=0.5, relwidth=0.1)
   Label(info, text="生日：").place(relx=0.2, rely=0.6, relwidth=0.1)
   text1=Entry(info, textvariable=sid,state='disable').place(relx=0.3, rely=0.1, relwidth=0.45, height=25)
   sid.set(sf[0])
   text2=Entry(info, textvariable=name).place(relx=0.3, rely=0.2, relwidth=0.45, height=25)
   name.set(sf[1])
   text3=Entry(info, textvariable=age).place(relx=0.3, rely=0.3, relwidth=0.45, height=25)
   age.set(sf[2])
   text4=Entry(info, textvariable=salary).place(relx=0.3, rely=0.4, relwidth=0.45, height=25)
   salary.set(sf[3])
   text5=Entry(info, textvariable=phone).place(relx=0.3, rely=0.5, relwidth=0.45, height=25)
   phone.set(sf[4])
   text6=Entry(info, textvariable=birthday).place(relx=0.3, rely=0.6, relwidth=0.45, height=25)
   birthday.set(sf[5])
   info.bind('<Return>',pas11)

def des():
   info.destroy()

def information(event):
   item=dataTreeview.selection()
   itemvalues=dataTreeview.item(item,'values')
   global info
   info=Toplevel()
   info.title("详细信息")
   info.geometry('400x400')
   button1=Button(info, text="更新信息",command=updateInfo).place(relx=0.4, rely=0.8, width=100)

Label(info, text="工号：").place(relx=0.2, rely=0.1, relwidth=0.1)
   Label(info, text="姓名：").place(relx=0.2, rely=0.2, relwidth=0.1)
   Label(info, text="年龄：").place(relx=0.2, rely=0.3, relwidth=0.1)
   Label(info, text="薪资：").place(relx=0.2, rely=0.4, relwidth=0.1)
   Label(info, text="电话：").place(relx=0.2, rely=0.5, relwidth=0.1)
   Label(info, text="生日：").place(relx=0.2, rely=0.6, relwidth=0.1)
   text1=Entry(info, textvariable=sid,state='disable').place(relx=0.3, rely=0.1, relwidth=0.45, height=25)
   sid.set(itemvalues[0])
   text2=Entry(info, textvariable=name).place(relx=0.3, rely=0.2, relwidth=0.45, height=25)
   name.set(itemvalues[1])
   text3=Entry(info, textvariable=age).place(relx=0.3, rely=0.3, relwidth=0.45, height=25)
   age.set(itemvalues[2])
   text4=Entry(info, textvariable=salary).place(relx=0.3, rely=0.4, relwidth=0.45, height=25)
   salary.set(itemvalues[3])
   text5=Entry(info, textvariable=phone).place(relx=0.3, rely=0.5, relwidth=0.45, height=25)
   phone.set(itemvalues[4])
   text6=Entry(info, textvariable=birthday).place(relx=0.3, rely=0.6, relwidth=0.45, height=25)
   birthday.set(itemvalues[5])

def isVaildDate(date):
       try:
           time.strptime(date, "％Y-％m-％d")
           return True
       except:
           return False

def showAllInfo():
   x = dataTreeview.get_children()
   for item in x:
       dataTreeview.delete(item)
   lst=col.find({},{'_id':0})
   for item in lst:
       i=list(item.values())
       dataTreeview.insert("", 1, text="line1", values=i)
def pas1(self):
   showAllInfo()

def pas2(self):
   add()

def pas3(self):
   pitch_on()

def pas33(self):
   deleteInfo()

def pas4(self):
   information2()

def pas5(self):
   searchInfo()

def pas55(self):
   search()

def pas6(self):
   impInfo()

def pas7(self):
   exp()

def pas8(self):
   appendInfo()

def pas9(self):
   global sf
   sf=dataTreeview.selection()
   sf=dataTreeview.item(sf,'values')

def pas10(self):
   expInfo()

def pas11(self):
   updateInfo()

def appendInfo():
   flag=1
   if sid.get() == "":
       showerror(title='提示', message='输入不能为空')
       flag=0
   if sid.get().isdigit() == False:
       showerror(title='提示', message='格式错误')
       sid.set("")
       flag=0

if name.get() == "":
       showerror(title='提示', message='输入不能为空')
       flag=0

if age.get() == "":
       showerror(title='提示', message='输入不能为空')
       flag=0
   if age.get().isdigit() == False:
       showerror(title='提示', message='格式错误')
       age.set("")
       flag=0

if salary.get() == "":
       showerror(title='提示', message='输入不能为空')
       flag=0
   if salary.get().isdigit() == False:
       showerror(title='提示', message='格式错误')
       salary.set("")
       flag=0

if phone.get() == "":
       showerror(title='提示', message='输入不能为空')
       flag=0
   if phone.get().isdigit() == False:
       showerror(title='提示', message='格式错误')
       phone.set("")
       flag=0

if birthday.get() == "":
       showerror(title='提示', message='输入不能为空')
       flag=0
   if isVaildDate(str(birthday.get())) == False:
       showerror(title='提示', message='格式错误')
       birthday.set("")
       flag=0
   if flag==1:
       x = dataTreeview.get_children()
       for item in x:
           dataTreeview.delete(item)
       list1 = {
               "work_number":sid.get(),
               "name":name.get(),
               "age":age.get(),
               "salary":salary.get(),
               "phone":phone.get(),
               "birthday":birthday.get()
           }
       col.insert_one(list1)
       lst=col.find({},{'_id':0})
       for item in lst:
           i=list(item.values())
           dataTreeview.insert("", 1, text="line1", values=i)
       info.destroy()

def deleteInfo():
   lst=list(col.find({},{'_id':0}))
   num = sid.get()
   flag = 0
   for i in range(len(lst)):
       if str(num)==str(lst[i].get("work_number")):
           flag = 1
           col.delete_one({'work_number':num})
           break

x = dataTreeview.get_children()
   for item in x:
       dataTreeview.delete(item)

lst=col.find({},{'_id':0})
   for item in lst:
       i=list(item.values())
       dataTreeview.insert("", 1, text="line1", values=i)
   info.destroy()

#更新操作
def updateInfo():
   sid_1 = sid.get()
   name_1 = name.get()
   age_1 = age.get()
   salary_1 = salary.get()
   phone_1 = phone.get()
   birthday_1 = birthday.get()
   flag=1
   if sid.get() == "":
       showerror(title='提示', message='输入不能为空')
       flag=0
   if sid.get().isdigit() == False:
       showerror(title='提示', message='格式错误')
       sid.set("")
       flag=0

if name.get() == "":
       showerror(title='提示', message='输入不能为空')
       flag=0

if age.get() == "":
       showerror(title='提示', message='输入不能为空')
       flag=0
   if age.get().isdigit() == False:
       showerror(title='提示', message='格式错误')
       age.set("")
       flag=0

if salary.get() == "":
       showerror(title='提示', message='输入不能为空')
       flag=0
   if salary.get().isdigit() == False:
       showerror(title='提示', message='格式错误')
       salary.set("")
       flag=0

if phone.get() == "":
       showerror(title='提示', message='输入不能为空')
       flag=0
   if phone.get().isdigit() == False:
       showerror(title='提示', message='格式错误')
       phone.set("")
       flag=0

if birthday.get() == "":
       showerror(title='提示', message='输入不能为空')
       flag=0
   if isVaildDate(str(birthday.get())) == False:
       showerror(title='提示', message='格式错误')
       birthday.set("")
       flag=0
   if flag==1:
       up={
           "work_number":sid_1,
           "name":name_1,
           "age":age_1,
           "salary":salary_1,
           "phone":phone_1,
           "birthday":birthday_1
       }

old=col.find_one({'work_number': sid_1},{"_id": 0})
       col.update_one(old, {'$set':up})
       x = dataTreeview.get_children()
       for item in x:
           dataTreeview.delete(item)
       lst=col.find({},{'_id':0})
       for item in lst:
           i=list(item.values())
           dataTreeview.insert("", 1, text="line1", values=i)
       showinfo(title='提示', message='更新成功！')
       des()

#搜索页面
def search():
   global info
   info=Toplevel()
   info.title("搜索信息")
   info.geometry('400x400')
   button1=Button(info, text="确认搜索",command=searchInfo).place(relx=0.4, rely=0.8, width=100)
   Label(info, text="工号：").place(relx=0.2, rely=0.1, relwidth=0.1)
   Label(info, text="姓名：").place(relx=0.2, rely=0.2, relwidth=0.1)
   Label(info, text="年龄：").place(relx=0.2, rely=0.3, relwidth=0.1)
   Label(info, text="薪资：").place(relx=0.2, rely=0.4, relwidth=0.1)
   Label(info, text="电话：").place(relx=0.2, rely=0.5, relwidth=0.1)
   Label(info, text="生日：").place(relx=0.2, rely=0.6, relwidth=0.1)
   text1=Entry(info, textvariable=sid).place(relx=0.3, rely=0.1, relwidth=0.45, height=25)
   sid.set("")
   text2=Entry(info, textvariable=name).place(relx=0.3, rely=0.2, relwidth=0.45, height=25)
   name.set("")
   text3=Entry(info, textvariable=age).place(relx=0.3, rely=0.3, relwidth=0.45, height=25)
   age.set("")
   text4=Entry(info, textvariable=salary).place(relx=0.3, rely=0.4, relwidth=0.45, height=25)
   salary.set("")
   text5=Entry(info, textvariable=phone).place(relx=0.3, rely=0.5, relwidth=0.45, height=25)
   phone.set("")
   text6=Entry(info, textvariable=birthday).place(relx=0.3, rely=0.6, relwidth=0.45, height=25)
   birthday.set("")
   info.bind('<Return>',pas5)
#搜索操作    
def searchInfo():
   lst=list(col.find({},{'_id':0}))
   sid_1 = sid.get()
   name_1 = name.get()
   age_1 = age.get()
   salary_1 = salary.get()
   phone_1 = phone.get()
   birthday_1 = birthday.get()
   flag=1
#     if sid.get().isdigit() == False:
# #         showerror(title='提示', message='格式错误')
#         sid.set("")
#         flag=0
#     if age.get().isdigit() == False:
# #         showerror(title='提示', message='格式错误')
#         age.set("")
#         flag=0
#     if salary.get().isdigit() == False:
# #         showerror(title='提示', message='格式错误')
#         salary.set("")
#         flag=0

#     if phone.get().isdigit() == False:
# #         showerror(title='提示', message='格式错误')
#         phone.set("")
#         flag=0
#     if isVaildDate(str(birthday.get())) == False:
# #         showerror(title='提示', message='格式错误')
#         birthday.set("")
#         flag=0
#     if flag==0:
#         showerror(title='提示', message='格式错误')
   if flag==1:
       fla = 0
       v=[]
       for i in range(len(lst)):
           if sid_1==str(lst[i].get("work_number")):
               fla = 1
               v.append(lst[i].values())
               continue
           elif name_1==lst[i].get("name"):
               fla = 1
               v.append(lst[i].values())
               continue
           elif age_1==lst[i].get("age"):
               fla = 1
               v.append(lst[i].values())
               continue
           elif salary_1==lst[i].get("salary"):
               fla= 1
               v.append(lst[i].values())
               continue
           elif phone_1==lst[i].get("phone"):
               fla = 1
               v.append(lst[i].values())
               continue
           elif birthday_1==lst[i].get("birthday"):
               fla= 1
               v.append(lst[i].values())
               continue
       if fla == 0:
           showerror(title='提示', message='无此信息，搜索失败！')
       x = dataTreeview.get_children()
       for item in x:
           dataTreeview.delete(item)
       for i in v:
           dataTreeview.insert("", 1, text="line1", values=list(i))
       des()

def impInfo():
   root1 = Tk()
   root1.withdraw()
   Folderpath = filedialog.askdirectory() #获得选择好的文件夹
   Filepath = filedialog.askopenfilename() #获得选择好的文件
   data=pd.read_csv(Filepath)

for i in range(len(data.values)):
       j=list(data.values[i])
       lst=col.find({},{'_id':0})
       flag=0
       for item in lst:
           i=list(item.values())
           if str(j[0])== str(i[0]):
               flag=1
               break
       if flag==0:
           list1 = {
                   "work_number":str(j[0]),
                   "name":j[1],
                   "age":j[2],
                   "salary":j[3],
                   "phone":j[4],
                   "birthday":j[5]
               }
           col.insert_one(list1)
   showinfo(title='提示', message='导入成功，可刷新！')

x = dataTreeview.get_children()
   for item in x:
       dataTreeview.delete(item)
   lst=col.find({},{'_id':0})
   for item in lst:
       i=list(item.values())
       dataTreeview.insert("", 1, text="line1", values=i)

def xFunc(event):
   a=xVariable.get()  

def exp():
   global info
   info=Toplevel()
   info.title("保存信息")
   info.geometry('500x200')
   button1=Button(info, text="确认备份",command=expInfo).place(relx=0.4, rely=0.8, width=100)
   Label(info, text="路径：",font=("黑体", 10)).place(relx=0.05, rely=0.2, relwidth=0.2)
   button2=Button(info, text="选择本地",command=selection).place(relx=0.8, rely=0.2, width=70)
   Label(info, text="文件名：",font=("黑体", 10)).place(relx=0.05, rely=0.4, relwidth=0.2)
   com = ttk.Combobox(info, textvariable=xVariable)
   com.place(relx=0.8, rely=0.4, width=70)
   com["value"] = (".csv", ".html", ".xlsx",".xls")    # #给下拉菜单设定值
   com.current(2)
   com.bind("<<ComboboxSelected>>", xFunc)     # #给下拉菜单绑定事件
   text1=Entry(info, textvariable=path).place(relx=0.25, rely=0.2, relwidth=0.5, height=25)
   text2=Entry(info, textvariable=file_name).place(relx=0.25, rely=0.4, relwidth=0.5, height=25)
   info.bind('<Return>',pas10)

def selection():
   root2 = Tk()
   root2.withdraw()
   Folderpath = filedialog.askdirectory() #获得选择好的文件夹
   path.set(str(Folderpath))

def expInfo():
   lst=col.find({},{'_id':0})
   df =  pd.DataFrame(list(lst))
   ftp=xVariable.get()
   file = path.get()+'/'+file_name.get()+xVariable.get()  
   print(file)
   if ftp=='.csv':
       df.to_csv(file,index=False,header=True)
   elif ftp=='.xlsx':
       df.to_excel(file,index=False,header=True)
   elif ftp=='.xls':
       df.to_excel(file,index=False,header=True)
   elif ftp=='.html':
       df.to_html(file,index=False,header=True)
   showinfo(title='提示', message='备份成功！')
   des()

path = StringVar()
file_name = StringVar()
xVariable = tkinter.StringVar()
#页面布局            
Button(root, text="刷新信息",command=showAllInfo,font=("黑体", 12),relief="raised", bd=7).place(relx=0.03, rely=0.15, width=120,height=50)
root.bind('<F3>',pas1)
Button(root, text="添加信息",command=add,font=("黑体", 12),relief="raised", bd=7).place(relx=0.03, rely=0.25, width=120,height=50)
root.bind('<F4>',pas2)
Button(root, text="删除信息",command=pitch_on,font=("黑体", 12),relief="raised", bd=7).place(relx=0.03, rely=0.35, width=120,height=50)
root.bind('<BackSpace>',pas3)
Button(root, text="更新信息",command=information2,font=("黑体", 12),relief="raised", bd=7).place(relx=0.03, rely=0.45, width=120,height=50)
root.bind('<Control-A>',pas4)
Button(root, text="搜索信息",command=search,font=("黑体", 12),relief="raised", bd=7).place(relx=0.03, rely=0.55, width=120,height=50)
root.bind('<Control-S>',pas55)
Button(root, text="导入数据",command=impInfo,font=("黑体", 12),relief="raised", bd=7).place(relx=0.03, rely=0.65, width=120,height=50)
root.bind('<Control-D>',pas6)
Button(root, text="导出数据",command=exp,font=("黑体", 12),relief="raised", bd=7).place(relx=0.03, rely=0.75, width=120,height=50)
root.bind('<Control-W>',pas7)

dataTreeview = ttk.Treeview(root, show='headings',height=20, column=('sid', 'name', 'age','salary','phone','birthday'))
dataTreeview.column('sid', width=10, anchor="center")
dataTreeview.column('name', width=10, anchor="center")
dataTreeview.column('age', width=10, anchor="center")
dataTreeview.column('salary', width=10, anchor="center")
dataTreeview.column('phone', width=10, anchor="center")
dataTreeview.column('birthday', width=10, anchor="center")
style_value = ttk.Style()
style_value.configure("dataTreeview", rowheight=20, font=("微软雅黑", 30))
dataTreeview.tag_configure('tag_odd',background="red",foreground="blue")
dataTreeview.tag_configure('tag_even',background="black",foreground="orange")
scrollBar=Scrollbar(width=20)
scrollBar.pack(side=RIGHT,fill=Y)
scrollBar.config(command=dataTreeview.yview)

dataTreeview.heading('sid', text='工号')
dataTreeview.heading('name', text='姓名')
dataTreeview.heading('age', text='年龄')
dataTreeview.heading('salary', text='薪水')
dataTreeview.heading('phone', text='电话')
dataTreeview.heading('birthday', text='生日')
dataTreeview.bind('<Double-Button-1>',information)
dataTreeview.bind('<ButtonRelease-1>',pas9)
x = dataTreeview.get_children()
for item in x:
   dataTreeview.delete(item)
lst=col.find({},{'_id':0})
for item in lst:
   i=list(item.values())
   dataTreeview.insert("", 1, text="line1", values=i)
dataTreeview.place(relx=0.2,rely=0.1, relwidth=0.78,relheight=20)

root.mainloop()

效果展示

来源：https://blog.csdn.net/m0_55762164/article/details/121497501