基于Web的模架报价业务管理信息系统研究与实现

华中科技大学硕士学位论文基于Web的模架报价业务管理信息系统研究与实现姓名：金伟申请学位级别：硕士专业：材料加工工程指导教师：黄早文;张祥林20050429IIIWebB/SJ2EEMVCWebB/J2EEMVCIVAbstractThemouldbaseistheimportantcomponentofmould.Owingtothecustomizationorderingandlargedailyorders,itishardtodealwithquotationsmanuallyforamouldbasemanufacturer.Accordingtosurveyandstudy,thecurrentmouldbasequotationgenerallyexistsgreatrandom,longquotationtimeandgreatinaccuracyetc.Sohowtomakethequotationofmouldbasestandardizedandrationalizedhasincreasinglybecomethejointconcernforbothproducersandcustomers.Withtherapiddevelopmentofcomputertechniquesandtheimprovementoftheenterprise’managementlevel,therequirementofadoptingthecomputertoassistaccuratequotationisveryurgent.Thepaperanalysestheconcurrentquotationtheoryinlandandoverseas,theactualityofquotationbusiness,thecomponentofmouldprice,incorporatesmouldbasequotationoperationflowandcharacteristic,comparescurrentlypopularquotationtheoriesandmethods,andselectsappropriatequotationmethodofmouldbase.Thenthepaperanalysesenterprise’soperationchainandinvestigatestheoperationmanagementsystemofmouldbasequotationbasedonWebthree-tierstructureandkeytechniques,andfinishesthewholesystem’sdesignandempoldersthemainmodulesthroughcombiningthetechnologyofnetworkanddatabaseandoperationmanagement.ThispaperintroducesthecurrentpopularB/Sthree-tierstructureandclassicaltechnologyofMVCdesignpatternonJ2EEplatform.Thefeasibilityandrationalityofthesystemwasverifiedthroughanexample.Last,Asumming-upofresearchanddevelopmenthasbeengiven,andanoutlookforfurtherinvestigationispresented.Thesystemintellectualizedandvisualizedtheprocessofmouldbasequotation,anddistributedthesoftware.Thesedisposalsaccordwiththeroutineofmouldbasequotationprocessandtherequirementofthefactandthequotationresultisbelievabletocustomerstoo.KeyWords:WebB/SJ2EEMVCMouldBaseQuotationSystem111.1[1],,123/45256789()101.2[2]12335l04519936AutoCADERP4[3][4]AutoCAD[5][6][7][8][9][10][11]AutoCADdBASEBoothroyd[12]Poli[13]ChenYuh-Min[14]ChinKwai-Sang[15]IF-THENChinKwai-Sang[16](DTMOLD-1)[17]/CEF:DixonandPoli(D-P)Boothloyd-5Dewhust(B-D)1.31234622.12.21234[18]2-172-1SLmMMs+++=SLMx++=(2-1)MsMxMmLS1r2r0r()%1001×=xMLr2100%SrM=×%1000×+=MSLr81r2r0r2-1M02111)1(rMrrMMxx-=-+=2-2sMsMCQGWJDZF=+++++++2-3CQGWJDZFDZFxMCQGWJDZFm=++++++++2-412()(1)1CQGWJDZFmrMr++++++++-=-01CQGWJDZFmr++++++++=-2-59sM2-370802-3QGWJFaGsaMGCDZ=+++xaMGCDZm=++++xMmxaMGCDZY=++++Y10DDaGdGDa=dxMDd(1)xaMGdCZY=++++2-62-6aGC2.3112-22-3BOM2-212BOM12()BCAHDPPPPPPPPIF=+++++⋅+123CCCCPPPP=++1nBbiiiiPVMC==⋅⋅∑11nCiiiPXY==⋅∑21nCsiviViPVFK==⋅⋅∑31nCihihiPHFK==⋅⋅∑1nAiiiPQA==⋅∑1nHhiiiPVT==⋅∑1nDiiiiPLRN==⋅⋅∑1nPiiiPPU==⋅∑PBP(+)CP()1CP2CP3CP3D/APHPDPPPIFbiViMiCiXiYsiVviFvKiHCAMhiF3D/13hK3D/iQiAhiViTiLiRiNiPiU3()(1)(2)(3)(4)1433.1JavaJavaInternet,[21]JavaAppletSwingservlet1Applet[22]AppletJavaJavaAppletHTMLInternetHTMLAppletHTMLAppletAppletWebWebAppletAppletWebAppletAppletAppletAppletJavaWebAppletApplet(AppletWeb)Applet(methods)AppletJavaAppletmain()init()paint()Javamain()Appletmain(),AppletAppletApplet(methods)init()start()stop()paint()destroy()2Swing[23][24]SwingSwingSwingSwing15(ModelViewController,MVC)MVCSwingSwingSwing3Servlet[25][26]ServletJavaWebServletWebJavaServletWebWebServletJavaServletServletServletCGIServletSunJavaServletAPIJavaServletWeb4[27]JavaJavaJavaJavaTHREADRUNABLE163.2JSPJSP(JavaServerPage)SunMicrosystems[28]HTML(*.htm,*.html)Java(Scriptlet)JSP(tag)JSP(*.jsp)WebJSPHTMLemailPluginActiveXJavaAppletFrame[29]JSPJavaJavaJavaBugsJSPJSPASP[30]1Java2JSP3JavaBeans4JSPWebJSPJSPWebJSP9[31]1requestGET/POST2response3pageContext4session175applicationservlet6out7configservlet8pageJSP9exceptionJSPJavaWeb3.3UMLUML[32]UML(9[33])(Usecasediagram)(Staticdiagram)()(Behaviordiagram)(Interactivediagram)18(Implementationdiagram)()UMLUMLUMLUMLBoochOMTDOSEUML00UMLUML(Stereotypes)(Responsibilities)(Extensibilitymechanisms)(Threads)(Processes)(Distribution)(Concurrency)(Patterns)(Collaborations)(Activitydiagram)(Type)(Class)(Instance)(Refinement)(Interfaces)(Components)BoochOMTDOSEBPRUML3.4J2EE19JavaJ2EEJava2Java2J2EEJavaJava2EJB(EnterpriseJavaBeans)JavaServletsAPIJSP(JavaServerPages)XMLJ2EEJ2EE[34]1J2EE2J2EEJ2EE3J2EE4J2EEJ2EE[35]12J2EEWeb3J2EE4EIS204UML4.1[36]1234567891011214.24.2.1[37][38]4-14-1224-24-2[39]234-34-34-4244-4(4-5)(4-6)(4-7)4-5254-64-7264.2.24-1~4-54-1++++/+++++++++BD4-2nvarcharnvarcharnvarchar/smallintsmallintmoneymoneymoneymoneymoneymoneymoneynvarcharmoneyBDmoneyint4-34-4:+++++++274-44-51()221324BOM34.2.3901996(Web)28B/SBrowser/Server/WebLANInternet[40][41]123456B/SJ2EEMVCModel-View-Controller4-8[42]4-94-8MVC294-9JavaBeanJavaServletJSPServletJavaBean/ServletJavaBean4-104-10JavaBean1()GUI30IENavigator2()(1)(2)(3)3SQLServerOracleServerJDBC3155.1[43]123[44]5-15-25-15-2325-35-35-4335-4Administrator5.26[45][46]134DBMS(DatabaseManagementSystem)3DBMS4()5DBMS65.2.135(E-R)E-RE-R(Entity-Relationshipmodal)5-55-5E-R5.2.2E-RE-R361235-15-1###AB########AB########3D/3D/####CNC########375.2.3DBMSDBMSDBMS5-25-3SQLServer5-65-2ProjectprojectIDnvarchar(50)projectNamenvarchar(50)industryClassnvarchar(50)m