ÖÐСÐÍͼÊé¹ÜÀíµÄͼÊéÐÅÏ¢¹ÜÀíϵͳ_¼ÆËã»úרҵÂÛÎÄ
·¢²¼Ê±¼ä£º
2015-01-16
À´Ô´£º
ÈË´ó¾¼ÃÂÛ̳
¼ÆËã»úרҵÂÛÎÄ·¶ÎÄ
ÕªÒª
±¾ÎÄ»ùÓÚAccessÊý¾Ý¿âºÍASP¼¼Êõ£¬Éè¼Æ²¢¿ª·¢Ò»Ì×ÊʺÏÓÚÖÐСÐÍͼÊé¹ÜÀíµÄͼÊéÐÅÏ¢¹ÜÀíϵͳ¡£ÔÚϵͳµÄʵÏÖÖÐÔËÓÃÁ˶àÖÖ²éѯ¼¼Êõ£»¶Ô²éѯ½á¹û²ÉÓûº´æ¼¼ÊõºÍÆäËüµÄϵͳÓÅ»¯¼¼Êõ£¬Ìá¸ßÁËϵͳµÄÐÔÄÜÍøÉϼìË÷µÄЧÂÊ£»Í¬Ê±ÔÚϵͳÖвÉÈ¡Á˶àÖÖ°²È«ÐÔ´ëÊ©£¬È·±£ÁËϵͳÔÚÒ»¶¨³Ì¶ÈÉϵݲȫ¿É¿¿¡£
ͨ¹ý¶ÔͼÊé¹Ý¹ÜÀíÈÕ³£¹¤×÷µÄÏêϸµ÷²é£¬´óÁ¿×ÊÁϵÄËѼ¯£¬¾¹ý±È½Ï×ܽáËûÃǶ¼ÊµÏÖÁËÒÔÏÂͼÊé¹ÜÀíµÄ»ù±¾¹¦ÄÜ£º1¡¢Í¼Êé¼ìË÷Ä£¿é£ºÊÇͼÊé¹ÜÀíϵͳµÄÖØҪģ¿éÖ®Ò»£¬ÊǶÁÕß¿ìËÙ²éѯͼÊéµÄ;¾¶¡£2¡¢Í¼Êé¹ÜÀíÄ£¿é£ºÊÇͼÊé¹ÜÀíÔ±²Ù×÷Ä£¿é£¬¶ÁÕßÊÇÎÞȨ½øÈëµÄ¡£±¾Ä£¿éÓɽè³öͼÊéµÇ¼Ç¡¢¹é»¹Í¼ÊéµÇ¼ÇºÍÐø½èͼÊéµÇ¼Ç×ÓÄ£¿é¹¹³É¡£3¡¢Êý¾Ýά»¤Ä£¿é£ºÊÇÓÉͼÊé¹ÜÀíÔ±¿ØÖƵÄÄ£¿é£¬ËüÓÉÔö¼Ó¡¢Ð޸ĺÍɾ³ý¶ÁÕߣ¬Ôö¼Ó¡¢ÐÞ¸Äɾ³ýͼÊ飬ä¯ÀÀÐ޸ĶÁÕß¡¢ä¯ÀÀÐÞ¸ÄͼÊéµÈ³ÌÐò×é³É¡£ 4¡¢Êý¾Ýͳ¼ÆÄ£¿é£ºÓɶÁÕßͳ¼Æ¡¢Í¼Êéͳ¼Æ¡¢½è³öͼÊé·ÖÀàͳ¼Æ¡¢µ½ÆÚÄ©¹é»¹Í¼Êé¶ÁÕßͳ¼Æ¼¸²¿·Ö×é³É¡£´Óϵͳ½á¹¹µÄ×éÖ¯£¬¹¦ÄܵÄʵÏÖ£¬¼¼ÊõµÄÒªÇóÒÔ¼°¿ÉÐÐÐԵȶ෽Ãæ½øÐп¼ÂÇ£¬ÈÏΪ±¾¿ÎÌâÊÇÒ»¸öÊÊÓ¦ÏÖ½ñͼÊé¹Ý¹ÜÀíÐèÇóµÄ¼ÆËã»úÐÅÏ¢¹ÜÀíϵͳ£¬¾ßÓÐÒ»¶¨µÄʵ¼Ê¿ª·¢¼ÛÖµºÍʹÓüÛÖµ¡£
¹Ø¼ü´Ê£ºASP£¬WEB£¬Access£¬Í¼Ê飬Êý¾Ý¿â
ABSTRACT
Based on Access and ASP technology, a kind of books information management system to arrange small or middle type of books management is designed and developed. For the query results, buffering and some System Optimization technologies are adopted, which improves greatly the searching speed on the web for reader. Many security measures are taken as well, which insures the safety and reliability of the system to some extent.
Through to the library management routine work's close investigation, the massive material's collection, summarized them after the comparison to realize the following books management basic function: 1st, books retrieva l module: Is one of books management system management system's important modules, is the reader inquires the books way fast. 2nd, books administration module: Is the librarian operates the module, the reader has no right to enter. This module by loans the books registration, the restore books registration and the renewal books registration sub module constitution. 3rd, data maintenance module: Is module which controls by the librarian, it by increases, the revision and the deletion reader, increases, the revision deletion books, the browsing revises the reader, the browsing to revise procedures and so on books to compose. 4th, data statistics module: Counts, the books statistics from the reader, to loan the books classification statistics, to count several parts to the end of the period restore books reader to compose. From system structure's organization, function realization, the technical request as well as feasible and so on carries on the consideration variously, thought that this topic is an adaptation nowadays the library management demand computer information management system, has certain actual development value and the use value.
Keywords: Active Server Pages (ASP), WEB, Access, Books, Database
Ŀ¼
ÕªÒªI
ABSTRACTII
µÚÒ»ÕÂ Ç°ÑÔ1
1.1 ±³¾°1
1.2 Ñо¿ÄÚÈÝ1
1.3 ¿ª·¢¹¤¾ß¼ò½é1
1.4 Access ¼ò½é2
1.5 SQLÓï¾ä¼ò½é3
µÚ2Õ ͼÊé¹ÜÀíϵͳ4
2.1ϵͳÉè¼ÆÖ÷ÒªÈÎÎñ4
2.2Ó¦ÓÃÐèÇó·ÖÎö4
2.3 ¹¦ÄÜÐèÇó4
2.4 ¸öÈËÄ£¿é¹¦ÄÜÏêϸÃèÊö5
2.5ϵͳ¾ßÌåÁ÷³Ì5
µÚ3Õ ͼÊé¹ÜÀíϵͳÊý¾Ý¿âÉè¼ÆÓë·ÖÎö7
3.1 Êý¾Ý¿âÐèÇó·ÖÎö7
3.2 Êý¾Ý¿â¸ÅÄîÉè¼Æ7
3.3 Êý¾Ý¿âµÄÂß¼½á¹¹Éè¼Æ8
µÚËÄÕ ϵͳµÄÉè¼ÆÓëʵÏÖ11
4.1ͼÊé¹Ý¹ÜÀíϵͳÖ÷´°Ìå11
4.2¸öÈËÄ£¿éÖ÷´°Ìå²Ëµ¥11
4.2.1¹ÜÀíÔ±Ìí¼ÓÀà±ð´°Ìå12
4.2.2²éѯ´°Ìå12
4.2.3ɾ³ý¶ÁÕßÀà±ð´°Ìå14
4.2.4²éѯÊé¼®´°Ìå14
4.2.5½èÊé´°Ìå15
4.3ϵͳÐÔÄÜÒÔ¼°°²È«ÐÔ17
4.3.1ϵͳÐÔÄÜ17
4.3.2ϵͳ°²È«ÐÔ18
µÚÎåÕ ϵͳ²âÊÔÓëÐÔÄÜ·ÖÎö19
µÚÁùÕ ½áÊøÓï21
ÖÂл22
²Î¿¼ÎÄÏ×23