The Design And Implementation Of Campus Supermarket Management Information System

With the public universities,private universities and higher vocational colleges are getting more and more in China and the smartphones are growing sharply in high school,as the most important part of campus retail format,university supermarkets develop rapidly and its function in the development of campus economy is more obvious.In order to meet extensive demand for campus retail goods brought by rapid growth of population of high school students,we need to provide more abundant and better quality goods and more convenient and safer sales service to teachers and students,and thus to effectively improve the competitiveness of the campus supermarket.Therefore,on the basis of traditional supermarket management,establishing management system for high school campus supermarket that meets actual demand is getting especially important.In this paper,history of development and current status of management information system of domestic and foreign small and medium-sized supermarkets are researched,and different characteristics of demand of campus supermarket are analyzed.Based on functional requirements and non-functional requirements of supermarket management system,the campus supermarket management system is divided into several functional modules such as system management,purchase control management,sales management,stock management and statistical analysis by using modularized design philosophy.Each functional modules basically covers the whole process of purchasing,selling,stocking.When the goods are put in storage,its basic information is registered,including item number,description,quantity,supplier and so on.When the goods is sold,register its sales information,including information of goods,and quantity of stock removal,and finally get various information of various goods by summarizing storage and stock removal information of goods,and the currently popular QR code for payment is also simply designed.Based on finishing demand analysis,the implementation of this system uses Java advanced programming language and SQL Server 2008 database.The administrator realizes effective management of the purchasing,inventory verification,sales and stock removal of the goods via campus supermarket management system,and thus to solve contradictions of supply and demand of goods in terms of time,quantity and price to realize comprehensive computerized management of purchase-sell-stock of the supermarket,reduce mistake,improve work efficiency,and guarantee comprehensive,timely,dynamic and safe scientific management of purchasing,selling and stock of campus supermarket.