教学文件管理系统方案设计

：ComputerKnowledgeandTechnology633(201011)，，（,100023）：，。，，。：；；：TP311：A：1009-3044(2010)33-9312-02TeachingDocumentManagementSystemDesignGONGZi-xia,CHENGJiang-chen,SHAOMing-gang(BiochemicalEngineeringCollegeofUnionUniversity,Beijing100023,China)Abstract:AlongwithteachingdocumentinUniversitieshasbecomeincreasinglydemandingstorage,managementforteachingdocumentisontheagenda.Thisarticlefromtheteachingdocumentmanagementsystemrequirementsanalysis,weproposethesystem’sfunctionalrequirements,anddesignthesystem.Keywords:teachingdocument;requirementsanalysis;plan，，。，，。，。，，，。1，，，，，，，，。，、，，，，，，，，。，、。，，，，，，。，，，，，，。2，9，。[1]：，，。，。，。，，。，，。1）：，，，、。2）：，、，：2010-09-03：（1978-），，，，，。ISSN1009-3044ComputerKnowledgeandTechnologyVol.6,No.33,November2010,pp.9312-9313,9316E-mail:[e-mail]：ComputerKnowledgeandTechnology633(201011)，、。3）Guest：。：，，，。：。：，Excel。，，。：；,，；；。：。：20M，，；。：，、，。：，、，；、、。：，，。；、、、。，，、、。3。（）、、、、、、、（，，，，A、B，A、B，，，）；Subversion；SQLServer2000；Eclipse；Struts+Hibernate[4]。B/S，[2]1。，，API。；，；；；；，，；（）；，；。，，9，，ER，。（id,）；（id,,id）；（id,,id,,,,,,）；（ID,）；：（id,,）；（id,id,,id,,）；（id,,,,,id,id,,id,id,,,,,id）；（id,,,,,,,,,,,,,,,,,,,,）；（id,id,id,,）。：；；；。（9316）19313：ComputerKnowledgeandTechnology633(201011)（9313）[4]web，，。4，，，。：[1]..[J].,2009(8).[2].[M].5.:,2008.[3].[J].,2009(23).[4].J2EE[J].,2009(4).Active:=true;end;DataModule1.ADOQuery1.Append;withDataModule1.ADOQuery2do//beginActive:=false;sql.Clear;sql.Add('select*fromvqwherepxrq=:d1andpxrq=:d2');Parameters.ParamByName('d1').Value:=synfz+'-01-01';Parameters.ParamByName('d2').Value:=synfz+'-12-31';Active:=true;i:=recordcount;Active:=false;end;ifi0thenbeginwithDataModule1.ADOQuery2do//1beginActive:=false;sql.Clear;sql.Add('selectmax(dh)asnnfromvqwherepxrq=:d1andpxrq=:d2');Parameters.ParamByName('d1').Value:=synfz+'-01-01';Parameters.ParamByName('d2').Value:=synfz+'-12-31';Active:=true;maxz:=FieldByName('nn').AsInteger;Active:=false;RzDBEdit1.Text:=IntToStr(maxz+1);end;endelse//，1beginRzDBEdit1.Text:=synfz+'00001';end;RzDBSpinEdit1.Value:=100;RzDBSpinEdit2.Value:=45;DataModule1.ADOQuery1.Post;Application.ProcessMessages;pxco.SetFocus;end;4。，，，。:[1].Delphi[M].:,2004.[2].Delphi[M].:,2005.9316