Python（Tkinter）+Mysql 交通违章管理系统（附源码）

数据库课程设计、 交通违章管理系统，

实现对车辆、司机、警察、违章及处罚等信息增加、删除、修改、查询，并能够查询和显示出交通违章通知等信息。
涉及：python、tkinter、mysql 、pymysql。望各位大佬指正。

- 登陆界面展示：

根据用户输入信息，判断密码是否正确以及身份是否对应。

# login command function
def login():
    identity_var = identity.get()
    user = userE.get()
    password = passwordE.get()
    # python Sequence unpacking
    if usertable.UserSelect(user) != 'error':
        password_sql, user_identity = usertable.UserSelect(user)
        print(identity_var, user_identity)
        if password == password_sql and identity_var == '1' or '2':
            if identity_var == '1' and str(user_identity) == '1':
                # login police_system
                tkinter.messagebox.showinfo(title='Landing', message='Verification passed')
                if 1:
                    Police_Windows1(user)
            elif identity_var == '0' == str(user_identity):
                # login driver_system
                tkinter.messagebox.showinfo(title='Landing', message='Verification passed')
                if 1:
                    Driver_Windows(user)
            else:
                tkinter.messagebox.showinfo(title='Landing', message='Identity error')
        else:
            tkinter.messagebox.showinfo(title='Landing', message='Password error')
    else:
        tkinter.messagebox.showinfo(title='Landing', message='User name does not exist')

- 警察操作界面：

部分代码

    # Driver
    btt = tkinter.Button(windows1, text='Select', font=('Arial', 12), command=driver.driver)
    btt.place(x=400, y=140)
    btt1 = tkinter.Button(windows1, text='Delete', font=('Arial', 12), command=tkwindows.delete_windows)
    btt1.place(x=500, y=140)
    btt2 = tkinter.Button(windows1, text='Update', font=('Arial', 12), command=tkwindows.update_windows)
    btt2.place(x=600, y=140)
    btt3 = tkinter.Button(windows1, text='Insert', font=('Arial', 12), command=tkwindows.insert_windows)
    btt3.place(x=700, y=140)
    # Police
    btt4 = tkinter.Button(windows1, text='Select', font=('Arial', 12), command=police.policeSelect)
    btt4.place(x=400, y=200)
    btt5 = tkinter.Button(windows1, text='Delete', font=('Arial', 12), command=tkwindows.police_delete_windows)
    btt5.place(x=500, y=200)
    btt6 = tkinter.Button(windows1, text='Update', font=('Arial', 12), command=tkwindows.police_update_windows)
    btt6.place(x=600, y=200)
    btt7 = tkinter.Button(windows1, text='Insert', font=('Arial', 12), command=tkwindows.police_insert_windows)
    btt7.place(x=700, y=200)

- 增删改查

• 修改

• 删除

• 增加

• 查询

- 签发违章罚单

- 违章罚单如图所示

  # -----
    line3 = tk.Label(text='__________________________________________________________________________________________'
                          '______________________________________')
    line3.place(x=30, y=395)
    # punish
    punish_type = tk.Label(text='Punish_type: ', font=('Arial', 13))
    punish_type.place(x=50, y=435)
    # punish_type = tk.Label(text=tuple[-5], font=('Arial', 13))
    # punish_type.place(x=100, y=435)
    punish_type1 = tk.Label(text='□Warning', font=('Arial', 13))
    punish_type1.place(x=150, y=475)
    punish_type2 = tk.Label(text='□Fine', font=('Arial', 13))
    punish_type2.place(x=400, y=475)
    punish_type3 = tk.Label(text='□Temporary withholding of driver license', font=('Arial', 13))
    punish_type3.place(x=150, y=515)
    # -----
    line4 = tk.Label(text='__________________________________________________________________________________________'
                          '______________________________________')
    line4.place(x=30, y=535)
    # Police Signature
    police_signature = tk.Label(text='Police Signature :', font=('Arial', 13))
    police_signature.place(x=50, y=575)
    police_id = tk.Label(text='Police Id :', font=('Arial', 13))
    police_id.place(x=400, y=575)
    # -----
    line5 = tk.Label(text='__________________________________________________________________________________________'
                          '______________________________________')
    line5.place(x=30, y=605)

- 系统存在问题：

	 1. 数据库字段设置不够严谨
	 2. 图像界面后续窗口设计不够完善
	 3. 。。。

---

2020/4/15 更新

• 更改Github上的代码错误
• 执行了代码优化，提升了运行速度
• 修改了代码的结构，以及将数据访问逻辑进行了整理
• 注明了使用方法，即Readme.md
• 增添了数据库文件
• Github：https://github.com/meetchen/Traffic-Violation-Management-System
• 如果可以的，点下star 三连一下，哈哈哈。谢谢你

有问题可以在我的博客留言

Leave a comment on my blog if you have any questions

Url : https://www.cduanran.com/guestbook/

Email ：duanran@cduanran.com