TianjinUniversityofTechnologyandEducation毕业设计专业:网络工程班级学号:网0402-11学生姓名:**指导教师:**教授二〇一一年六月天津工程师范学院本科生毕业设计基于asp+sql的商务网站建设Thee-commercesitebasedonAsp+sqlbuilding专业班级:**学生姓名:**指导教师:**教授系别:计算机2011年6月摘要在Internet飞速发展的今天,互联网成为人们快速获取、发布和传递信息的重要渠道,它在人们政治、经济、生活等各个方面发挥着重要的作用。论文首先介绍了建立电子商务网站的意义,接着介绍“宠物天堂”网站的意义。继而阐述了Internet的相关知识及设计一个网站的步骤,然后阐述了本网站的整体规划与设计情况,并对制作网页所用到的相关软件的特点与应用作了概括说明,其中主要包括用DreamweaverMX制作页面,用SQLsever2000制作后台数据库,用asp实现互动功能,用Photoshop6.0加工处理图像等,并讲述了它们的使用要点及其方法。系统包括首页、用户注册、宠物陵园、后台管理四大功能模块,其设计过程涉及了网站的立意、策划、页面以及后台运行的程序等问题。系统由一个主页面和若干子页面以超连接的形式出现,各子页面之间也有联系,提供了较为有效和全面的服务。关键词:ASP;Dreamweaver;SQLABSTRACTTherapiddevelopmentofInternetoftoday,itbecomesanimportantchannelbywhichpeoplecanacquire,releaseandtransmitinformation.Itplaysanimportantroleinpolitics,economy,anddailylifeandsoon.First,thispaperintroducesthesignificanttoestablishthisWebsite.Second,itdiscussesbrieflytherelevantknowledgeabouttheInternetandthestepsofestablishingaWebsite,givestheplananddesignindetail,especiallythesoftwarerelatedtotheweb-pagedesigningisexplained.ItincludesmakingHomePagebyapplicationofDreamweaverMx,makingdatabasebySQLsever2000,makingactivepagesbyASP,processingimagesbyPhotoshop6.0,etc.Besides,itdiscussestheirimportantpointsandpretrayhowtousethem.Thispaperincludesthecontentthattheauthorwantstoexpress.Thesystemismadeupoffourfunctionalmodules:Homepage,userregistration.,petcemeteryandback-stagemanagement.Thisprocessincludesthesitestopic,design,pagesdesignandprogramruninbackground,andtheprocessestobuildingawebsiteandsomepointsthattheauthorshouldpayattentionincourseofmakingwebsites.Thesystemconsistsofonemaininterface.Theotherfunctionspresentinthemaininterfaceasmenus,itprovideamoreeffectiveandcomprehensiveservice.Keywords:ASP;dreamweaver;SQL目录1引言...........................................................................................................................11.1选题的意义和背景..............................................................................................11.2商务网站的发展历史及应用现状.....................................................................11.3本课题研究的内容和方法..................................................................................22ASP..........................................................................................................................42.1ASP的定义.........................................................................................................42.2ASP技术基本原理.............................................................................................42.3ASP的运行环境.................................................................................................52.4ASP技术在电子商务中的应用.........................................................................52.5ASP常用内置函数.............................................................................................73数据库结构设计与实现...........................................................................................123.1创建数据库.......................................................................................................123.2数据库逻辑结构设计.......................................................................................123.2.1管理员数据表Admin................................................................................133.2.2宠物信息表Pet.........................................................................................133.2.3用户信息表Users.....................................................................................143.3创建表的脚本文件...........................................................................................144网站设计与实现...................................................................................................154.1可行性分析........................................................................................................154.1.1经济可行性.................................................................................................164.1.2技术可行性.................................................................................................164.1.3运行可行性.................................................................................................164.2系统功能模块..................................................................................................164.2.1用户模块.....................................................................................................174.2.2宠物陵园模块............................................................................................224.2.3搜索模块....................................................................................................255结论.........................................................................................................................266参考文献.................................................................................................................277致谢.....................................................................................................................288附录:英译中.......................................................................................................