Design And Implementation Of Government Audit System Based On MVC

With the continuous development and popularization of computer application technology,communication technology and Internet,computerized accounting has been widely used in various government departments,institutions and enterprises.The method of government audit has also changed.As the government audit work is becoming more and more heavy and the scale is expanding,the audit work relies more and more on computers.The traditional audit method has been replaced by the informatization audit.This paper introduces the development of audit informatization at home and abroad,points out the shortcomings in the use and research of current audit systems,and then clarifies the design direction of government audit system.According to the actual needs of government audit and the current situation of audit informatization,this paper designs and implements the government audit system based on MVC(Model-View-Controller,a software design model).Firstly,after introducing the background knowledge of audit work and some typical scenarios of software usage,this paper briefly gives a detailed requirement analysis of each functional module of the system,and carries out a non-functional requirement analysis of the system.Secondly,the module of the system is designed based on the demand analysis,dividing the system into six functional modules: project management,data acquisition,audit data analysis,audit statistical sampling analysis,audit working manuscript,system management.Each function module and the database of the system is designed and explained in detail,and the core table structure of the database is mainly introduced.Thirdly,this paper proposes a data access acceleration method based on read-write separation,which is compared with the traditional data access method and applied to the core table of the system to improve the efficiency of data access in querying and updating of voucher information table,reviewing and updating of audit working papers.Lastly,the government audit system is implemented according to the designed function modules of the system,and the functional test and performance test of the system are carried out.This paper focuses on the test of the function modules of the system.Finally,the system passes the test and meets the requirements of government audit.