本科生毕业论文
网上订餐系统设计与开发
Design and Development of Online Meal
Ordering System
所在院(部)：
学生姓名： 指导教师： 研究起止日期：
年 月
摘 要
随着时间的推移，计算机网络覆盖全球，今天的中国也以计算机为核心，计算机的出现给生活带来了很多的便利，各行各业都依赖于计算机的使用。网上订餐已变成当今年轻人喜爱的生活方式之一。网上订餐系统基于JSP，采用了Jsp+javaBean+MySQL技术。MySQL为数据库开发平台，Tomcat作为信息服务器，Jsp作为前台页面显示。网上订餐系统，可以让用户在线浏览菜品信息（图片，文字描述）、在线下订单、查看购物车，留言板、查询订单等功能。系统管理员可以添加和删除的菜肴，管理用户，管理删除订单。与普通的订餐相比，网上订餐系统为用户和商家都提供了更高的效率和更便捷的手段 。
关键词：网上订餐； MVC模型；Jsp
Abstract
With the passage of time, the computer network has covered the whole world, today’s China also takes computers as the core. The appearance of computers bring much convenience to life, all walks of life are dependent on the use of computers. Online meal ordering has become one of young people’s favorite ways of life at present. The online meal ordering system is based on JSP and uses the MVC model with Jsp+javaBean+SQL three-layer structure. The system takes MySQL as the database development platform, Tomcat as the information server and Jsp as the front page display. The online meal ordering system allows users to browse information of dishes online (pictures, text descriptions) and place orders online, View your shopping cart, message board, query the order. The system administrator can add and delete dishes, manage users, and manage and delete orders. Compared with ordinary meal ordering, the online meal ordering system provides users and merchants with higher efficiency and more convenient means.
Keywords: online ordering; MVC; JSP
目 录
1．绪论 ............................................................................. 1
1.1 背景及意义 .................................................................. 1 1.2 国内外现状 .................................................................. 1 1.3论文主要工作 ................................................................. 2 1.4论文结构安排 ................................................................. 2 2．相关语言及开发工具介绍 ........................................................... 3
2.1 JSP ......................................................................... 3
2.1.1 JSP重要功能 ........................................................... 3 2. 2 JDBC介绍 ................................................................... 3 2. 3 SERVLET技术 ................................................................. 4 2. 4 MVC介绍 .................................................................... 4 2.5 MYECLIPSE 简介 ............................................................... 5 2.6应用服务器 TOMCAT ............................................................. 5 2.7 本章小结 .................................................................... 5 3．网上订餐系统的分析和总体设计 ..................................................... 6
3.1系统设计分析 ................................................................. 6 3. 2系统用户分析 ................................................................ 6
3.2.1普通用户 ............................................................... 6 3.2.2管理员 ................................................................. 6 3.3系统功能分析 ................................................................. 7
3.3.1前台模块分析 ........................................................... 7 3.3.2后台模块分析 ........................................................... 7 3.4本章小结 ..................................................................... 8 4．系统数据库设计 ................................................................... 9
4.1 设计图 ...................................................................... 9 4.2数据库设计 .................................................................. 11 4.3本章小结 .................................................................... 13
5．系统模块设计实现 ................................................................ 14
5.1前台主要模块功能设计 ........................................................ 14
5.1.1数据库链接 ............................................................ 14 5.1.2用户登录模块功能设计 .................................................. 15 5.1.3商品模块功能设计 ...................................................... 16 5.1.4购物车模块功能设计 .................................................... 20 5.1.5订单模块功能设计 ...................................................... 21 5.1.6留言板模块功能设计 .................................................... 22 5.2后台主要模块功能设计 ........................................................ 24
5.2.1管理员登录模块功能设计 ................................................ 24 5.2.2菜单管理模块功能设计 .................................................. 26 5.2.3用户管理模块功能设计 .................................................. 29 5.2.4留言管理模块功能设计 .................................................. 31 5.2.5订单管理模块功能设计 .................................................. 31 5.3查询分页 .................................................................... 34 5.4网站系统测试 ................................................................ 35
5.4.1功能测试 .............................................................. 35 5.4.2数据测试 .............................................................. 35 5.4.3测试结果 .............................................................. 36 5.5本章小结 .................................................................... 36 结束语 ............................................................................. 37 参考文献 ........................................................................... 38 致谢 ............................................................................... 39