基于三层架构的学生管理系统快速开发

(),2008,30(S2):211~214CN53-1045/NISSN0258-7971JournalofYunnanUniversity*杨怡怀1,解永刚1,申东娅2,沈嘉1(1.,650118;2.,650091):,C#3,VisualStudio2005,SQLServer2005,LTP.NetC#,.:;;VisualStudio;SQLServer;C#:TP311:A:0258-7971(2008)S2-0211-04(MIS).,.,,,,.,,,.,VisualStudio2005,SQLServer2005,LTP.NetC#,,.,,.1,/,...3,1GUI,form;2,BOCustomer,,HTTP;3,DACustomer,,ADO.Net,SQL,.,.1Fig.1Three-tierarchitecturefigure;;.2,LTP.Net,.2.1,ADO.Net,*:2008-10-04:(1979-),,,,..,3::,..:2:dbo.T_ActRecord,;dbo.T_Studuen,t,2..:,,.,,.,,,,.2.2,,:,,.2Fig.2Buildingtable2.3,WindowsForms,,.2.4,,ORM,,,,ORM.,SQL,SQL,.,.,,ORM,ORM,,ORM.,,,,,.212()303Fig.3Generatingtheframecode4Fig.4ComplexityinquiringNetAdvantagefor.NET2007Volume1CLR2.0,.3,Internet,.,C/S,213S2:.B/S.5Fig.5Applicationsketchmap4,.c#,/.SQLDLL,,,,.,:.,,,,,.:[1]LEISTS,ZELLNERG.Evaluationofcurrentarchitectureframeworks[C].ProceedingsoftheACMSymposiumonAppliedComputing2,Dijon,France,2006:15461553.[2]RAHAYUJW,CHANGE,DILLONTS,eta.lAmethodologyfortransforminginheritancerelationshipsinanobjectorientedconceptualmodeltorelationaltables[C].InformationandsoftwareTechnology,2000,571592.[3].VisualStudio2005[M].:,2008.[4].[D].:,2006.[5]McClureRA,KRUGERIH.SQLDOM:CompiletimecheckingofdynamicSQLstatements[C].Proceedingsofthe27thInternationalConferenceonSoftwareEngineering,2005:8896.[6],..NET[J].:,2007,20(4):502504.Quicklyexploitsofthestudentmanagementsystembasedonthree-tierarchitectureYANGYihuai1,XIEYonggang1,SHENDongya2,SHENJia1(1.DepartmentofElectricalMechanicalEngineering,KunmingUniversity,Kunming650118,China;2.SchoolofInformation,YunnanUniversity,Kunming650091,China)Abstract:Thethree-tierarchitectureisrealizedinthisarticle.WiththeProfessionalVisualStudio2005exploittools,SQLServer2005databaseandtheLTP.Netcodeautogenerator,astudentmanagementsystemisquicklyexploited.Keywords:database;three-tierarchitecture;VisualStudio;SQLServer;C#214()30