Design And Implementation Of Database General Query System

Currently,query is an important function in management information systems.The query module in traditional management information system is to write codes for each user's demand.But with the requirements of users increase,system needs to be redesigned,which results in a lot of problems,such as huge workload of coding,lots of duplicate workload,poor generality,high maintenance costs and so on.In order to solve those problems,this paper uses XML to store query definition files to truly realize the “general”,so that developers do not need to write any code.This paper analyses the query modules of existing management information systems,extracts the keys of different query requirements in query flow and query logic,and designs a general query system based on the configuration file.This system is divided into five modules: model information management module,query definition module,query page generation module,security management module and system management module.The most important function of the mode information management module is to set the database connection information and generate system data dictionary information.The query definition module generate query page code by combining the query configuration file with the page template.The query definition module and the query page generation module complement each other.The security management module guarantees the security of the system by four aspects: user authentication,access control,system log and exception handles.The system management module provides basic information for system operations.Testing shows that this system is well adapt to the growing and changing query demand.It also effectively reduces the workload to speed up the development progress,and make system easier to maintain.