文档包括:
word说明书一份,共66页,约22000字
目录
致谢................................................................4
摘要................................................................5
Abstract.............................................................6
一、绪论............................................................7
1.1 数据库技术以及智能决策支持系统的技术概念.....................7
1.1.1 数据库技术概念...........................................7
1.1.2 智能决策支持系统的技术概念...............................7
1.2 研究背景意义及主要研究内容...................................8
1.2.1 国外林木病虫害防治专题数据库技术的研究现状及发展趋势.....8
1.2.2 国内林木病虫害防治专题数据库技术的研究现状及发展趋势.....9
1.2.3 本文主要研究内容及研究意义..............................10
1.3 本章小结....................................................11
二、 各专题数据库的设计与建立......................................12
2.1 气象数据库的设计与建立......................................12
2.1.1 气象数据的搜集与处理....................................12
2.1.2 气象数据库的数据表构成与建立............................13
2.2 杨树病虫害数据库的设计与建立................................21
2.2.1 杨树的重要性与现存问题..................................21
2.2.2 杨树的灾害现状..........................................22
2.2.3 影响杨树病虫害爆发蔓延的因素分析........................23
2.2.4 杨树病害、虫害数据库的构建..............................24
2.3 植保机械数据库的设计与建立..................................30
2.3.1 植保机械简介............................................30
2.3.2 建立植保机械数据库......................................32
2.4 本章小结....................................................34
三、 智能决策支持系统的开发........................................35
3.1 决策树和数据库流程图的设计..................................35
3.2 智能决策系统的开发..........................................37
3.2.1 登录界面设计............................................37
3.2.2 气象决策系统设计........................................38
3.2.3 植保机械决策设计........................................39
3.3.4 主操作界面设计..........................................42
3.3 宏与编码实现................................................43
3.3.1 创建宏..................................................43
3.3.2 编码实现................................................43
3.4 人机交互性..................................................47
3.5 本章小结....................................................49
四、系统的调试和安全维护...........................................50
4.1 系统的调试与发布............................................50
4.2 系统的安全管理及其保护......................................51
4.3 本章小结....................................................53
五、 主要研究结论与进一步研究建议..................................54
5.1 主要研究结论................................................54
5.2 进一步研究建议..............................................55
参考文献...........................................................56
附录 1 部分软件开发界面...........................................58
附录 2 程序代码...................................................63
摘要
在杨树病虫害防治过程中,植保机械承担着保护树木健康成长的重要任务, 但传统植保机械不仅机械化、自动
化、精细化程度不高,而且施药效率较为低下, 浪费的农药对环境造成了巨大的污染。因此,为减少病虫害防
治成本、提高农药 使用效率、保护生态环境,研究智能化植保机械迫在眉睫。
本文不仅分析了植保机械发展现状、研究了智能化植保机械,而且分析了针 对智能植保机械建立数据库的必要
性,开发完成了包括气象数据库、杨树病虫害 管理数据库、植保机械数据库、气候条件与喷施农药智能决策系
统、植保机械作 业智能决策系统在内的基于植保机械的杨树病虫害防治专题数据库。
气象数据库收集了南京连续两年的日均气象资料,准确地为植保机械作业提 供林业气象服务。杨树病虫害数据
库收集多种常见的杨树病害、虫害的资料,而 植保机械数据库则收录了多种植保机械资料,总结了不同植保机
械的不同特点。 气候条件与喷施农药智能决策系统和植保机械作业智能决策系统把三个数据库 连接运作起来
。基于植保机械的杨树病虫害防治专题数据库为科学合理地利用气 候条件、提高杨树病虫害防治效果提供科学
依据和技术支持,还能提供统计分析 功能和特定检索功能,能根据实际情况决策出不同的防治方案,以节省人
力、物 力。
关键词:杨树、病虫害防治、智能化植保机械、专题数据库、智能决策
Abstract
Plant protection machinery plays an important part in the healthy growth of trees. However , it
is deficit in mechanization , automation , precision and pesticide application efficiency
in which wasted pesticide pollutes the environment. Therefore ,
it is high time we conducted research on intelligent plant protection machinery for cost
reduction , improvement of pesticide application efficiency and environment conservation.
This paper not only analyses the current situation of plant protection machinery and researches
intelligent plant protection machinery ,but also analyses the necessity of its database
establishment and develops the databases including meteorological
database , poplar disease and pest management database , climatic conditions and
spraying decision system and plant protection machinery database and its operation decision
system.
Meteorological database is a collection of the daily meteorological data of the nanjing for two
consecutive years,accurately for plant protection machinery operation provides a forestry
meteorological service. Poplar disease and database is the
collection of the data for a variety of common poplar diseases and insect pests ,and
plant protection machinery database includes a variety of eppo machinery data ,
summarizes the different characteristics of different plant protection machinery.
Climatic conditions and spraying decision system and plant protection machinery database
and its operation decision system connect the three databases.The specialized
database can provide scientific basis and technological support for using
climate conditions properly and improving pest control efficiency. , and offer
statistical analysis and specific search function , choose various control methods
according to the situation to save labor and resources.
Keywords: poplar、prevention and control of diseases and pests 、intelligent plant protection
machinery、specialized database 、i ntelligent decision
|