汽车可靠性试验数据管理系统开发（本科毕业论文设计）.doc

Õª Òª

Æû³µ¿É¿¿ÐÔÊÇÆû³µ×îÖØÒªµÄÐÔÄÜÖ®Ò»¡£Æû³µµÄ¿É¿¿ÐÔÌá¸ßÁË£¬¾ÍÒâζ×ÅÆû³µµÄÕû³µÖÊÁ¿Ìá¸ßÁË£¬Ó¦´Ë£¬Æû³µ¿É¿¿ÐÔÊÔÑéÊÇÒ»Ïî±Ø²»¿ÉÉÙµÄÖØÒªÊÔÑé¡£Æû³µ¿É¿¿ÐÔÊÔÑéÊý¾Ý¹ÜÀíϵͳ¾ÍÊÇΪÁËÈ«Ãæ¡¢¼°Ê±¡¢×¼È·µØ»ã¼¯¡¢Í³¼Æ¡¢·ÖÎöÕâЩÊý¾Ý¡£
±¾´Î±ÏÒµÉè¼ÆµÄÄ¿µÄ¾ÍÊÇÉè¼ÆÒ»¸öÆû³µ¿É¿¿ÐÔÊÔÑéÊý¾ÝµÄ¹ÜÀíϵͳ¡£±¾³ÌÐòÐèÒª²ÉÓÃÁËAccess2003ºÍVB6.0×÷ΪӦÓÿª·¢¹¤¾ß¡£¸ÃÉè¼ÆÖ÷ÒªÍê³É¶ÔÆû³µ¿É¿¿ÐÔÊÔÑéÊý¾Ý¹ÜÀíϵͳµÄÐèÇó·ÖÎö¡¢¹ØϵÊý¾Ý¿âµÄ·ÖÎö¡¢¹¦ÄÜÄ£¿éµÄ»®·Ö£¬²¢ÓÉ´ËÉè¼ÆÊý¾Ý¿â½á¹¹ºÍÓ¦ÓóÌÐò¡£ÖصãÊÇÊý¾Ý¿âµÄ½¨Á¢ºÍÓ¦ÓóÌÐòµÄ¿ª·¢¡£¶ÔÓÚÇ°ÕßÓ¦¸Ã¸ù¾ÝÆû³µ¿É¿¿ÐÔÊÔÑéÊý¾ÝµÄÌص㣬½¨Á¢ÊʺÏÃèÊöÆû³µ¿É¿¿ÐÔÊÔÑéÊý¾ÝµÄÊý¾Ý¿â¡£¶ÔÓÚºóÕßÔòÒªÇóÓ¦ÓóÌÐò¹¦ÄÜÍ걸£¬²Ù×÷¼òµ¥µÈÌص㡣×îºóϵͳµÄÔËÐнá¹ûÖ¤Ã÷£¬¸ÃÉè¼Æ¿ÉÒÔʵÏÖÕû³µ¡¢×@@ɺÍÁ㲿¼þµÄ¿É¿¿ÐÔÊÔÑéÊý¾Ý¹ÜÀí¹¦ÄÜ£»Ö§³ÖÊýÖµ¡¢Îı¾¡¢Í¼Æ¬µÈ¶àÖÖÊý¾Ý¸ñʽµÄµ¼ÈëºÍµ¼³ö£»¾ß±¸²éѯ¡¢¶Ô±ÈºÍͳ¼Æ·ÖÎö¹¦ÄÜ¡£ÍêÈ«Âú×ãÆû³µ¿É¿¿ÐÔÊÔÑéÊý¾Ý¹ÜÀíϵͳµÄÒªÇó¡£


¹Ø¼ü´Ê£ºÆû³µ¿É¿¿ÐÔ£¬¿É¿¿ÐÔÊÔÑ飬Êý¾Ý¹ÜÀí£¬ÏµÍ³·ÖÎö
ABSTRACT

The reliability of automobile is one of the most important performance. Improving the reliability of automobile, that means improving the quality of a vehicle, therefore, the reliability test is essential and important. The reliability of automobile tentative data management system is for comprehensive, prompt, collects,statistically analyze to these data accurately.
The graduation project is aimed to design a management system for automobile reliability test data. The procedures require the use of the Access2003 and VB6.0 as application development tools. This design mainly completes the analysis of automobile reliability tentative data management system and the relational database, the division functional module, thus designs the database structure and the application procedure. The key point is the database establishment and the application procedure development. In regard to the former, it should be based on the characteristics of automobile reliability test data to establish appropriate description of automobile reliability test database. While, for the latter requires the application program with perfect function and easy to operate,etc. The final results show that this design can be achieved, assembly and the spare part reliability test data management function; support numerical value, text, images and other data format for the import and export; and posses functions for contrast, inquiry and statistics analysis. It can fully meet the reliability test data management system.


Key words£º The Reliability of Vehicle £¬Reliability Test£¬Data Management£¬System Analysia














Ŀ ¼

ÖÐÎÄÕªÒª ¢ñ
ABSTRACT ¢ò
1Ð÷ÂÛ 1
1.1 ±¾¿ÎÌâµÄÒâÒå 1
1.2 Êý¾Ý¿â¹ÜÀíϵͳµÄ¸ÅÄî 1
1.3 Æû³µ¿É¿¿ÐÔÊÔÑéÊý¾Ý¹ÜÀíϵͳ 2
1.4 ±¾ÂÛÎÄËù×÷¹¤×÷ 2
2 Æû³µ¿É¿¿ÐÔÊÔÑé 3
2.1¸ÅÊö 3
2.1.1Æû³µ¿É¿¿ÐԵĶ¨Òå 3
2.1.2¹ÊÕϵĶ¨ÒåÓë·ÖÀà 3
2.1.3Æû³µ¿É¿¿ÐÔÊÔÑé 4
2.1.4Æû³µ¿É¿¿ÐÔÊÔÑéÀàÐÍ 4
2.2 ÌØÊâÌõ¼þϵĿɿ¿ÐÔÊÔÑé 4
2.2.1ÌØÊâ»·¾³¿É¿¿ÐÔÊÔÑé 4
2.2.2¼«ÏÞÌõ¼þ¿É¿¿ÐÔÊÔÑé 5
2.3 Õû³µ¿É¿¿ÐÔÊÔÑé 6
2.3.1 Æû³µ¿É¿¿ÐÔÐÐÊ»ÊÔÑé 6
2.3.2 Æû³µ¿É¿¿ÐǪ̂¼ÜÄ£ÄâÊÔÑé 7
3 VBÓëÊý¾Ý¿â 8
3.1ÓÃMicrosoft Access 2003 ´´½¨Êý¾Ý¿â 8
3.1.1Êý¾Ý¿âµÄÑ¡Ôñ 8
3.1.2´´½¨Ò»¸öÐÂÊý¾Ý¿â 8
3.2Ó¦ÓÃϵͳ¿ª·¢¹¤¾ß 8
3.2.1±à³Ì»·¾³µÄÑ¡Ôñ 8
3.2.2 ADO±à³Ì 9
3.3 SQLÓïÑÔ½éÉÜ 11
4 Æû³µ¿É¿¿ÐÔÊÔÑéÊý¾Ý¹ÜÀíϵͳÉè¼Æ·ÖÎö 13
4.1 ϵͳӦÓÃÐèÇó·ÖÎö 13
4.2 ϵͳ¹¦Äܽṹ¿ò¼Üͼ 13
4.3 ϵͳ¹¦ÄÜ 13
4.3.1 ÊÔÑéԭʼÐÅÏ¢µÄ±£´æ 14
4.3.2 Òì³£Êý¾ÝµÄÅжÏÓ뱨¾¯ 14
4.3.3 Êý¾Ýͳ¼Æ¹¦ÄÜ 14
4.3.4 ¶Ô±È·ÖÎö¹¦ÄÜ 14
4.3.5 ²éѯ¹¦ÄÜ 14
4.3.6 ɾ³ýºÍÐÞ¸ÄÊý¾Ý¹¦ÄÜ 15
4.3.7 µÇ¼ʱµÄÃÜÂëÈÏÖ¤¹¦ÄÜ 15
4.3.8ÊÔÑé³µÐÍÔö¼ÓÓëɾ³ý 15
4.4 ϵͳÊý¾Ý¿âÉè¼Æ 15
4.4.1ÊÔÑé³µÐÍÐÅÏ¢±í 16
4.4.2Æû³µÍ¼Æ¬ÐÅÏ¢±í 16
4.4.3ÊÔÑé»ù±¾ÐÅÏ¢±í 16
4.4.4¹ÊÕÏÐÅÏ¢ÊäÈë±í 17
4.4.5ϵͳÓû§ÐÅÏ¢±í 18
4.5 ¶¨Òå±í¼ä¹Øϵ 18
5Æû³µÊÔÑéÊý¾Ý¹ÜÀíϵͳӦÓóÌÐòÉè¼Æ 20
5.1 ϵͳ´°ÌåÄ£¿éµÄ×é³É 20
5.2 Óû§ÃÜÂëÈÏÖ¤´°ÌåµÄʵÏÖ 20
5.3 ϵͳÖ÷´°ÌåµÄʵÏÖ 21
5.4 Óû§ÐÅÏ¢¹ÜÀí´°ÌåÄ£¿éµÄʵÏÖ 22
5.5 ³µÐÍÐÅÏ¢¹ÜÀí´°ÌåÄ£¿éµÄʵÏÖ 23
5.6ͼƬÐÅÏ¢¹ÜÀí´°ÌåÄ£¿éµÄʵÏÖ 24
5.7 ÊÔÑé»ù±¾ÐÅÏ¢¹ÜÀí´°ÌåµÄʵÏÖ 24
5.8 ¹ÊÕÏÐÅÏ¢ÊäÈëÄ£¿éµÄʵÏÖ 26
5.9 ¿É¿¿ÐÔ·ÖÎö¹ÜÀíÄ£¿éµÄʵÏÖ 27
6 ½áÂÛ 29
ÖÂл 30
²Î¿¼ÎÄÏ× 31