系统是用JSP在网络上架构一个动态的电子商务网站,它是在WINDOWSXP下,以SQL Server 2000为数据库开发平台,Tomcat网络信息服务作为应用服务器,采用JSP(Java Server Pages)技术开发的网上购物系统。 本系统主要为用户提供了会员注册,购物车管理,商品搜索,用户资料修改等功能,为管理员提供了商品管理,用户信息管理,新闻信息管理,广告链接管理等功能。在设计方面,本系统采用B/S三层结构,同时使用JSP技术进行动态页面的设计,从系统的安全性和代码的可重用性方面考虑,运用JavaBean对程序的关键代码进行封装。后台数据库选用SQLSERNER 数据库。关 键 词:网上购物; JSP;数据库;商品管理;论文类型:设计报告 Title: The Design of The Shop OnLine System Speciality: Major of Computer Science & Technology Applicant: Liangjia Supervisor: Prof. Zhaoyanfeng ABSTRACT Online shopping, product information is retrieved via the Internet, and electronic purchase orders issued by shopping request, and then fill in the personal check or credit card account number, vendor shipments by mail order or home delivery by courier There is no longer meet use and dissemination of information browsing, but a desire to bring the full enjoyment network more convenient. Internet shopping is being adapted to the fast pace of todays society to live, so that customers can enjoy the convenience of fast and easy way to purchase their own like commodities. The thesis has firstly introduced the practical situation and the developing background of the system. And then has described the designing goal、system need and the whole designing plan, has described the detailed design and reality of the system in detail. Finally, conclusion has been drawn about the system and problem has also been raised.
The system is trying to use JSP in a dynamic network of e-commerce websites structure, which is in Windows XP, SQL Server 2000 for database development in platform, Tomcat application server as a network information services, use JSP (Java Server Pages) technology development online shopping system.
The system has mainly provided users with the following functions: membership registration,shopping car management,goods search、information modify etc. It has also provided managers with goods management,customer information management,news management , management and so on. It has been designed with B/S mode of three-tier structure, JSP technology in dynamic page design. Considering from the security and reusing code of the system, key codes has been secured by JavaBean technology. Access database has been used as the background database.KEY WORDS: Online shopping; JSP;database; systemTYPE OF THESIS: Design Report 目 录1 绪论 1 1.1前言 1 1.1.1网上购物系统的背景 1 1.2网上购物系统的概述 ..2 1.2.1网上购物系统的现状 ……………………………………………………2 1.2.1系统实现的目标 …………………………………………………………3 1.2.1系统的开发意义 …………………………………………………………4 2程序开发的技术基础 5 2.1 ?HTML语言 5 2.1.1 HTML语言概述 5 2.1.2 JAVASCRIPT语言概述 ……………………………………………………5 2.2 ?JSP技术 6 2.2.1 JSP概述 6 2.3数据库原理 ………………………………………………………………………7 2.3.1 SQL语言简单介绍 ………………………………………………………7 2.3.2 ADO技术介绍 ……………………………………………………………8 3网上购物系统需求分析 11 3.1系统的可行性分析 11 3.1.1网站的设计目标 11 3.1.2网站的可行性分析………………………………………………………12 3.2.3网站的深入调查…………………………………………………………12 3.2.4网站设计的特点…………………………………………………………12 3.2.5网站开发的设计思想……………………………………………………12 3.2.6系统的总体规则 …………………………………………………………12 3.2系统的功能分析 …………………………………………………………………12 3.2.1功能分析..................................................12 3.2.2数据库功能说明............................................13 3.3系统的需求分析…………………………………………………………………13 3.3.1需求分析..................................................13 3.1.2数据库需求分析............................................13 4网上购物系统的设计 ……………………………………………………………………15 4.1系统概要设计 ……………………………………………………………………15 4.1.1系统设计概述 ……………………………………………………………15 4.1.2系统原理 …………………………………………………………………15 4.1.3用户模块的程序流图 ……………………………………………………16 4.2 系统总体结构设计 17 4.2.1前台模块详细功能描述 17 4.2.2后台模块详细功能描述 …………………………………………………17 4.3系统详细设计 ……………………………………………………………………18 4.3.1代码设计..................................................18 4.3.2数据库结构设计............................................18 4.3.3数据库详细结构设计........................................18 4.4用户界面设计....................................................21 4.4.1输入设计..................................................21 4.4.2输出设计..................................................21 4.4.3人—机对话设计............................................22 5网上购物系统的实现 23 5.1各功能模块的实现 23 5.1.1数据库连接的实现 23 5.1.2用户注册模块的实现……………………………………………………23 5.1.3用户登录模块的实现……………………………………………………24 5.1.4购物车模块的实现………………………………………………………27 5.1.5后台管理模块的实现……………………………………………………28 6 系统测试 31 6.1系统运行环境的搭建
31 6.1.1 JAVA虚拟机的安装 31 6.1.2 Tomcat环境搭建…………………………………………………………31 6.2系统程序的安装和加载…………………………………………………………31 6.2.1文件的拷贝………………………………………………………………31 6.2.2数据库的连接……………………………………………………………31 6.3系统测试 31 6.3.1 系统测试分析 31 6.3.2单元测试分析 ……………………………………………………………33 6.3.3测试分析及说明 …………………………………………………………34 6.4系统维护 …………………………………………………………………………34 6.4.1系统维护 …………………………………………………………………34 7 结论与展望 37 7.1 结论 37 7.2 系统中存在的问题及展望 38 致谢 41 参考文献 43 附录 45 攻读学位期间取得的研究成果 47CONTENTS1 Introduction 11.1 Preface 1 1.1.1 Background of Online Shopping System 1 1.2 Overview of Online Shopping System 21.2.1 Online Shopping System Status 21.2.2 System achieve to Goals 31.2.3 System Development of Meaning 4 2 Technology base program development 52.1 HTML language 5 2.1.1 HTML Language Overview 5 2.1.2 JAVASCRIPT Language Overview 52.2 JSP Technology 6 2.1.2 JSP Overview 6 2.3 Database Principles 7 2.3.1 SQL languages brief Introduction 7 2.3.2 ADO technology Introduced 8 3 Online Shopping System Requirements Analysis 113.1 System Feasibility Analysis 11 3.1.1 Web site design goals 11 3.1.2 Site Feasibility Analysis 12 3.1.3 Site-depth investigation 12 3.1.4 Web site design features 12 3.1.5 Web site design development 12 3.1.6 The overall rules system 123.2 System Functional Analysis 12 3.2.1 Functional Analysis 12 3.2.2 Database Function 12 3.3 System Requirements Analysis 13 3.3.1 Needs Analysis 13 3.3.2 Database Needs Analysis 13 4 Online Shopping SystemDesign 154.1 Summary Design Of System 11 4.1.1 System Design overview 15 4.1.2 System Principle 15 4.1.3 User module program flow graph 164.2 System Architecture Design 17 4.2.1 Detailed description of the module features front 17 4.2.2 Detailed functional description of the background module 17 4.3 Detailed design of the system 18 4.3.1 Code design 18 4.3.2 DatabaseStructure Design 18 4.3.3 Database Detailed Structure Design 18 4.4 User Interface Design 21 4.4.1 Input Design 21 4.4.2 Output Design 21 4.4.3 Man - Machine Dialogue Design 22 5 Online Shopping System Implement 235.1 Implementation of each functional module 23 5.1.1 Implementation of database connection 23 5.1.2 Implementation User registration module 23 5.1.3 Implementation user login module 24 5.1.4 Implementation Shopping Cart Module 27 5.1.5 Implementation Management Module in the background 28 6 System Test 316.1 System operating environment built 31 6.1.1 JAVA virtual machine installed 31 6.1.2 Tomcat environment built 316.2 System installation and loading 31 4.2.1 Copies of documents 31 4.2.2 Database connection 31 6.3 System Test 31 6.3.1 System Test Analysis 31 6.3.2 Unit Testing Analysis 33 6.3.3 Test analysis and description 34 6.4 System Maintenance 34 6.4.1 System Maintenance 34 7 Conclusions and Outlook 37 7.1 Conclusions 377.2 System Problems and Outlook 38 Acknowledgements 41 References 43 Appendices 45 Achievements 47 Declaration 在每一章的末尾插入下一章的MathType的章标记(打印前将其字体颜色变为 1