Design And Implementation Of Common Query System Based On MVC And AJAX

Under the background of global information, the daily operations of the enterprisesrely much more on the information systems, and the query system is one of the mostimportant part of the enterprises information system. It provides data support forenterprises’ business flow and decision analysis. The approach of existing query systems isto write codes for each query need, however, as the demand is complex and frequentlychanging, which make the system with some problems, such as duplicate developmentworkload, high security risks, poor users experience and so on.Based on experience of traditional query development, this paper providescomprehensive analysis of various types of existing information query systems, andabstract out the common features of different query needs in query interface, queryprocesses, business logic and some other aspects, this paper also analyses features ofsome queries, and proposes overall solution ideas of general query systems, using designideas of MVC to redraw the structure of query, achieving separation of display logic andbusiness logic, separation of query logic and actual business logic. It also abstract out thegeneral query page. Use AJAX for asynchronous interaction.Under the guidance of above-mentioned solution ideas, this paper provides a generalquery system based on lightweight JavaEE platform with B/S mode.The backend of thesystem uses a mature MVC framework---Struts2, the frontend uses ExtJs framework.This system is truly a "general" query system, developers do not need to write any code.To achieve the add/delete/edit of the business plan, they just need to write the querydefinition in the database and change the configuration of the database. This system usesrole-based access control (RBAC) mechanism and security review mechanism, and makeefforts to improve the ability to prevent SQL injection attacks, which ensures the securityof the system. The asynchronous interaction technology of this system allows users tocustomize the query flexibly and they can save their custom queries. This system has beenput into use and both the developers and users have good reviews.