Design And Realization Of Marketing Report Management System Based On J2EE Framework

In recent years,with the continuous development of information construction of power enterprises,the quality of service and the level of internal management of the whole industry have been greatly improved.Production and sales data of the electric power enterprise is increasing exponentially,so we need a report management system which conforms to the characteristics of the electric power industry.The report management system can provide production and sales information,at the same time,it can helps the eterprise managers to make analysis and decision,do planning and manage.Generally speaking,the classification of marketing business is various and the data structure is complex in the electirc power enterprise,the traditional report design model could not satisfy the requirement of the electric marketing business system.The traditional report system mostly adopts the client/erver structure(C/S structure),so the logic relation between the report processing part and other business logic parts is relatively high,which leads to high coupling and low portability,and the later upgrade and maintenance of the report system is very difficult.A good solution to these problems has been proposed in this study.The design and development of the system as well as its features is as follows.In the first part of this paper,such prolems as high coupling and poor portability which exist in the current report management system of the electric power enterprise is analyzed and the necessity and significance is elaborated.Technology used in the development of the report management system is introduced in detail,deep analysis of the characteristics and advantages of the MVC design pattern and the JavaEE architecture is made,UML is introduced and choice of the UnEAP development platform and the Oracle database is analyzed.In the second part,from such aspects as project overview,total requirements,usecase analysis and system security requirements,the overall requirement analysis of report management system is carried out.In the third part,architechture design is conducted,fuction description and modeling analysis of the four function modules includes user management module,report statistics module,function compactt module,report analysis module.Such key technology as data integrity,database access technology,component development and information integration system development are also disccussed,and the design of the system database is completed.In the fourth part,the realization of the marketing report management system under JavaEE framework is introduced,the design and implementation of the whole pages,seven reporting modules,user management module is discussed one by one.Several key technical points of the specific development process includes the export of the excel spreadsheets,attachment upload and download are emphasized.To predict the power consumption in a certain period,the load forecasting algorithm based on grey model is studied.In the fifth part,from the aspects of internal logic and the external function of the program,software test plan which is the combination of the function test and performance test is drawn up.Function test using black box testing,detailed test is carried on by writing test cases of the different system modules.And system pressure test is conducted by using LoadRunner.In this study,management and business logic of the system modules are seperated,and an independent report module is designed and developed.The generation of reports,statistics,auditing,reporting and printing are relized in it and an grey model is used to predit the power consumption.The problems of high coupling and poor portability which exist in the general report management system in the electric industry have been solved.Forcasting of the power consumption is realized.It provides a good reference for the promotion of automation and intelligent management in the electric power industry.