| 摘要: |
| 获取实测振动PSD路谱后，因为路线多样、数据量庞大以及处理过程复杂，给实测振动PSD路谱工程化应用带来了极大的不便。为了有效地将实测数据运用于包装测试中，以Visual Basic 6.0为前台语言，SQL Server 2000为后台数据库，开发了路谱信息处理软件，实现了路谱数据从实际环境至实验室处理过程的所有步骤，并兼具了线路信息存储功能，同时分别建立了不同的数据库，满足数据存储与后期扩展、更新要求。 |
| 关键词: 振动PSD 管理 软件开发 Visual Basic 6.0 SQL Server 2000 |
| DOI： |
| 分类号:TB485.3; TB487 |
| 基金项目: |
|
| Design and Development of Road Spectrum Management System Based on VB and SQL |
|
WEN Qi1, LU Li-xin2,3, HUANG Xiang-fei4
|
|
1.Jiangnan University, Wuxi 214122, China;2.1.Jiangnan University, Wuxi 214122, China;3.2.China National Light Industry Package Quality Supervising & Testing Center, Wuxi 214122, China;4.Midea Washing Machine Division Research & Development Center, Wuxi 214028, China
|
| Abstract: |
| The amount of road vibration PSD data through actual measurement is large and complex due to route diversity. It is difficult to apply in practical engineering. A road spectrum management system was developed using Visual Basic 6.0 as interface language and SQL Server 2000 as backstage database to make full use of the actual measurement data in packaging test. The software achieves all of the steps of test spectrum of actual environment spectral data to the laboratory process. It also sets up different database according to data processing steps respectively. The database can satisfy the requirement of data expansion and updating in future. |
| Key words: vibration PSD software development Visual Basic 6.0 SQL Server 2000 |
渝公网安备 50010702501716号