·¢²¼Ê±¼ä£º2015-01-16 À´Ô´£ºÈË´ó¾­¼ÃÂÛ̳

¼ÆËã»úרҵÂÛÎÄ·¶ÎÄ Õª Òª ÔÚÎÒ¹ú£¬ËäȻԶ³Ì½ÌÓýÒѾ­ÅµØ·¢Õ¹ÆðÀ´£¬µ«ÊÇĿǰѧУÓëÉç»áÉϵĸ÷ÖÖ¿¼ÊԴ󶼲ÉÓô«Í³µÄ¿¼ÊÔ·½Ê½£¬Ëæ×Å¿¼ÊÔÀàÐ͵IJ»¶ÏÔö¼Ó¼°¿¼ÊÔÒªÇóµÄ²»¶ÏÌá¸ß£¬½ÌʦµÄ¹¤×÷Á¿½«»áÔ½À´Ô½´ó£¬²¢ÇÒÆ乤×÷½«ÊÇÒ»¼þÊ®·Ö·³ËöºÍ·Ç³£ÈÝÒ׳ö´íµÄÊÂÇ飬¿ÉÒÔ˵´«Í³µÄ¿¼ÊÔ·½Ê½ÒѾ­²»ÄÜÊÊÓ¦ÏÖ´ú¿¼ÊÔµÄÐèÒª¡£Òò´Ë£¬¿ª·¢»ùÓÚwebµÄÔÚÏß¿¼ÊÔϵͳÔÚµ±Ç°ÒѳÉΪһÏîÆÈÇеÄÐèÇó¡£ ±¾±ÏÒµÉè¼ÆµÄ¿ÎÌâÊÇ¡°»ùÓÚwebµÄÔÚÏß¿¼ÊÔϵͳµÄÉè¼ÆÓëʵÏÖ¡±¡£ÏµÍ³ÊµÏÖÉæ¼°µ½Êý¾Ý¿â¼¼Êõ¡¢ÍøÂç¼¼Êõ¡¢Èí¼þ¹¤³Ì¡¢±à³ÌÄÜÁ¦µÈ£»ÐèÒª¾ß±¸¶ÀÁ¢¹Û²ì·ÖÎöµÄÄÜÁ¦¡¢ÏµÍ³Éè¼ÆµÄÄÜÁ¦¡¢ÒÔ¼°Êµ¼Ê±à³Ì¼¼ÄÜ¡£ ±¾¿ÎÌâÖ÷Òª½â¾ö¿¼ÉúµÇ½£¬È˹¤³öÌ⣬¿¼Éú¿¼ÊÔ£¬È˹¤ÔÄ¾í£¬³É¼¨ÆÀ¹ÀºÍÊÔ¾í·ÖÎö£¬ºÍ×ۺϹÜÀíµÈÄ£¿é£¬°üÀ¨Ç°Ì¨¿Í»§¶Ë³ÌÐòµÄ¿ª·¢ºÍºǫ́Êý¾Ý¿âµÄÉè¼Æ¡£Ç°ÕßÖ÷ҪΪ½çÃ濪·¢ºÍ²¿·Ö¹¦ÄܵÄʵÏÖ£»ºóÕßÖ÷ҪΪÊý¾Ý¿â±í¸ñµÄÉè¼ÆºÍ´´½¨£¬´æ´¢¹ý³ÌµÄ´´½¨ºÍά»¤¡¢ÊÓͼµÄ´´½¨ºÍά»¤¡¢SQLº¯ÊýµÄ´´½¨ºÍά»¤µÈ¡£ ±¾ÏµÍ³µÄ¿ª·¢¹¤¾ßΪ£¬Microsoft SQL Server 2000£¬ASP¼¼Êõ£¬Î¢ÈíµÄIISºÍ½éÃ濪·¢¹¤¾ßMacromedia Dreamweaver MX 2004,²ÉÓÃB/S½á¹¹ ¹Ø¼ü´Ê£ºÔÚÏß¿¼ÊÔ¡¢Ô¶³Ì½ÌÓý¡¢SQL¡¢web¡¢B/S¡¢ASP DESIGN AND IMPLEMENTATION OF ON-LINE EXAMINATION SYSTEM BASED ON WEB ABSTRACT In China, the distance education has been remarkably developed, but now most of the examinations are organized by the traditional test method in the schools and communities. With the increase of examination types and examination demands, the workload of teachers will grow larger and larger, and those works will be very cumbersome and very easy to go wrong. It can be said that the traditional examination methods can not meet the needs of modern examinations. Therefore, the development of web-based online examination system has become an urgent demand in the current. The topic of this project is ¡°Design and implementation of on-line examination system based on web¡± The major scope covers database technology, network technology, software engineering, programming and other capabilities. Ability of independent analysis, examination system design, and practical programming skills are assessed. The task mainly includes six modules: candidates logging on, artificial topic, the candidates examination, artificial markers, performance eva luation and analysis of the test, such as front-end(client) software development, that includes user interface development and implementation of some functions etc; and back-end database system design, that includes database table design and creation, stored procedure creation and maintenance, view creation and maintenance and SQL function creation and maintenance. Developing tools used are Microsoft SQL Server 2000, ASP technology, Microsoft IIS and Macromedia Dreamweaver MX 2004 which is an interface development tool, and B/S architecture is applied. KEYWORDS£ºon-line examination£¬Distance Education £¬SQL£¬web, B/S¡¢ASP Ä¿ ¼ Õª ÒªII ABSTRACTIII µÚÒ»Õ Òý ÑÔ1 1.1 Ñ¡ÌâÒâÒå1 1.2 ¿ª·¢¹¤¾ßµÄÑ¡Óü°½éÉÜ1 1.2.1 ¿ª·¢¹¤¾ßµÄÑ¡Óá­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­...¡­¡­¡­¡­¡­¡­¡­¡­1 1.2.2 ¿ª·¢¹¤¾ßµÄ½éÉÜ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­...¡­¡­¡­1 µÚ¶þÕ ϵͳ×ÜÌå·ÖÎöÓëÉè¼Æ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­.5 2.1 ÐèÇó·ÖÎö5 2.1.1ѧÉú×Óϵͳ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­.¡­¡­¡­¡­..¡­¡­¡­¡­5 2.1.2 ½Ìʦ×Óϵͳ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­...¡­¡­¡­¡­¡­¡­5 2.2 ¹¦ÄÜÃèÊö...5 2.3 ϵͳ¹¦ÄÜÄ£¿é½á¹¹Í¼...6 2.4 ϵͳҳÃæÉè¼Æ..7 µÚÈýÕ Êý¾Ý¿âµÄÉè¼Æ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­.....9 3.1Êý¾Ý¿âÉè¼ÆÔ­Ôò9 3.2 Êý¾Ý¿âÂß¼­½á¹¹Éè¼Æ9 µÚËÄÕ Èí¼þʵÏÖ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­.¡­..14 4.1 µÇÊý¾Ý¿âµÄÉè¼ÆÓëÁ¬½Ó14 4.2 Óû§µÇ½ÑéÖ¤14 4.3¿¼ÊÔʱ¼ä¿ØÖÆ18 4.4ÊÔ¾íµÄËæ»úÉú³É19 4.5 ¹æ¶¨µÄʱ¼äÄÚÇ¿ÆȽ»¾í20 4.6×Ô¶¯ÆÀ·Ö¼¼ÊõµÄʵÏÖ20 4.7ϵͳ°²È«ÐÔ22 µÚÎåÕ ϵͳµÄʹÓÃ˵Ã÷Óë°²×°¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­...¡­¡­¡­23 5.1 ÔËÐл·¾³ÒªÇó23 5.1.1 ·þÎñÆ÷¶ËÅäÖá­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­...¡­..23 5.1.2 ¿¼ÊÔ¼ÆËã»úÅäÖá­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­.23 5.2 °²×°ÉèÖÃ24 ²Î¿¼ÎÄÏס­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­.¡­¡­¡­¡­.27 Ö ¡¡Ð»28