毕业设计商品进销存系统论文4ZYl9.doc

商品进销存系统摘 要中小型批发、零售企业及连锁店往往存在一些共同的特点和问题，为了解决问题，我们设计了商品进销存系统。该系统是一个多层数据库系统，使用VB做为前端开发工具，以SQL SEVER2000做为后台数据库操作平台，并使用ODBC连接访问数据库。系统开发的总体任务是实现各种信息的系统化、规范化、自动化。以进、销、存管理为基本要求,主要功能包括：用户名和密码的管理、基本信息的输入和修改、进货信息的管理、销售信息的管理、库存信息的管理、财务信息的管理。设计的模块主要是实现用户名和密码的管理、基本信息的输入和修改、进货信息的管理。关键词：商业信息管理,数据库,SqlSever2000,Visual BasicAbstractThere are some still common characteristics and questions among the retailers and chain stores in selling medium and small-scale in batches. In order to solve these problems, we have designed the system of goods’inlet ,sale and stored . This system is a multi-layer database system,which use VB as the front developing instrument, SQL SEVER2000 as backstage supporters database operating platform and ODBC to connect and visit the database.The overall task of this system developed is to put different information systematizations , standardizatiosn , automizations into reality. The basic demand includes enter commodity, sell commodity and store commodity. The main function includes: the management of user name and password’s input,the basic information of input and modification,the management of stocking information ,stored information and financial information . The module that I designed mainly achieve the management of user name and password’s input,the basic information of input and modification,the management of stocking information.Keywords: Business information management,Database,SqlSever2000,Visual Basic目 录 TOC \o 1-3 \h \z HYPERLINK \l _To绪 论 PAGEREF _To\h 4 HYPERLINK \l _To1 开发工具简介 PAGEREF _To\h 5 HYPERLINK \l _To1.1 SQLSEVER 2000 PAGEREF _To\h 5 HYPERLINK \l _To1.1.1 介绍 PAGEREF _To\h 5 HYPERLINK \l _To1.1.2 安装环境和过程 PAGEREF _To\h 5 HYPERLINK \l _To1.1.3 基本知识 PAGEREF _To\h 5 HYPERLINK \l _To1.1.4 基础语法 PAGEREF _To\h 6 HYPERLINK \l _To1.1.5 数据库的相关操作 PAGEREF _To\h 8 HYPERLINK \l