【毕业论文】用Delhpi设计进销存系统的设计与实现.doc

进销存系统的设计与实现 摘 要：企业进销存系统是一个典型的管理信息系统，其开发主要包括后台数据库的建立和维护以及前端应用程序的开发两个方面，对于前者要求建立起数据一致性和完整性强、数据安全性好的数据库。而对于后者则要求应用程序功能完备、易使用等特点。 经过分析，由于Delphi 在开发数据库前端对数据库的强大支持能力及其具有的简洁明快的编程语言、功能强大的组件、灵活方便的编程环境和提供的窗体对快速原型开发的支持，我们以Borland公司的BORLAND DELPHI 6.0作为前端开发工具，以 Microsoft SQL Server 2000作为后台数据库开发工具，系统采用C/S结构。本文以一个企业进销存系统的分析、设计和开发的全过程为主线，给出了企业进销存系统的设计和技术实现过程。 关键词：企业进销存系统 数据库 组件 窗体 C/S结构 Design and Implementation of Stock Sale System Ding Yang (Dept. of Computer and Information Science, Southwest Forestry College, Kunming, Yunnan, 650224, China) Abstract: Enterprise stock sale system is a typical management information system. Its development mainly includes supporter foundation and maintains of the backstage database, and the development of application program of the forestage .As to the former one, it’s required to set up a consistency and integrality strong, security kind database, and as well as the completed application program function and easy characteristic of usage to the later one. ?? As a result of analyzing, because of Delphi’s strong support ability to the database while developing the forestage and succinct and lucid programming language, powerful component, flexible and convenient programming environment and the offered support of window body that develops the fast prototype, We decide to use Borland Delphi 6.0 of Borland Company as the developing instrument of forestage together with Microsoft SQL Server 2000 as backstage supporter. The system adopts C/S structure. This text takes a main shaft of analyzing and designing the stock sale system of the enterprise, provides a design and technological procedure of the stock sale system. Keywords: Enterprise Stock-Sale System Database Component Form C/S Architecture 目 录 1引言 1 2 任务的提出与需求分析 1 2.1市场背景 1 2.2中小企业“进、销、存”运作的模式 1 2.3系统需求 2 3 系统的技术支持 2 3.1系统的运行环境 2 3.2系统的硬件支撑平台 2 3.2系统的开发技术 3 3.3.1 SQL Server后台数据库管理系统 3 3.3.2 Delphi6.0　VCL组件的体系结构 4 3.3.3?数据库组件介绍 5 3.3.4 SQL语言在Delphi中的应用 6 4 总体概要设计 9 4.1 系