4.2.2 主键与外键 ........................................... 13 4.2.3 基本表的性质 ......................................... 13 4.3 数据库表设计 ............................................... 13 第5章 详细设计 ................................................... 18

5.1 前台功能模块 ............................................... 18

5.1.1 首页 ................................................. 18 5.1.2 产品查询 ............................................. 20 5.1.3 购物车 ............................................... 21 5.1.4 收银台 ............................................... 23 5.1.5 用户维护 ............................................. 25 5.1.6 订单管理 ............................................. 28 5.2 后台功能模块 ............................................... 31

5.2.1 登录页面 ............................................. 31 5.2.2 权限管理 ............................................. 32 5.2.3 系统管理 ............................................. 35 5.2.4 分类管理 ............................................. 36 5.2.5 商品管理 ............................................. 38 5.2.6 用户管理 ............................................. 39 5.2.7 订单管理 ............................................. 41 5.2.8 网站前台 ............................................. 41

第6章 系统测试 ................................................... 42

6.1 测试环境 ................................................... 42 6.2 系统测试 ................................................... 42 结 论 ............................................................. 45 致 谢 ............................................................. 46 参考文献 ........................................................... 47 附录 设计系统部分源代码 ........................................... 49

II

Contents

ChapterⅠ Introduction .............................................................................................. 1

1.1 Purpose of the study of research ...................................................................... 1 1.2 Research background ....................................................................................... 1

1.2.1 e-commerce ............................................................................................ 1 1.2.2 Jquery ...................................................................................................... 2 1.2.3 Ajax ......................................................................................................... 2 1.2.4 Json ......................................................................................................... 3 1.3 Project development environment ................................................................... 4

1.3.1 hardware environment ............................................................................ 4 1.3.2 software environment ............................................................................. 5

ChapterⅡ Overall Analysis........................................................................................ 6

2.1 Feasibility analysis ........................................................................................... 6

2.1.1 Technical Feasibility ............................................................................... 6 2.1.2 Economic feasibility ............................................................................... 7 2.1.3 Social Feasibility .................................................................................... 7 2.2 System functional requirements analysis ......................................................... 7 2.3 System performance requirements analysis ..................................................... 8 ChapterⅢ Functional Module Design....................................................................... 9

3.1 Design of foreground function module ............................................................ 9 3.2 background function module design .............................................................. 10 ChapterⅣ Database Design .................................................................................... 12

4.1 Overview ......................................................................................................... 12 4.2 Database design principles ............................................................................. 12

4.2.1 Relationship between the original document and the entity ............... 12

I

4.2.2 primary key and foreign key ................................................................ 13 4.2.3 The nature of the basic table ................................................................ 13 4.3 Database table design ..................................................................................... 13 ChapterⅤ Detailed Designs...................................................................................... 18

5.1 Front desk function module............................................................................ 18

5.1.1 Home ..................................................................................................... 18 5.1.2 Product Inquiry ..................................................................................... 20 5.1.3 Shopping Cart ....................................................................................... 21 5.1.4 Cashier .................................................................................................. 23 5.1.5 User Maintenance ................................................................................. 25 5.1.6 Order Management ............................................................................... 28 5.2 Background function module ......................................................................... 31

5.2.1 Login Page ............................................................................................ 31 5.2.2 Authority Management ......................................................................... 32 5.2.3 System Management ............................................................................ 35 5.2.4 Classification Management .................................................................. 36 5.2.5 Merchandise Management ................................................................... 38 5.2.6 User Management ................................................................................. 39 5.2.7 Order Management ............................................................................. 41 5.2.8 Website Front Desk .............................................................................. 41

ChapterⅥ System Testing ........................................................................................ 42

6.1 Test environment ............................................................................................ 42 6.2 System testing ................................................................................................. 42 Conclusion .................................................................................................................. 45 Acknowledgements .................................................................................................... 46 Reference .................................................................................................................... 47

Appendix Parts of Source Code of the Designed System .................................................. 49

II

第1章 绪论

1.1 课题研究的目的意义

现如今电子商务已经成为了网络发展的趋势，众多商家与创业者在寻觅网络商海中的机遇，而网上购物无疑是这场浪潮中的佼佼者。网上购物不仅满足了消费者的各种生活需求，使人们对网络的认识不再单纯的隔着屏幕，而是能切实的感受到网络的真实性，便捷性。而同时它又能带动周边经济的发展：网上支付渠道的多样，线下物流系统的不断完善，网上二手市场、网上拍卖会等。因此，一个比较完善的网上购物系统是当下消费者和投资者所共同期待的，它既能保障消费者对网络购物的热情和信任，又能使投资者得到预期或更大的回报。

1.2 课题研究背景

在本节中将对本课题的相关工作，如电子商务、系统主要应用技术等基本知识点进行背景介绍。

1.2.1 电子商务

电子商务是指在互联网（Internet）、企业内部网（Intranet）和增值网（VAN，Value Added Network）以上线上交易的方式进行交易活动和相关服务的活动，是传统商业活动各环节的电子化、网络化。电子商务是利用微电脑技术和网络通讯技术进行的商务活动[1]。

（1）电子商务的类型：从其交易对象来看，电子商务的应用包括企业与

1