武汉理工大学学报(信息与管理工程版)
武漢理工大學學報(信息與管理工程版)
무한리공대학학보(신식여관리공정판)
JOURNAL OF WUHAN AUTOMOTIVE POLYTECHNIC UNIVERSITY
2015年
3期
282-286
,共5页
毕家鑫%钟绍华%杨胜兵%吉孔武
畢傢鑫%鐘紹華%楊勝兵%吉孔武
필가흠%종소화%양성병%길공무
LabVIEW%Access数据库%曲率半径%LabSQL%Excel
LabVIEW%Access數據庫%麯率半徑%LabSQL%Excel
LabVIEW%Access수거고%곡솔반경%LabSQL%Excel
LabVIEW%Access database%curvature radius%LabSQL%Excel
在利用LabVIEW 开发后视镜曲率半径测控系统的过程中,需要对大量测试数据进行存储、管理、查询、检索,以及将所检索的数据发送到Excel做成报表打印出来,由此提出了在LabVIEW中访问数据库的需求。先利用Access搭建数据库,然后通过ODBC接口函数库驱动程序建立与Access数据库的连接,采用第三方开发的LabVIEW 数据库访问工具包LabSQL,直接在LabVIEW 中以调用子VI、Microsoft ADO 对象和SQL语言实现对数据库的访问,最后采用了LabVIEW报表生成子VI来实现生成Excel报表,并实现其与Access数据库的数据交互。
在利用LabVIEW 開髮後視鏡麯率半徑測控繫統的過程中,需要對大量測試數據進行存儲、管理、查詢、檢索,以及將所檢索的數據髮送到Excel做成報錶打印齣來,由此提齣瞭在LabVIEW中訪問數據庫的需求。先利用Access搭建數據庫,然後通過ODBC接口函數庫驅動程序建立與Access數據庫的連接,採用第三方開髮的LabVIEW 數據庫訪問工具包LabSQL,直接在LabVIEW 中以調用子VI、Microsoft ADO 對象和SQL語言實現對數據庫的訪問,最後採用瞭LabVIEW報錶生成子VI來實現生成Excel報錶,併實現其與Access數據庫的數據交互。
재이용LabVIEW 개발후시경곡솔반경측공계통적과정중,수요대대량측시수거진행존저、관리、사순、검색,이급장소검색적수거발송도Excel주성보표타인출래,유차제출료재LabVIEW중방문수거고적수구。선이용Access탑건수거고,연후통과ODBC접구함수고구동정서건립여Access수거고적련접,채용제삼방개발적LabVIEW 수거고방문공구포LabSQL,직접재LabVIEW 중이조용자VI、Microsoft ADO 대상화SQL어언실현대수거고적방문,최후채용료LabVIEW보표생성자VI래실현생성Excel보표,병실현기여Access수거고적수거교호。
In the process of developing rearview mirror curvature radius measurement and control system based on LabVIEW , it is necessary to storage , manage and inquire the large amount of test data and send the retrieved data into Excel for printing out , which proposed??the demand of accessing the database in LabVIEW .Firstly, Access was used to build a database , and then a connection to access the database was established via ODBC interface library drivers .Based on free LabVIEW database access toolkit LabSQL, which was developed by third -party, the sub-VI, the Microsoft ADO object and the SQL language were ap-plied to directly access to the database .Finally, the LabVIEW report generation sub -VI was used to generate Excel report which can interact with the Access -database .