ÕªÒª
°ì¹«×Ô¶¯»¯£¬Ó¢ÎÄ Office Automation£¬¼ò³ÆOA£¬Êǰ칫ÐÅÏ¢´¦ÀíµÄ×Ô¶¯»¯£¬ËüÀûÓÃÏȽøµÄ¼¼Êõ£¬Ê¹È˵ĸ÷Öְ칫ҵÎñ»î¶¯Öð²½Óɸ÷ÖÖÉ豸¡¢¸÷ÖÖÈË»úÐÅϢϵͳÀ´ÐÖúÍê³É£¬´ïµ½³ä·ÖÀûÓÃÐÅÏ¢£¬Ìá¸ß¹¤×÷ЧÂʺ͹¤×÷ÖÊÁ¿£¬Ìá¸ßÉú²úÂʵÄÄ¿µÄ¡£
ò¡ÌؼÆËã»ú¿Æ¼¼¹«Ë¾ÍøÕ¾µÄ°ì¹«×Ô¶¯»¯ÏµÍ³£¬»ùÓÚ¹«Ë¾±¾ÉíÄÚ²¿¹ÜÀí¼°ÒµÎñ·¢Õ¹ÐèÇó£¬Ó¦ÓüÆËã»ú¼¼Êõ£¬Internet¼¼Êõ£¬ÊµÏÖÆóÒµ°ì¹«×Ô¶¯»¯£¬¹ÜÀíÐÅÏ¢»¯¡£±¾ÏµÍ³²ÉÓýṹ»¯ÓëÔÐÍ·¨½áºÏµÄϵͳ¿ª·¢·½·¨¡£Õû¸öϵͳ·ÖΪϵͳÕûÌåÉè¼Æ¼°Óû§Éí·ÝÑé֤ģ¿é£¬Ô±¹¤ÐÅÏ¢¹ÜÀíÄ£¿é£¬²ÆÎñÐÅÏ¢¹ÜÀíÄ£¿é£¬Ô±¹¤ÐÅÏ¢½»Á÷Ä£¿éµÈ¡£ÏµÍ³¿ª·¢²ÉÓÃÏȽøµÄ¿ª·¢Èí¼þÓë¼¼Êõ£¬¼´²ÉÓÃDream weaverÒ³ÃæÖÆ×÷Èí¼þÓëPhotoshopµÈ¼¼ÊõÏà½áºÏ¿ª·¢ÏµÍ³µÄÒ³Ã棬ÓÃJSP¶¯Ì¬Ò³ÃæÉè¼Æ¼¼ÊõÓëJava Bean¼¼ÊõÒÔ¼°FlashʵÏÖϵͳµÄ¶¯Ì¬½»»¥¹¦ÄÜ£¬SQL Server 2000Êý¾Ý¿â¹ÜÀíϵͳ¿ª·¢Ç¿´óÍêÉƵÄÊý¾Ý¿âÖ§³Ö»·¾³¡£
±¾ÎÄΧÈÆò¡Ìع«Ë¾°ì¹«×Ô¶¯»¯ÏµÍ³µÄ¹æ»®ºÍÓû§Éí·ÝÑé֤ģ¿é¼°Ô±¹¤ÐÅÏ¢¹ÜÀíÄ£¿éµÄÉè¼ÆÓëʵÏÖÕ¹¿ª£ºµÚÒ»ÕÂΪÐ÷ÂÛ£¬½éÉÜ°ì»á×Ô¶¯»¯ÏµÍ³µÄ±³¾°£¬ÂÛÎĵÄÑо¿ÄÚÈݼ°ÏµÍ³µÄ¿ÉÐÐÐÔ·ÖÎö¡£µÚ¶þÕÂÃèÊöÁËÕû¸öϵͳ¼°Óû§Éí·ÝÑé֤ģ¿éÔ±¹¤ÐÅÏ¢¹ÜÀíÄ£¿éµÄ¿ª·¢¹¤¾ß¡£µÚÈýÕÂ˵Ã÷ÁËϵͳÐèÇó·ÖÎö£»µÚËÄÕÂ˵Ã÷ÁËϵͳµÄÏêϸÉè¼Æ¡£µÚÎåÕÂΪϵͳµÄ¿ª·¢ÊµÏÖ¡£µÚÁùÕÂΪϵͳ²âÊÔ¼°¿ª·¢×ܽᡣÎÄÕÂÄÚÈݳäʵ£¬Í¼ÎIJ¢Ã¯¡£
¹Ø¼ü×Ö£º°ì¹«×Ô¶¯»¯ Ô±¹¤ÐÅÏ¢ JSP Êý¾Ý¿â
Abstract
Office automation , English Office Automation, abbreviated as OA, the automation of information processing that work , it utilizes advanced technology, makes various official working operational activities of people's help to finish by various apparatus , various man-machine information systems progressively , reach and fully utilize information, improve working efficiency and work quality , the purpose to boost Productivity .
The office automated systems of the websites of training school of the auspicious open scientific and technological computer, based on auspicious open scientific and technological computer training school internal management and business develop the demand, employ the computer technology, Internet technology, realizes enterprise's office automation , manage the information. This system adopts the systematic development approach that structurize combines with prototype law. Whole system divide into system global design and custom status validate module, employee information administer module, financial information administer module, employee information communication module and so on. System develops, adopt advanced development software and technology, and adopt Dream weaver page animation software and Photo shopped. technology combine together and develop the systematic page, use JSP dynamic page designing technique and Java Bean technology and mutual function of trends of Flash implementation system, SQL Server 2000 data base management system develops the strong and complete database and supports the environment.
This text is around the planning of the office automated system and design and realizing expansion of public custom status validate module and employee information administer module: Chapter one is the introduction, recommend that can do the background of the automated system£¬the research contents of the thesis and systematic feasibility analysis. Chapter two has described and worked in whole system and custom status validate and employee information administer the developing instrument of the module. Chapter three has explained requirement analysis; Chapter four introduces system design of the module in detail. Chapter five has in order to realize some systematically. Sixth develop, summarize for system testing. The article is rich in content; both pictures and texts are excellent.
Key word: Office automation employee information JSP Databas
Ŀ¼
ÕªÒª I
ABSTRACT II
Ŀ¼ IV
µÚ1Õ Ð÷ ÂÛ 1
1.1 ¿ÎÌâ±³¾° 1
1.1.1 °ì¹«×Ô¶¯»¯¸ÅÊö 1
1.1.2 ò¡ÌؼÆËã»ú¿Æ¼¼¹«Ë¾°ì¹«Ä£Ê½µÄÏÖ×´ 2
1.2 ÂÛÎĵÄÑо¿ÄÚÈÝ 3
1.2.1 ò¡Ìع«Ë¾°ì¹«ÐÅÏ¢¹ÜÀíϵͳ¸ÅÊö 3
1.2.2 Óû§Éí·ÝÑé֤ģ¿é¸ÅÊö 4
1.2.3 Ô±¹¤ÐÅÏ¢¹ÜÀíÄ£¿é¸ÅÊö 4
1.2.4 ²ÆÎñÐÅÏ¢¹ÜÀíÄ£¿é¸ÅÊö 5
1.2.5 ÄÚ²¿ÐÅÏ¢½»Á÷Ä£¿é¸ÅÊö 5
1.2.6 ϵͳ¼¼ÊõÒªÇó¼°¿ÉÐÐÐÔ 5
1.3 ÂÛÎĵÄ×éÖ¯½á¹¹ 6
µÚ2Õ ò¡Ìع«Ë¾°ì¹«ÐÅÏ¢¹ÜÀíϵͳÐèÇó·ÖÎö 7
2.1 ϵͳ¸ÅÊö 7
2.1.1 Éè¼ÆÄ¿±ê 7
2.1.2 ϵͳÌصã 7
2.2 ϵͳÔËÐеĻ·¾³ 8
2.2.1 É豸ҪÇó 8
2.2.2 Ö§³ÅÈí¼þ 9
2.3 ϵͳµÄÓÃÀýÉè¼Æ 9
2.3.1ϵͳÓÃÀýͼ 9
2.3.2 Óû§Éí·ÝÑéÖ¤×ÓϵͳÓÃÀýͼ 10
2.3.3Ô±¹¤ÐÅÏ¢¹ÜÀí×ÓϵͳÓÃÀýͼ 11
2.3.4 ²ÆÎñÐÅÏ¢¹ÜÀí×ÓϵͳÓÃÀýͼ 12
2.3.5 ÄÚ²¿ÐÅÏ¢½»Á÷×ÓϵͳÓÃÀýͼ 13
2.4 ÐèÇó¹æ¸ñ 14
2.4.1怫 14
2.4.2Ìí¼ÓÓû§ 15
2.4.3ɾ³ýÓû§ 15
2.4.4²é¿´Ô±¹¤ÐÅÏ¢ 15
2.4.5²é¿´²¿ÃžÀíÐÅÏ¢ 15
2.4.6Ð޸ĸöÈËÐÅÏ¢ 15
2.4.7ÐÞ¸ÄËùÓÐÈËÐÅÏ¢ 15
2.4.8ä¯ÀÀ¸öÈ˱¨±í 15
2.4.9Ìí¼Ó±¨±í 16
2.4.10Ð޸ı¨±í 16
2.4.11ɾ³ý±¨±í 16
2.4.12²éѯ±¨±í 16
2.4.13²éѯËùÓб¨±í 16
2.4.14ä¯ÀÀ²¿Ãű¨±í 16
2.4.15 ²é¿´ÄÚ²¿ÐÅÏ¢ 16
2.4.16 ·¢ËÍÄÚ²¿ÐÅÏ¢ 17
µÚ3Õ ϵͳÉè¼Æ 18
3.1 ϵͳÉè¼Æ 18
3.1.1Óû§Éí·ÝÑé֤ģ¿é·ÖÎö 19
3.1.2 Ô±¹¤ÐÅÏ¢¹ÜÀíÄ£¿é·ÖÎö 20
3.1.3 ²ÆÎñÐÅÏ¢¹ÜÀíÄ£¿é·ÖÎö 22
3.1.4 ÄÚ²¿ÐÅÏ¢½»Á÷Ä£¿é·ÖÎö 24
3.2 Éè¼Æ¼¼ÊõÓ뿪·¢»·¾³ 26
3.2.1 Éè¼Æ¼¼Êõ 26
3.3 ϵͳÊý¾Ý¿âÉè¼Æ 27
3.3.1 Êý¾Ý¿â½á¹¹Éè¼Æ 28
3.3.2 Êý¾Ý¿âÂß¼Éè¼Æ 28
3.3.3 Êý¾Ý¿âÎïÀíÉè¼Æ 31
µÚ4Õ ϵͳʵÏÖ 35
4.1 µÇ½-¹¦ÄÜÉè¼ÆÃèÊö(LOGIN.JSP) 35
4.2 ϵͳÖ÷Ò³Ãæ(HOME.JSP) 36
4.3 ¹«Ë¾Ô±¹¤ÐÅÏ¢¹ÜÀí×Óϵͳ 37
4.3.1 Ô±¹¤ÐÅÏ¢¹ÜÀí×ÓϵͳÖ÷Ò³Ã棨employeeinformation.jsp£© 37
4.3.2 Ð޸ĸöÈËÐÅÏ¢Ò³Ã棨modifypersonalinformation.jsp£© 39
4.3.3 ϵͳ¹ÜÀíÔ±¹ÜÀíÒ³Ã棨systemmanager.jsp£© 41
4.3.4 Ìí¼ÓÐÂÓû§Ò³Ã棨addnewuser.jsp£© 42
4.4 ¹«Ë¾²ÆÎñÐÅÏ¢¹ÜÀí×Óϵͳ 43
4.4.1Ìí¼ÓвÆÎñÐÅÏ¢¼Ç¼ҳÃ棨addfinancialrecord.jsp£© 44
4.4.2 Ìí¼ÓвÆÎñÏîÄ¿¼Ç¼ҳÃ棨addfinancilalrecord.jsp£© 45
4.4.3 Éú³É²ÆÎñÐÅÏ¢±¨±íÒ³Ã棨financialreport.jsp£© 46
4.4.4 Ð޸IJÆÎñÐÅÏ¢±¨±íÒ³Ã棨modifyfinancialrecord.jsp£© 48
4.5 ¹«Ë¾ÄÚ²¿ÐÅÏ¢½»Á÷ϵͳ 49
4.5.1 ÄÚ²¿Í¨Öª¹«¸æÅÆ£¨messagboard.jsp£© 49
µÚ5Õ ϵͳ²âÊÔ½á¹û 51
5.1 ²âÊԼƻ® 51
5.2 ²âÊÔÓÃÀý 51
5.2.1 ¶ÔÓû§Éí·ÝÑéÖ¤¹¦ÄܽøÐвâÊÔ 51
5.2.2 ¶ÔÔ±¹¤ÐÅÏ¢¹ÜÀí¹¦ÄܽøÐвâÊÔ 51
5.2.3 ¶Ô²ÆÎñÐÅÏ¢¹¦ÄܽøÐвâÊÔ 52
5.3 ²âÊÔ½á¹û 52
µÚ6Õ ϵͳ¿ª·¢×ܽá 54
6.1 ϵͳ´æÔÚµÄÎÊÌâ 54
6.3 δÀ´Õ¹Íû 54
6.4½áÊøÓï 55
Ö л 56
²Î¿¼ÎÄÏ× 57
ÍâÎÄÎÄÏ×ÔĶÁÓë·Òë 58
Ó¢ÎÄ·Òë 63
µÚ1Õ Ð÷ ÂÛ
1.1 ¿ÎÌâ±³¾°
1.1.1 °ì¹«×Ô¶¯»¯¸ÅÊö
°ì¹«×Ô¶¯»¯£¬Ó¢ÎÄOffice Automation£¬¼ò³ÆOA£¬Êǰ칫ÐÅÏ¢´¦ÀíµÄ×Ô¶¯»¯£¬ËüÀûÓÃÏȽøµÄ¼¼Êõ£¬Ê¹È˵ĸ÷Öְ칫ҵÎñ»î¶¯Öð²½Óɸ÷ÖÖÉ豸¡¢¸÷ÖÖÈË¡¢»úÐÅϢϵͳÀ´ÐÖúÍê³É£¬´ïµ½³ä·ÖÀûÓÃÐÅÏ¢£¬Ìá¸ß¹¤×÷ЧÂʺ͹¤×÷ÖÊÁ¿£¬Ìá¸ßÉú²úÂʵÄÄ¿µÄ¡£
°ì¹«×Ô¶¯»¯ÓÉ70Äê´úδ80Äê´ú³õÔÚÎÒ¹úµÄÌá³ö£¬µ½ÏÖÔÚÒÑÓÐÁ˽ü¶þÊ®Äê·¢Õ¹ÀúÊ·¡£ÓÉÓڰ칫×Ô¶¯»¯¼¼ÊõµÄ²»¶Ï·¢Õ¹£¬°ì¹«×Ô¶¯»¯Ð²úÆ·²»¶ÏµÄ³öÏÖ£¬°ì¹«×Ô¶¯»¯µÄÄÚºÒ²²»¶ÏµØ·á¸»ºÍ·¢Õ¹¡£