快递业务管理系统的设计与实现
摘要: 着网络新零售的到来，传统物流在网购的洗礼下迅速蜕变，在这场以互联网为基础的时代变革中，哪家企业能率先转变其工作模式就能最先分得一杯羹，物流管理也不例外。传统的物流管理模式效率低下，不仅耗费大量的人力物力，信息维护也极易出现错误。近年来物流管理系统逐步在全国范围内实施使用，它的实现使用户足不出户即可完成寄件、查件等业务，同时也方便物流公司对海量物流数据的处理，是物流管理发展中一个重要的里程碑。
本文实现的快递业务管理系统管理系统，采用C/S网络架构进行设计，客户端发送请求获取功能操作，内部实现则由服务器端完成。开发时选用Python语言来提升开发效率。前台页面使用Tkinter GUI实现，后台数据库采用SQL server 2008 R2，使用Pymssql连接sql server服务器。该系统包括基本的查件、寄件、用户管理、快递管理、最优路径选择五个模块，可以满足小型快递业务管理的日常运作需求。系统实现后还通过大量的测试用例检验系统的可靠性，以便给用户带来最佳的使用感。
关键词：快递业务管理系统；Python；PyMssql； SQL server;Tkinter
Abstract: With the arrival of new network retail, traditional logistics has changed rapidly under the baptism of online shopping. In this Internet-based era change, which enterprise can take the lead in changing its working mode can first get a share of the pie, and logistics management is no exception.The traditional logistics management mode is inefficient, which not only consumes a lot of manpower and material resources, but also is easy to make mistakes in information maintenance.In recent years, the logistics management system has been gradually implemented nationwide. Its implementation enables users to complete sending, checking and other businesses without leaving home, and also facilitates the processing of massive logistics data of logistics companies, which is an important milestone in the development of logistics management.
The express service management system implemented in this paper is designed using C / S network architecture, the client sends the request acquisition function, and the internal implementation is completed by the server side.The Python language is used in the development process to improve the development efficiency.Front ground page is implemented using Tkinter GUI, background database using SQL server 2008 R2, and using Pymssql to connect to the sql server server.The system includes five modules: basic piece check, delivery, user management, express management, and optimal path selection, which can meet the daily operation needs of small express business management.After the implementation of the system, the reliability of the system is also tested through a large number of test cases, so as to bring users the best sense of use.
Key words: express business management system; Python; PyMssql; SQL server; Tkinter
目录
一．绪论 4
1.1研究背景及意义 4
1.2结构安排 4
二．关键技术介绍 6
2.1 SQL SERVER 6
2.2 Python 6
2.3 Tkinter GUI 6
2.4 PyMssql 7
三．系统分析 8
3.1可行性分析 8
3.1.1技术可行性 8
3.1.2经济可行性 8
3.1.3操作可行性 8
四.系统概要设计 9
4.1体系架构设计 9
4.2系统架构设计 9
4.3 UI模块设计 10
4.4 数据库设计 10
4.4.1 E-R图 10
4.4.2 数据库表结构设计 11
4.5业务逻辑设计 12
4.5.1登录与注册 13
4.5.2主界面 14
4.5.3邮寄界面 14
4.5.4 一键查询界面 15
4.5.5 查询界面 16
4.5.6管理界面 16
五.系统实现 17
5.1 SQL 命令配置文件 17
5.2 登录界面 17
5.3 注册界面 17
5.4 主界面 17
5.5 邮寄界面 18
5.5 一键查询界面 18
5.6 查件界面 18
5.7 管理界面 19
6.系统测试 20
6.1测试方法 20
6.2测试环境 20
6.3测试结果 20
7.总结与展望 21
