»ùÓÚvbµÄÉçÇøÊé¼®ÐÅÏ¢¹ÜÀíϵͳµÄÉè¼ÆÓëʵÏÖ_±¾¿Æ±ÏÒµÂÛÎÄ
·¢²¼Ê±¼ä£º
2015-03-09
À´Ô´£º
ÈË´ó¾¼ÃÂÛ̳
±¾¿Æ±ÏÒµÂÛÎÄ·¶ÎÄ
ÕªÒª
Èç½ñÉçÇøÒѾÍêÈ«ÈÚÈëÁËÈËÃǵÄÕý³£Éú»î£¬ÉçÇø»¯Éú»îÖÐÒ²³öÏÖÁËÔ½À´Ô½¶àµÄÐÅÏ¢ÌṩµÄ·þÎñÀàÐÍ¡£ÉçÇøÍ¼Êé¹ÝµÄ³öÏÖ£¬ÎªÈËÃÇÌṩÁËÒ»¸öеÄÐÅÏ¢»ñȡ;¾¶¡£µ«Í¬Ê±£¬¼øÓÚÊÖ¹¤Ê½µÄ¹ÜÀí·½Ê½£¬Îª¹ÜÀíÈËÔ±´øÀ´ÁËÐí¶à²»±ã£¬¶øÇÒ¹¤×÷ЧÂʵÍÏ¡£Òò´Ë£¬°ÑͼÊé¹ÜÀíÐÅϢϵͳÓëÉçÇø½áºÏ£¬³ÉΪÁËÒ»ÖÖ±ØÈ»µÄÇ÷ÊÆ¡£ÉçÇøÊé¼®¹ÜÀíϵͳ£¬Îª¹ÜÀíÈËÔ±´øÀ´Á˼«´óµÄ¹¤×÷±ãÀû£¬Ìá¸ßÁ˹¤×÷µÄЧÂÊ¡£¶øÇÒ½µµÍÁ˹¤×÷µÄʧÎóÂÊ£¬Í¬Ê±£¬Ò²½ÚÔ¼Á˹¤×÷ºÄ·Ñʱ¼ä£¬Îª¹ÜÀíÔ±£¬Îª¶ÁÕß´øÀ´Á˱ãÀû¡£
ΪÁ˸üºÃµÄʵÏÖ¶ÔͼÊéµÄ¹ÜÀí£¬²ÉÓÃVB 6.0×÷Ϊ¿ª·¢¹¤¾ß£¬Éè¼ÆÊµÏÖÊý¾Ý¿â¹ÜÀíϵͳ£ºÍ¼Êé½èÔĹÜÀíϵͳ¡£ÏµÍ³Éè¼ÆÁËͼÊé¹ÜÀí£¬Óû§¹ÜÀí£¬½èÔĹÜÀí£¬¹ÜÀíÔ±¹ÜÀí£¬²éѯ¹ÜÀí£¬ÃÜÂë¹ÜÀí£¬Êý¾Ý¿â¹ÜÀíµÈÄ£¿é¡£Äܹ»ÊµÏÖÒÔÏÂÈÎÎñ£ºÓû§·Ö¼¶È¨ÏÞ²Ù×÷¡¢½è»¹Í¼Êé²Ù×÷¡¢Êé¿âά»¤²Ù×÷¡¢²éѯ²Ù×÷µÈ£¬¿ÉÒÔ´ó´ó¼õÇáͼÊé¹Ý¹¤×÷ÈËÔ±µÄ¹¤×÷Á¿£¬È«ÃæÌá¸ßÁËͼÊé¹ÝµÄ¹ÜÀíЧÂʼ°·þÎñÖÊÁ¿¡£
±¾ÎÄÖ÷Òª½éÉÜÁËÊý¾Ý¿â¹ÜÀíϵͳ¡¢Êý¾Ý¿âµÄ¸ÅÄîÒÔ¼°¿ª·¢¹¤¾ßVB 6.0ºÍMicrosoft SQL 2000µÄÌØµãºÍϵͳ¿ª·¢µÄÁ÷³Ì¡£ÆäÖÐÖØµã½éÉÜÁËϵͳ¸÷¸öÄ£¿éµÄÉè¼ÆÓëʵÏÖ¹ý³Ì¡£
¹Ø¼ü´Ê: Êé¼®¹ÜÀí£¬ÐÅϢϵͳ£¬VB 6.0£¬Microsoft SQL Server 2000
ABSTRACT
Management Information System is a continuous development of new subject, as the information technology in the management of the increasingly in-depth and extensive application, the implement of management information system has become mature in technology gradually. The books are our best way to get information, but because of the library collection increased greatly, cause the traditional librarians of the increasing workload, forced people to use of new management approach to manage the books.
In order to achieve better management of the books, using VB 6.0 as an exploitation tool, design Database Management System: Book Loan Management System. Design of the system includes Book Management, User Management, Borrow-Return Management, Administrator Management, Query Management, Password Management, Database Management module, etc. It can carry out the following mission: the users¡¯ classification authority to operate, borrow-return book operation, book maintenance operation, query operation, etc. It can greatly reduce the workload of staff, comprehensively enhance the library's management efficiency and service quality.
This article main talked about the concept of the Database Management System and the Database, the features of the exploitation tool: VB 6.0 and Microsoft SQL 2000 and the development process of the system. The introduction focused on the various modules of the system design and implementation process.
Keywords: Book Management, Management System, VB 6.0, Microsoft SQL Server 2000
Ŀ¼
ÕªÒªI
ABSTRACTII
µÚ1Õ Ð÷ÂÛ1
1.1¿ª·¢±³¾°¼°ÏÖ×´1
1.2 ¿ª·¢Ä¿±ê¼°ÈÎÎñ1
µÚ2Õ ϵͳ¿ª·¢¹¤¾ß½éÉÜ3
2.1 Visual Basic ¼ò½é3
2.2 SQL Server 2000 ¼ò½é4
µÚ3Õ ϵͳ·ÖÎö5
3.1ϵͳ¿ÉÐÐÐÔ·ÖÎö5
3.1.1 ¼¼Êõ¿ÉÐÐÐÔ5
3.1.2 ¾¼Ã¿ÉÐÐÐÔ5
3.1.3 ²Ù×÷¿ÉÐÐÐÔ6
3.2 ÐèÇó·ÖÎö6
3.2.1 ÐèÇó·ÖÎöµÄÖØÒªÐÔ6
3.2.2 ϵͳʵ¼ÊÐèÇó·ÖÎö6
3.3 ϵͳÉè¼ÆÔÔò7
3.4ϵͳҵÎñÁ÷³Ìͼ8
µÚ4Õ Êý¾Ý¿âÉè¼Æ9
4.1 Êý¾Ý¿âÉè¼ÆÔÔò9
4.2 Êý¾Ý¿â¸ÅÄî½á¹¹Éè¼Æ9
4.3 Êý¾Ý¿âÂß¼½á¹¹Éè¼Æ10
4.4ʹÓÃADOÊý¾Ý¿Ø¼þ·ÃÎÊÊý¾Ý¿â12
µÚ5Õ ϵͳģ¿éÉè¼ÆÓëʵÏÖ15
5.1 ϵͳ¹¦ÄÜ·ÖÎö15
5.1.1 ÉçÇøÍ¼Êé¹Ý»ù±¾ÐÅÏ¢´¦Àí¹ý³Ì·ÖÎö15
5.1.2 ½èÔÄÐÅÏ¢´¦Àí¹ý³Ì·ÖÎö15
5.1.3 ½çÃæÉè¼Æ·ÖÎö16
5.2 ϵͳ¹¦ÄÜÄ£¿éʵÏÖ16
5.2.1 ϵͳµÇ¼16
5.2.2Êé¼®ÐÅÏ¢¹ÜÀí³ÌÐòÉè¼Æ18
5.2.3 ¶ÁÕßÐÅÏ¢¹ÜÀí³ÌÐòÉè¼Æ19
5.2.4 Êé¼®½èÔÄ¡¢¹é»¹¡¢Ðø½è³ÌÐòÉè¼Æ20
5.2.5 ¹ÜÀíÔ±ÐÅϢģ¿éÉè¼Æ23
5.2.5 ÐÅÏ¢»ã×ÜÄ£¿éÉè¼Æ24
5.3 ϵͳÔËÐвâÊÔ24
5.4 ϵͳά»¤25
5.4.1ϵͳά»¤µÄ»ù±¾¸ÅÄî25
5.4.2 ϵͳά»¤¹¤×÷µÄÄÚÈÝ25
5.4.3 ϵͳά»¤µÄÀàÐÍ25
5.4.4 ϵͳά»¤¹¤×÷µÄÌØµã26
5.4.5 ϵͳµÄ¿Éά»¤ÐÔ26
5.4.6 ϵͳά»¤µÄ×éÖ¯Óë¹ÜÀí26
5.5 ϵͳ´æÔÚµÄÎÊÌâ27
µÚ6Õ ×ܽá28
ÖÂл29
²Î¿¼ÎÄÏ×30