超市进销存管理系统的VB实现.doc

安徽工程科技学院毕业设计（论文） 超市进销存管理系统的VB实现 Implement of super-market stocking-selling-storing management system based on visual basic  摘 要 随着信息时代的来临和计算机技术的飞速发展，世界已进入在计算机信息管理领域中激烈竞争的时代。企业管理的信息化越来越得到重视，超市进销存系统就在这样的背景下成为了我们的研究对象。 本课题以商品在超市中的流动过程为参考依据，利用Visual Basic作为人机界面开发环境，采用SQL 数据库语言，结合WINSOWS操作系统来研究如何建立一个面向企业的或面向公司的进销存管理系统。超市采购、销售和库存有机的结合，是超市获得最大的经济效益的关键。超市进销存管理系统是专为超市的产品的进、销和存体系制作的电子商务应用系统，它涉及到了超市进销存管理的全过程，主要包括进货、库存、销售、报损四个方面。 通过本设计，我们可以拓展思路，将其运用在实际生活和工作中，如学校的图书管理系统，人力资源管理系统等方面，应用前景广阔。 关键词：信息管理系统；Visual Basic；SQL；超市 Implement of super-market stocking-selling-storing management system based on visual basic Abstract With information age coming and computer science developing, the universal competition lies maily in the computer information management. The information of enterprise management has been obtained more and more attention, so we research and design the supermarket invoicing system. By referring to the flow of merchandise in the supermarket, using Visual Basic as the developing tool of man-machine interface, adopting SQL database language and WINSOWS the operating system of WINDOWS, we study how to establish a stocking-selling-storing management system for business-oriented companies. The organic combination of supermarkets’ procurement, sales and inventory is the key issue that guarantees the largest economic benefits. Supermarket inventory management system is specially designed for the stocking-selling-storing of supermarket products, which combines the whole process of the supermarket management. Based on the design, we can extend the method in this paper to other resemble system, for example, the library management system, and the human resources management system, etc. So, the stocking-selling-storing management system has a good prospect for applications. Key words: Management Information System; Visual Basic; SQL; Supermarket 目 录 引 言 1 第1章 绪论 2 1.1 研究内容 2 1.2 研究方法 2 1.3 研究目的 2 1.4 研究成果 2 1.5 研究展望 3 第2章 预备知识 4 2.1 数据库相关的基本概念 4 2.2 SQL数据库 6 2.3 Vis