Design And Implementation Of Furniture Selling Information System

On the background of continuously growth of national income,residents' willing to purchase furniture for the improvement of living condition has been released,thus provided source power for the development of furniture sales industry.The development of furniture selling information system can provide office platform for furniture selling company,to improve furniture selling automation and information level.A furniture selling company in Henan province is selected as research background in this dissertation,to develop furniture selling information system especially for this company,and attain the aim of enhances company's information level.All kind of users' requirements for information system during business process are investigated,and users' requirements are summarized into several aspects.System users' are divided into four kinds of participants,which include system manager,storage manager,selling manager and customer.Participants' requirements are carried out,and use case analysis model is established for the description of participants' requirements.Functional features of this information system are summarized,and system is divided into four modules,which include system management module,furniture management module,product purchase module and data query module.Functions in every module are determined too.The technical platform of J2 EE is selected for system development,and system develop circumstance is established by the technical JSP,Servlet and JDBC.The system is divided into three layers;include View,Control and Model,based on system design MVC pattern.View layer is responsible for user interface creation;Control layer is responsible for business logic process;Model layer is responsible for data access between system and database.On the basis of data storage requirements analysis of every module,database structure is designed and database tables are created.Business process of every function is analyzed;classes and methods in every layer are designed.According to system design model,the system is accomplished and system running result is acquired.Furniture selling information system that developed in this dissertation can meet users' requirements,and enhanced information level of furniture selling company.