基于Web的模架报价与产品信息管理系统研究

华中科技大学硕士学位论文基于Web的模架报价与产品信息管理系统研究姓名：宋亚鹏申请学位级别：硕士专业：材料加工工程指导教师：张祥林20060410IB/SMVCJ2EEJ2EEIIAbstractWiththeintensecompetitioninnowadaysinformationsociety,made-to-orderproductionbecomesaninevitabletrendformouldbasemanufacturer.Detailedoperationalandtechnicalinformationoneachcustomerordershouldbecommunicatedthoroughly.Quotationsareimportantintheorders’acquisitionprocess,andthecapabilitytowinordersdependsontheaccuracyandrapidityofquotations.Inordertoprovidecompetitivequotationsquicklyandenhancetheoperationalcapacitytoresponsetheenterprisemarket,itisnecessaryformouldcompaniestoapplytheManagementInformationSystem.Accordingtothegeneraloperationalflowandexistingenterpriseorganizationmanagement,thebusinessmanagementandoperatingflowsarereconstructedafterinvestigationinenterprises.Thecharacteristicsandthepricecompositionarestudied,andthequotationmethodswhicharesuitableformouldbasemanufactureandtheproductdatamanagementbasedonquotationoperationarepresented.Throughproductdatamanagement,enterpriseinternaldepartmentsarelinked,andenterpriseinformationandresourcesareshared.Theefficiencyofproductdevelopmentandmanufacturingisimproved.Inpracticalterms,productinformationorientedManagementInformationSystemisdesignedoverall,andthedatabasesystemisbuilt.Accordingtorequirements,basedonB/Sthree-tierframework,thesystemwasdevelopedbyusingMVCarchitectureandJ2EEplatform.Therefore,thesystemcanbeexpandedandmaintainedeasily.Basedonthemethodsmentionedabove,theproductquotationinformationissharedeffectivelyandthedataistransmittedrapidly,anditmakesthemanagementmorestandardized.Astheresultofthepersonalitydevelopmentforthespecificsectors,theriskisavoided,andthecostisreducedandtheimplementationcycleisshortened.Keywords:MouldBase;Quotation;ProductInformationManagement;J2EEII_____11WTOWTO21.11.1.1[1]60065013%170005050%33%6%11%[2-6]CAD/CAE/CAM31.1.2[7]123451.2ERPIT4[8-13]CAD/CAM/CAE1234C/S51.3123452361.41.4.1[14-18]PDM12WebWebPDMWebB/S[19-20]JSPJSPJAVA71.4.212UML34Java822.1IT19982150053000420054200550010105001008000/150/500/OAMISMISMISMISMIS92.2[21]2-1BOM2-12.2.12-110BOMBOMCAPP2.2.22-1112.2.3[22]123/455678910122.3B/SC/SMVCUML2.3.1B/SInternet/IntranetWebB/SBrowser/Server3C/SClient/Server[23-24]2-2Client/ServerC/S90C/SC/SCloudHubHubClientClientClientClientServerServerPrinter2-2Client/ServerTCP/IP13InternetWebBrowser/ServerB/S2-3BrowserTCP/IPRequestResponseWebServerDataBaseServer2-3Browse/ServerB/SB/SWebWebTCP/IPWebWebB/SITB/SMIS2.3.2J2EEB/SJ2EE.netjavaJ2EE[25]1J2EEJ2EEJava14J2EEJ2EE23JavaEJBBeanBeanBean456J2EEJ2EEJ2EE2J2EE1JavaScriptJavaScriptJavaScriptHTMLJavaJavaWebWebJavaScriptHTML[26]2J2EEServlet[27]ServletJavaWebCGIServletCGICGIServletServletServletServletWebWebServlet15ServletWebServletServlet3J2EEJSP[28]JSPWebJSPWebWebJSPWebHTMLJavaJSPJSPWebJSPHTML4J2EEJavaBeanJavaBean[29]JavaBeanJavaJavaBeanJavaJavaBeanJavaBeanJavaBeanJavaBeanJSPJavaBeanJSPtag5J2EEJDBC[30]JDBCAPIODBCJDBCJDBCJava2.3.3MVCMVCJ2EEJ2EEweb[31]MVCModel-16View-ControllerModelViewController2-4MVCwebViewWebHTMLXHTMLXMLJSPMVCModelModel/MVCController172.3.4JDBCWebWeb1JDBC[32-34]JavaJDBCJavaDataBaseConnectionJavaJDBCJDBCJavaJDBCAPIAPIJDBCAPIJDBCJDBC-ODBCJava2-5JDBCSQLJavaJDBCJDBCAPIJDBCAPIJDBCJDBC-ODBCDBMS2-5Java2connectionpoolWebWebWeb18ResourcePool12DBMSServletJSP12requestrequest2-6JDBCAPIDBConnectionPoolDBConnetionPoolManagerwrapperJDBC192.3.5B/SWeb1WebWeb1Web2WebInternetWeb3WebWeb4Web5WebJSPWebTomcatMicrosoftIISiPlanetNetWareNovellNetWareWebServerBEAWeblogicTomcatJSPServletTomcat220MicrosoftSQLServer2000SQLServer20002.4UMLOOA&D8090UMLBoochRumbaughJacobson[35-37]UMLUMLUMLUML1UMLUMLUMLUML2UMLUMLUMLUML9··Staticdiagram21·Behaviordiagram·Interactivediagram·ImplementationdiagramUMLUMLUML222333.1WebwebWebwebCIMSB/SJ2EEMVC3-124WebJDBCHTMLJSPTCP/IPHTTP3-1web3.23-2BOM3-22512BOM3456Web263.33-3BOMQC3-312273.43-4;BOM)BOMBOM3-4283-53-53.53.5.129[40-41]E-RE-R3-61n1n111n1nn1n1n1nnn1nn11n1111nnnn1113-6E-RE-R[56]111NN1MN303.5.23-13-1###AB########AB########3D/3D/####CNC########3-23-3SQLServer3-7313-2ProjectprojectIDnvarchar(50)projectNamenvarchar(50)industryClassnvarchar(50)manufactureClassnvarchar(50)customerIDnvarchar(50)contactPersonIDnvarchar(50)projectAdderIDnvarchar(50)startTimenvarchar(50)projectStatedatetime(8)workflowIDnvarchar(50)3-3ProductproductIDnvarchar(50)productNamenvarchar(50)productTypenvarchar(50)projectIDnvarchar(50)productPicnvarchar(50)productAmountnvarchar(50)receiveTimedatetime(8)quoteDeadlinenvarchar(50)leadTimenvarchar(50)quotationStatenvarchar(50)productStatenvarchar(50)workflowIDnvarchar(50)quotationMethodnvarchar(50)productOrdernvarchar(50)prodConfirmDatenvarchar(50)prodConfirmTimenvarchar(50)323-7ProjectProductSQLServer3344.1TRQDMMMP++++++=3214.1QDMMMPc++++=3214.2P——PricePc——M1——MaterialCostM2——ManufacturingCostM3——ManagementCostD——DevelopmentCostCAECAM34Q——TransportcostsR——Return1030T——Taxtrtaxratetr17%M1M24.24.2[38-39]1352929234364.34.3.14-14-24-137()4-24.3.24.3.2.1DBIR2025A35B40C704-3200mm250mmBIDA35mmB40mm70mm4-3DBIR2025384-44.3.2.24-5394-54-6404-74-64-74.3.34.3.3.1=414-83.