摘要旅游网站建设是面向现实需求的一个实用系统。其设计的目的是为游客和旅游网站提供一个友好的、直接的交流平台。本系统主要分为六大模块:旅游咨询信息、旅游线路信息、热点旅游线路信息、线路查询、留言信息以及权限管理。该系统的主要功能:提供给管理者一个简单的界面,可以合理计划安排导游的工作和及时了解游客的要求和信息;提供给游客一个清新的界面选择自己向往的旅游胜地。本系统采用JSP进行开发,结合SQLSEVER来创建数据库和程序跟踪与管理信息。本系统的设计过程完全按照软件工程的要求开发的,主要分为以下几个步骤:首先进行可行性研究;第二步进行详细调查,需求分析;第三步进行系统总体结构设计,完成系统所需的数据库设计;第四步进行系统详细设计,最后进行软件编码和系统测试。关键词:总体设计;数据库设计;详细设计;JSP;SQLSERVERAbstractThetravelingwebsiteconstructionisfacestherealisticdemandanutilitysystem.Itsdesign'sgoalisinafriendlywayprovidesoneforthetouristandthetravelingwebsite,thedirectexchangeplatform.Thissystemmainlydividesintosixbigmodules:Travelingconsultationinformation,touristrouteinformation,hotspottouristrouteinformation,lineinquiry,messageinformationaswellasjurisdictionmanagement.Thissystem'smajorfunction:Providesforthesuperintendentasimplecontactsurface,mayplanreasonablyarrangestourguide'sworkandunderstandstourist'srequestandtheinformationpromptly;Providestouristattractionwhichafreshcontactsurfacechoosesitselfforthetouristtoyearn.ThissystemusesJSPtocarryonthedevelopment,unifiesSQLSEVERtofoundthedatabaseandtheprogramtrackingandthemanagementinformation.Thissystem'sdesignprocessdeferstothesoftwareengineeringcompletelytherequestdevelopment,mainlydividesintothefollowingseveralsteps:Firstconductsthefeasibilitystudy;Secondstepcarriesonthecloseinvestigation,thedemandanalysis;Thirdstepcarriesonthesystemgrossstructuredesign,completesdatabasedesignwhichthesystemneeds;Fourthstepcarriesonthesystemdetaileddesign,finallycarriesonthesoftwarecodeandthesystemtest.Keyword:SystemdesignDatabasedesignDetaileddesignJSPSQLSEVER目录摘要...........................................................................................................................................1Abstract...........................................................................................................................................21.绪论.............................................................................................................................................51.1选题背景...........................................................................................................................61.2选题依据...........................................................................................................................61.3旅游系统现状...................................................................................................................62.JSP软件介绍................................................................................................................................82.1JSP介绍............................................................................................................................82.2JSP版本简介..................................................................................................................82.3JSP语言的基本特点......................................................................................................92.3.1可视化设计.........................................................................................................102.3.2事件驱动编程......................................................................................................112.4数据库的介绍..................................................................................................................112.5关系型数据库的实现......................................................................................................122.5.1JDBC数据访问接口............................................................................................132.5.2JDBC的体系结构............................................................................................132.5.3JDBC访问后台数据库的技术实现方法........................................................142.6旅游系统软件开发方法.................................................................................................143.项目定义...................................................................................................................................163.1系统分析.........................................................................................................................163.2问题定义.........................................................................................................................163.2.1设计目的和任务..................................................................................................173.2.2设计要求.............................................................................................................173.3可行性分析.....................................................................................................................183.4需求分析.......................................................................................................................194.系统开发.....................................................................................................................................214.1系统设计.........................................................................................................................214.2本系统的总体设计.................................