Sales Management System is a typical management information system (MIS), including the establishing and maintaining of background database, and the development of front-end application. With regard to the front request to establish a database which is consistent, strong of integrity, and good for data security. For the background request to establish applications with full functions, easy to use and so on.
This system is mainly to the completion of lamps Invoicing customers and staff management, including add, edit, delete, query and user management. It can complete all kinds of information browse, query, adding, deleting, modifying, and other functions.
This system uses Microsoft SQLServer2000 to design databases and the popular web page design language - JSP to design web pages. it has a flexible database structure, and a good support for the database application.
This thesis firstly talked about the background of lamp sales management, and then introduced the concept, origin, definition and sort of the ERP. Also the general situation of the lamp sales managemanet are mentioned. And the J2EE framework and the SQLServer2000 which this system used are introduced. At last,it detailed the realization of the various modules and algorithms.