基于网络超市商品销售管理系统的设计与实现

论文字数:15796,页数:37

摘  要
随着互联网日益深入我们的生活，网上商品销售的方式也逐渐被人们所接受，因而集成销售管理功能的网上销售系统也显得更加重要而实用。鉴于此，本课题设计了基于网络超市的商品销售管理系统。首先，论文简单介绍了商品销售管理系统的产生、发展和现状；然后对本系统使用的几项关键技术做了介绍；最后用软件工程的分析方法从系统需求分析、系统设计、数据库设计、系统实现等几个方面对整个系统进行了阐述。同时对系统的功能，包括商品目录显示、用户注册、用户登录、购物车、定单查询、系统维护管理等功能模块进行了实现。本系统主要运用了HTML、JSP编程技术与SQL Server数据库等关键技术进行设计、实现。设计中使用页面模块化思想，并部分采用三层架构思想，使用JavaBean 完成对数据库的操作，对销售管理、系统维护部分使用Servlet技术实现。当然系统还存在许多不足之处有待改进，特别是安全方面的问题还没有很好的考虑和实现。

关键词：网络超市；管理系统；JSP；JavaBean；Servlet
The Design and Implement of the System of Trade and Management of Products based on Online Supermarket
Abstract
As the close link of Internet with our lives, the online trading has been accepted by people gradually. So the online integrating system of trade and management becomes very important and useful. Therefore, this project designs the system of trade and management of products based on online supermarket. At the beginning, the paper introduces the origin, development and the current situation of the system of trade and management of products briefly. Then it describes some key technologies simply being used by the system. Finally, the system has been analyzed from several aspects, such as the analysis of requirement, designs of the whole system, database design and the implementation of system by using the methods of software engineering. Meanwhile, this project implements the functions which the system requires, including the catalogs, user registration, user login, shopping cart, order inquiry, maintenance and management of system and so on. The system builds this online shopping system based on HTML, JSP and SQL Server database. In the process of designing system, the thinking of modularization of pages and three-layer structure is adopted in the project. The operation of database is made by using JavaBean. Servlets are used to achieve some parts of the system, such as the trade management and system maintenance. But lots of improvements should be made for this system, especially the security issue which is not solved properly.

Key words: Online Supermarket; Management system; JSP; JavaBean; Servlet

目  录

1 引言 1
1.1选题背景 1
1.2国内外发展现状 1
1.3本课题的研究内容及方法 2
2技术理论基础及开发平台 3
2.1 技术理论基础 3
2.1.1 HTML语言 3
2.1.2 JSP技术 4
2.1.3 SQL Server数据库 5
2.2 开发平台 5
2.2.1 简介 5
2.2.2 特点 6
3 需求分析与设计方案 6
3.1 需求分析 6
3.1.1 需求背景 6
3.1.2 可行性分析 7
3.2 设计方案 8
3.2.1 设计目标 8
3.2.2 系统总体设计 8
4 各模块及数据库设计 9
4.1 数据库设计 9
4.1.1 数据分析 9
4.1.2概念结构分析 10
4.1.3逻辑结构分析 11
4.2各模块详细设计 13
4.2.1 用户模块 13
4.2.2 在线模块 14
4.2.3 系统维护模块 17
4.3主要核心代码 17
4.3.1 数据库连接 17
4.3.2 登录确认 18
4.3.3 购物车 19
4.3.4 管理员维护 21
5 系统的运行结果 24
5.1 实验环境与结果 24
5.1.1 实验环境 24
5.1.2 运行结果及分析 25
5.2 系统的不足及改进方法 28
结    论 29
参考文献 30
致    谢 31