The Design And Realization Of Municipal Management System Of Yuhuatai Distric In Nanjing

With the rapid development of social construction, Municipal Administration Department’s workload increases, but the majority of Municipal Administration Department still use manual mode to deal with municipal administration business, The model is inefficient, and the business data archiving is very difficult. In order to solve the defects, and improve the efficiency, the Municipal Administration Department decided to introduce the municipal management system to replace the existing model.The thesis introduces the implementation process of municipal management system from requirements, design, implementation and testing. Firstly, the thesis analysis the system requirements by use case which includes Municipal service acceptance, municipal business processing, enterprise management, basic information management, and system management, and the non functional requirements are introduced. Based on the requirements scheme, the thesis completes the design scheme which includes functional architecture design and database design, and module design. According to the design scheme, the system is completed which uses J2 EE platform to develop code, and uses SQL Server2012 to store data. In order to support users to deal with municipal administration business, the system is implemented based on B/S model. At last, the thesis completes the testing which includes functional testing and performance testing. In the construction process, the main work and contribution are as follows:(1)The SMS notification is introduced in the municipal service acceptance stage and municipal business processing stage which can improve the working efficiency, the SMS notification is implemented by third-party gateway technology, and uses Web Service Technology to connect the gateway. In addition, the blocking queue technology is used to send mass SMS tasks.(2)The system provides security function to protect data which includes data backup function, and data recovery function. The backup function can read data to BAK file which is implemented by backup methods; the restore function can read date from BAK file to database which is implemented by restore methods.(3)The import function is introduced to manage large scale data which is implemented by JXL plug-in, it can improve work efficiency.At present, the system has been constructed, and it has been deployed to the Nanjing Yuhuatai District Municipal Administration Department for processing municipal management business, The system can meet the need of Nanjing Yuhuatai District municipal management departments.