目录
1.创建数据库表
2.ER图
3.实现功能简述
4.部分功能页面展示
5.python代码
6.不足说明
1.创建数据库表
系统主要的处理对象有：订单信息、寄件人信息、收件人信息、配送员信息。具体数据类型设置如下：
寄件人表：姓名、身份证号、地址、性别、电话号码。
收件人表：姓名、身份证号、地址、性别、电话号码。
配送员表：姓名、工号、身份证号、性别、电话号码。
订单表：订单编号、运输时间、物流站、快递员、寄件人、收件人、商品、价格。
2.ER图
3.实现功能简述
该系统主要分为两个模块，分别面对管理员及游客这两类应用人员，管理员具有对数据进行增删查改操作的最高权限；游客仅被赋予了查询订单权限，不可以对数据进行增删改操作。
管理员进入正式操作窗口之前需要进行身份验证，当且仅当输入已有账号及对应密码后（此处需要提前在库中添加一个管理员表（manger），表中有账户名称和账户密码两个元素）才能进入实际操作页面，游客只需点击首页游客登录按钮即可进入查询页面进行查询操作。
该系统利用python代码实现，总共分为八个部分，分别是系统开始首页面、管理员登录页面、管理员注册页面、管理员信息选择操作页面、人员信息操作选择页面、收件人/寄件人/配送员信息操作页面、订单信息操作页面以及游客订单查询页面。
本系统页面显示主要由tkinter库完成，系统页面的背景插入主要由PIL库实现，PyCharm连接MySQL Workbench实现数据库sql语句的应用及对数据的相关管理工作。
4.部分功能页面展示
首页：
管理员登录页面：
管理员注册页面：
收件人/寄件人/配送员信息操作页面，三个页面结构相同，以下只展示第一个页面：
订单信息操作页面：
游客操作页面：
5.python代码
import pymysqlfrom tkinter import *from tkinter.messagebox import *from tkinter import ttkimport tkinter as tkimport tkinter.font as tkFontfrom PIL import Image,ImageTkdef delButton(tree):x = tree.get_children()for item in x:tree.delete(item)def back(root):root.destroy()StartPage()image1=Noneimg1=None#(1)物流信息管理系统def StartPage():global image1global img1root=tk.Tk()root.title('物流信息管理系统')root.geometry('490x650+500+100')root['background']='white'image1 = Image.open('1.png')img1 = ImageTk.PhotoImage(image1)Label(root,image=img1).pack()#place(relx=0,rely=0)Button(root, text="管理员登录", font=tkFont.Font(size=16), command=lambda: Login(root), width=25,height=2, fg='black', bg='gainsboro', activebackground='black', activeforeground='white').place(relx=0.21,rely=0.45)Button(root, text="游客登录", font=tkFont.Font(size=16), command=lambda:GuestPage(root), width=25,height=2, fg='black', bg='gainsboro', activebackground='black', activeforeground='white').place(relx=0.21,rely=0.6)Button(root, text='退出系统', height=2, font=tkFont.Font(size=16), width=25, command=root.destroy,fg='black', bg='gainsboro', activebackground='black', activeforeground='white').place(relx=0.21,rely=0.75)root.mainloop()image2=Noneimg2=None#(2)管理员登录页面def Login(root):global image2global img2root.destroy()root= tk.Tk()root.title('管理员登录页面')root.geometry('1200x700+200+50')root['background']='white'image2 = Image.open('6.png')img2 = ImageTk.PhotoImage(image2)Label(root,image=img2).pack()Label(root, text='账号：',font=("楷体", 15),bg='white').place(relx=0.4,rely=0.35)Label(root, text='密码：',font=("楷体", 15),bg='white').place(relx=0.4,rely=0.45)username=StringVar()pwd=StringVar()entry_username=Entry(root,textvariable=username, show=None)entry_username.place(relx=0.45, rely=0.35, relwidth=0.2,relheight=0.039)entry_pwd = Entry(root, textvariable=pwd, show='*')entry_pwd.place(relx=0.45, rely=0.45, relwidth=0.2,relheight=0.039)Button(root, text="登录", width=15, font=tkFont.Font(size=15), command=lambda:sign_in(root, entry_username, entry_pwd),fg='black', activebackground='black', activeforeground='white').place(relx=0.47,rely=0.57)Button(root, text="注册", width=15, font=tkFont.Font(size=15),command=lambda:register_Page(root),fg='black',activebackground='black', activeforeground='white').place(relx=0.47,rely=0.65)root.protocol('WM_DELETE_WINDOW', lambda:back(root))root.mainloop()#(2.1)def sign_in(root, entry_username, entry_pwd):db = pymysql.connect(host="localhost", user="root",\password="root", db="fu_logistics", port=3306)cur = db.cursor()sql="select * from manger where username='%s'"%(entry_username.get())try:cur.execute(sql)result = cur.fetchone()mima=result[1]except:showinfo(title='提示', message='账号/密码错误！')cur.close()db.close()if mima==entry_pwd.get():MangerChoosePage(root)else:showinfo(title='提示', message='账号/密码错误！')image8=Noneimg8=None#（3）管理员注册页面def register_Page(root):global image8global img8root.destroy()root=Tk()root.title('管理员注册页面')root.geometry('1200x700+200+50')root['background']='white'image8 = Image.open('7.png')img8 = ImageTk.PhotoImage(image8)Label(root,image=img8).pack()Label(root, text='输入账号：',font=("楷体", 15),bg='white').place(relx=0.4,rely=0.35)Label(root, text='输入密码：',font=("楷体", 15),bg='white').place(relx=0.4,rely=0.45)Label(root, text='确认密码：',font=("楷体", 15),bg='white').place(relx=0.4,rely=0.55)username=StringVar()pwd=StringVar()sure_pwd=StringVar()entry_username=Entry(root,textvariable=username, show=None)entry_username.place(relx=0.495, rely=0.35, relwidth=0.2,relheight=0.039)entry_pwd = Entry(root, textvariable=pwd, show='*')entry_pwd.place(relx=0.495, rely=0.45, relwidth=0.2,relheight=0.039)entry_sure_pwd = Entry(root, textvariable=sure_pwd, show='*')entry_sure_pwd.place(relx=0.495, rely=0.55, relwidth=0.2,relheight=0.039)Button(root, text="注册", width=15, font=tkFont.Font(size=15),command=lambda:register(root,entry_username,entry_pwd,entry_sure_pwd),fg='black',activebackground='black', activeforeground='white').place(relx=0.47,rely=0.65)Button(root, text="退出", width=15, font=tkFont.Font(size=15),command=lambda:Login(root),fg='black',activebackground='black', activeforeground='white').place(relx=0.47,rely=0.75)root.protocol('WM_DELETE_WINDOW', lambda:Login(root))root.mainloop()#(3.1)def register(root,entry_username,entry_pwd,entry_sure_pwd):db = pymysql.connect(host="localhost", user="root",password="root", db="fu_logistics", port=3306)cur = db.cursor()sql="insert into manger values('%s','%s')"% (entry_username.get(),entry_pwd.get())cur.execute("select * from manger where username='%s'"%(entry_username.get()))result = cur.fetchall()if result:showinfo('提示','该账号已存在，请重新输入！')else:if len(entry_pwd.get())==6:if entry_sure_pwd.get()==entry_pwd.get():cur.execute(sql)mit()showinfo('提示','注册成功！')Login(root)else:showinfo('提示','两次输入密码不相同，请重新输入！')else:showinfo("提示","请输入六位数密码！")cur.close()db.close()image3 = Noneimg3 = None# (4)管理员信息选择操作页面def MangerChoosePage(root):global image3global img3root.destroy()root = Tk()root.title('管理员信息选择操作页面')root.geometry('600x750+500+40') # ('950x700')root['background'] = 'white'image3 = Image.open('8.png')img3 = ImageTk.PhotoImage(image3)Label(root, image=img3).pack()Button(root, text="人员信息操作", font=tkFont.Font(size=16), command=lambda: Manger_user_Page(root), width=25,height=2, fg='black', bg='gainsboro', activebackground='black', activeforeground='white').place(relx=0.22,rely=0.3)Button(root, text="订单信息操作", font=tkFont.Font(size=16), command=lambda: MangerPage(root), width=25,height=2, fg='black', bg='gainsboro', activebackground='black', activeforeground='white').place(relx=0.22,rely=0.5)Button(root, text='退出', height=2, font=tkFont.Font(size=16), width=25, command=lambda: back(root),fg='black', bg='gainsboro', activebackground='black', activeforeground='white').place(relx=0.22, rely=0.7)root.protocol('WM_DELETE_WINDOW', lambda: back(root))root.mainloop()image4=Noneimg4=None#(5)人员信息操作页面def Manger_user_Page(root):global image4global img4root.destroy()root = Tk()root.geometry('565x600+500+80')root.title('人员信息操作页面')root['background']='white'image4 = Image.open('4.png')img4 = ImageTk.PhotoImage(image4)Label(root,image=img4).pack()Button(root, text="收件人信息操作",activebackground='gainsboro',font=('楷体',15), command=lambda: Uers_infor_Page(root=root,table='recipient')).place(relx=0.27, rely=0.4, width=250)Button(root, text="寄件人信息操作",activebackground='gainsboro',font=('楷体',15), command=lambda: Uers_infor_Page(root=root,table='sender')).place(relx=0.27, rely=0.52, width=250)Button(root, text="配送员信息操作", activebackground='gainsboro',font=('楷体',15), command=lambda: Uers_infor_Page(root=root,table='distributor')).place(relx=0.27, rely=0.64, width=250)Button(root, text="退出", activebackground='gainsboro',font=('楷体',15), command=lambda:MangerChoosePage(root)).place(relx=0.27, rely=0.76, width=250)root.protocol('WM_DELETE_WINDOW', lambda:MangerChoosePage(root))root.mainloop()image6=Noneimg6=None#(6)收件人、寄件人、配送员信息操作页面def Uers_infor_Page(root,table):global image6global img6root.destroy()root=Tk()root.geometry('900x700+300+50')if table=='recipient':Title='收件人'+'信息操作页面'temp1='身份证号'temp2='地址'elif table=='distributor':Title='配送员'+'信息操作页面'temp1= '工号'temp2='身份证号'else:Title='寄件人'+'信息操作页面'temp1= '身份证号'temp2='地址'root.title(Title)root['background']='floralwhite'image6 = Image.open('3.jpeg')img6 = ImageTk.PhotoImage(image6)Label(root,text=Title,compound='bottom',image=img6,font=('楷体',30),fg='blue',bg='floralwhite').pack()Label(root, text="姓名：").place(relx=0.02, rely=0.08, relwidth=0.1)Label(root, text=temp1+'：').place(relx=0.5, rely=0.08, relwidth=0.1)Label(root, text=temp2+'：').place(relx=0.02, rely=0.14, relwidth=0.1)Label(root, text="性别：").place(relx=0.5, rely=0.14, relwidth=0.1)Label(root, text="电话号码：").place(relx=0.02, rely=0.2, relwidth=0.1)name = StringVar()ID = StringVar()address = StringVar()sex = StringVar()phonenumber = StringVar()entry_name = Entry(root, textvariable=name )entry_name.place(relx=0.12, rely=0.08, relwidth=0.3, height=25)entry_ID = Entry(root, textvariable=ID)entry_ID.place(relx=0.6, rely=0.08, relwidth=0.3, height=25)entry_address = Entry(root, textvariable=address)entry_address.place(relx=0.12, rely=0.14, relwidth=0.3, height=25)entry_sex = Entry(root, textvariable=sex)entry_sex.place(relx=0.6, rely=0.14, relwidth=0.3, height=25)entry_phonenumber = Entry(root, textvariable=phonenumber)entry_phonenumber.place(relx=0.12, rely=0.2, relwidth=0.3, height=25)list1=[entry_name,entry_ID,entry_address,entry_sex,entry_phonenumber]Tree1 = ttk.Treeview(root, show='headings',column=('name','ID','address','sex','phonenumber'))Tree1.column('name', width=50, anchor="center")Tree1.column('ID', width=70, anchor="center")Tree1.column('address', width=40, anchor="center")Tree1.column('sex', width=70, anchor="center")Tree1.column('phonenumber', width=70, anchor="center")# 表格标题设置Tree1.heading('name', text='姓名')Tree1.heading('ID', text=temp1)Tree1.heading('address', text=temp2)Tree1.heading('sex', text='性别')Tree1.heading('phonenumber', text='电话号码')Tree1.place(relx=0.01,rely=0.5, relwidth=0.98)def treeviewClick(event):item = Tree1.selection()[0]item_text = Tree1.item(item, "values")entry_name.delete(0, 'end')entry_ID.delete(0, 'end')entry_address.delete(0, 'end')entry_sex.delete(0, 'end')entry_phonenumber.delete(0, 'end')entry_name.insert(0, item_text[0])entry_ID.insert(0, item_text[1])entry_address.insert(0, item_text[2])entry_sex.insert(0, item_text[3])entry_phonenumber.insert(0, item_text[4])Button(root, text="显示所有人员信息", command=lambda: showAll_user_Info(tree=Tree1,table=table)).place(relx=0.12, rely=0.3, width=120)Button(root, text="增加人员信息", command=lambda: append_user_Info(tree=Tree1, list=list1,table=table)).place(relx=0.32, rely=0.3,width=120)Button(root, text="删除人员信息", command=lambda: delete_user_Info(tree=Tree1,table=table)).place(relx=0.52, rely=0.3, width=120)Button(root, text="更改人员信息", command=lambda: update_user_Info(tree=Tree1, list=list1,table=table)).place(relx=0.72, rely=0.3,width=120)Button(root, text="根据姓名查找", command=lambda: find_use_Info(tree=Tree1,table=table,entry=entry_name,flag='name')).place(relx=0.02, rely=0.38,width=135)Button(root, text="根据"+temp1+"查找", command=lambda: find_use_Info(tree=Tree1,table=table,entry=entry_ID,flag='ID')).place(relx=0.22, rely=0.38,width=135)Button(root, text="根据"+temp2+"查找", command=lambda: find_use_Info(tree=Tree1,table=table,entry=entry_address,flag='address')).place(relx=0.42, rely=0.38,width=135)Button(root, text="根据性别查找", command=lambda: find_use_Info(tree=Tree1,table=table,entry=entry_sex,flag='sex')).place(relx=0.62, rely=0.38,width=135)Button(root, text="根据电话号码查找", command=lambda: find_use_Info(tree=Tree1,table=table,entry=entry_phonenumber,flag="phonenumber")).place(relx=0.82, rely=0.38,width=135)Tree1.bind('<ButtonRelease-1>', treeviewClick)root.protocol('WM_DELETE_WINDOW', lambda:Manger_user_Page(root))root.mainloop()#(6.1)def showAll_user_Info(tree,table):delButton(tree)db = pymysql.connect(host="localhost", user="root",password="root", db="fu_logistics", port=3306)cur = db.cursor() #用db操作游标if table=='recipient':sql="select * from recipient"elif table=='sender':sql="select * from sender"else:sql="select * from distributor"cur.execute(sql) # 执行sql语句#fetchone()返回一条记录（元组），没有结果则返回none#fetchall()返回所有元组，构成一个二维元组results = cur.fetchall()for item in results:tree.insert('', "end", values=item)cur.close()db.close() # 关闭连接#(6.2)def append_user_Info(tree,list,table):delButton(tree)list2 = []for i in range(len(list)):if list[i].get() == '':showerror(title='提示', message='输入不能为空!')returnelse:list2.append(list[i].get())x = tree.get_children()for item in x:tree.delete(item)db = pymysql.connect(host="localhost", user="root",password="root", db="fu_logistics", port=3306)cur = db.cursor()try:if table == 'recipient':sql1 = "insert into recipient values('%s','%s','%s','%s','%s')"% (list2[0], list2[1], list2[2], list2[3], list2[4])elif table == 'sender':sql1 = "insert into sender values('%s','%s','%s','%s','%s')"% (list2[0], list2[1], list2[2], list2[3], list2[4])else:sql1 = "insert into distributor values('%s','%s','%s','%s','%s')"% (list2[0], list2[1], list2[2], list2[3], list2[4])cur.execute(sql1)mit()if table == 'recipient':sql = "select * from recipient"elif table == 'sender':sql = "select * from sender"else:sql = "select * from distributor"cur.execute(sql)results = cur.fetchall()for item in results:tree.insert('', "end", values=item)showinfo(title='提示', message='添加/更改成功！')except:showinfo(title='提示', message='该人员/编号已存在！')returncur.close()db.close()#(6.3)def delete_user_Info(tree,table):if not tree.selection():showerror(title='提示', message='请选择一条信息！')returnres=askyesno('提示','是否确认删除？')if res==True:for item in tree.selection():selectedItem = tree.selection()[0]no1 = tree.item(selectedItem, 'values')[1]tree.delete(item)if table == 'recipient':sql = "delete from recipient where RID = '%s' " % no1elif table == 'sender':sql = "delete from sender where SID = '%s' " % no1else:sql = "delete from distributor where Dnum = '%s' " % no1db = pymysql.connect(host="localhost", user="root",password="root", db="fu_logistics", port=3306)cur = db.cursor()cur.execute(sql)mit()cur.close()db.close()showinfo(title='提示', message='删除成功！')#(6.4)def update_user_Info(tree, list,table):if not tree.selection():showerror(title='提示', message='请选择一条信息！')returnelse:res=askyesno("提示","是否确认更新数据？")if res==True:for item in tree.selection():selectedItem = tree.selection()[0]no1 = tree.item(selectedItem, 'values')[1]tree.delete(item)if table == 'recipient':sql = "delete from recipient where RID = '%s' " % no1elif table == 'sender':sql = "delete from sender where SID = '%s' " % no1else:sql = "delete from distributor where Dnum = '%s' " % no1db = pymysql.connect(host="localhost", user="root",password="root", db="fu_logistics", port=3306)cur = db.cursor()cur.execute(sql)mit()cur.close()db.close()append_user_Info(tree, list,table)return#(6.5)def find_sql_line(table,flag,entry):if table=='recipient':if flag=='name':sql = "select * from recipient where Rname = '%s'"%(entry.get())elif flag=='ID':sql = "select * from recipient where RID = '%s'"%(entry.get())elif flag=='address':sql = "select * from recipient where Raddress = '%s'"%(entry.get())elif flag=='sex':sql = "select * from recipient where Rsex = '%s'"%(entry.get())else:sql = "select * from recipient where Rphonenumber = '%s'"%(entry.get())elif table=='sender':if flag=='name':sql = "select * from sender where Sname = '%s'"%(entry.get())elif flag=='ID':sql = "select * from sender where SID = '%s'"%(entry.get())elif flag=='address':sql = "select * from sender where Saddress = '%s'"%(entry.get())elif flag=='sex':sql = "select * from sender where Ssex = '%s'"%(entry.get())else:sql = "select * from sender where Sphonenumber = '%s'"%(entry.get())else:if flag=='name':sql = "select * from distributor where Dname = '%s'"%(entry.get())elif flag=='ID':sql = "select * from distributor where Dnum = '%s'"%(entry.get())elif flag=='address':sql = "select * from distributor where DID = '%s'"%(entry.get())elif flag=='sex':sql = "select * from distributor where Dsex = '%s'"%(entry.get())else:sql = "select * from distributor where Dphonenumber = '%s'"%(entry.get())return sql#(6.6)def find_use_Info(tree,table,entry,flag):delButton(tree)db = pymysql.connect(host="localhost", user="root", password="root", db="fu_logistics", port=3306)cur = db.cursor()sql=find_sql_line(table=table,flag=flag,entry=entry)cur.execute(sql)results = cur.fetchall()if results:for item in results:tree.insert('', "end", values=item)else:showinfo(title='提示', message='无该信息！')cur.close()db.close()image7=Noneimg7=None#（7）订单信息操作页面def MangerPage(root1):global image7global img7root1.destroy()root1 = Tk()root1.geometry('1000x700+300+50')root1.title('订单信息操作页面')root1['background']='floralwhite'image7 = Image.open('2.jpeg')img7 = ImageTk.PhotoImage(image7)Label(root1, text='订单信息操作页面',bg='floralwhite', fg='blue', font=('楷体', 20),compound='bottom',image=img7).pack()Label(root1, text="订单编号：",font=('楷体', 13)).place(relx=0.5, rely=0.07, relwidth=0.1)Label(root1, text="运输时间：",font=('楷体', 13)).place(relx=0.5, rely=0.12, relwidth=0.1)Label(root1, text="物流站：",font=('楷体', 13)).place(relx=0.5, rely=0.17, relwidth=0.1)Label(root1, text="快递员：",font=('楷体', 13)).place(relx=0.5, rely=0.22, relwidth=0.1)Label(root1, text="寄件人：",font=('楷体', 13)).place(relx=0.5, rely=0.27, relwidth=0.1)Label(root1, text="收件人：",font=('楷体', 13)).place(relx=0.5, rely=0.32, relwidth=0.1)Label(root1, text="商品：",font=('楷体', 13)).place(relx=0.5, rely=0.37, relwidth=0.1)Label(root1, text="价格：",font=('楷体', 13)).place(relx=0.5, rely=0.42, relwidth=0.1)Onum = StringVar()Odelivery_time = StringVar()Olog_station = StringVar()Odistributor = StringVar()Osender = StringVar()Orecipient = StringVar()Ogoods = StringVar()Oprice = StringVar()entry_Onum = Entry(root1, textvariable=Onum)entry_Onum.place(relx=0.6, rely=0.07, relwidth=0.3, height=25)entry_Odelivery_time = Entry(root1, textvariable=Odelivery_time)entry_Odelivery_time.place(relx=0.6, rely=0.12, relwidth=0.3, height=25)entry_Olog_station = Entry(root1, textvariable=Olog_station)entry_Olog_station.place(relx=0.6, rely=0.17, relwidth=0.3, height=25)entry_Odistributor = Entry(root1, textvariable=Odistributor)entry_Odistributor.place(relx=0.6, rely=0.22, relwidth=0.3, height=25)entry_Osender = Entry(root1, textvariable=Osender)entry_Osender.place(relx=0.6, rely=0.27, relwidth=0.3, height=25)entry_Orecipient = Entry(root1, textvariable=Orecipient)entry_Orecipient.place(relx=0.6, rely=0.32, relwidth=0.3, height=25)entry_Ogoods = Entry(root1, textvariable=Ogoods)entry_Ogoods.place(relx=0.6, rely=0.37, relwidth=0.3, height=25)entry_Oprice = Entry(root1, textvariable=Oprice)entry_Oprice.place(relx=0.6, rely=0.42, relwidth=0.3, height=25)list1 = [entry_Onum, entry_Odelivery_time, entry_Olog_station, entry_Odistributor, entry_Osender, entry_Orecipient,entry_Ogoods, entry_Oprice]Tree1 = ttk.Treeview(root1, show='headings',column=('Onum', 'Odelivery_time', 'Olog_station', 'Odistributor', 'Osender', 'Orecipient', 'Ogoods', 'Oprice'))Tree1.column('Onum', width=50, anchor="center")Tree1.column('Odelivery_time', width=70, anchor="center")Tree1.column('Olog_station', width=40, anchor="center")Tree1.column('Odistributor', width=70, anchor="center")Tree1.column('Osender', width=70, anchor="center")Tree1.column('Orecipient', width=70, anchor="center")Tree1.column('Ogoods', width=70, anchor="center")Tree1.column('Oprice', width=40, anchor="center")Tree1.heading('Onum', text='订单编号')Tree1.heading('Odelivery_time', text='运输时间')Tree1.heading('Olog_station', text='物流站')Tree1.heading('Odistributor', text='快递员')Tree1.heading('Osender', text='寄件人')Tree1.heading('Orecipient', text='收件人')Tree1.heading('Ogoods', text='商品')Tree1.heading('Oprice', text='价格')Tree1.place(rely=0.5, relwidth=1)Button(root1, text="根据编号查找",activebackground='gray',font=('楷体',13), command=lambda:findInfo(check=1, tree=Tree1, list=list1) ).place(relx=0.15, rely=0.17, width=150)Button(root1, text="查询所有订单",activebackground='gray',font=('楷体',13), command=lambda: showAllInfo(tree=Tree1)).place(relx=0.15, rely=0.10, width=150)Button(root1, text="增加订单", activebackground='gray',font=('楷体',13), command=lambda: appendInfo(tree=Tree1, list=list1)).place(relx=0.15, rely=0.24, width=150)Button(root1, text="删除订单", activebackground='gray',font=('楷体',13), command=lambda: deleteInfo(tree=Tree1)).place(relx=0.15, rely=0.31, width=150)Button(root1, text="更改订单信息", activebackground='gray',font=('楷体',13), command=lambda: updateInfo(tree=Tree1, list=list1)).place(relx=0.15, rely=0.38, width=150)def treeviewClick(event):item = Tree1.selection()[0]item_text = Tree1.item(item, "values")entry_Onum.delete(0, 'end')entry_Odelivery_time.delete(0, 'end')entry_Olog_station.delete(0, 'end')entry_Odistributor.delete(0, 'end')entry_Osender.delete(0, 'end')entry_Orecipient.delete(0, 'end')entry_Ogoods.delete(0, 'end')entry_Oprice.delete(0, 'end')entry_Onum.insert(0, item_text[0])entry_Odelivery_time.insert(0, item_text[1])entry_Olog_station.insert(0, item_text[2])entry_Odistributor.insert(0, item_text[3])entry_Osender.insert(0, item_text[4])entry_Orecipient.insert(0, item_text[5])entry_Ogoods.insert(0, item_text[6])entry_Oprice.insert(0, item_text[7])Tree1.bind('<ButtonRelease-1>', treeviewClick)root1.protocol('WM_DELETE_WINDOW', lambda:MangerChoosePage(root1))root1.mainloop()#(7.1)def showAllInfo(tree):delButton(tree)db = pymysql.connect(host="localhost", user="root",password="root", db="fu_logistics", port=3306)cur = db.cursor() #用db操作游标cur.execute("select * from orders")results = cur.fetchall()for item in results:tree.insert('', "end", values=item)cur.close()db.close() # 关闭连接#(7.2)def appendInfo(tree,list):delButton(tree)list2 = []for i in range(len(list)):if list[i].get() == '':showerror(title='提示', message='输入不能为空!')returnelse:list2.append(list[i].get())x = tree.get_children()for item in x:tree.delete(item)db = pymysql.connect(host="localhost", user="root",password="root", db="fu_logistics", port=3306)cur = db.cursor()try:cur.execute("insert into orders values('%s','%s','%s','%s','%s','%s','%s','%s')" % (list2[0], list2[1], list2[2], list2[3], list2[4], list2[5], list2[6], list2[7]))mit()#对数据进行修改、删除、插入时最好都commit一下,跟在execute()后面cur.execute("select * from orders")results = cur.fetchall()for item in results:tree.insert('', "end", values=item)showinfo(title='提示', message='添加/更新成功！')except:showinfo(title='提示', message='该编号已存在！')returncur.close()db.close()#(7.3)def deleteInfo(tree):if not tree.selection():showerror(title='提示', message='请选择一条信息！')returnres = askyesno('提示！', '是否确认删除？')if res == True:for item in tree.selection():selectedItem = tree.selection()[0]no1 = tree.item(selectedItem, 'values')[0]tree.delete(item)db = pymysql.connect(host="localhost", user="root",password="root", db="fu_logistics", port=3306)cur = db.cursor()cur.execute("delete from orders where Onum = '%s'" % no1)mit()cur.close()db.close()showinfo(title='提示', message='删除成功！')#(7.4)def updateInfo(tree, list):if not tree.selection():showerror(title='提示', message='请选择一条信息！')returnelse:res=askyesno("提示！","是否确认更新数据？")if res==True:for item in tree.selection():selectedItem = tree.selection()[0]no1 = tree.item(selectedItem, 'values')[0]tree.delete(item)db = pymysql.connect(host="localhost", user="root",password="root", db="fu_logistics", port=3306)cur = db.cursor()cur.execute("delete from orders where Onum = '%s'" % no1)mit()cur.close()db.close()appendInfo(tree, list)return#(7.5)def findInfo(check, tree, list):if check:delButton(tree)db = pymysql.connect(host="localhost", user="root",password="root", db="fu_logistics", port=3306)cur = db.cursor()cur.execute("select * from orders where Onum = '%s'" % list[0].get()) # 执行sql语句results = cur.fetchall()if results:for item in results:tree.insert('', "end", values=item)else:showinfo(title='提示', message='无该订单编号！')cur.close()db.close()image5=Noneimg5=None#(8)游客订单信息查询页面def GuestPage(root):global image5global img5root.destroy()root=Tk()root.title('游客订单信息查询页面')root.geometry('850x730+300+50')root['background']='white'image5 = Image.open('5.png')img5 = ImageTk.PhotoImage(image5)Label(root,text='游客订单信息查询页面',compound='bottom',image=img5,bg='floralwhite',fg='blue',font=('楷体',20)).pack(side=TOP, fill='x')Label(root,text='订单编号：',font=('楷体',13)).place(relx=0.07,rely=0.15,relwidth=0.15)Label(root, text='收件人姓名：',font=('楷体',13)).place(relx=0.07, rely=0.25, relwidth=0.15)Label(root, text='寄件人姓名：',font=('楷体',13)).place(relx=0.07, rely=0.35, relwidth=0.15)Label(root, text='配送时间：',font=('楷体',13)).place(relx=0.07, rely=0.45, relwidth=0.15)Onum=StringVar()Rname=StringVar()Sname=StringVar()Odeliver_time=StringVar()entry_Onum = Entry(root, textvariable=Onum)entry_Onum.place(relx=0.2, rely=0.15, relwidth=0.3, height=25)entry_Rname = Entry(root, textvariable=Rname)entry_Rname.place(relx=0.2, rely=0.25, relwidth=0.3, height=25)entry_Sname = Entry(root, textvariable=Sname)entry_Sname.place(relx=0.2, rely=0.35, relwidth=0.3, height=25)entry_Odeliver_time = Entry(root, textvariable=Odeliver_time)entry_Odeliver_time.place(relx=0.2, rely=0.45, relwidth=0.3, height=25)Tree1 = ttk.Treeview(root, show='headings',column=('Onum', \'Odelivery_time', 'Olog_station', 'Odistributor', 'Osender', 'Orecipient', 'Ogoods','Oprice'))Tree1.column('Onum', width=50, anchor="center")Tree1.column('Odelivery_time', width=80, anchor="center")Tree1.column('Olog_station', width=40, anchor="center")Tree1.column('Odistributor', width=70, anchor="center")Tree1.column('Osender', width=70, anchor="center")Tree1.column('Orecipient', width=70, anchor="center")Tree1.column('Ogoods', width=70, anchor="center")Tree1.column('Oprice', width=40, anchor="center")# 表格标题设置Tree1.heading('Onum', text='订单编号')Tree1.heading('Odelivery_time', text='运输时间')Tree1.heading('Olog_station', text='物流站')Tree1.heading('Odistributor', text='快递员')Tree1.heading('Osender', text='寄件人')Tree1.heading('Orecipient', text='收件人')Tree1.heading('Ogoods', text='商品')Tree1.heading('Oprice', text='价格')Tree1.place(rely=0.6, relwidth=1)Button(root, text="按编号查询",bg='gainsboro',fg='black',activebackground='grey',font=('楷体',13), command=lambda:Find_infor_num(Tree1,entry_Onum)).place(relx=0.65, rely=0.15, width=150)Button(root, text="按姓名查询",bg='gainsboro',fg='black', activebackground='grey',font=('楷体',13), command=lambda:Find_infor_name(Tree1,entry_Rname,entry_Sname)).place(relx=0.65, rely=0.3, width=150)Button(root, text="按时间查询",bg='gainsboro',fg='black', activebackground='grey',font=('楷体',13), command=lambda:Find_infor_time(Tree1,entry_Odeliver_time)).place(relx=0.65, rely=0.45, width=150)root.protocol('WM_DELETE_WINDOW', lambda:back(root))root.mainloop()#(8.1)def Find_infor_num(Tree1,Name):delButton(Tree1)db = pymysql.connect(host="localhost", user="root", password="root", db="fu_logistics", port=3306)cur = db.cursor()cur.execute("select * from orders where Onum = '%s'" % Name.get())results = cur.fetchall() # 获取查询的所有记录if results:for item in results:Tree1.insert('', "end", values=item)else:showinfo(title='提示', message='无该订单编号！')cur.close()db.close()#(8.2)def Find_infor_name(Tree1,Name1,Name2):delButton(Tree1)db = pymysql.connect(host="localhost", user="root", password="root", db="fu_logistics", port=3306)cur = db.cursor()if Name1.get():cur.execute("select * from orders where Orecipient = '%s'" % Name1.get())results = cur.fetchall()if not results:showinfo(title='提示', message='无该收件人！')else:for item in results:Tree1.insert('', "end", values=item)if Name2.get():cur.execute("select * from orders where Osender = '%s'" % Name2.get())results = cur.fetchall()if not results:showinfo(title='提示', message='无该寄件人！')else:for item in results:Tree1.insert('', "end", values=item)cur.close()db.close()#(8.3)def Find_infor_time(Tree1,time):delButton(Tree1)db = pymysql.connect(host="localhost", user="root", password="root", db="fu_logistics", port=3306)cur = db.cursor()ch='%'+time.get()+'%'cur.execute("select * from orders where Odelivery_time like '%s'" % ch)results = cur.fetchall()if results:for item in results:Tree1.insert('', "end", values=item)else:showinfo(title='提示', message='无该配送日期！')cur.close()db.close()if __name__=='__main__':StartPage()
6.不足说明
1.本数据库在创建时，没有添加外码，因此表间数据不具有对应关系，数据插入时不受外码影响。
2.部分代码是根据已创建的数据库结构来对应编写，延展性不强。
3.对部分插入数据无完整语句限制，部分不按实际规则填写的数据也会被写入数据库。
