秦华天然气销售管理系统

XXXXXXX毕业设计（论文）题目：秦华天然气销售管理系统摘要销售管理系统是一个大型企业产品销售不可缺少的部分,它的内容对于企业的决策者和管理者来说都至关重要,所以销售管理系统应该能够为用户提供充足的信息和快捷的查询手段。使其公司人事管理初步实行计算机化，让计算机在销售管理中得到初步应用。使销售管理者总是根据准确、及时的销售信息来进行决策，实现管理。实践证明，当管理的信息量和复杂程度达到某一限度时，即管理人员的劳动强度超过其承受能力时，就必须采用新的管理手段，即用计算机技术信息的收集、加工、传递和存贮等，可以使用销售基础信息，高效、合理、恰当地管理。这样，销售信息系统随着计算机的应用、发展而不断完善，计算机在销售信息管理中的地位也就是益重要。本文在研究目前各个企业销售管理情况的基础上，从企业的实际需求出发，采用当前较为流行的B/S（浏览器/服务器）结构和JSP动态网页开发技术，基于Windows2000Server操作系统和Sql数据库，设计并实现了一个功能较为完善的小型企业销售管理系统。通过对系统进行一系列的需求分析、设计、编码、测试等工作，使系统实现了对企业员工信息和产品信息的查看，添加，修改，删除，以及搜索的功能。重点对系统设计过程作了相应描述，同时也对系统需要改进的地方做了总结。本系统经过测试，运行效果稳定，操作方便、快捷。适用于一般企业的销售管理要求。关键字：销售管理系统，SQLServer数据库，B/S，JSPABSTRACTSale'smanagingsystemisapartoflargebusinessenterpriseproductsaleindispensability,itscontentstothedecisionmakerandgovernorofbusinessenterprisealltopassimportance,sosalemanagementthesystemshouldbeabletoprovideampleinformationandfastsearchmeansforcustomer.Makeitscompanypersonalmanagementfirststeppracticeacalculatortoturn,letthecalculatorbesellingtogetaninitialapplicationinthemanagement.Maketosellgovernoralwaysaccordingtoaccurate,thesaleinformationintimetocarryondecision,carryoutamanagement.Practiceaproof,whentheamountofinformationandcomplicateddegreeofmanagementattainssomeonelimit,namelythemanager'slaborstrengthexceeditacceptanceability,havetoadoptnewmanagementmeans,thenusethecollectionsofcalculatortechniqueinformation,process,deliverandsavetostore...etc.,canuseasalefoundationinformation,efficiently,reasonable,fittinglymanagement.Thus,saleinformationsystemalongwiththeapplicationofcalculatoranddevelopmentandcontinuouslyperfect,calculatoratsellthepositionintheinformationmanagementisalsoabenefitimportance.BasedonthestudythecurrentmanagementofallbusinesssalesonthebasisoftheactualdemandfromenterprisesstartingwiththemorepopularB/S(browser/server)JSPstructureanddynamicwebdevelopmenttechnology,basedonWindows2000ServeroperatingsystemanddatabaseSql,designedandimplementedafeatureofperfectmanagementsystemforsmallbusinesssales.Throughaseriesofsystemrequirementsanalysis,design,coding,testing,thesystemhasinformationontheemployeesandproductview,add,modify,delete,andsearchfunctions.Focusonthesystemdesignprocessaccordinglydescribed,butalsotheneedtoimprovethesystemoflocalitiestosumup.Aftertestingthesystem,operatingresultsstability,andeasytooperate,fast.Applytogeneralcorporatesalesmanagementrequirements.KEYWORDS:SalesManagementSystem，SQLServer，B/S，JSP1目录第1章前言........................................................11.1系统设计的背景................................................11.2系统设计的意义................................................2第2章系统概述....................................................32.1JSP的技术原理................................................32.1.1JSP语言及其特点...........................................32.1.2Java及JavaServlets概述..................................42.1.3JavaBean简介..............................................52.2相关服务器....................................................52.2.1JDK的安装和配置............................................52.2.2Tomcat安装及配置..........................................62.2.3SQLServer2000简介.......................................7第3章系统需求分析及总体设计.....................................113.1需求分析.....................................................113.1.1功能需求..................................................113.1.2性能需求.................................................113.2系统功能模块设计.............................................133.3数据库需求分析...............................................133.4关系图.......................................................14第4章数据库结构设计..............................................154.1数据库实现...................................................154.1.1TB_USER（员工注册表）......................................154.1.2tb_gasOrder(订单生成表)..................................154.1.3tb_bank(银行信息表)......................................154.1.4tb_client(客户信息表)....................................164.1.5tb_company(公司信息表)...................................164.1.6tb_credit(客户资信表)....................................174.1.7tb_duty(职务信息表)......................................174.1.8tb_gasCancel(退气信息查询表).............................174.1.9tb_right(权限表).........................................1724.2用JSP连接数据库.............................................18第5章系统详细设计................................................195.1总体框架.....................................................195.1.1文件架构.................................................195.1.2登陆模块.................................................215.1.3员工修改个人信息.........................................245.1.4业务管理模块.............................................255.1.5银行信息模块..............................................295.1.6企业资信模块..............................................295.2系统设置模块.................................................305.2.1员工权限管理.............................................305.2.2公司简介设置.............................................31第6章系统测试和维护..............................................336.1系统测试.....................................................