ÕªÒª
Ëæ׿ÆËã»ú¼°ÍøÂç¼¼ÊõµÄ·ÉËÙ·¢Õ¹£¬InternetÓ¦ÓÃÔÚÈ«Çò·¶Î§ÄÚÈÕÒæÆÕ¼°£¬µ±½ñÉç»áÕý¿ìËÙÏòÐÅÏ¢»¯Éç»áÇ°½ø£¬ÐÅÏ¢×Ô¶¯»¯µÄ×÷ÓÃÒ²Ô½À´Ô½´ó¡£´Ó¶øʹÎÒÃÇ´Ó·±ÔÓµÄÊÂÎñÖнâ·Å³öÀ´£¬Ìá¸ßÁËÎÒÃǵŤ×÷ЧÂÊ¡£
ÔÚ»¥ÁªÍøÔ½À´Ô½ÆÕ¼°µÄ½ñÌ죬ÐÅÏ¢ÔÚÈËÃǵÄÈÕ³£Éú»îÖÐÕ¼¾ÝÁ˷dz£ÖØÒªµÄµØλ£¬Ñ§Éú²©¿Í¹ÜÀíϵͳÊÇ»ùÓÚJAVAºÍSQL ServerµÄÒ»ÖÖÔÚInternetÉϹ«¿ª·¢²¼µÄ¿ìËÙ¸üеÄѧÉúÐÅÏ¢µÄÍøվϵͳ£¬Ê¹ÓÃÕß¿ÉÒÔ¼òµ¥¿ìËÙµØÍê³ÉѧÉú²©¿Í¹ÜÀíµÄ´´½¨¡¢·¢²¼ºÍ¸üУ¬ÊÇÒ»¸ö·½±ãµÄ¹©¹ã´óѧÉúÓû§Ï໥½»Á÷µÄƽ̨¡£±¾ÎÄÖ÷ÒªÑо¿¶àÓû§ÏµÍ³£¬Ö÷Òª°üÀ¨Óû§×¢²áµÇ¼¡¢Ç°Ì¨ä¯ÀÀ¡¢ÆÀÂÛ²©¿Í¹¦ÄÜ£¬ºǫ́·¢±í²©¿ÍµÄ¹¦ÄÜ¡¢Ïà¹ØµÄ¹ÜÀí¹¦ÄܺÍÐÞ¸ÄÕË»§ÐÅÏ¢µÈ¹¦ÄÜ¡£±¾ÎÄÖ÷Òª½éÉÜÁ˸ÃϵͳµÄ»ù±¾¹¦Äܼ°¾ßÌåÉè¼ÆʵÏÖ·½·¨£ºÏµÍ³·ÖÎöÖÐϵͳµÄ½á¹¹Í¼·ÖÎöÁËϵͳ¸÷Ä£¿éµÄ¹¦ÄÜ£»ÔÚϵͳÉè¼ÆÖУ¬ÏêϸµØÕ¹ÏÖÁËϵͳ¸÷¸ö¹¦ÄÜÄ£¿éµÄÉè¼Æ˼·µÈ¡£
¹Ø¼ü´Ê£º²©¿Í¹ÜÀíϵͳ£»JAVA£»SQL
Abstract
Along with the computer and network technology, the rapid development of Internet application and popularization in the global scope, the society is quick to information society, the function of information automation. So we from multifarious affairs liberates, improve our work efficiency.
The Internet is becoming more and more popular in the information in People's Daily life occupied a very important position, the student diary management system is based on JAVA and SQL Server on a kind of Internet public information quickly update students website system, user can simply and quickly complete student log management of creation, release and update, is a convenient for students to user communication platform. This paper mainly studies multi-user system, including registered user login, browse, comments log function, the function, the background Posting relevant management function and modify the account information, etc. This paper introduces the basic function of the system and the specific design method in the analysis of the system, system structure analysis of each module in the system function, In the system design, system function module design, etc.
Keywords: log management system, JAVA, SQL
Ŀ ¼
IµÚ1ÕÂ. Ð÷ÂÛ 1
1.1¸ÅÊö 1
1.2Éè¼Æ±³¾° 1
1.3 Éè¼ÆÒâÒå 2
1.4Éè¼Æ·½·¨ 2
µÚ2ÕÂ. ÀíÂÛ×ÛÊö 3
2.1 JSP¼¼Êõ¼ò½é 3
2.2 JSP¹¤×÷ÔÀí 3
2.3 JSPÌåϵ½á¹¹ 3
2.4 JSPµÄÌصã 4
2.5ϵͳÊý¾Ý¿âÁ¬½Ó 5
2.6 SQL Server¼ò½é 8
2.7 ¡°½á¹¹»¯²éѯÓïÑÔ¡±£¨SQL£©¼ò½é 8
2.8 BSģʽÓëC/SģʽµÄ±È½Ï·ÖÎö 9
2.9 JDBC½éÉÜ 10
µÚ3Õ ϵͳ·ÖÎö 12
3.1 ¿ÉÐÐÐÔ·ÖÎö 12
3.1.1 ¼¼Êõ¿ÉÐÐÐÔ 12
3.1.2 ²Ù×÷¿ÉÐÐÐÔ 12
3.1.3 ·¨ÂÉ·½Ãæ¿ÉÐÐÐÔ 12
3.1.4 ·ÖÎö½áÂÛ 13
3.2 µ÷²éÑо¿ 13
3.2.1ÌṩÓû§×¢²á 13
3.2.2¡¡Óû§Î¬»¤¸öÈË»ù±¾ÐÅÏ¢ 13
3.2.3¡¡²©¿ÍºÍÆÀÂÛ¹ÜÀí 13
3.2.4¡¡ÆÕͨÓû§ÐèÇó 13
3.2.5¡¡¹ÜÀíÔ±ÐèÇó 13
3.3 ϵͳ¹¦ÄÜÁ÷³Ìͼ 14
3.4×éÖ¯½á¹¹ 14
3.5ϵͳģ¿é»®·Ö 15
3.6ϵͳ¹¦ÄÜÉè¼Æ 16
3.7 ²Ù×÷Á÷³Ì 17
3.8 »·¾³ÅäÖà 17
3.8.1Ó²¼þÌõ¼þ 17
3.8.2 Èí¼þÌõ¼þ 17
µÚ4Õ ×ÜÌåÉè¼Æ 18
4.1Ä£¿é»®·Ö 18
4.2¹¦ÄÜÄ£¿é³õ²½Éè¼Æ 18
4.2.1×¢²áÓû§Ä£¿é 18
4.2.2ÆÕͨÓû§Ä£¿é 18
4.2.3¹ÜÀíԱģ¿é 19
4.3¹¦ÄÜÄ£¿é½á¹¹Í¼ 19
»ùÓÚÍøÕ¾µÄÐèÇ󣬸ù¾Ý¹¦ÄÜÄ£¿éµÄ³õ²½Éè¼Æ£¬Éè¼ÆÁËÍøÕ¾¸÷¹¦ÄܵŦÄÜͼ 19
4.3.1¡¡×¢²áÓû§Ä£¿é 19
4.3.2¡¡ÓοͷÃÎÊÄ£¿é 20
4.3.3¡¡¹ÜÀíԱģ¿é 20
4.4ÏêϸÃèÊöÓÃÀý 21
4.5 ϵͳÊý¾ÝÁ÷ͼ 23
4.6ϵͳÊý¾ÝÄ£ÐÍÉè¼Æ 24
µÚ5Õ ϵͳʵÏÖ 27
5£®1³£ÓòÙ×÷˵Ã÷ 27
5.2Ö÷Ò³ 27
5.3ϵͳµÇ½ 27
5.4Óû§¹¦ÄܽçÃæÉè¼Æ 28
5.4.1Ìí¼ÓÏàƬ 29
5.4.2 Ð޸ĸöÈË»ù±¾ÐÅÏ¢ 29
5.4.3 ·¢²¼²©ÎÄ 30
5.4.4 ¹ÜÀí²©¿Í 30
5.4.5·¢±í²©¿ÍÆÀÂÛ 31
5.5¹ÜÀíÔ±½çÃæÉè¼Æ 32
5.5.1 ¹ÜÀíÔ±µÇ¼½çÃæ 32
5.5.2 ¹ÜÀíÖ÷½çÃæ 32
µÚ6Õ ²âÊÔ 35
6.1 ²âÊÔµÄÈÎÎñ¼°Ä¿±ê 35
6.1.1 ²âÊÔµÄÈÎÎñ 35
6.1.2 ²âÊÔµÄÄ¿±ê 35
6.2 ²âÊÔ·½°¸ 35
6.3 ²âÊÔÓÃÀý 35
6.3.1 »áÔ±µÇ¼²âÊÔ 35
6.3.2¹ÜÀíÔ±µÇ¼²âÊÔ 36
½á ÂÛ 38
²Î¿¼ÎÄÏ× 39
ÖÂл 40
µÚÒ»Õ Ð÷ÂÛ
ѧÉú²©¿Í¹ÜÀíϵͳÊÇÒ»ÖÖÊ®·Ö¼òÒ×µÄɵ¹Ïʽ¸öÈËÐÅÏ¢·¢²¼·½Ê½£¬ÈÃÈκÎÈ˶¼¿ÉÒÔÏñÃâ·Ñµç×ÓÓʼþµÄ×¢²á¡¢ÊéдºÍ·¢ËÍÒ»Ñù£¬¼òµ¥¿ìËÙµØÍê³É¸öÈ˲©¿ÍµÄ´´½¨¡¢·¢²¼ºÍ¸üУ¬Óû§¿ÉÒÔͨ¹ý¸Ãϵͳ·¢²¼²©ÎÄ¡¢Í¼Æ¬µÈ¸÷ÖÖÐÅÏ¢£¬ÊÇÒ»¸ö·½±ãµÄ¹©¹ã´óѧÉúÓû§Ï໥½»Á÷µÄƽ̨¡£
Ò»°ãÒ»¸ö²©¿Íϵͳ¾ÍÊÇÒ»¸öÒ³Ã棬Ëüͨ³£Óɼò¶Ì¶ø¾³£¸üеIJ©¿Í²©¿Í¹¹³É£¬ËùÓв©¿Í¶¼ÊÇ°´ÕÕÈÕÆÚÅÅÁУ¬ÏÖÔÚÁ÷ÐеIJ©¿Í¹ÜÀíϵͳ¾ÍÊDz©¿ÍϵͳµÄ¾ßÌå±íÏÖ¡£¿´ÉÏȥƽµÎÞÆ棬ºÁÎÞ¿ÉìÅÒ«Ö®´¦£¬µ«Ëü¿ÉÒÔÈÃÿ¸öÈËÁã³É±¾µØ´´½¨×Ô¼ºµÄÍøÂçýÌ壬ÿ¸öÈ˶¼¿ÉÒÔËæʱ°Ñ×Ô¼ºµÄÏë·¨ºÍÁé¸ÐÔÚ²©¿ÍϵͳվµãÉϸüС£ËüµÄÈËÐÔ»¯ºÍƽÃñÊÓ½ÇʹµÃËüÌṩµÄÏûÏ¢¸üÌù½üÈËÃǵÄÉú»î£¬¶øÇÒËüËѼ¯µÄÐÂÎÅ×ÊÁÏ´ó¶àÊǵÚÒ»ÊÖ×ÊÁÏ¡£¼òÑÔÖ®£¬¸Ãϵͳ¾ßÓÐÓѺõÄÓû§½çÃæ¡¢¼òµ¥Ò׶®µÄ²Ù×÷·½Ê½¡¢Ç¿´óµÄ¹¦ÄÜ£¬Óй㷺µÄÓ¦ÓÿռäºÍÎ޿ɱÈÄâµÄ¼ÛÖµ¡£