中国森林植物病害信息管理系统的建立

Establishment of Chinese Forest Plant Disease Information Management System

以VisualBasic6.0编程及Access数据库为技术支持,采用ADO数据访问技术,SQL语言查询技术和智能化技术,依据近几十年来我国森林中发生普遍而严重的病害以及中国林业科学研究院森林植物病害标本为数据库源,建立了中国森林植物病害信息管理系统。系统的数据库结构包括标本信息库(42字段),森林植物病害信息库(39字段),用户信息库(4字段)。该信息管理系统不仅具有对数据库的管理功能,而且具有对普通用户的服务功能。为了保证系统的安全和维护,设计了高级用户和普通用户,高级用户授权了对数据库的全方位维护。系统能对中国林业科学研究院森林植物病害标本库进行管理,同时也可对全国现有森林植物病害信息进行管理。系统具有良好的服务功能,主要表现在友好界面、精确查询和模糊查询方面。该系统为林业工作者提供了丰富详细的森林病害信息,在林业系统内具有广阔的应用前景。

The forest plant diseases information system was established on the basis of Microsoft Visual Basic 6.0 and Microsoft Access 2000. The techniques used in the system are ADO, SQL language and intelligentized query. The sources of the database was based on Chinese forest disease occurred badly in recent decades and the forest plant disease specimen of Chinese Academy of Forestry. The database included three tables. They were forest plant disease specimen information table including 42 data fields, forest plant diseases information table including 39 data fields and user information table including 4 data fields. In order to make the database safe and easy to be managed, two kinds of users as common user and senior user were set. The senior users were allowed to manage the database, while the common users were allowed to query and browse the information only. With the system, the forest plant disease specimen of Chinese Academy of Forestry and the whole country＇ s forest plant disease information could be managed. The system offering exact and blocking query service contained lots of particular forest plant diseases information and was easy to operate. So it would have a wide application outlook.