基于SQL Server的JSP宠物驿站的设计与实现

编号：_______________商丘科技职业学院毕业论文（设计）题目：基于SQLServer的JSP宠物驿站的设计与实现系别：计算机科学系专业：计算机软件技术姓名：刘洋兵成绩：指导教师：潘亚2011年4月商丘科技职业学院毕业论文（设计）I基于SQLServer的JSP网上书店的设计与实现摘要JAVA是当今流行的Web应用程序开发技术之一，作为一种B/S编写环境，它将HTML语言、java语言和服务器组件有机地结合在一起，可以用来创建交互式的动态网页和具有数据库访问功能的Web应用程序。从软件的技术层面看，JSP有与浏览器无关、易于生成、面向对象、源程序码不会外漏等特点。从应用的层面看，JSP可以处理由浏览器到站点服务器的表单输入;可以访问和编辑服务器端的数据库、读写Web服务器的文件和实现访问计数器的功能。正是这些特点和功能决定了JSP对传统IT业、硬件业、应用服务业以及通信业都会产生了巨大的影响。本文对网站构建的几种主要的技术，如网络技术、JAVA编程思想、IIS技术及网络数据库技术等进行了分析，研究了他们的具体应用方法，对它们的优劣也作了一些探讨;选用SQLServer作为后台数据库，MSVS作为前台的开发工具，并将软件工程相关理论应用于整个系统开发过程中。结合现有的设备条件和具体的实际情况，实现了基于JSP技术的网上书店计方案，该系统使用B/S模式,访问SQLServer数据库。实现用户的注册和登陆、图书的查询、定购、信息反馈等。关键词:宠物驿站;JSP;组织结构设计;SQLServer基于SQLServer的JSP宠物驿站的设计与实现IIDesignandImplementationofASP.NETOnlineBookstoreBasedonSQLServerAbstractNowadays,JSPisapopulardevelopmenttechnologyofWebapplication,Asascript-programmingenvironmentofserver,itcombinesHTML,javalanguage,scriptcodeandserverpackagetogetherorganically,canbeusedforestablishingWebapplication,whichhasinteractivedynamicwebpageandfunctionofdatabasevisit.Watchingfromtechnologicalaspectofsoftware,JSPhassomecharacteristicssuchas:canexistwithoutcompiling,easytoproduce,independentofbrowser,Orient-Object,sourcecodecan’tleak.Readfromtheaspectofapplication,JAVAcandealwiththeformfrombrowserinputtowebsiteserver;canvisitandeditserverdatabase,readandwriteWebfileofserver,realizethefunctionsthatdeterminedJSPtotraditionalItindustry,hardwareindustry,servicetrade,andcommunicationindustrywillallexertanenormousinfluence.Thepaperbuiltonthesiteofseveralmajortechnologiessuchas:networktechnology,andnetworktechnologiesServerdatabasetechnologyfortheanalysisandstudytheirspecificapplicationontheirmeritsandmadesomeexploring,selectionSQLServerasabackgrounddatabase,theJAVAasatoolforfuturedevelopment,andrelatedsoftwareengineeringtheorytotheentiresystemdevelopmentprocess,theintegrationofexistingequipmentconditionsandspecificconditions,basedonJAVABeantechnologytoachieveaonlinebookstoredesignformulation.Thissystem,basedonB/Smodel,linksandvisitstheMicrosoftSQLServerdatabaseregisteringandloggingin,bookconsultingandordering,andinformationfeedbackarerealized.Keywordsonlinebookstore;JSP;designoforganizationstructure;SQLServer商丘科技职业学院毕业论文（设计）III目录摘要.............................................................................................................................................IABSTRACT.................................................................................................................................II引言........................................................................................................................................-1-一、系统开发平台的配置........................................................................................................-1-（1）IIS组件简介................................................................................................................-1-（2）IIS组件的安装............................................................................................................-2-（3）IIS组件的设置............................................................................................................-2-二、开发平台的选择与工作原理............................................................................................-3-（1）采用JSP的优势...............................................................................................................3（2）JAVA的工作机制........................................................................................................-3-（3）JAVA的六大内置对象简介........................................................................................-4-三、网上书店的系统分析........................................................................................................-4-（1）宠物驿站模式的确定..................................................................................................-5-（2）系统数据流程分析......................................................................................................-5-（3）宠物驿站的数据库设计..............................................................................................-7-1.数据库概念结构设计.....................................................................................................-7-2.数据库逻辑结构设计.....................................................................................................-8-四、网上书店的功能设计......................................................................................................-12-（1）前台事务管理系统....................................................................................................-12-（2）后台事务管理系统....................................................................................................-13-五、网上书店有关技术的实现..............................................................................................-14-（1）数据库的链接............................................................................................................-14-（2）宠物的查询................................................................................................................-14-（3）订单的实现操作.......................