ÕªÒª
±¾ÎÄÊÇÕë¶Ô¿ÆÑÐÏîÄ¿É걨µÄʵ¼ÊÇé¿ö£¬¿ª·¢µÄСÐÍÍøÕ¾Éè¼Æ¿ÎÌâ¡£ÆäÄ¿µÄÊÇʹ¿ÆÑÐÏîÄ¿É걨¹ÜÀíʵÐÐÖƶȻ¯ºÍ¿Æѧ»¯µÄ¹ÜÀí£¬±£Ö¤¿ÆÑмƻ®Ô²ÂúÍê³É£¬³ö³É¹û¡¢³öЧÒ棬Ìá¸ß¾ºÕùÁ¦¡£´«Í³µÄÊÖ¹¤¼Ç¼ͳ¼Æ²Ù×÷ÒѾԶԶ²»ÄÜÂú×ãʵ¼Ê¹¤×÷µÄÐèÒª£¬ÎªÁËÌá¸ß¹¤×÷ЧÂÊ£¬¶ÔÆäʵʩ¼ÆËã»ú¹ÜÀíÊÇÊ®·Ö±ØÒªµÄ¡£¿ª·¢ºÍÉè¼ÆµÄ¿ÆÑÐÏîÄ¿É걨¹ÜÀíϵͳÊÇÕâ¸öʱ´úµÄ²úÎÀûÓüÆËã»úÖ§³Ö¹ÜÀíÕ߸ßЧÂÊÍê³É¿ÆÑÐÏîÄ¿É걨µÄ¹ÜÀí¡£±¾ÏµÍ³°üº¬ÁË¿ÆÑÐÈËÔ±¹ÜÀíºÍ¿ÆÑÐÏîÄ¿¹ÜÀíµÈ¡£
±¾ÏµÍ³ÊÇÔÚWindows XP»·¾³Ï£¬²ÉÓÃB/S½á¹¹£¬ÒÔMySQLΪÊý¾Ý¿â¿ª·¢Æ½Ì¨£¬²ÉÓÃJSP(JAVA Server Pages)¼¼Êõ¿ª·¢µÄ¡£´ËϵͳµÄÉè¼Æ´Ó¹¦ÄÜÉÏÀ´Ëµ£¬ÊDZȽÏÍ걸µÄ£¬ÏµÍ³ÒÔWeb½çÃæÓë¹ÜÀíÔ±½»»¥£¬Îª¹ÜÀíÔ±ÌṩÐÅÏ¢²¢½ÓÊÜÆä²Ù×÷£¬Í¬Ê±Í¨¹ýÊý¾Ý¿â¹ÜÀíϵͳÀ´´æ´¢ÐÅÏ¢Êý¾Ý¡£±¾ÏµÍ³µÄ»ù±¾¹¦ÄÜ£ºÊý¾Ý½øÐмÈë¡¢Ð޸ġ¢É¾³ý¡¢²éѯ¡¢Í³¼ÆµÄ»ù±¾¹¦ÄÜ¡£
¹Ø¼ü´Ê£ºMySQL £»¹ÜÀíϵͳ£»JSP
Abstract
This article is in view of actual situation of scientific research project application, the small website design tasks. Its purpose is to make scientific research projects to implement systematic and scientific management, to ensure the successful completion of a research project, achievements, talents, benefit, improve the competitiveness. The operation of the traditional manual recording statistics can not meet the need of practical work, in order to improve the work efficiency, it is necessary for the implementation of computer management. The development and design of the scientific research project management system is a product of this era, the use of computer support management efficiency of scientific research projects completed declaration management. The system includes scientific research personnel management and the scientific research project management.
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
2.ϵͳ·ÖÎö. 2
2.1¿ÉÐÐÐÔ·ÖÎö... 2
2.1.1¾¼ÃÉϵĿÉÐÐÐÔ... 2
2.1.2¼¼ÊõÉϵĿÉÐÐÐÔ... 3
2.1.3²Ù×÷ÉϵĿÉÐÐÐÔ... 3
2.2ϵͳ¹¦ÄÜÐèÇó·ÖÎö... 3
2.2.1¹¦ÄÜÐèÇó... 3
2.2.2ÐÔÄÜÐèÇó... 4
2.3ÒµÎñÁ÷³Ì·ÖÎö... 5
2.4Êý¾ÝÁ÷³Ì·ÖÎö... 6
2.5Êý¾Ý¿âÉè¼Æ.... 7
2.5.1Êý¾Ý¿â¸ÅÄî½á¹¹Éè¼Æ... 7
2.5.2Êý¾Ý¿âÂß¼½á¹¹Éè¼Æ... 9
3.ϵͳÉè¼Æ. 11
3.1ϵͳÌåϵ½á¹¹... 11
3.2 ¿ª·¢Èí¼þ... 12
3.2.1 JSP¼¼Êõ... 12
3.2.2 Tomcat ·þÎñÆ÷... 13
3.2.3 MYSQL. 13
3.2.4 MyEclipse. 15
3.3ϵͳµÄÈíÓ²¼þƽ̨... 16
4.ϵͳ²Ù×÷ʵÏÖ. 16
4.1¹ÜÀí²Ù×÷... 16
4.1.1µÇ½ҳÃæ... 16
4.1.2¹ÜÀíÔ±Õ˺ÅÌí¼ÓÒ³Ãæ... 18
4.1.3¿ÆÑÐÈËÔ±Ìí¼ÓÒ³Ãæ... 19
4.1.4¿ÆÑÐÈËÔ±¹ÜÀíÒ³Ãæ... 21
4.2¿ÆÑÐÈËÔ±²Ù×÷... 23
4.2.1¸öÈË×ÊÁÏÐÞ¸ÄÒ³Ãæ... 23
4.2.2¿ÆÑÐÏîÄ¿Ìí¼ÓÒ³Ãæ... 25
4.2.3ËùÓпÆÑÐÏîÄ¿²é¿´Ò³Ãæ... 27
4.2.4ÉêÇë¼ÓÈëÌí¼ÓÒ³Ãæ... 29
5.Èí¼þ²âÊÔÓë·ÖÎö. 30
5.1ϵͳ²âÊԵĶ¨Òå... 31
5.2ϵͳ²âÊÔµÄÄ¿µÄ¼°ÒâÒå... 31
5.3ϵͳ²âÊÔµÄÖØÒªÐÔ... 31
5.4ϵͳ²âÊԵij£Ó÷½·¨... 32
5.5²âÊÔ»·¾³Óë²âÊÔÌõ¼þ... 33
5.6ϵͳÔËÐÐÇé¿ö... 33
5.7²âÊÔ×ܽá... 33
6.½áÂÛ. 34
6.1ϵͳµÄÌصã.... 34
6.2ϵͳµÄ²»×ãºÍ¸Ä½ø.... 34
6.3Éè¼ÆÊÕ»ñÓëÐĵÃ... 34
Ö л. 36
²Î ¿¼ ÎÄ Ï×. 37