The Project And Finance Management System's Research And Realization Of Administrative Committee Of Zhongguancun Science Park

The information-based construction of the government is nowadays aneffective way to make full use of internal and external resources and to improveworking efficiency and management level. Zhongguancun Science ParkCommittee is a responsible government organization for the development ofZhongguancun Science Park. It pays lots of attention to information construction,and it is making a layout in an overall view and developing it gradually.Therefore it is necessary to improve the management level and service ability ofthe administrative community through information construction.Based on this requirement, the project and finance management system ofZhongguancun Science Park is developed and becomes the core sub-system ofthe Committee, taking charge of the whole project and financial control. The userwho uses this system includes financial departments, organizations andenterprises in the park. Using this system, every department of administrativecommittee handles kinds of project that is applied by enterprise, parkorganization and association, organizes the project examination and approval,tracks the the every stage of project execution, carry on a judge acceptance to theproject,puts forward the budget plan of the next year, puts the budget in practiceand appropriates fouds for project. Financial department gathers and notarizesbudget, gathers and notarizes the plan of funds usage, and carrays on finalaccouts.The park organization and enterprise use this system to apply project online and manage the related information of project that they undertake.It needs a good database structure and a good architecture that could supportchange of requirement to implement the project and finance system.The database design of project and finance system mainly includes threeparts:system database tables, foundation database tables, and business databasetables. The system database tables are mainly tables that are created to support the SOF(Frame and SOA) framework, including workflow module related tablesand general query module related tables. The foundation database tables mainlyinclude tables that are used to describe the basic information of enterprise, forexample, the most important organization code, organization name etc. Thebusiness data mainly covers the business data that appears during the process ofhandling each item business, for example, project-related data, funds-related dataetc.This system is based on Digital China company's SOF framework. The SOFframework is developed using the currently popular technique of Struts,Hibernate, Spring, Ajax. This thesis mainly introduces the three most importantmodules.i. The general query module:through the general query module of SOFframework, business form could be ordered easily and data records could beeasily added, deleted, edited and viewed. The general query module isimplemented based on the technique of Struts and Hibernate. In fact, Strutsis a MVC framework, that is implemented based on JSPModel2. In Strutsframework, model is made of JavaBean and EJB modules that implementthe business logic, controller is implemented through ActionServlet andAction, view mainly includes a set of JSP page.As the persistent middleware, Hibernate provides an object-oriented method of accessing databasefor java program.The general query module combines Struts and Hibernate,firstly, struts framework saves the form data that the user inputs to theActionForm object, then the SOF framework converts the Struts ActionFormobject to Hibernate entity object and using Hibernate persistent techniquesave the entity object to datasase, implementing the function of convenientlyordering form.If the business form changes, there is no need to modify thejava program, only to modify the foreground jsp page.Using the generalquery module, programmer could fastly develops the program that finishesthe adding, deleting, editing and viewing of any tables, only needing one hour,actually fast development.ii. Workflow module:Workflow module is also important in the project andfinance system.After the enterprise or agency have applied project throughexterior web, they deliver the project to Zhongguancun administrativecommittee who organizes the project examination and approval, that isimplemented based on the workflow module. The workflow module isimplemented based on the technique of Spring and Hibernate. The workflowmodule of SOF framework mainly use the Spring's dependence injectionmodule. Dependence injection is the foundation of Spring framework. TheInversion of Control module lowers the dependence among the applicationmodule. In virtue of XML document,developers could link differentapplication module on the runtime. Workflow module uses the Spring'sDependence Injection module to associate with the concrete business tableand configure the interceptor services that are business-related additionaloperation in each step of workflow. For example,at the last step of projectexamination and approval, besides saving the approval data,there is need tosend notice to enterprise. Of course, the workflow module also use theHibernate technique to save and modify the business data. Using theworkflow module of SOF framework,developer could convenientlyconfigure the flow step. This function satisfies the reqirement that the flowof project examination and approval unceasingly changing.iii. Validation module:The validation module validates the data in form,suchas, the required field, the length of character and the repeat data with therecord that already exists in database. It is on the client side that the formdata validation is finished. Client side validation avoids the frequentcommunication with the server as well as the frequent page refresh,whichcould give the user a good interface feeling. The validation module isdeveloped,adopting the JavaScript language and Ajax technique and basedon the extensive applied javascript class library Prototype. Using the Ajax asynchronous transport technique,validation module could validate therepeat data with the record that already exists in database and the pageneedn't refresh.This paper introduced the financial sub-system detailedly. Financemanagement module mainly manages the special project funds of theZhongguancun Administrative Committee, such as the next-year budget, thefinancial plan, appropriation registration and appropriation confirmation etc. Therealization of budget management module and funds usage plan managementmodule mainly adopts the SOF framework's general query module and validationmodule,and the examination and approval of appropriation list is implementedbased on the workflow module.Budget management: Each department budgets regularly according to thefinancial plan of the next year. Related leaders examine and approve the budget,gather and send the budget to financial department administrators' system.Financial department gathers budget, and notarizes budget after the financialoffice approved.Funds useage plan: According to the project funds usage plan in the database,department draws up the next month's funds usage plan, and submits toprincipal who examines and approves the funds usage plan.The administrator offinancial department gathers the funds usage plan,and prints the funds usageplan form.After the city finance department have notarized the funds usage plan,the administrator of financial department registers the results to system, so thateach department could query the funds usage plan.Appropriation management: After the funds usage plan wasconfirmed,business department registers and prints the appropriation lists whichwill be examined and approved by related leaders. After the appropriationformally takes effect in finance,business departments will carry on theconfirmation of appropriation and notice the application departments.The Project and Finance Management System consists of two sub-systems: one is project applying and handling sub-system of external web, the other isproject and finance management sub-system of internal web. This paper's authorparticipated in and completed the eighty percent design and development work ofthe internal web sub-system.Currently, this system have already entered test-running stage. Duringtest-running stage, the customer also occasionally puts forward requirementchange, but the SOF-based project and finance system performs very welltowards requirement change. This proves the general query module that isimplemented based on Struts and Hibernate and the workflow module that isimplemented based on Spring, Hibernate and JavaScript could be agile torequirement change.