SQL SERVER 2005 课程设计网上订餐开发系统课程设计报告

摘 要

随着21世纪的进步，社会的生活节奏越来越快，网络的迅速崛起，互联网已日益成为提供信息的最佳渠道和逐步进去传统的流通领域，传统的餐饮业也面连着巨大的挑战，网上订餐主要是针对白领还有大学生这些特定群体，一些白领在中午时间或者晚上高峰时间就餐，许多顾客由于高峰时间拥挤根本没时间来享受美味，这样既可以提前订餐不浪费中午午休的时间，也可以和同事加深感情，更可以每天换各种各样的菜式，保证每天工作的效率和身体的健康，这些问题就产生了快捷订餐的要求，最快的方式莫过于利用计算机网络，将餐饮业和计算机网络结合起来，就形成了网上订餐系统，能足不出户，轻松闲逸地实现自己订购餐饮和食品（包括饭、菜、盒饭便当等），有能力的餐饮企业对对餐品提供商提供网上订餐服务，不仅提高餐饮企业的服务质量，扩大知名度，也是为最终用户提供方便快捷的食品服务方式。 关键字：网上订餐，计算机网络，时尚化

1

ABSTRACT

Along with the progress of the 21st century, the social life rhythm faster and faster, the rapid rise of the Internet, the Internet has increasingly to be the best channel to provide information and gradually entered the traditional circulation field, traditional food and beverage industry also face is attached to a huge challenge, online order these specific groups mainly for white-collar workers and college students, white-collar workers in the noon meal time or evening rush hour, many customers because of the crowded rush hour had no time to enjoy the tasty, both to reservation in advance is not a waste of time for my lunch break at noon, also can and colleagues to deepen feelings, more can every day in a wide variety of dishes, ensure daily work efficiency and the health of the body, these problems arise and quick reservation request, the fastest way is by using computer network, combine the restaurant industry and computer network, it formed the online reservation system, can never leave home, leisure easily to realize their ordering food and beverage and food, including rice, vegetables, bento lunch box, etc.), capable of catering enterprises to the rightness products provider to provide online reservation service, not only improve the service quality of catering enterprises, enlargement popularity, but also for the end user to provide convenient and quick way of food service.

KEY WORDS: online,reservation,fashionable,computer,network

2

目 录

引 言 ........................................... 1 第一章 系统开发的意义、目的及功能 ................. 2

1.1开发意义 ................................... 2 1.2开发目的 ................................... 2 1.3系统功能 ................................... 2 第二章 需求分析 .................................. 3

2.1 可行性分析 ................................. 3 2.2 功能需求分析 ............................... 3 2.3 性能与安全性分析 ........................... 4 2.4 软件设计的目的及背景 ....................... 4 2.6软件设计的思想与目标 ....................... 4 第三章 系统设计 .................................. 5

3.1 功能结构图 ................................. 5 3.2 角色的确定 ................................. 5 3.3 创建用例 ................................... 6 3.4 创建角色与用例关系图 ....................... 7 3.5 数据库需求分析 ............................. 7 3.6 数据库设计原则 ............................. 8 3.7 数据库表清单 ............................... 8 3.8 创建E-R图 ................................ 14

3

第四章 系统详细设计 ............................. 18

4.1 模块功能 ................................. 18

4.1.1 普通用户子系统模块 ........................ 18 4.1.2 管理员子系统模块 ........................... 19

4.2 用户界面 .................................. 4.2.1 登录界面 ................................... 204.2.2 操作界面 ................................... 21第五章 开发工具 ............................... 5.1 ASP功能介绍 .............................. 5.1.1 ASP简介 ................................... 225.1.2 ASP的功能 .................................. 235.1.3 使用ASP与SQL Server架设网站 ............... 235.1.4 使用范围 ................................... 235.2 SQL Sever 2005简介 ...................... 5.3 ODBC简介 ................................ 5.4 Dreamweaver简介 ......................... 5.4.1 便捷的网站管理 ............................. 265.4.2无可比拟的控制力 ............................ 265.4.2所见即所得的特点 ............................ 265.5 VBScript简介 ............................ 5.6 IIS服务器介绍 ...........................

4

20

22

22

24 25 26

26 27