devbox
盐析白兔
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

数据库课程设计：物流信息管理系统（PyCharm+MySQL）_物流管理数据库实训

作者：盐析白兔 | 2024-05-02 16:14:24

赞

踩

物流管理数据库实训

目录

1.创建数据库表

2.ER图

3.实现功能简述

4.部分功能页面展示

 5.python代码 

6.不足说明

1.创建数据库表

系统主要的处理对象有：订单信息、寄件人信息、收件人信息、配送员信息。具体数据类型设置如下：

寄件人表：姓名、身份证号、地址、性别、电话号码。

收件人表：姓名、身份证号、地址、性别、电话号码。

配送员表：姓名、工号、身份证号、性别、电话号码。

订单表：订单编号、运输时间、物流站、快递员、寄件人、收件人、商品、价格。

2.ER图

3.实现功能简述

该系统主要分为两个模块，分别面对管理员及游客这两类应用人员，管理员具有对数据进行增删查改操作的最高权限；游客仅被赋予了查询订单权限，不可以对数据进行增删改操作。

管理员进入正式操作窗口之前需要进行身份验证，当且仅当输入已有账号及对应密码后（此处需要提前在库中添加一个管理员表（manger），表中有账户名称和账户密码两个元素）才能进入实际操作页面，游客只需点击首页游客登录按钮即可进入查询页面进行查询操作。

该系统利用python代码实现，总共分为八个部分，分别是系统开始首页面、管理员登录页面、管理员注册页面、管理员信息选择操作页面、人员信息操作选择页面、收件人/寄件人/配送员信息操作页面、订单信息操作页面以及游客订单查询页面。

本系统页面显示主要由tkinter库完成，系统页面的背景插入主要由PIL库实现，PyCharm连接MySQL Workbench实现数据库sql语句的应用及对数据的相关管理工作。

4.部分功能页面展示

首页：

 管理员登录页面：

 管理员注册页面：

 收件人/寄件人/配送员信息操作页面，三个页面结构相同，以下只展示第一个页面：

 订单信息操作页面：

 游客操作页面：

 5.python代码 

  1. import pymysql
  2. from tkinter import *
  3. from tkinter.messagebox import *
  4. from tkinter import ttk
  5. import tkinter as tk
  6. import tkinter.font as tkFont
  7. from PIL import Image,ImageTk
  8.  
  9. def delButton(tree):
  10.     x = tree.get_children()
  11.     for item in x:
  12.         tree.delete(item)
  13.  
  14. def back(root):
  15.     root.destroy()
  16.     StartPage()
  17.  
  18. image1=None
  19. img1=None
  20. #(1)物流信息管理系统
  21. def StartPage():
  22.     global image1
  23.     global img1
  24.     root=tk.Tk()
  25.     root.title('物流信息管理系统')
  26.     root.geometry('490x650+500+100')
  27.     root['background']='white'
  28.     image1 = Image.open('1.png')
  29.     img1 = ImageTk.PhotoImage(image1)
  30.     Label(root,image=img1).pack()#place(relx=0,rely=0)
  31.     Button(root, text="管理员登录", font=tkFont.Font(size=16), command=lambda: Login(root), width=25,
  32.                height=2, fg='black', bg='gainsboro', activebackground='black', activeforeground='white').place(relx=0.21,rely=0.45)
  33.     Button(root, text="游客登录", font=tkFont.Font(size=16), command=lambda:GuestPage(root), width=25,
  34.                height=2, fg='black', bg='gainsboro', activebackground='black', activeforeground='white').place(relx=0.21,rely=0.6)
  35.     Button(root, text='退出系统', height=2, font=tkFont.Font(size=16), width=25, command=root.destroy,
  36.                fg='black', bg='gainsboro', activebackground='black', activeforeground='white').place(relx=0.21,rely=0.75)
  37.     root.mainloop()
  38.  
  39. image2=None
  40. img2=None
  41. #(2)管理员登录页面
  42. def Login(root):
  43.     global image2
  44.     global img2
  45.     root.destroy()
  46.     root= tk.Tk()
  47.     root.title('管理员登录页面')
  48.     root.geometry('1200x700+200+50')
  49.     root['background']='white'
  50.     image2 = Image.open('6.png')
  51.     img2 = ImageTk.PhotoImage(image2)
  52.     Label(root,image=img2).pack()
  53.     Label(root, text='账号：',font=("楷体", 15),bg='white').place(relx=0.4,rely=0.35)
  54.     Label(root, text='密码：',font=("楷体", 15),bg='white').place(relx=0.4,rely=0.45)
  55.     username=StringVar()
  56.     pwd=StringVar()
  57.     entry_username=Entry(root,textvariable=username, show=None)
  58.     entry_username.place(relx=0.45, rely=0.35, relwidth=0.2,relheight=0.039)
  59.     entry_pwd = Entry(root, textvariable=pwd, show='*')
  60.     entry_pwd.place(relx=0.45, rely=0.45, relwidth=0.2,relheight=0.039)
  61.     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)
  62.     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)
  63.     root.protocol('WM_DELETE_WINDOW', lambda:back(root))
  64.     root.mainloop()
  65. #(2.1)
  66. def sign_in(root, entry_username, entry_pwd):
  67.     db = pymysql.connect(host="localhost", user="root",\
  68.             password="root", db="fu_logistics", port=3306)
  69.     cur = db.cursor()
  70.     sql="select * from manger where username='%s'"%(entry_username.get())
  71.     try:
  72.         cur.execute(sql)
  73.         result = cur.fetchone()
  74.         mima=result[1]
  75.     except:
  76.         showinfo(title='提示', message='账号/密码错误！')
  77.         cur.close()
  78.         db.close()
  79.  
  80.     if mima==entry_pwd.get():
  81.         MangerChoosePage(root)
  82.     else:
  83.         showinfo(title='提示', message='账号/密码错误！')
  84.  
  85. image8=None
  86. img8=None
  87. #（3）管理员注册页面
  88. def register_Page(root):
  89.     global image8
  90.     global img8
  91.     root.destroy()
  92.     root=Tk()
  93.     root.title('管理员注册页面')
  94.     root.geometry('1200x700+200+50')
  95.     root['background']='white'
  96.     image8 = Image.open('7.png')
  97.     img8 = ImageTk.PhotoImage(image8)
  98.     Label(root,image=img8).pack()
  99.     Label(root, text='输入账号：',font=("楷体", 15),bg='white').place(relx=0.4,rely=0.35)
  100.     Label(root, text='输入密码：',font=("楷体", 15),bg='white').place(relx=0.4,rely=0.45)
  101.     Label(root, text='确认密码：',font=("楷体", 15),bg='white').place(relx=0.4,rely=0.55)
  102.     username=StringVar()
  103.     pwd=StringVar()
  104.     sure_pwd=StringVar()
  105.     entry_username=Entry(root,textvariable=username, show=None)
  106.     entry_username.place(relx=0.495, rely=0.35, relwidth=0.2,relheight=0.039)
  107.     entry_pwd = Entry(root, textvariable=pwd, show='*')
  108.     entry_pwd.place(relx=0.495, rely=0.45, relwidth=0.2,relheight=0.039)
  109.     entry_sure_pwd = Entry(root, textvariable=sure_pwd, show='*')
  110.     entry_sure_pwd.place(relx=0.495, rely=0.55, relwidth=0.2,relheight=0.039)
  111.     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)
  112.     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)
  113.     root.protocol('WM_DELETE_WINDOW', lambda:Login(root))
  114.     root.mainloop()
  115. #(3.1)
  116. def register(root,entry_username,entry_pwd,entry_sure_pwd):
  117.     db = pymysql.connect(host="localhost", user="root",password="root", db="fu_logistics", port=3306)
  118.     cur = db.cursor()
  119.     sql="insert into manger values('%s','%s')"% (entry_username.get(),entry_pwd.get())
  120.     cur.execute("select * from manger where username='%s'"%(entry_username.get()))
  121.     result = cur.fetchall()
  122.     if result:
  123.         showinfo('提示','该账号已存在，请重新输入！')
  124.     else:
  125.         if len(entry_pwd.get())==6:
  126.             if entry_sure_pwd.get()==entry_pwd.get():
  127.                 cur.execute(sql)
  128.                 db.commit()
  129.                 showinfo('提示','注册成功！')
  130.                 Login(root)
  131.             else:
  132.                 showinfo('提示','两次输入密码不相同，请重新输入！')
  133.         else:
  134.             showinfo("提示","请输入六位数密码！")
  135.     cur.close()
  136.     db.close()
  137.  
  138. image3 = None
  139. img3 = None
  140. # (4)管理员信息选择操作页面
  141. def MangerChoosePage(root):
  142.     global image3
  143.     global img3
  144.     root.destroy()
  145.     root = Tk()
  146.     root.title('管理员信息选择操作页面')
  147.     root.geometry('600x750+500+40')  # ('950x700')
  148.     root['background'] = 'white'
  149.     image3 = Image.open('8.png')
  150.     img3 = ImageTk.PhotoImage(image3)
  151.     Label(root, image=img3).pack()
  152.     Button(root, text="人员信息操作", font=tkFont.Font(size=16), command=lambda: Manger_user_Page(root), width=25,
  153.            height=2, fg='black', bg='gainsboro', activebackground='black', activeforeground='white').place(relx=0.22,
  154.                                                                                                            rely=0.3)
  155.     Button(root, text="订单信息操作", font=tkFont.Font(size=16), command=lambda: MangerPage(root), width=25,
  156.            height=2, fg='black', bg='gainsboro', activebackground='black', activeforeground='white').place(relx=0.22,
  157.                                                                                                            rely=0.5)
  158.     Button(root, text='退出', height=2, font=tkFont.Font(size=16), width=25, command=lambda: back(root),
  159.            fg='black', bg='gainsboro', activebackground='black', activeforeground='white').place(relx=0.22, rely=0.7)
  160.     root.protocol('WM_DELETE_WINDOW', lambda: back(root))
  161.     root.mainloop()
  162.  
  163. image4=None
  164. img4=None
  165. #(5)人员信息操作页面
  166. def Manger_user_Page(root):
  167.     global image4
  168.     global img4
  169.     root.destroy()
  170.     root = Tk()
  171.     root.geometry('565x600+500+80')
  172.     root.title('人员信息操作页面')
  173.     root['background']='white'
  174.     image4 = Image.open('4.png')
  175.     img4 = ImageTk.PhotoImage(image4)
  176.     Label(root,image=img4).pack()
  177.     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)
  178.     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)
  179.     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)
  180.     Button(root, text="退出", activebackground='gainsboro',font=('楷体',15), command=lambda:MangerChoosePage(root)).place(relx=0.27, rely=0.76, width=250)
  181.     root.protocol('WM_DELETE_WINDOW', lambda:MangerChoosePage(root))
  182.     root.mainloop()
  183.  
  184. image6=None
  185. img6=None
  186. #(6)收件人、寄件人、配送员信息操作页面
  187. def Uers_infor_Page(root,table):
  188.     global image6
  189.     global img6
  190.     root.destroy()
  191.     root=Tk()
  192.     root.geometry('900x700+300+50')
  193.     if table=='recipient':
  194.         Title='收件人'+'信息操作页面'
  195.         temp1='身份证号'
  196.         temp2='地址'
  197.     elif table=='distributor':
  198.         Title='配送员'+'信息操作页面'
  199.         temp1= '工号'
  200.         temp2='身份证号'
  201.     else:
  202.         Title='寄件人'+'信息操作页面'
  203.         temp1= '身份证号'
  204.         temp2='地址'
  205.     root.title(Title)
  206.     root['background']='floralwhite'
  207.     image6 = Image.open('3.jpeg')
  208.     img6 = ImageTk.PhotoImage(image6)
  209.     Label(root,text=Title,compound='bottom',image=img6,font=('楷体',30),fg='blue',bg='floralwhite').pack()
  210.     Label(root, text="姓名：").place(relx=0.02, rely=0.08, relwidth=0.1)
  211.     Label(root, text=temp1+'：').place(relx=0.5, rely=0.08, relwidth=0.1)
  212.     Label(root, text=temp2+'：').place(relx=0.02, rely=0.14, relwidth=0.1)
  213.     Label(root, text="性别：").place(relx=0.5, rely=0.14, relwidth=0.1)
  214.     Label(root, text="电话号码：").place(relx=0.02, rely=0.2, relwidth=0.1)
  215.  
  216.     name = StringVar()
  217.     ID = StringVar()
  218.     address = StringVar()
  219.     sex = StringVar()
  220.     phonenumber = StringVar()
  221.  
  222.     entry_name = Entry(root, textvariable=name )
  223.     entry_name.place(relx=0.12, rely=0.08, relwidth=0.3, height=25)
  224.     entry_ID = Entry(root, textvariable=ID)
  225.     entry_ID.place(relx=0.6, rely=0.08, relwidth=0.3, height=25)
  226.     entry_address = Entry(root, textvariable=address)
  227.     entry_address.place(relx=0.12, rely=0.14, relwidth=0.3, height=25)
  228.     entry_sex = Entry(root, textvariable=sex)
  229.     entry_sex.place(relx=0.6, rely=0.14, relwidth=0.3, height=25)
  230.     entry_phonenumber = Entry(root, textvariable=phonenumber)
  231.     entry_phonenumber.place(relx=0.12, rely=0.2, relwidth=0.3, height=25)
  232.  
  233.     list1=[entry_name,entry_ID,entry_address,entry_sex,entry_phonenumber]
  234.  
  235.     Tree1 = ttk.Treeview(root, show='headings',column=('name','ID','address','sex','phonenumber'))
  236.     Tree1.column('name', width=50, anchor="center")
  237.     Tree1.column('ID', width=70, anchor="center")
  238.     Tree1.column('address', width=40, anchor="center")
  239.     Tree1.column('sex', width=70, anchor="center")
  240.     Tree1.column('phonenumber', width=70, anchor="center")
  241.     # 表格标题设置
  242.     Tree1.heading('name', text='姓名')
  243.     Tree1.heading('ID', text=temp1)
  244.     Tree1.heading('address', text=temp2)
  245.     Tree1.heading('sex', text='性别')
  246.     Tree1.heading('phonenumber', text='电话号码')
  247.  
  248.     Tree1.place(relx=0.01,rely=0.5, relwidth=0.98)
  249.  
  250.     def treeviewClick(event):
  251.         item = Tree1.selection()[0]
  252.         item_text = Tree1.item(item, "values")
  253.  
  254.         entry_name.delete(0, 'end')
  255.         entry_ID.delete(0, 'end')
  256.         entry_address.delete(0, 'end')
  257.         entry_sex.delete(0, 'end')
  258.         entry_phonenumber.delete(0, 'end')
  259.  
  260.         entry_name.insert(0, item_text[0])
  261.         entry_ID.insert(0, item_text[1])
  262.         entry_address.insert(0, item_text[2])
  263.         entry_sex.insert(0, item_text[3])
  264.         entry_phonenumber.insert(0, item_text[4])
  265.  
  266.     Button(root, text="显示所有人员信息", command=lambda: showAll_user_Info(tree=Tree1,table=table)).place(relx=0.12, rely=0.3, width=120)
  267.     Button(root, text="增加人员信息", command=lambda: append_user_Info(tree=Tree1, list=list1,table=table)).place(relx=0.32, rely=0.3,width=120)
  268.     Button(root, text="删除人员信息", command=lambda: delete_user_Info(tree=Tree1,table=table)).place(relx=0.52, rely=0.3, width=120)
  269.     Button(root, text="更改人员信息", command=lambda: update_user_Info(tree=Tree1, list=list1,table=table)).place(relx=0.72, rely=0.3,width=120)
  270.  
  271.     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)
  272.     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)
  273.     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)
  274.     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)
  275.     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)
  276.  
  277.     Tree1.bind('<ButtonRelease-1>', treeviewClick)
  278.     root.protocol('WM_DELETE_WINDOW', lambda:Manger_user_Page(root))
  279.     root.mainloop()
  280. #(6.1)
  281. def showAll_user_Info(tree,table):
  282.     delButton(tree)
  283.     db = pymysql.connect(host="localhost", user="root",password="root", db="fu_logistics", port=3306)
  284.     cur = db.cursor() #用db操作游标
  285.     if table=='recipient':
  286.         sql="select * from recipient"
  287.     elif table=='sender':
  288.         sql="select * from sender"
  289.     else:
  290.         sql="select * from distributor"
  291.     cur.execute(sql)  # 执行sql语句
  292.     #fetchone()返回一条记录（元组），没有结果则返回none
  293.     #fetchall()返回所有元组，构成一个二维元组
  294.     results = cur.fetchall()
  295.     for item in results:
  296.         tree.insert('', "end", values=item)
  297.     cur.close()
  298.     db.close()  # 关闭连接
  299. #(6.2)
  300. def append_user_Info(tree,list,table):
  301.     delButton(tree)
  302.     list2 = []
  303.     for i in range(len(list)):
  304.         if list[i].get() == '':
  305.             showerror(title='提示', message='输入不能为空!')
  306.             return
  307.         else:
  308.             list2.append(list[i].get())
  309.  
  310.     x = tree.get_children()
  311.     for item in x:
  312.         tree.delete(item)
  313.  
  314.     db = pymysql.connect(host="localhost", user="root",password="root", db="fu_logistics", port=3306)
  315.     cur = db.cursor()
  316.     try:
  317.         if table == 'recipient':
  318.             sql1 = "insert into recipient values('%s','%s','%s','%s','%s')"% (list2[0], list2[1], list2[2], list2[3], list2[4])
  319.         elif table == 'sender':
  320.             sql1 = "insert into sender values('%s','%s','%s','%s','%s')"% (list2[0], list2[1], list2[2], list2[3], list2[4])
  321.         else:
  322.             sql1 = "insert into distributor values('%s','%s','%s','%s','%s')"% (list2[0], list2[1], list2[2], list2[3], list2[4])
  323.         cur.execute(sql1)
  324.         db.commit()
  325.         if table == 'recipient':
  326.             sql = "select * from recipient"
  327.         elif table == 'sender':
  328.             sql = "select * from sender"
  329.         else:
  330.             sql = "select * from distributor"
  331.         cur.execute(sql)
  332.         results = cur.fetchall()
  333.         for item in results:
  334.             tree.insert('', "end", values=item)
  335.         showinfo(title='提示', message='添加/更改成功！')
  336.     except:
  337.         showinfo(title='提示', message='该人员/编号已存在！')
  338.         return
  339.     cur.close()
  340.     db.close()
  341. #(6.3)
  342. def delete_user_Info(tree,table):
  343.     if not tree.selection():
  344.         showerror(title='提示', message='请选择一条信息！')
  345.         return
  346.     res=askyesno('提示','是否确认删除？')
  347.     if res==True:
  348.         for item in tree.selection():
  349.             selectedItem = tree.selection()[0]
  350.             no1 = tree.item(selectedItem, 'values')[1]
  351.             tree.delete(item)
  352.             if table == 'recipient':
  353.                 sql = "delete from recipient where RID = '%s' " % no1
  354.             elif table == 'sender':
  355.                 sql = "delete from sender where SID = '%s' " % no1
  356.             else:
  357.                 sql = "delete from distributor where Dnum = '%s' " % no1
  358.             db = pymysql.connect(host="localhost", user="root",password="root", db="fu_logistics", port=3306)
  359.             cur = db.cursor()
  360.             cur.execute(sql)
  361.             db.commit()
  362.             cur.close()
  363.             db.close()
  364.             showinfo(title='提示', message='删除成功！')
  365. #(6.4)
  366. def update_user_Info(tree, list,table):
  367.     if not tree.selection():
  368.         showerror(title='提示', message='请选择一条信息！')
  369.         return
  370.     else:
  371.         res=askyesno("提示","是否确认更新数据？")
  372.         if res==True:
  373.             for item in tree.selection():
  374.                 selectedItem = tree.selection()[0]
  375.                 no1 = tree.item(selectedItem, 'values')[1]
  376.                 tree.delete(item)
  377.                 if table == 'recipient':
  378.                     sql = "delete from recipient where RID = '%s' " % no1
  379.                 elif table == 'sender':
  380.                     sql = "delete from sender where SID = '%s' " % no1
  381.                 else:
  382.                     sql = "delete from distributor where Dnum = '%s' " % no1
  383.                 db = pymysql.connect(host="localhost", user="root",password="root", db="fu_logistics", port=3306)
  384.                 cur = db.cursor()
  385.  
  386.                 cur.execute(sql)
  387.                 db.commit()
  388.  
  389.                 cur.close()
  390.                 db.close()
  391.             append_user_Info(tree, list,table)
  392.             return
  393. #(6.5)
  394. def find_sql_line(table,flag,entry):
  395.     if table=='recipient':
  396.         if flag=='name':
  397.             sql = "select * from recipient where Rname = '%s'"%(entry.get())
  398.         elif flag=='ID':
  399.             sql = "select * from recipient where RID = '%s'"%(entry.get())
  400.         elif flag=='address':
  401.             sql = "select * from recipient where Raddress = '%s'"%(entry.get())
  402.         elif flag=='sex':
  403.             sql = "select * from recipient where Rsex = '%s'"%(entry.get())
  404.         else:
  405.             sql = "select * from recipient where Rphonenumber = '%s'"%(entry.get())
  406.     elif table=='sender':
  407.         if flag=='name':
  408.             sql = "select * from sender where Sname = '%s'"%(entry.get())
  409.         elif flag=='ID':
  410.             sql = "select * from sender where SID = '%s'"%(entry.get())
  411.         elif flag=='address':
  412.             sql = "select * from sender where Saddress = '%s'"%(entry.get())
  413.         elif flag=='sex':
  414.             sql = "select * from sender where Ssex = '%s'"%(entry.get())
  415.         else:
  416.             sql = "select * from sender where Sphonenumber = '%s'"%(entry.get())
  417.     else:
  418.         if flag=='name':
  419.             sql = "select * from distributor where Dname = '%s'"%(entry.get())
  420.         elif flag=='ID':
  421.             sql = "select * from distributor where Dnum = '%s'"%(entry.get())
  422.         elif flag=='address':
  423.             sql = "select * from distributor where DID = '%s'"%(entry.get())
  424.         elif flag=='sex':
  425.             sql = "select * from distributor where Dsex = '%s'"%(entry.get())
  426.         else:
  427.             sql = "select * from distributor where Dphonenumber = '%s'"%(entry.get())
  428.  
  429.     return sql
  430. #(6.6)
  431. def find_use_Info(tree,table,entry,flag):
  432.     delButton(tree)
  433.     db = pymysql.connect(host="localhost", user="root", password="root", db="fu_logistics", port=3306)
  434.     cur = db.cursor()
  435.     sql=find_sql_line(table=table,flag=flag,entry=entry)
  436.     cur.execute(sql)
  437.     results = cur.fetchall()
  438.     if results:
  439.         for item in results:
  440.             tree.insert('', "end", values=item)
  441.     else:
  442.         showinfo(title='提示', message='无该信息！')
  443.     cur.close()
  444.     db.close()
  445.  
  446. image7=None
  447. img7=None
  448. #（7）订单信息操作页面
  449. def MangerPage(root1):
  450.     global image7
  451.     global img7
  452.     root1.destroy()
  453.     root1 = Tk()
  454.     root1.geometry('1000x700+300+50')
  455.     root1.title('订单信息操作页面')
  456.     root1['background']='floralwhite'
  457.     image7 = Image.open('2.jpeg')
  458.     img7 = ImageTk.PhotoImage(image7)
  459.     Label(root1, text='订单信息操作页面',bg='floralwhite', fg='blue', font=('楷体', 20),compound='bottom',image=img7).pack()
  460.     Label(root1, text="订单编号：",font=('楷体', 13)).place(relx=0.5, rely=0.07, relwidth=0.1)
  461.     Label(root1, text="运输时间：",font=('楷体', 13)).place(relx=0.5, rely=0.12, relwidth=0.1)
  462.     Label(root1, text="物流站：",font=('楷体', 13)).place(relx=0.5, rely=0.17, relwidth=0.1)
  463.     Label(root1, text="快递员：",font=('楷体', 13)).place(relx=0.5, rely=0.22, relwidth=0.1)
  464.     Label(root1, text="寄件人：",font=('楷体', 13)).place(relx=0.5, rely=0.27, relwidth=0.1)
  465.     Label(root1, text="收件人：",font=('楷体', 13)).place(relx=0.5, rely=0.32, relwidth=0.1)
  466.     Label(root1, text="商品：",font=('楷体', 13)).place(relx=0.5, rely=0.37, relwidth=0.1)
  467.     Label(root1, text="价格：",font=('楷体', 13)).place(relx=0.5, rely=0.42, relwidth=0.1)
  468.  
  469.     Onum = StringVar()
  470.     Odelivery_time = StringVar()
  471.     Olog_station = StringVar()
  472.     Odistributor = StringVar()
  473.     Osender = StringVar()
  474.     Orecipient = StringVar()
  475.     Ogoods = StringVar()
  476.     Oprice = StringVar()
  477.  
  478.     entry_Onum = Entry(root1, textvariable=Onum)
  479.     entry_Onum.place(relx=0.6, rely=0.07, relwidth=0.3, height=25)
  480.     entry_Odelivery_time = Entry(root1, textvariable=Odelivery_time)
  481.     entry_Odelivery_time.place(relx=0.6, rely=0.12, relwidth=0.3, height=25)
  482.     entry_Olog_station = Entry(root1, textvariable=Olog_station)
  483.     entry_Olog_station.place(relx=0.6, rely=0.17, relwidth=0.3, height=25)
  484.     entry_Odistributor = Entry(root1, textvariable=Odistributor)
  485.     entry_Odistributor.place(relx=0.6, rely=0.22, relwidth=0.3, height=25)
  486.     entry_Osender = Entry(root1, textvariable=Osender)
  487.     entry_Osender.place(relx=0.6, rely=0.27, relwidth=0.3, height=25)
  488.     entry_Orecipient = Entry(root1, textvariable=Orecipient)
  489.     entry_Orecipient.place(relx=0.6, rely=0.32, relwidth=0.3, height=25)
  490.     entry_Ogoods = Entry(root1, textvariable=Ogoods)
  491.     entry_Ogoods.place(relx=0.6, rely=0.37, relwidth=0.3, height=25)
  492.     entry_Oprice = Entry(root1, textvariable=Oprice)
  493.     entry_Oprice.place(relx=0.6, rely=0.42, relwidth=0.3, height=25)
  494.  
  495.     list1 = [entry_Onum, entry_Odelivery_time, entry_Olog_station, entry_Odistributor, entry_Osender, entry_Orecipient,entry_Ogoods, entry_Oprice]
  496.  
  497.     Tree1 = ttk.Treeview(root1, show='headings',
  498.                          column=('Onum', 'Odelivery_time', 'Olog_station', 'Odistributor', 'Osender', 'Orecipient', 'Ogoods', 'Oprice'))
  499.     Tree1.column('Onum', width=50, anchor="center")
  500.     Tree1.column('Odelivery_time', width=70, anchor="center")
  501.     Tree1.column('Olog_station', width=40, anchor="center")
  502.     Tree1.column('Odistributor', width=70, anchor="center")
  503.     Tree1.column('Osender', width=70, anchor="center")
  504.     Tree1.column('Orecipient', width=70, anchor="center")
  505.     Tree1.column('Ogoods', width=70, anchor="center")
  506.     Tree1.column('Oprice', width=40, anchor="center")
  507.  
  508.     Tree1.heading('Onum', text='订单编号')
  509.     Tree1.heading('Odelivery_time', text='运输时间')
  510.     Tree1.heading('Olog_station', text='物流站')
  511.     Tree1.heading('Odistributor', text='快递员')
  512.     Tree1.heading('Osender', text='寄件人')
  513.     Tree1.heading('Orecipient', text='收件人')
  514.     Tree1.heading('Ogoods', text='商品')
  515.     Tree1.heading('Oprice', text='价格')
  516.  
  517.     Tree1.place(rely=0.5, relwidth=1)
  518.  
  519.     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)
  520.     Button(root1, text="查询所有订单",activebackground='gray',font=('楷体',13), command=lambda: showAllInfo(tree=Tree1)).place(relx=0.15, rely=0.10, width=150)
  521.     Button(root1, text="增加订单", activebackground='gray',font=('楷体',13), command=lambda: appendInfo(tree=Tree1,  list=list1)).place(relx=0.15, rely=0.24, width=150)
  522.     Button(root1, text="删除订单", activebackground='gray',font=('楷体',13), command=lambda: deleteInfo(tree=Tree1)).place(relx=0.15, rely=0.31, width=150)
  523.     Button(root1, text="更改订单信息", activebackground='gray',font=('楷体',13), command=lambda: updateInfo(tree=Tree1, list=list1)).place(relx=0.15, rely=0.38, width=150)
  524.  
  525.     def treeviewClick(event):
  526.         item = Tree1.selection()[0]
  527.         item_text = Tree1.item(item, "values")
  528.  
  529.         entry_Onum.delete(0, 'end')
  530.         entry_Odelivery_time.delete(0, 'end')
  531.         entry_Olog_station.delete(0, 'end')
  532.         entry_Odistributor.delete(0, 'end')
  533.         entry_Osender.delete(0, 'end')
  534.         entry_Orecipient.delete(0, 'end')
  535.         entry_Ogoods.delete(0, 'end')
  536.         entry_Oprice.delete(0, 'end')
  537.  
  538.         entry_Onum.insert(0, item_text[0])
  539.         entry_Odelivery_time.insert(0, item_text[1])
  540.         entry_Olog_station.insert(0, item_text[2])
  541.         entry_Odistributor.insert(0, item_text[3])
  542.         entry_Osender.insert(0, item_text[4])
  543.         entry_Orecipient.insert(0, item_text[5])
  544.         entry_Ogoods.insert(0, item_text[6])
  545.         entry_Oprice.insert(0, item_text[7])
  546.  
  547.     Tree1.bind('<ButtonRelease-1>', treeviewClick)
  548.     root1.protocol('WM_DELETE_WINDOW', lambda:MangerChoosePage(root1))
  549.     root1.mainloop()
  550. #(7.1)
  551. def showAllInfo(tree):
  552.     delButton(tree)
  553.     db = pymysql.connect(host="localhost", user="root",password="root", db="fu_logistics", port=3306)
  554.     cur = db.cursor() #用db操作游标
  555.     cur.execute("select * from orders")
  556.  
  557.     results = cur.fetchall()
  558.     for item in results:
  559.         tree.insert('', "end", values=item)
  560.     cur.close()
  561.     db.close()  # 关闭连接
  562. #(7.2)
  563. def appendInfo(tree,list):
  564.     delButton(tree)
  565.     list2 = []
  566.     for i in range(len(list)):
  567.         if list[i].get() == '':
  568.             showerror(title='提示', message='输入不能为空!')
  569.             return
  570.         else:
  571.             list2.append(list[i].get())
  572.  
  573.     x = tree.get_children()
  574.     for item in x:
  575.         tree.delete(item)
  576.  
  577.     db = pymysql.connect(host="localhost", user="root",password="root", db="fu_logistics", port=3306)
  578.     cur = db.cursor()
  579.     try:
  580.         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]))
  581.         db.commit()#对数据进行修改、删除、插入时最好都commit一下,跟在execute()后面
  582.         cur.execute("select * from orders")
  583.         results = cur.fetchall()
  584.         for item in results:
  585.             tree.insert('', "end", values=item)
  586.         showinfo(title='提示', message='添加/更新成功！')
  587.     except:
  588.         showinfo(title='提示', message='该编号已存在！')
  589.         return
  590.     cur.close()
  591.     db.close()
  592. #(7.3)
  593. def deleteInfo(tree):
  594.     if not tree.selection():
  595.         showerror(title='提示', message='请选择一条信息！')
  596.         return
  597.     res = askyesno('提示！', '是否确认删除？')
  598.     if res == True:
  599.         for item in tree.selection():
  600.             selectedItem = tree.selection()[0]
  601.             no1 = tree.item(selectedItem, 'values')[0]
  602.             tree.delete(item)
  603.  
  604.             db = pymysql.connect(host="localhost", user="root",password="root", db="fu_logistics", port=3306)
  605.             cur = db.cursor()
  606.             cur.execute("delete from orders where Onum = '%s'" % no1)
  607.             db.commit()
  608.  
  609.             cur.close()
  610.             db.close()
  611.             showinfo(title='提示', message='删除成功！')
  612. #(7.4)
  613. def updateInfo(tree, list):
  614.     if not tree.selection():
  615.         showerror(title='提示', message='请选择一条信息！')
  616.         return
  617.     else:
  618.         res=askyesno("提示！","是否确认更新数据？")
  619.         if res==True:
  620.             for item in tree.selection():
  621.                 selectedItem = tree.selection()[0]
  622.                 no1 = tree.item(selectedItem, 'values')[0]
  623.                 tree.delete(item)
  624.  
  625.                 db = pymysql.connect(host="localhost", user="root",password="root", db="fu_logistics", port=3306)
  626.                 cur = db.cursor()
  627.  
  628.                 cur.execute("delete from orders where Onum = '%s'" % no1)
  629.                 db.commit()
  630.  
  631.                 cur.close()
  632.                 db.close()
  633.             appendInfo(tree, list)
  634.             return
  635. #(7.5)
  636. def findInfo(check, tree, list):
  637.     if check:
  638.         delButton(tree)
  639.     db = pymysql.connect(host="localhost", user="root",password="root", db="fu_logistics", port=3306)
  640.     cur = db.cursor()
  641.     cur.execute("select * from orders where Onum = '%s'" % list[0].get())  # 执行sql语句
  642.     results = cur.fetchall()
  643.     if results:
  644.         for item in results:
  645.             tree.insert('', "end", values=item)
  646.     else:
  647.         showinfo(title='提示', message='无该订单编号！')
  648.     cur.close()
  649.     db.close()
  650.  
  651. image5=None
  652. img5=None
  653. #(8)游客订单信息查询页面
  654. def GuestPage(root):
  655.     global image5
  656.     global img5
  657.     root.destroy()
  658.     root=Tk()
  659.     root.title('游客订单信息查询页面')
  660.     root.geometry('850x730+300+50')
  661.     root['background']='white'
  662.     image5 = Image.open('5.png')
  663.     img5 = ImageTk.PhotoImage(image5)
  664.     Label(root,text='游客订单信息查询页面',compound='bottom',image=img5,bg='floralwhite',fg='blue',font=('楷体',20)).pack(side=TOP, fill='x')
  665.     Label(root,text='订单编号：',font=('楷体',13)).place(relx=0.07,rely=0.15,relwidth=0.15)
  666.     Label(root, text='收件人姓名：',font=('楷体',13)).place(relx=0.07, rely=0.25, relwidth=0.15)
  667.     Label(root, text='寄件人姓名：',font=('楷体',13)).place(relx=0.07, rely=0.35, relwidth=0.15)
  668.     Label(root, text='配送时间：',font=('楷体',13)).place(relx=0.07, rely=0.45, relwidth=0.15)
  669.  
  670.     Onum=StringVar()
  671.     Rname=StringVar()
  672.     Sname=StringVar()
  673.     Odeliver_time=StringVar()
  674.  
  675.     entry_Onum = Entry(root, textvariable=Onum)
  676.     entry_Onum.place(relx=0.2, rely=0.15, relwidth=0.3, height=25)
  677.     entry_Rname = Entry(root, textvariable=Rname)
  678.     entry_Rname.place(relx=0.2, rely=0.25, relwidth=0.3, height=25)
  679.     entry_Sname = Entry(root, textvariable=Sname)
  680.     entry_Sname.place(relx=0.2, rely=0.35, relwidth=0.3, height=25)
  681.     entry_Odeliver_time = Entry(root, textvariable=Odeliver_time)
  682.     entry_Odeliver_time.place(relx=0.2, rely=0.45, relwidth=0.3, height=25)
  683.  
  684.  
  685.  
  686.     Tree1 = ttk.Treeview(root, show='headings',column=('Onum', \
  687.         'Odelivery_time', 'Olog_station', 'Odistributor', 'Osender', 'Orecipient', 'Ogoods','Oprice'))
  688.     Tree1.column('Onum', width=50, anchor="center")
  689.     Tree1.column('Odelivery_time', width=80, anchor="center")
  690.     Tree1.column('Olog_station', width=40, anchor="center")
  691.     Tree1.column('Odistributor', width=70, anchor="center")
  692.     Tree1.column('Osender', width=70, anchor="center")
  693.     Tree1.column('Orecipient', width=70, anchor="center")
  694.     Tree1.column('Ogoods', width=70, anchor="center")
  695.     Tree1.column('Oprice', width=40, anchor="center")
  696.     # 表格标题设置
  697.     Tree1.heading('Onum', text='订单编号')
  698.     Tree1.heading('Odelivery_time', text='运输时间')
  699.     Tree1.heading('Olog_station', text='物流站')
  700.     Tree1.heading('Odistributor', text='快递员')
  701.     Tree1.heading('Osender', text='寄件人')
  702.     Tree1.heading('Orecipient', text='收件人')
  703.     Tree1.heading('Ogoods', text='商品')
  704.     Tree1.heading('Oprice', text='价格')
  705.  
  706.     Tree1.place(rely=0.6, relwidth=1)
  707.  
  708.     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)
  709.     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)
  710.     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)
  711.     root.protocol('WM_DELETE_WINDOW', lambda:back(root))
  712.     root.mainloop()
  713. #(8.1)
  714. def Find_infor_num(Tree1,Name):
  715.     delButton(Tree1)
  716.     db = pymysql.connect(host="localhost", user="root", password="root", db="fu_logistics", port=3306)
  717.     cur = db.cursor()
  718.  
  719.     cur.execute("select * from orders where Onum = '%s'" % Name.get())
  720.     results = cur.fetchall()  # 获取查询的所有记录
  721.     if results:
  722.         for item in results:
  723.             Tree1.insert('', "end", values=item)
  724.     else:
  725.         showinfo(title='提示', message='无该订单编号！')
  726.  
  727.     cur.close()
  728.     db.close()
  729. #(8.2)
  730. def Find_infor_name(Tree1,Name1,Name2):
  731.     delButton(Tree1)
  732.     db = pymysql.connect(host="localhost", user="root", password="root", db="fu_logistics", port=3306)
  733.     cur = db.cursor()
  734.     if Name1.get():
  735.         cur.execute("select * from orders where Orecipient = '%s'" % Name1.get())
  736.         results = cur.fetchall()
  737.         if not results:
  738.             showinfo(title='提示', message='无该收件人！')
  739.         else:
  740.             for item in results:
  741.                 Tree1.insert('', "end", values=item)
  742.     if Name2.get():
  743.         cur.execute("select * from orders where Osender = '%s'" % Name2.get())
  744.         results = cur.fetchall()
  745.         if not results:
  746.             showinfo(title='提示', message='无该寄件人！')
  747.         else:
  748.             for item in results:
  749.                 Tree1.insert('', "end", values=item)
  750.  
  751.     cur.close()
  752.     db.close()
  753. #(8.3)
  754. def Find_infor_time(Tree1,time):
  755.     delButton(Tree1)
  756.     db = pymysql.connect(host="localhost", user="root", password="root", db="fu_logistics", port=3306)
  757.     cur = db.cursor()
  758.     ch='%'+time.get()+'%'
  759.     cur.execute("select * from orders where Odelivery_time like  '%s'" % ch)
  760.     results = cur.fetchall()
  761.     if results:
  762.         for item in results:
  763.             Tree1.insert('', "end", values=item)
  764.     else:
  765.         showinfo(title='提示', message='无该配送日期！')
  766.     cur.close()
  767.     db.close()
  768.  
  769. if __name__=='__main__':
  770.     StartPage()

6.不足说明

1.本数据库在创建时，没有添加外码，因此表间数据不具有对应关系，数据插入时不受外码影响。

2.部分代码是根据已创建的数据库结构来对应编写，延展性不强。

3.对部分插入数据无完整语句限制，部分不按实际规则填写的数据也会被写入数据库。

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/盐析白兔/article/detail/524924
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号