Õª  Òª

ÏÖ´úÐÅÏ¢¼¼ÊõµÄ·¢Õ¹,ʹµÃ»ùÓÚWEB¼¼ÊõµÄÍøÉÏÅÅ¿Îϵͳ³ÉΪ¼¼Êõ¸Ä¸ïÓë·¢Õ¹µÄ·½Ïò¡£±¾Îľ͸ù¾ÝÏÖÒÑ´æÔÚµÄÎÊÌ⣬¶ÔÍøÉÏÅÅ¿Îϵͳ×öÁËÈ«ÃæµÄ·ÖÎöºÍÕûÌåµÄ½éÉÜ¡£½éÉÜÁËASP+ACCESS¼¼Êõ¿ª·¢¸ÃϵͳµÄ×ÓϵͳµÄÕû¸ö¹ý³Ì£¬¼´ÍøÉÏÅÅ¿Îϵͳ¡£¸ÃϵͳÖ÷ÒªÀûÓÃÁËASPÇ¿´óµÄÍøÂçÊý¾Ý¿â·ÃÎʼ¼Êõ£¬ÊµÏÖÁËÍøÉÏÅſεķ½±ãÐÔ¡£±¾ÎÄÊÇÔڲο¼¸÷ÖÖÊг¡ÉÏÁ÷ÐеÄÅÅ¿ÎÈí¼þµÄ»ù´¡Éϳ¢ÊÔÐÔµØÌá³öÁËÒ»ÖÖ´óѧÅÅ¿ÎËã·¨£¬²¢¿ª·¢¶ø³ÉСÐÍ×Ô¶¯ÅÅ¿Îϵͳ¡£ÅÅ¿ÎÎÊÌâµÄÑо¿Ö÷ÒªÊǽâ¾ö¸÷ÖÖ½Ìѧ×ÊÔ´Èç½ÌÊÒ¡¢½ÌʦµÄºÏÀíÓÐЧÀûÓÃÎÊÌ⣬±ÜÃâ½Ìʦ¡¢°à¼¶ÔÚÉÏ¿Îʱ¼ä¡¢µØµãÉϵijåÍ»£¬Ê¹ÅÅ¿Îʱ¼ä·ÖÅä¾ùÔÈ¡£ÔÚËã·¨Éè¼ÆÖÐΪÅſβÙ×÷ÉèÖÃÁ˲»Í¬µÄÓÅÏȼ¶£¬Öð¼¶ÅſΣ¬ÓÐЧµØ½µµÍÁËÅÅ¿Îʱ¼ä³åÍ»µÄ¼¸ÂÊ£¬Ìá¸ßÁËÅſεijɹ¦ÂÊ¡£ÁíÍ⣬ϵͳΪ½ÌʦºÍ½ÌÊÒ·Ö±ðÉè¼ÆÁËÅſμ¶±ð£¬´Ó¶øÄܹ»±ÜÃâ½Ìѧ×ÊÔ´¹ýÓÚ¼¯ÖеØʹÓã¬ÊµÏÖ¾ùºâ»¯ÀûÓá£
ÂÛÎÄÖ÷Òª½éÉÜÁ˱¾¿ÎÌâµÄ¿ª·¢±³¾°¡¢ÏµÍ³·ÖÎö¡¢Êý¾Ý¿âÉè¼ÆºÍϵͳµÄÉè¼ÆÓëʵÏÖ¡£

¹Ø¼ü´Ê  ASP£»ACCESS£»×Ô¶¯ÅſΣ¬Êý¾Ý¿â£¬¿Î³Ì±í

ABSTRACT
With the development of information technology, the web-based education platform has been a direction of modern education. According to the problems existing at present, the paper gives an overall analysis and introduction of Internet courseware system. At the same time, it gives all the procession of developing the subsystem using ASP+ACCESS technology. Through the strong ability of ASP+ACCESS technology, it realizes online studying adaptively. The system designs and realizes different navigation strategies such as module navigation, searching navigation, knowledge classifying navigation and helping navigation. These strategies have different functions. Searching knowledge navigation and knowledge classifying navigation are mainly based on the relations of the knowledge and then supplies different knowledge to users. So that it improves users' learning efficiency and study enthusiasm to a certain extent. The system is also realized using the course example ¡°C programming¡±.
The paper mainly introduces the development¡¯s context, system analysis, database design, the system design and implementation.

Key words  ASP; ACCESS ; course automatic ; database; curriculum schedule

Ä¿  ¼

µÚÒ»½Ú Ð÷  ÂÛ  ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­   2
1.1¿ÎÌâ±³¾°  ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­ 2
1.1.1ÍøÉÏÅÅ¿ÎϵͳµÄÏÖ×´   ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­   3
1.1.2 ÍøÉÏÅÅ¿Îϵͳ¶Ôµ¼º½ÏµÍ³µÄÐÂÒªÇó  ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­  3
1.2±¾¿ÎÌâµÄÑо¿ÒâÒå  ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­  4
1.3Ïà¹Ø¼¼Êõ½éÉÜ  ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­  5
1.3.1ä¯ÀÀÆ÷/·þÎñÆ÷Ä£ÐÍ ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­ 6
1.3.2 ASP¼¼ÊõµÄ½éÉÜ ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­ 7
1.3.3 ADO·Ã¿â¼¼Êõ½éÉÜ ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­ 7

µÚ¶þ½Ú ϵͳ·ÖÎö ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­ 9
2.1ϵͳµÄ¿ÉÐÐÐÔÑо¿ ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­ 9
2.2 ϵͳÐèÇó·ÖÎö¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­ 10
2.2.1Óû§ÐèÇó·ÖÎö ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­  11
2.2.2 ϵͳÉè¼ÆÄ¿±ê·ÖÎö ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­  12
2.3Óû§Ä£Ð͵ĽéÉÜ ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­  13
2.4ϵͳµ¼º½¹¦ÄÜÄ£¿é½éÉÜ  ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­  14
2.4.1 ½Ìʦ¹ÜÀí½éÉÜ ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­  16
2.4.2 °à¼¶¹ÜÀí½éÉÜ ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­  18
2.4.3¿Î³Ì¹ÜÀí½éÉÜ ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­   19
2.4.4 ½ÌÊÒ¹ÜÀí½éÉÜ ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­  20
2.4.5 ʱ¼ä¶Î¹ÜÀí½éÉÜ ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­  22
2.5 С½á ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­  23

µÚÈý½Ú Êý¾Ý¿âÉè¼Æ  ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­  24
3.1Êý¾Ý¿âµÄÐèÇó·ÖÎö ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­ 25
3.2 ºǫ́Êý¾Ý¿âµÄÅäÖà¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­ 25
3.3 Êý¾Ý¿â±í½á¹¹Éè¼Æ ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­ 25
3.4 E-RÄ£ÐÍ ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­ 26

µÚËÄ½Ú ÏµÍ³ÏêϸÉè¼ÆÓëʵÏÖ ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­ 27
4.1 ϵͳ¹¤×÷Ô­Àí½éÉÜ  ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­ 27
4.2ϵͳÊý¾ÝÁ÷ͼ ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­ 28
4.3ϵͳµÄʵÏÖËã·¨ ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­ 28
4.3.1Óû§ÐÅÏ¢³õʼ»¯Ëã·¨ ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­ 29
4.3.2¼ìË÷µ¼º½Ëã·¨ ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­ 29
4.3.3°²Åſγ̹ØÁªµ¼º½Ëã·¨ ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­ 29
4.3.4ÍøÂç¿Î³Ì°²ÅſγÌÏÔʾËã·¨ ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­ 30
4.5Ç°¶ËÒ³ÃæµÄÉè¼ÆÓëʵÏÖ ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­ 30
4.5.1 ϵͳ¹«ÓÃÒ³Ãæ ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­ 30
4.5.2 Óû§µÇ½ҳÃæ ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­ 30
4.5.3 ¹ÜÀíÊ×ҳģ¿é ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­ 31
4.5.4 ½Ìʦ¹ÜÀíÄ£¿é ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­ 31
4.5.5 °à¼¶¹ÜÀíÄ£¿é ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­ 31
4.5.6¿Î³Ì¹ÜÀíÄ£¿é ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­ 32
4.5.7½ÌÊÒ¹ÜÀíÄ£¿é ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­ 32
4.5.8ʱ¼ä¶Î¹ÜÀíÄ£¿é ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­  32
4.5.9¿Î³Ì¹ÜÀíÄ£¿é ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­ 33
4.6.0ÃÜÂëÐÞ¸ÄÄ£¿é ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­ 33
5 ½áÊøÓï ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­ 33

ÖÂл  ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­   34

²Î¿¼ÎÄÏ× ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­ 35

µÚÒ»½Ú Ð÷  ÂÛ

1.1 ¿ÎÌâ±³¾°
δÀ´µÄ½ÌÓýºÍѧϰ½«ÊÇÔÚÍøÂç»·¾³Ï½øÐеĻòÕßÊÇͨ¹ýÍøÂçʵÏֵģ¬¶øÏÖ½ñ¹ØÓÚÍøÂç½ÌÓýÔõô×ö£¬½«¹Øϵµ½ÒÔºóµÄ·¢Õ¹¡£Ä¿Ç°£¬¹úÄÚ¿ªÕ¹ÍøÂç½ÌÓýÊÔµãÒÑÒ»ÄêÓÐÓ࣬¶øÍøÂç½ÌÓý¾¿¾¹Ó¦¸ÃÔõô×ö£¬¶¼ÔÚ̽Ë÷¡¢Ñо¿Ö®ÖС£ÍøÉÏÅÅ¿Îϵͳ´òÆÆÁË´«Í³Ñ§Ð£½ÌÓýµÄ¿ÎÌÃÊÚ¿Îģʽ£¬Í¬Ê±Ò²Í»ÆÆÁË´«Í³Ô¶³Ì½ÌÓýÎÞ·¨ÊµÊ©ÓÐЧµÄ¹µÍ¨ºÍ½»Á÷µÄ¾ÖÏÞ£¬ËüÒªÇó½¨Á¢Ò»ÖÖȫеĽÌѧÓëѧϰģʽ¡£ÕâÖÖ½ÌѧģʽҪÇó½Ìʦת±ä´«Í³µÄ½Ìѧ¹ÛÄ´Ó֪ʶ´«ÊÚÕßµ½Ñ§Ï°°ïÖúÕß¡¢´Ù½øÕߣ¬¸Ä±ä´«Í³µÄ¿ÎÌÃÊڿλ£¬´Ó¿ÎÌÃÊÚ¿Îת±äÍøÂç½Ìѧ¿Î¼þÖÆ×÷¡¢ÍøÉÏ´ðÒÉ¡¢ÍøÉϲ¼ÖÃ/ÅúÔÄ×÷Òµ¡¢ÍøÉÏ×é֯ѧÉúµÄ×ÔÖ÷ѧϰ»î¶¯¡¢Ìṩѧϰ×ÊÔ´µÈ£»Í¬Ê±ÕâÖÖ½ÌѧģʽҲҪÇóѧÉú¸Ä±ä´«Í³µÄѧϰ¹ÛµãºÍѧϰ·½·¨£¬´ÓÖ÷Òª½ÓÊܽÌʦ½²ÊÚΪÖ÷ת±äΪ×ÔÖ÷ѧϰΪÖ÷£¬´ÓÒÔ¿ÎÌÃÌý¿ÎΪÖ÷µÄѧϰ»î¶¯×ª±äΪÍøÉÏÌý¿Î¡¢¿Îºó´ðÒÉ¡¢ÌÖÂÛ¡¢²âÑéÁ·Ï°¡¢ä¯ÀÀÏà¹Ø¿ÎÍâ×ÊÔ´¡¢±Ê¼Ç¼Ç¼µÈһϵÁеÄ×ÔÖ÷ѧϰ»î¶¯¡£
ҪʵÏÖÕâÖÖ½Ìѧģʽ¡¢½Ìѧ£¨Ñ§Ï°£©»î¶¯µÄ´óת±ä£¬ÓÐÁ½¸öÒòËØÊÇÖÁ¹ØÖØÒªµÄ£¬Ê×ÏÈÊÇ´Ó½ÌÓý¹ÛÄîÉÏת±ä£¬´ÓÖØÊÓ¡°½Ì¡±µ½ÖØÊÓ¡°Ñ§¡±£¬´Ó¡°ÐÐΪÖ÷Ò塱¡¢¡°ÈÏÖªÖ÷Ò塱µÈÖ¸µ¼¡°½Ìѧ¡±µÄ½ÌѧÀíÂÛת±äµ½¡°½¨¹¹Ö÷Ò塱µÈÖ¸µ¼¡°Ñ§Ï°¡±µÄѧϰÀíÂÛ£¬Òª½øÐнÌʦÔÚ½Ìѧ¹ý³ÌÖеĽÇÉ«´Óж¨Î»µÄÀíÂÛÓëʵ¼ùÑо¿£»Æä´Î£¬ÒªÓÐÒ»Ì×Äܹ»ºÜºÃµØÖ§³ÖÍøÉϽÌѧ£¨Ñ§Ï°£©µÄÖ§³Ö¹¤¾ß£¬ÒªÄܹ»Ê¹½ÌʦÄܷܺ½±ãµÄʵʩÐÂģʽϵĽÌѧ»î¶¯£¬Ñ§ÉúÄܹ»ºÜ·½±ãÔÚÍøÂçÉϽøÐÐѧϰ¡£

˵Ã÷£º±¾Õ¾ËùÓгÌÐò¶¼±£Ö¤ÔËÐУ¬Ã¿¸öÌâÄ¿¶¼ÓжÔÓ¦µÄÊÓƵÑÝʾ¼Ïñ£¬½ØͼÎĵµµÈÄÚÈÝ¡£

ÈçÐèÒª¸ü¶à×ÊÁÏÇëÁªÏµ¿Í·þÈËQQ£º:1523433965