jsp+sqlserver家用电器商品销售管理系统设计
本文以家用电器商品销售的信息管理为例子设计销售信息管理系统.对家电商品进行进货、库存和销售进行系统化的管理。该系统实现的主要功能有：系统管理，登陆用户信息的增加与修改；基本信息管理：商品、供应商和客户信息的录入；销售业务，商品的销售业务；查询统计，对基础信息的查询，销售信息统计；库存管理，商品的入库和出库业务，商品的进货业务。
[毕业论文关键词]：商品销售；MVC架构；java；sqlServer2008
Abstract
Business information management system is with the business, procurement, inventory management, financial management, business and other related information management system, it covers the most important and the most core part of the business enterprise. Among them, the sales information management system is a typical application of managing information system (MIS), its development mainly includes the backstage database the establishment and maintenance of and front-end application development two aspects. The establishment and maintenance of the background data is required to establish data consistency and integrated, data security good characteristics such as database, and front-end application development is refers to the application can provide a simple and convenient use, the characteristics of friendly interface and powerful data manipulation functions.
Based on the household appliances sales information management design sales information management system for example. To replenish onr's stock, inventory and sales of home appliance commodity systematic management. the main function of the system are: system management, the increase of the user information and modification; Basic information management: goods, supplier and customer information input; Sales, sales operations; Query statistics, query of basic information, sales information statistics; Inventory management, inbound and outbound goods business, commodity purchase business.
[Key Words]：Sale management system；MVC architecture；Java；Sqlserver2008
目 录
摘 要 I
Abstract II
1、绪论 1
1.1 研究背景及意义 1
1.2 主要研究工作 1
2. 开发工具简介 2
2.1 Eclipse简介 2
2.2 SQLserver2008简介 2
3. 需求分析 3
3.1 系统业务流程分析 3
3.2 功能模块分析 4
3.3 系统开发分析 10
4.系统设计 12
4.1 系统功能图 12
4.2 数据库设计 12
5.系统功能实现 19
5.1 系统开发简介 19
5.2 操作界面实现 19
5.3 系统功能实现 21
5.4 程序目录结构 29
6.项目总结 32
参考文献 33
致 谢 34
家用电器商品销售管理系统设计与实现
1. 绪论
1.1 研究背景及意义
随着市场经济的飞速发展，销售商业务范围的不断扩大，销售企业之间的竞争将越来越激烈，销售业务所需要处理的数据量越来越庞大，企业想得到更好的发展机会，就需要改变企业的经营模式，提高企业的运营效率。一直以来人们使用传统人工的方式管理文件档案、统计和查询数据，这种管理方式存在着许多缺点，如：效率低、保密性差。人工的大量浪费；另外时间一长，将产生大量的文件和数据[2]，对日常业务过程中商品信息更新、查找和维护都带来了不少的困难，这种传统的管理手段已经不能满足市场和顾客的需要，企业急需管理系统来实现商品的数据和信息的管理。