退耕还林管理系统信息动态查询的设计与实现  

Dynamic Inquiry Design and Implementation of Management System on Returning Cultivated Land to Forestry

作　　者：冯益明[1] 张会儒[1] 

机构地区：[1]中国林业科学研究院资源信息研究所,北京100091

出　　处：《计算机工程与应用》2004年第15期211-213,217,共4页Computer Engineering and Applications

摘　　要：该文从退耕还林工程的特点出发,指出退耕还林管理系统对查询要求的复杂性。进而介绍了一种对任意数据库,按任意字段、任意条件的组合进行多条件随机查询的方法。在实现查询的过程中,通过分析SQLAnyWhere中两个系统表单,提出解决中、英文表名及字段名互换方式,通过设计一视图文件,来实现查询内容的代码转换,最终得出用户需要的且便于理解的结果。Complexities of management system on returning cultivated land to forestry(RCLF)for inquiry requirement are pointed out from the angle of the characteristics of engineering on RCLF,and thus a multiple-condition random inquiry method for random database according to the combination with random fields and conditions are introduced.In the course of inquiry implementation,the interchangeable mode resolving Chinese and English names of table or fields is presented by analysing2systematic tables in SQL AnyWhere,followed by implementation of code exchange of inquiry contents by designing a view file,as a result,the easily understood results of user requirement are obtained.

关 键 词：退耕还林 管理信息系统 动态查询 SQL POWERBULIDER 

分 类 号：TP391[自动化与计算机技术—计算机应用技术]