ÕªÒª
ËæןßУµÄ²»¶ÏÀ©ÕУ¬µ¼Ö½Ìѧ×ÊÔ´½ôÕÅ£¬ÓÈÆäÊǽÌÊÒ×ÊԴʹÓûìÂÒ¡¢¹ÜÀí²»¹æ·¶µÈÎÊÌâ¸ü¼Ó͹ÏÔ³öÀ´£¬ÈçºÎºÏÀíÅäÖú͹ÜÀí½ÌÊÒÀ´Âú×ãѧÉúºÍ½ÌʦµÄÐèÇó³ÉΪÎÒÃÇÑо¿ºÍ½â¾öµÄÎÊÌâ¡£¿ª·¢ºÍÉè¼ÆµÄУ԰½ÌÊÒÐÅÏ¢¹ÜÀíϵͳÊÇÕâ¸öʱ´úµÄ²úÎÀûÓÃÐÅÏ¢¼¼ÊõʵÏÖ¶Ô½ÌÊÒ×ÊÔ´µÄ¹ÜÀí£¬Ê¹½ÌʦºÍѧÉú¸ü·½±ãµÄʹÓýÌÊÒ£¬ÈùÜÀíÔ±¸ü·½±ãµÄÕÆÎÕ½ÌÊÒʹÓÃÇé¿ö£¬ÓÐÀûÓÚÌá¸ß½ÌÊÒµÄʹÓÃÂÊ£¬Í¬Ê±»¹Íƶ¯ÁËÐÅÏ¢»¯½¨É裬²¢ÇÒ¶ÔÌá¸ß¹¤×÷ЧÂÊ¡¢È«ÃæʵÏÖÎÞÖ½»¯°ì¹«Ò²ÓÐ×ÅÖØÒªÒâÒå¡£
±¾ÏµÍ³ÊÇÔÚWindows XP»·¾³Ï£¬²ÉÓÃB/S½á¹¹£¬ÒÔMySQLΪÊý¾Ý¿â¿ª·¢Æ½Ì¨£¬²ÉÓÃJSP(JAVA Server Pages)¼¼Êõ¿ª·¢µÄ¡£´ËϵͳµÄÉè¼Æ´Ó¹¦ÄÜÉÏÀ´Ëµ£¬ÊDZȽÏÍ걸µÄ£¬ÏµÍ³ÒÔWeb½çÃæÓë¹ÜÀíÔ±½»»¥£¬Îª¹ÜÀíÔ±ÌṩÐÅÏ¢²¢½ÓÊÜÆä²Ù×÷£¬Í¬Ê±Í¨¹ýÊý¾Ý¿â¹ÜÀíϵͳÀ´´æ´¢ÐÅÏ¢Êý¾Ý¡£±¾ÏµÍ³µÄ»ù±¾¹¦ÄÜ£ºÊý¾Ý½øÐмÈë¡¢Ð޸ġ¢É¾³ý¡¢²éѯ¡¢Í³¼ÆµÄ»ù±¾¹¦ÄÜ¡£
¹Ø¼ü´Ê£ºMySQL £»¹ÜÀíϵͳ£»JSP
Abstract
With the continuous enrollment, cause the teaching resources, especially the problem of classroom resources using chaos, management is not standardized, more prominent, how the rational allocation and management, to meet the needs of students and teachers become our study and solve problems. The development and design of the campus classroom information management system is a product of this era, the realization of classroom resource management by using information technology, make the teachers and students more convenient use of classrooms, allow administrators to more easily grasp the classroom use, improve classroom efficiency, but also promote the informatization construction, and to improve the work efficiency, the full realization of the paperless office has important significance.
This system is under Windows XP environment, using B/S structure, using MySQL database development platform, using JSP (JAVA Server Pages) technology development. The design of this system from the function, is more complete, the system to the Web interface and administrator interaction, and provide information for administrators and accept its operation, at the same time to store information and data through database management system. The basic functions of the system: the basic function of data entry, modify, delete, query, statistics.
Keywords: MySQL; management system; JSP
Ŀ¼
1.¸ÅÊö 1
1.1¿ÎÌâÑо¿Ä¿µÄºÍÒâÒå 1
1.2¹úÄÚÍâ·¢Õ¹ÏÖ×´ 1
1.3¿ÎÌâÑо¿µÄÖ÷ÒªÄÚÈÝ 2
1.4¿ÎÌâÑо¿µÄÄ¿±ê 2
1.5ÐÅÏ¢¹ÜÀíϵͳ 2
2.ϵͳ·ÖÎö 3
2.1¿ÉÐÐÐÔ·ÖÎö 3
2.1.1¾¼ÃÉϵĿÉÐÐÐÔ 3
2.1.2¼¼ÊõÉϵĿÉÐÐÐÔ 3
2.1.3²Ù×÷ÉϵĿÉÐÐÐÔ 3
2.2ϵͳ·ÖÎö 4
2.2.1¹¦ÄÜÐèÇó 4
2.2.2ÐÔÄÜÐèÇó 5
2.3ÒµÎñÁ÷³Ì·ÖÎö 5
2.4Êý¾ÝÁ÷³Ì·ÖÎö 7
2.5Êý¾Ý¿âÉè¼Æ 7
2.5.1Êý¾Ý¿â¸ÅÄî½á¹¹Éè¼Æ 8
2.5.2Êý¾Ý¿âÂß¼½á¹¹Éè¼Æ 10
3.ϵͳÉè¼Æ 13
3.1ϵͳÌåϵ½á¹¹ 13
3.2 ¿ª·¢Èí¼þ 14
3.2.1 JSP¼¼Êõ 14
3.2.2 Tomcat ·þÎñÆ÷ 15
3.2.3 MYSQL 16
3.2.4 MyEclipse 17
3.3ϵͳµÄÈíÓ²¼þƽ̨ 18
4.ϵͳ²Ù×÷ʵÏÖ 18
4.1¹ÜÀíÔ±²Ù×÷ʵÏÖ 18
4.1.1ϵͳµÇ½½çÃæ 18
4.1.2¹ÜÀíÔ±Óû§¹ÜÀíÒ³Ãæ 22
4.1.3½ÌʦÐÅÏ¢Ìí¼ÓÒ³Ãæ 23
4.1.4½ÌʦÐÅÏ¢¹ÜÀíÒ³Ãæ 25
4.1.5ѧÉúÐÅÏ¢Ìí¼ÓÒ³Ãæ 27
4.1.6ѧÉúÐÅÏ¢¹ÜÀíÒ³Ãæ 29
4.1.7ά»¤¼Ç¼Ìí¼ÓÒ³Ãæ 31
4.1.8Õ¼ÓÃÉêÇë¹ÜÀíÒ³Ãæ 32
4.2½Ìʦ²Ù×÷ʵÏÖ 34
4.2.1Õ¼ÓÃÉêÇëÒ³Ãæ 34
4.2.2¿Î³Ì°²ÅŲ鿴ҳÃæ 36
5.Èí¼þ²âÊÔÓë·ÖÎö 36
5.1ϵͳ²âÊԵĶ¨Òå 36
5.2ϵͳ²âÊÔµÄÄ¿µÄ¼°ÒâÒå 37
5.3ϵͳ²âÊÔµÄÖØÒªÐÔ 37
5.4ϵͳ²âÊԵij£Ó÷½·¨ 37
5.5²âÊÔ»·¾³Óë²âÊÔÌõ¼þ 38
5.6ϵͳÔËÐÐÇé¿ö 39
5.7²âÊÔ×ܽá 39
6.½áÂÛ 39
6.1ϵͳµÄÌصã 39
6.2ϵͳµÄ²»×ãºÍ¸Ä½ø 40
6.3Éè¼ÆÊÕ»ñÓëÐĵà 40
Ö л 41
²Î ¿¼ ÎÄ Ï× 42