本科毕业设计：无线传感器网络远程数据传输初稿(附录)关键词：物联网,SQLServer软件设计,C#

I摘要无线传感器网络是由大量无处不在的微小传感器节点组成，它能根据环境自主完成指定任务的自治监控功能，使用灵活、方便，已在国内外军用、民用领域得到广泛关注，是对21世纪产生巨大影响力的技术之一。本文主要是提出无线传感器网络应用于战场环境监控方面的数据远程传输解决方案。通过串口与汇聚节点连接，接收汇聚节点发送过来的数据，实现无线传感器网络监测功能。本地监控软件系统后台采用MicrosoftOfficeAccess2007数据库，实现数据的存储。通过利用定时器定时读取数据库，完成对节点采集数据信息的实时更新。本设计选用SQLServer2008完成以太网中数据库远程连接，并将数据通过以太网传输至远程计算机终端。远程监控预警软件系统前台应用VisualStudio2008编程开发环境，采用C#语言对进行界面设计、实现。本设计通过数据库远程访问技术和C#软件编程，完成了无线传感器网络数据的远程传输，实现了远程终端对无线传感器网络数据的访问，为无线传感器网络与军用网络无缝连接提供了解决办法，对无线传感器网络网络在实战中的地位、作用提高有重大意义。关键词：无线传感器网络；界面设计；数据库远程访问；串口通信IIAbstractWSNconsistsofamassofsensornodesdeployedeverywhere.Itcanperformassignedtaskautomaticllyaccordingtodeployedenvironmentanditisflexibleandconvenient.Duetotheseadvantages,WSNhasgainedextensiveattentioninmilitaryandcivilianfieldandithasbeenoneoftechnologieswhichhavegreetinfluenceonthe21stcentury.Inthispaper,weputforwardadataremotetransmissionsolutiontobattlefieldenvironmentmonitoringusingWSN.Inthissolution,weconnectlowercomputerthroughserialporttoperformmonitoringfunction.WeapplyMicrosoftOfficeAccess2007Databaseinthebackgwindoflocalmonitoringsoftwaresystemtocompletedatastorage,thetimerinreadingdatabasetoaccomplishread-timeupdatesofinformationcollected,theSQLServer2008inrealizingremoteconnectionofdataethernetandtransmittingdatatoremoteterminal.Intheforegroundofremotemonitoringsoftwaresystem,weuseC#whichbasedonVSplatformtodesigninterface.thedataremotetransmissionsolutioncontributetoexpandingfunctionofWSNanditofferssolutiontoseamlessconnectionofWSNandmilitarynetwork.ThedateromotetransmissionandtheremoteterinalaccesstodataofWirelessSensorNetworkarecompletedinThisdesignbytheremotedatabaseaccesstechnologyandC#softwareprogramming.Itcanperformassignedtaskaccordingtoenvironment.It’sflexibleandconvenient.KeyWords:WirelessSensorNetwork,interfacedesignation,Remoteaccessdatabases,SerialcommunicationIII目录摘要......................................................IABSTRACT..................................................II目录...................................................III第一章绪论................................................1§1.1引言..............................................................................................................................................1§1.2课题背景与研究意义..................................................................................................................2§1.3无线传感器网络应用研究现状..................................................................................................3§1.4设计任务......................................................................................................................................5第二章无线传感器网络和以太网简介..........................7§2.1无线传感器网络.....................................................7§2.1.1无线传感器网络工作机制........................................7§2.1.2无线传感器网络的协议.........................................8§2.1.3无线传感器网络构架...........................................8§2.2以太网.............................................................9§2.2.1IEEE802.3标准................................................9§2.2.2CSMA/CD共享介质以太网.......................................10§2.2.3以太网的工作原理............................................11第三章基于WSN的侦察与监控系统...........................12§3.1基于WSN的侦察与监控系统设计......................................12§3.2节点的硬件系统....................................................13§3.3侦查与监控系统本地监控软件系统....................................14§3.3.1本地监控软件功能设计........................................14§3.3.2本地数据库设计..............................................15第四章远程传输方案实现...................................16§4.1数据远程传输方案的论证.............................................16§4.2远程监控预警软件设计要求...........................................16§4.3远程监控与远程预警功能设计思路....................................17§4.4远程监控预警软件开发平台...........................................19II§4.4.1开发工具的选择..............................................20§4.4.2开发工具概述................................................20§4.5远程终端串口数据获取..............................................23§4.6数据库的远程访问.................................................24§4.6.1远程终端的数据获取............................................................................................24§4.6.2SQLSERVER2008设置开启远程连接.....................................................................25§4.6.3ACCESS数据库升迁到SQLSERVER数据库.............................................................26§4.7远程监控软件的程序设计............................................30§4.7.1传感器数据远程监控功能实现...................................30§4.7.2远程预警功能实现............................................33§4.7.3数据库远程连接设置功能实现...................................38第五章无线传感器网络数据远程传输测试.....................42§5.1远程传输测试环境搭建..............................................42§5.2远程传输测试内容..................................................42§5.3远程传输测试步骤..................................................43§5.3.1远程监控预警软件初始化.......................................43§5.3.2远程数据库连接测试..........................................44§5.3.3远程监控预警功能测试........................................45§5.4远程传输测试结果...........................................