基于Python+SQLSERVER的快递业务管理系统的设计与实现 毕业论文+项目源码及数据库文件
快递业务管理系统的设计与实现摘要: 着网络新零售的到来，传统物流在网购的洗礼下迅速蜕变，在这场以互联网为基础的时代变革中，哪家企业能率先转变其工作模式就能最先分得一杯羹，物流管理也不例外。传统的物流管理模式效率低下，不仅耗费大量的人力物力，信息维护也极易出现错误。近年来物流管理系统逐步在全国范围内实施使用，它的实现使用户足不出户即可完成寄件、查件等业务，同时也方便物流公司对海量物流数据的处理，是物流管理发展中一个重要的里程碑。本文实现的快递业务管理系统管理系统，采用C/S网络架构进行设计，客户端发送请求获取功能操作，内部实现则由服务器端完成。开发时选用Python语言来提升开发效率。前台页面使用Tkinter GUI实现，后台数据库采用SQL server 2008 R2，使用Pymssql连接sql server服务器。该系统包括基本的查件、寄件、用户管理、快递管理、最优路径选择五个模块，可以满足小型快递业务管理的日常运作需求。系统实现后还通过大量的测试用例检验系统的可靠性，以便给用户带来最佳的使用感。关键词：快递业务管理系统；Python；PyMssql； SQL server;TkinterAbstract: 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目录一．绪论 41.1研究背景及意义 41.2结构安排 4二．关键技术介绍 62.1 SQL SERVER 62.2 Python 62.3 Tkinter GUI 62.4 PyMssql 7三．系统分析 83.1可行性分析 83.1.1技术可行性 83.1.2经济可行性 83.1.3操作可行性 8四.系统概要设计 94.1体系架构设计 94.2系统架构设计 94.3 UI模块设计 104.4 数据库设计 104.4.1 E-R图 104.4.2 数据库表结构设计 114.5业务逻辑设计 124.5.1登录与注册 134.5.2主界面 144.5.3邮寄界面 144.5.4 一键查询界面 154.5.5 查询界面 164.5.6管理界面 16五.系统实现 175.1 SQL 命令配置文件 175.2 登录界面 175.3 注册界面 175.4 主界面 175.5 邮寄界面 185.5 一键查询界面 185.6 查件界面 185.7 管理界面 196.系统测试 206.1测试方法 206.2测试环境 206.3测试结果 207.总结与展望 21
