基于MapX的水利管理系统

基于MapX的水利管理系统
                  ——数据管理子系统的实现
 

摘要:基于Map X的水利管理系统是典型的信息管理系统(MIS),其开发主要包括后台数据库的建立和维护以及前端与GIS 相连应用程序的开发两个方面。对于前者要求建立1致性和完整性强、数据安全性好的数据库。而对于后者则要求应用程序功能完备,易使用等特点。因此本人结合水利管理系统的对数据库方面的实际要求，对SQL Server2000数据库管理系统、SQL语言原理、Delphi应用程序设计，Delphi数据库开发技术进行了较深入的学习和应用，主要完成对水利管理系统的需求分析、功能模块划分、数据库模式分析，并由此设计了数据库结构和应用程序。系统运行结果证明，本文所设计的水利管理信息系统可以满足水利工作人员实现程序替代人工对灌区的水源情况、灌溉情况以及灌区的其它信息的管理工作。本系统具体划分了不同用户的操作权限，实现了数据库表的查询，记录的添加、删除和修改，报表的生成等数据管理功能；实现了多数据库表的连接操作，实现了多条件查询和模糊查询，并灵活实现了对自动选择更新间隔录入数据和手动录入其它情况相结合的更能；实现了计算机对水利信息的统计、分析功能，以及辅助决策等功能。
关键词：水利管理；GIS；SQL；数据库设计
 
WATER MANAGEMENT SYSTEM BASED ON MAPX
                     —REALIZATION OF DATA MANAGEMENT CHILD SYSTEM
 
ABSTRACT: The water management system based on MapX is the typical information management system (MIS). Its development mainly includes two aspects of application produce, the maintenance of the backstage data basement and the establishment of front stage application which is connected with GIS. Requests to the former it is strong to establishes the data uniformity and the integrity regarding, the data security good storehouse. But regarding of the latter then requests application procedure function is complete, easy to use and so on the characteristic. Therefore I integrated the typical water system’s request in fact, carried on to study deeply the application of SQL Server2000 database management system, the principle of the SQL language, the Delphi7.0 application programming, the Delphi technology mainly using in the data fields .completed the demand analysis of the water management system, the module division of the function, the pattern analysis of the database, and from this has designed the database structure and the application procedure. After running this water management system, the result proved that this system can satisfied the people to collect and manage the data of water and other information automatically in the range of irrigate the field. This system has divided the different users operation jurisdiction specifically. It has realized so functions such as the database table browsing, the recording increase, the deletion and the revision, the report form production, has realized the multi- databases table connection operation, has realized the multi- conditions inquiry and the fuzzy inquiry, has entered the data source automatically and freely by person, this system has realized that it counts and analyses the data by computer and help the users to make a decision for the water management based on the data. （转载自http://zw.ＮＳＥaＣ.com科教作文网）
Keyword：Management of Water；GIS；SQL；Data Base Design

注释：不含源代码