The Design And Implementation Of Pipeline Business Approval System For Planning Bureau

With the continuous expansion of the urban population,urban residents are paying more and more attention to urban construction,leading to urban planning,which at the primary position of urban construction,getting the particularly important.A good planning scheme is the cornerstone of urban construction.For the Planning Bureau,the pipeline business underground is a strict test for construction units,material suppliers,and workers' skills literacy.Due to the shortcomings of the traditional pipeline business approval process,like time-consuming of publication and approval process,the traditional approval scheme has been difficult to meet the needs of the Planning Bureau for the approval work.Therefore,this paper has designed and developed a pipeline business approval system for the Planning Bureau.In the technical design process of the pipeline business approval system for the Planning Bureau,SSH technology architecture is adopted.Struts framework implements the overall control of the process through three parts:Model,View,and Controller.As an open source framework,Spring framework can reduce the complexity of system development.Hibernate implements O/R Mapping function and conducts lightweight Object Encapsulation for JDBC which is mainly used for the data persistence layer.In addition,according to the system performance requirements of the system,and taking into account the advantages of the SQL Server2014 database for processing massive data,data security,and database usability,the database of the pipeline business approval system for the Planning Bureau uses the SQL Server2014 database.The functional structure of the pipeline business approval system for the Planning Bureau is designed as follows:The receiving approval processing business mainly refers to the recipients' management function of various types of licenses and approval forms existing in the pipeline business approval system for the Planning Bureau.The receiving approval processing business is divided into seven functions,involving license receiving management,to-do project management,done project management,concluded project management,copying project management,workflow management,and selection of principal.The task management business is worked for the task manager to manage the project tasks and project messages existing in the pipeline business approval system for the Planning Bureau.The task management business is further divided into task query management and task reminder information management.Graphical browsing business is mainly worked for the operator to do graphical manipulation of the needs in the system,such as the red line of the map.The system management business is worked for the system administrator to manage information about users,roles,organizations and others in the pipeline business approval system for the Planning Bureau.The design and implementation of the pipeline business approval system for the Planning Bureau will reduce the time spent by the Planning Bureau in the pipeline business review process to the greatest extent,improve the efficiency of the staff of the Planning Bureau,and enable the Planning Bureau to play a greater role in urban construction,save time for the pipeline construction side and the auditor,and give a greater contribution to the city construction.