济宁市水资源数据库管理系统的研建

【作者】 徐中华；

【导师】 李云峰； 郭建青；

【作者基本信息】 长安大学 ， 水文学与水资源， 2003， 硕士

【摘要】 目前，全球正面临着水资源危机，中国已被列入世界14个最贫水国之一。如何科学、高效、合理地进行水资源管理是水科学工作者当前面临的紧要任务。本文阐述了加强水资源管理和提高管理水平对缓解水资源供需矛盾的意义。通过深入研究分析国内外水资源信息管理水平及发展状况，同时结合济宁市水资源特点，在考虑用户需求的基础上，进行系统需求分析、数据库设计和应用程序设计。并详细介绍了水资源数据库管理系统的设计原则、开发过程及具体实现。采用计算机语言和数据库管理技术，利用面向对象的数据库管理软件Access 2002和内嵌的VBA(Visual Basic Application)应用程序语言，开发建立济宁市水资源数据库管理系统。实现对水资源数据的管理、供需分析等功能，更好的应用计算机技术提高水资源管理的高效性和科学性。 该系统为用户提供面向对象的操作环境，用户不必记任何枯燥的命令，操作简便，易于掌握。系统除具有一般的录入、编辑、删除、查询、统计计算功能外，还实现了报表动态打印、统计图形动态绘制与输出及供需预测和供需平衡分析。同时，为弥补作图方面的某些不足，该系统通过对象连接与嵌入(OLE)技术，可随时调用其它绘图软件，如：Surfer，Grapher等，体现了实用性强的系统设计原则。能满足济宁市日常水资源管理工作的需要，并为政府部门制定水资源相关政策提供基础数据和科学依据。更多还原

【Abstract】 At present, the whole world is being faced with the water resources crisis, China is one of the 14 most poor water countries of the world. How to manage the water resources scenically, efficiently and reasonably, is a crucial mission to be faced for water science workers. The paper ascertains signification of enhancing the level of water resources management for reducing the contradiction of water supply and demand. Through researching and analyzing ofthe domestic and foreign level of water resource information management and the developing condition, combining with the characteristics of water resources of JiNing city, On the based of considering user’s demand, the systemic demand analysis is done in this paper, as well as the design of database and application program. And the designing principle, developing process and realizing concretely of water resource database management system are described in detail in this paper. JiNing Water Resources DataBase Management System(JNWRDBMS) is established with advanced computer language and the technique of the database management techniques and using Object Oriented database management software- Access 2002 and in-line VBA. The JNWRDBMS realizes the functions of managing water resources data and analyzing the contradiction of supply and demand, and so enhances the efficiency and scientific approach of water resources data management with computer technology.The JNSRDBMS brings forward Object Oriented Operation Environment, so user can operate it handy, master it at ease, and not bearing in mind any boring commands. The system can also implement report dynamic print, Stat. graph mapping and output except functions of input, edit, delete, query and calculating. It can also transfer other mapping software by means of OLE technology in order to compensate some shortcoming in map aspects in the JNWRDBMS, such as Surfer, Grapher, and so on. So it shows powerful principle of system design. Moreover, it can meet the needs of water resources management routine of JiNing, and provide basal data and scientific basis for government to draw up water resource correlative policies.更多还原