资源预览需要最新版本的Flash Player支持。
您尚未安装或版本过低,建议您
Aug4,2005JournalofChinaUniversityofMiningTechnologyVol3,No21©19941996JournalofChinaUniversityofMiningTechnologyhttp//isedj.org/3/21/ASP.NETwebsitenewsmanagementsystemmanagementsystemdesignandrealizationLiangCheeWeeLutherCollegeDecorah,IA52101,USAAbstractusesASP.NETandADO.TheNETtechnologydevelopmentwebsitenewsmanagementsystemmanagementsystem,hasrealizedthewebsitenewsdynamicmanagement,evenmorepromptlycausedtotheinformationmanagement,tobehighlyeffective,enhancedtheworkingefficiency.Meanwhiletothesystemdevelopmentprinciple,thesystemfunctioncharacteristicandthedesignproposalhascarriedontheintroduction.KeywordASP.NETADO.NETnewsmanagementdatabaseAlongwiththeInternetpopularization,moreandmoremanyenterprisesestablishedownWWWwebsite,theenterprisehavebeenpossibletodemonstratetheproductthroughthewebsite,issuedthenewesttendency,carriedontheexchangeandthecommunicationwiththeuser,withpartnerestablishmentrelation,aswellasdevelopmentelectroniccommerceandsoon.Newsmanagementsystemmanagementsystemisconstitutestheenterprisewebsiteanimportantconstituent,itisshoulderingthedoubledeckedfunction,ontheonehandmayuseforthedynamicissuerelatednewproductorthenewdevelopmentproject,ontheotherhandmaypromptlytothecustomerannouncetheenterprisemanagestheachievement,thetechnologyandtheresearchanddevelopmentprogresses,recommendsorthepreferentialbenefitengineeringproject,theproductandtheservicespecially,thustheattractioncustomer,expandsthecustomergroup.Thetraditionalwebsitenewsmanagementwayhastwokinds,oneisthestaticHTMLpage,renewswhentheinformationneedsretomanufacturethepagethenontopassonthepageandtherevisioncorrespondinglink,thiswaybecausetheefficiencytooislownotnotmultipurposealready.Two,basedonASPandthescriptlanguage,thedynamichomepageandthedatabaseunion,processesthroughtheapplicationprocedurethenews,thisisapresentmorepopularprocedure.ButbecausetheASPitselflimitationenablesthesystemtohavesomeinsurmountableflaws,buthasadoptedASP.IntheNETtechnologysystemperformancehadtheverybigimprovement,itmainlydisplaysinfollowingseveralaspectsAfter1.becausetheASPpageeachtimeopenstheprocesswhichallmustpassthroughtranslatesfirstexplained,thereforethepageisopeningrepeatedlytimespeednotanypromotion,butASP.AftertheNETpageonlyneedsatimeoftranslationnottoneedretotranslate,isreviseduntilthispageortheWebapplicationprocedurerestarts.Thisenabledwhenvisitedmanytimesthespeedtohavetheenormouspromotion.2.becauseASPhasnotprovidedanyoutputdataforthecontentpart,thereforewhenusesASPcomposesthedatabasepageonlycandrawsupportfromADOtheRecordSetobjectreadingtherecordbythepen,butASP.NETpassesADO.NETprovidesdatabasepartandsoonDataGridmaydirectlywiththedatabaserelation.3.ASP.NETsupportapplicationprocedureASP.NETwebsitenewsmanagementsystemmanagementsystemdesignandrealization115©19941996JournalofChinaUniversityofMiningTechnologyhttp//isedj.org/3/21/realtimerenewal.Themanagerdoesnotneedtoswitchoffthenetworkserverornottoevenneedtostoptheapplicationprocedurethemovementbeingpossibletorenewtheapplicationdocument.Theapplicationproceduredocumentnevercanlock,thereforeeveninproceduremovementtimethedocumentmaycover.Afterthefileupdating,thesystemcantemperatelytransformtothenewedition.4.ASP.NETadoptedcodebehindthewaycompilationcodetocausethecodetochangeinthecompilation,thestructureisclearer,reducedthesystemdevelopmentandthemaintenanceorderofcomplexityandtheexpense.1systemdevelopmentprinciple1.1basedonASP.NETtechnologysystemstructuralmodelASP.TheNETstructureisthreesystemsUIlevel,servicelogiclevelanddatalevel.TheUIlevelisresponsiblewiththeuserinteractive,thereceiveusersinputandthedatawhichtransmitstheserverendpresentsforthecustomer.Theservicelogiclevelwillberesponsiblefortherequestwhichwillreceivethebrowsertotransmitandrequestedwillbequeaththedatalevel,atthesametimerequestedtheprocessingresultwillissuethebrowser.ItbytheWebform,XMLtheWebserviceandthemoduleserviceiscomposed.WebformisASP.TheNETapplicationprocedurecoreisat,itispresentsthedataandtheinformationfoundationtothecustomer,alsoistheinformationandthedatafoundationwhichtheresponseandtheprocessingcustomerandthedemonstrationWebformproducesalternately.ThedatalevelpassesADO.TheNEToperationdataprovidesthedigitaldataserviceforbusinesslogiclevel,likethestoreddatumoperatingresult,returnstothedataretrievalresultandsoon.1.2ADO.NETvisitdatabaseprincipleIsconnectedwiththedatabase,ADO.NEThasprovidedfollowing3waysIsconnectedthroughODBCIsconnectedthroughOLEDBDirectandSQLServerisconnected.3waysasaresultoftheapplicationleveldifference,causetheefficiency由低到高,independencefromGaoDaodi.Regardingconnecteddatabasedataprocessing,alsosome2ways,namelyonekindisisolatesisomerismthroughDataSetthedatapool,anotherkindisbyflowsthewayreadingtheDataReaderwayfromthedatapool.Thetraditionalapplicationprocedureisthroughestablishesfirsttothedatabaseconnection,maintainstheconnectionintheprocedureentiremovementprocessthewaytodesign.ASP.NEThasadoptedtheseparationconnectionwayconstructionofdata.WhenbrowsertoWebserverrequesthomepage,theserverprocessesthisrequest,andrequestedthehomepagetransmissionforthebrowser,thentheconnectionisseparated,sendsoutthenextrequestuntilthebrowser.ADO.TheNETanotherinnovationwashasintroducedthedatasetDataset.Adatasetisinthememoryprovidesthedatarelationalgraphthehighspeedbuffer.Thedatasetknowsnothingabouttothedatapool,theymayorthroughcallinthedatabytheprocedurefromthedatawarehousebuttoproduce,thepacking.Nomatterthedatafromwheregain,thedatasetallisbutisoperatedthroughtheusesimilarproceduretemplate,anditusesthesamelatentdatabuffer.2systemsfunctionaldesigns2.1systemsfunctionstructuresThisnewsmanagementsystemmanagementsystemmayoperatingsystemplatformmoveinWindowsin2,000Server,theWebserverisIIS,thedatabaseserverisMicrosoftSQLServer2000,MicrosoftVisualStudiowhichthedevelopmentkituses.NETandDreamWeaver.Chart2producesthesystemthefunctionstructuredrawing.ItsworkflowisTheuserregistersthroughthejurisdictionjudgment,theaverageconsumeronlycanglanceover,readingandtheinquirynews,theregistrationuserbesidesmaycompletetheaverageconsumertheoperation,butalsomayenterthenewsadministrationmoduletocarryonthenewsinput,Aug4,2005JournalofChinaUniversityofMiningTechnologyVol3,No21©19941996JournalofChinaUniversityofMiningTechnologyhttp//isedj.org/3/21/therevisionandthedeletionoperation.Theregistrationusereliminatessystemadministrationsupernumeraryofficialonlytobeablethenewswhichinputstooneselftocarryonthedeletionoperation.2.2systemsfunctioncharacteristics1operates,thecontactsurfacesimplyfriendlyControlsthelikepagelayoutcompletely,causesthenewstheinputworktobesimplerManyoptionsincludingthenewscategory,theorigindepartmentandsoononlyneedtoclickonthemousetobepossibletocompleteMoreover,thetrackappearsthepromptinformationalsoletstheuserasnecessaryclearownoperationsituation.2immediatelyobviouslyTothenewsprocessingincludinginput,revision,deletionimmediatelydemonstratedinthemainpagecorrespondingcolumn,achievestheimmediateissue,theimmediateeffectivefunction.3functionperfectIncludingcommonwebsitenewsmanagementeachaspectThenewsinput,thebrowsing,thedeletion,therevision,theretrievalandsooneachaspect,completelyhasrealizedthewebsitetotheimmediatenewsmanagementrequest.4facilitatesthetransplantInviewofthedifferententerprise,onlyneedstomaketherevisiontobepossibleslightlytodevelopsuitsthisenterprisecharacteristicthewebsitenewsmanagementsystemmanagementsystem3systemsdetaileddesignsThesystemmainfunctionisrealizesthroughseveralfunctionsmodules.Concretedesignprocessasfollows1systemregistersThismoduleisresponsibletheusertodivideintotheaverageconsumerandtheregistrationuserrealizestheuserjurisdictionmanagement.2newsbrowsingThismodulenegativedutiesandresponsibilitiespageliststhewebsiteallnewsinformation,includingthetitle,thetype,theorigindepartmentfieldandtheissuedate,eachnewstitleismadeanultralink,clicksonthemtobeabletojumptransfersthepagetocarryonnewsreading.3NewsreadingClicksonthetitlelinkinotherpagesnamelytoenterthenewsreadingpage,eachnewsdetailedinformationistakenthistimeout,includingthecontent,thetitle,thekeywordsandsoon,anddeferstotherelativelyfixedformtolayasideinthepagedifferentregion,allnewsusesamepagelayout,onlywillbeapproximatelyvariousfieldscorrespondencecontentisdifferent,moreover,thepageotherpositions,maythedynamiclayingasideotherparts,thecrisscrossedstationsymbolizelogo,linkpictureandsoonpageadvertisementbanner,mayveryeasilyrealizetheabundantandelegantreadingeffectlikethis.4newsinquiryThismoduleprovidedthenewsinquiryfunction,theinputhastreatedthesearchthecontentandthedesignationclassificationinformationmayfastfindconformstotheconditionnews,andoutputinquiryresult.5NewsmanagementThismodulenegativedutiesandresponsibilitiespagedisplayedtheregistrationuserwhichregistersoncetoissuealsothedeletionnewsinformation,theuserhasnotbeenpossibletocarryonthedeletion,therevisiontothisnews.Thenonnewsissueeliminatessystemadministrationsupernumeraryofficialnottohavetothisnewsprocessingjurisdiction,thereforethedifferentuserwillenterthispagetodemonstratethedifferentcontent.6newsinputandrevisionTheregistrationuserinputsthecontentwhichanewsneeds,containsthetitle,thekeywords,thetype,theorigindepartment,theissuedateandsoon,atthesametimefromregistersthemoduletoobtainuser,theseinformationarereadinthedatabasetopreserve.Thismodulealsoisresponsibletoeditundertheconditiontherenewal,bynow,itwillactaccordingtotheTitlefieldvaluewhichobtainedtothepagetocontrolaninitialization.Underregistersthepagetakethesystemthecompilationtoproducethemaineventandthefunctionastheexample,explainsthissystemtheperformancehistory.ASP.NETwebsitenewsmanagementsystemmanagementsystemdesignandrealization117©19941996JournalofChinaUniversityofMiningTechnologyhttp//isedj.org/3/21///IsRegUserOkfunctionWhetherthejudgmentuseralreadydidregisterandthepasswordwaswhethercorrectPublicboolIsRegUserOk{StringnameTextBoxName.Text.TrimStringpwdTextBoxPassword.Text.Trim//Establishment/OpensthedatabaseconnectionSqlConnectionconnnewSqlConnectionConn.ConnectionStringserverlocalUidsaPwdDatabasejxdbConn.Open//EstablishesthesqlstringofcharacterStringsqlselectfromregwherenamenameSqlDataReaderdrSqlCommandcmdnewSqlCommandsql,ConnDrcmd.ExecuteReader//RetentionuserregistrationornotinformationBoolisRegUserExistdr.Read//ClosesDataReaderDr.Close//ObtainsauserpasswordStringsqlBothselectfromregwherenamenameSqlBothandpwdpwdSqlCommandcmdBothnewSqlCommandsqlBoth,ConnSqlDataReaderdrBothDrBothcmdBoth.ExecuteReader//AtthesametimeretentionuserfamouspasswordexistenceinformationBoolisBothExistdrBoth.Read//ClosesDataReaderDrBoth.CloseConn.Close//WhetherthejudgmentuserdoesregisterIfIsRegUserExist{Response.WritealertthisusernotyetregistersReturnfalse}//JudgmentusernameandpasswordarewhetherconsistentelseifisBothExist{Response.Writealertreturnfalse}elsereturntrue}FinallyproducesbehindthesystemthedatastorageplanUsingMicrosoftSQLServer2,000establishmentsdatabasesanditsmemoryprocess.Hereproducestwoessentialdatasheets,oneisthefieldwhichdatasheetNewscontainsincludesSerialnumber,name,title,keywords,content,type,origindepartmentanddate
个人主页