旅游网站(旅游信息管理系统)的设计与实现(SQL)(含录像)

摘要

当今社会己进入信息社会时代。信息己经受到社会的广泛关注，被看作社会和科学技术发展的三大支柱（材料、能源、信息）。信息是管理的基础，是进行决策的基本依据。在一个组织里，信息己作为人力、物力、财力之外的第四种能源，占有重要的地位。然而，信息是一种非物质的，有别于基本资源的新形式的资源。信息也是管理的对象，必须进行管理和控制。

本文主要介绍了旅行社会员认证查询系统的设计，本系统主要采用JSP为编程语言，数据库采用 SQLSERVER 2000。可以方便旅行社会员管理需要。主要包括会员信息管理，新闻资讯活动管理，线路查询等功能。本系统易于操作，使用方便，交互性强，具有很高的可靠性。 

关键词： 总体设计    数据库设计    JSP 

 

Abstract

Now social oneself enter the information society time. Information oneself undergoes to society's widespread attention, is regarded as social and the scientific technological advance three big props (material, energy, information). The information is the management foundation, is carries on policy-making the basic basis. In an organization, information oneself takes outside the manpower, the physical resource, the financial resource fourth kind of energy, holds the important status. However, the information is one non-material, is different with the base resources the new form resources. The information is also the management object, must carry on the management and the control.

This article mainly introduced the travel agency members authenticate referral system's design, this system mainly uses JSP is the programming language, the database uses SQLSERVER 2000. May facilitate the travel agency members to manage the need. Mainly includes the member information management, the news information activity management, functions and so on line inquiry. This system simplify operation, the easy to operate, interactive to be strong, has the very high reliability.

Key word:  System design   Database design     JSP  

 

目    录

摘要 1

Abstract 2

1. 绪论 3

2.JSP软件介绍 3

2.1 JSP介绍 3

2.2 数据库的介绍 4

2.3关系型数据库的实现 5

3. 项目定义 6

3.1 系统分析 6

3.2 问题定义 7

3.2.1设计目的和任务 8

3.2.2 设计要求 8

3.3 可行性分析 9

3.4  需求分析 10

4.系统开发 11

4.1 系统设计 11

4.2本系统的总体设计 12

4.3详细设计 13

4.4、E-R模型简介 14

4.5、本系统的E-R图及数据库表的结构 15

4.6 模块功能实现 17

系统调试与测试 20

5.1 程序调试 21

5.2 程序的测试 21

5.2.1 测试的重要性及目的 21

5.2.2 测试的步骤 22

5.2.3 测试的主要内容 23

6. 问题解决过程及体会 24

致    谢 25