機(jī)械參量在線(xiàn)監(jiān)測(cè)系統(tǒng)設(shè)計(jì)（本科畢業(yè)論文設(shè)計(jì)）
摘 要

機(jī)械參量在線(xiàn)監(jiān)測(cè)是指對(duì)工農(nóng)業(yè)生產(chǎn)中的機(jī)械設(shè)備的溫度、壓力、振動(dòng)、流量、液位、電量、轉(zhuǎn)速等機(jī)械特征參量進(jìn)行在線(xiàn)實(shí)時(shí)的監(jiān)測(cè)，及時(shí)獲取機(jī)械設(shè)備的運(yùn)作情況，能第一時(shí)間了解到機(jī)械設(shè)備是否正常工作。當(dāng)監(jiān)測(cè)出機(jī)械設(shè)備的特征參量出現(xiàn)異常情況，就知道設(shè)備出現(xiàn)故障而沒(méi)能正常運(yùn)作，這時(shí)及時(shí)的處理出現(xiàn)的問(wèn)題,使設(shè)備恢復(fù)正常。
機(jī)械參量在線(xiàn)監(jiān)測(cè)實(shí)現(xiàn)過(guò)程中，先用傳感器測(cè)量被測(cè)信號(hào)，將傳感器輸出的電量信號(hào)進(jìn)行整形、轉(zhuǎn)換、濾波處理變成標(biāo)準(zhǔn)信號(hào)，然后用數(shù)據(jù)采集卡采集信號(hào)并轉(zhuǎn)換為計(jì)算機(jī)能處理的數(shù)字信號(hào)，通過(guò)設(shè)備驅(qū)動(dòng)程序，數(shù)字信號(hào)進(jìn)入計(jì)算機(jī)；在LABVIEW平臺(tái)下，調(diào)用信號(hào)處理子模塊，編寫(xiě)儀器功能流程、功能算法，設(shè)計(jì)虛擬儀器前面板，實(shí)現(xiàn)數(shù)據(jù)的顯示、查詢(xún)、將數(shù)據(jù)存入數(shù)據(jù)庫(kù)等功能。
在本次設(shè)計(jì)中，首先介紹了機(jī)械參量在線(xiàn)監(jiān)測(cè)的現(xiàn)狀和發(fā)展趨勢(shì)，研究的目的和意義；接下來(lái)簡(jiǎn)單介紹了虛擬儀器，本次設(shè)計(jì)用到的LabVIEW軟件和MySQL數(shù)據(jù)庫(kù)的相關(guān)知識(shí)，并具體介紹了LabVIEW和MySQL數(shù)據(jù)庫(kù)的連接。最后部分是機(jī)械參量在線(xiàn)監(jiān)測(cè)系統(tǒng)設(shè)計(jì)的硬件結(jié)構(gòu)和軟件組成方面的知識(shí)。
設(shè)計(jì)完成了任務(wù)書(shū)的要求，實(shí)現(xiàn)了數(shù)據(jù)庫(kù)功能，成功的將數(shù)據(jù)庫(kù)和LabVIEW連接，采集的數(shù)據(jù)能在虛擬面板上顯示并存入數(shù)據(jù)庫(kù)。能夠通過(guò)LabVIEW對(duì)數(shù)據(jù)庫(kù)進(jìn)行查詢(xún)、刪除和插入。


關(guān)鍵詞：在線(xiàn)監(jiān)測(cè)，LabVIEW，MySQL，數(shù)據(jù)采集

ABSTRACT

The on-line supervision machinery parameter is a kind of on-line and real-time supervision to the temperature, vibration, rate of flow, liquid place, electricity volume, rotation rate and other machinery characteristics of machinery equipment in industrial and agricultural production. Obtaining operation condition of machinery equipment in time can enable people to know whether the machinery equipment works regularly or not. When some abnormal condition supervised in characteristic parameter appears, in can be informed that there is something wrong with the equipment and it malfunctions. Therefore, the problems can be solved in time and the equipment can function normally again.
When the machinery parameter is on-line supervising step, it firstly measures the objective signal by using sensors, then; the electric volume transmitted by sensors will be reshaped, transformed, and wave-filtered till the formal signal can be gained. Secondly, the data-collecting card will be used to collect signal and the digital signal should be transformed and then handle by computers. Next, the signal will be sent into computers by equipment driver. Under LABVIEW platform, calculation methods and designing equipment module can make the display, check, depositing data in data bank be fulfilled.
The design meets the demand of the requirements, fulfills the data-bank function, and makes the database and LABVIEW be connected successfully. The collected data can be displayed on fictitious module and deposited in database. The database can be checked, deleted and inserted into by LABVIEW.
This design firstly introduces current situation and developing trend of on-line supervision of machinery parameter, the research purpose and its significance, then, the design will make use of relevant knowledge about LABVIW software and MySQL database. This design will also specifically introduce the connection between LABVIEW and MySQL. The last part of this design will display the knowledge about hardware structure and composing of software of on-line supervision system design of machinery parameter.


Key words: on-line monitoring,LabVIEW,MySQL, Data Acquisition



目 錄
摘 要 I
ABSTRACT II
1 緒論 1
1.1課題研究的背景和意義 1
1.1.1 機(jī)械參量在線(xiàn)監(jiān)測(cè)的研究現(xiàn)狀 1
1.1.2 在線(xiàn)監(jiān)測(cè)的意義 2
1.2在線(xiàn)監(jiān)測(cè)技術(shù)的發(fā)展階段及發(fā)展趨勢(shì) 3
1.2.1在線(xiàn)監(jiān)測(cè)發(fā)展階段 3
1.2.2在線(xiàn)監(jiān)測(cè)的發(fā)展趨勢(shì) 3
1.3課題研究主要任務(wù) 4
2 虛擬儀器技術(shù) 5
2.1虛擬儀器的概念 5
2.2虛擬儀器的分類(lèi) 6
2.3 虛擬儀器的組成 8
2.4 LabVIEW軟件簡(jiǎn)介 9
2.4.1選擇LabVIEW的理由 9
2.4.2 LabVIEW軟件的特點(diǎn) 9
3數(shù)據(jù)庫(kù)介紹 12
3.1采集數(shù)據(jù)的存儲(chǔ) 12
3.2 數(shù)據(jù)庫(kù)的選擇 13
3.3 MySQL數(shù)據(jù)庫(kù)管理系統(tǒng) 14
4 LabVIEW和MySQL數(shù)據(jù)庫(kù)的連接 16
4.1 LabVIEW中利用LabSQL訪(fǎng)問(wèn)數(shù)據(jù)庫(kù) 16
4.1.1 LabVIEW中與數(shù)據(jù)庫(kù)接口的方法 16
4.1.2 數(shù)據(jù)庫(kù)訪(fǎng)問(wèn)的工具包LabSQL簡(jiǎn)介 16
4.1.3 LabVIEW中對(duì)LabSQL的使用 17
4.2 LabVIEW與MYSQL連接方法 18
4.2.1數(shù)據(jù)庫(kù)中建表 18
4.2.2 LabVIEW與MYSQL的連接 20
5機(jī)械參量在線(xiàn)監(jiān)測(cè)系統(tǒng)設(shè)計(jì) 23
5.1硬件配置 23
5.1.1硬件設(shè)計(jì)的原則 23
5.1.2 系統(tǒng)硬件結(jié)構(gòu) 23
5.2 系統(tǒng)軟件設(shè)計(jì) 32
5.2.1 軟件結(jié)構(gòu) 32
5.2..2設(shè)計(jì)原則 33
5.2.3 軟件模塊 34
5.2.4系統(tǒng)工作流程 35
5.2.5系統(tǒng)的前面板和程序圖 37
6 結(jié)論與展望 39
6.1結(jié)論 39
6.2展望 39
致謝 40
參 考 文 獻(xiàn) 41