TheDesignandImplementationofASPWebSiteNewsManagementSystemsAbstractTheuseofASPandSQLtechnologynewssitemanagementsystem,toachievethedynamicmanagementofthenewsWebsite,makingthemanagementofinformationmoretimely,efficient,improvetheworkefficiency.Atthesametime,thedevelopmentofsystemstheory,systemsanddesignfeaturesareintroduced.[Keyword]ASP,SQL,newsmanagement,databaseWiththepopularizationofInternet,moreandmorecompaniessetuptheirown:1.ASPpagetoopenasaresultofeachmustbecompiledtoexplaintheprocess,sowhenthepageopensintherateofrepeatedthereisnoupgrade,andonlyneedaASP.NETpagedonotneedtorecompilecompileduntilthepagehasbeenmodifiedorWebApplicationprocessrestarted.Thismakesthespeedinanumberofvisitshasgreatlyimproved.2.AstheASPdoesnotprovideanyoutputdataforthecontentofthecomponents,sowritingadatabaseusingASPpagecanusetheRecordSetObjectADOtoreadrecordsoftransaction,whiletheASPprovidedthroughtheDataGrid,suchasADO.NETdatabaseanddatabasecomponentscanbedirectlyContact.3.ASPsupportreal-timeapplicationupdates.Administratorsdonothavetoturnoffthenetworkserverorevendonothavetostoprunningtheapplicationcanupdatetheapplicationonfile.Applicationdocumentswillneverbelocked,soevenwhentheprogramrunsinthepapercanbeoverwritten.Whenthedocumentisupdated,thesystemwillconverttothenewmoderateversion.4.ASPtakethecode-behindapproachtothepreparationofthecodemakesthecodeeasiertoprepare,structuremoreclearly,reducingthesystemdevelopmentandmaintenanceofthecomplexityandthecostof.1SystemDevelopmentPrinciple1.1TheSystemArchitectureModelofASP-basedTechnologyASPisathree-tiersystemstructure:UILayer,BusinessLogicTieranddatalayer.UIlayerisresponsibleforinteractionwiththeuser,receivinguserinputandserver-sidedatafrompresenttoclients.BusinessLogicTierisresponsibleforreceivingrequestsfrombrowserrequeststothedatalayersandatthesametimetheresultsoftherequestsenttothebrowser.ItconsistsofWebForms,XMLWebservicesandservicecompositioncomponents.WebFormsASP.NETwhichisthecoreoftheapplication,itispresentedtocustomersbasedondataandinformationaswellastorespondtoanddealwithcustomersanddisplayinteractiveWebformgeneratedbasedoninformationanddata.DatalayerstomanipulatedatathroughtheADO.NETlayerforbusinesslogictoprovidedataservices,suchasstoringtheresultsofdatamanipulationandreturntotheresultsofdataretrieval.1.2TheprincipleofaccesstothedatabaseADO.NETConnectedwiththedatabase,ADO.NETprovidethefollowingthreekindsofways:throughODBCconnected;connectedthroughOLEDB;directlyconnectedwiththeSQLServer.Applicationofthreekindsofwaysasaresultofdifferencesinlevels,makingtheefficiencyfromlowtohigh,hightolowindependence.Connectedtothedatabasefordataprocessing,therearetwokindsofways,thatis,throughaDatasettotheisolationofheterogeneousdatasources,andtheotherisastreamtoreadfromthedatasource(DataReadermode).Traditionalapplicationistocreateaconnectiontothedatabase,intheprocessisrunningthewholewaytomaintainconnectionstothedesign.ASP.NETtakendisconnectedmodedatastructure.WhenabrowserrequestsapagetotheWebserver,theservertodealwiththisrequest,therequestedpageandsendtoyourbrowser,andthenconnectionwasdisconnecteduntilthenextbrowserrequestissued.ADO.NETAnotherinnovationistheintroductionofadataset(Dataset).Adatasetistherelationshipbetweenmemorymaptoprovidehigh-speeddatabuffer.Datasetofdatasourcesknowthattheycanbeadoptedbytheprogramortransferredfromthedatawarehousedataweregenerated,tofill.Regardlessofwherethedataacquisition,datasetsarethesameprocedurethroughtheuseoftemplatestobeoperated,andit'spotentialtousethesamedatabuffer.2SystemsFunctionalDesigns2.1SystemsFunctionStructuresThenewsmanagementsysteminWindows2000Serveroperatingsystemplatforms,WebserverIIS,thedatabaseserverforMicrosoftSQLServer2000,developmenttoolsusedinMicrosoftVisualStudio.NETandDreamWeaver.Itsworkprocessesasfollows:theuserloginthroughtheauthoritytodeterminethegeneralusercanonlybrowse,readandqueryinformation,registereduserscanbecompletedinadditiontotheordinaryus