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

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


關(guān)鍵詞：在線監(jiān)測，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ī)械參量在線監(jiān)測的研究現(xiàn)狀 1
1.1.2 在線監(jiān)測的意義 2
1.2在線監(jiān)測技術(shù)的發(fā)展階段及發(fā)展趨勢 3
1.2.1在線監(jiān)測發(fā)展階段 3
1.2.2在線監(jiān)測的發(fā)展趨勢 3
1.3課題研究主要任務(wù) 4
2 虛擬儀器技術(shù) 5
2.1虛擬儀器的概念 5
2.2虛擬儀器的分類 6
2.3 虛擬儀器的組成 8
2.4 LabVIEW軟件簡介 9
2.4.1選擇LabVIEW的理由 9
2.4.2 LabVIEW軟件的特點(diǎn) 9
3數(shù)據(jù)庫介紹 12
3.1采集數(shù)據(jù)的存儲 12
3.2 數(shù)據(jù)庫的選擇 13
3.3 MySQL數(shù)據(jù)庫管理系統(tǒng) 14
4 LabVIEW和MySQL數(shù)據(jù)庫的連接 16
4.1 LabVIEW中利用LabSQL訪問數(shù)據(jù)庫 16
4.1.1 LabVIEW中與數(shù)據(jù)庫接口的方法 16
4.1.2 數(shù)據(jù)庫訪問的工具包LabSQL簡介 16
4.1.3 LabVIEW中對LabSQL的使用 17
4.2 LabVIEW與MYSQL連接方法 18
4.2.1數(shù)據(jù)庫中建表 18
4.2.2 LabVIEW與MYSQL的連接 20
5機(jī)械參量在線監(jiān)測系統(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