µÚÒ»·¶ÎÄÍø - רҵÎÄÕ·¶ÀýÎĵµ×ÊÁÏ·ÖÏíÆ½Ì¨

±ÏÒµÉè¼ÆOA°ì¹«ÏµÍ³

À´Ô´£ºÓû§·ÖÏí ʱ¼ä£º2025/7/31 18:03:44 ±¾ÎÄÓÉloading ·ÖÏí ÏÂÔØÕâÆªÎĵµÊÖ»ú°æ
˵Ã÷£ºÎÄÕÂÄÚÈݽö¹©Ô¤ÀÀ£¬²¿·ÖÄÚÈÝ¿ÉÄܲ»È«£¬ÐèÒªÍêÕûÎĵµ»òÕßÐèÒª¸´ÖÆÄÚÈÝ£¬ÇëÏÂÔØwordºóʹÓá£ÏÂÔØwordÓÐÎÊÌâÇëÌí¼Ó΢ÐźÅ:xxxxxxx»òQQ£ºxxxxxx ´¦Àí£¨¾¡¿ÉÄܸøÄúÌṩÍêÕûÎĵµ£©£¬¸ÐлÄúµÄÖ§³ÖÓëÁ½⡣

Abstract

With the rapid development of the Internet, the traditional way of paper office fai-ling to meet the modern company needs. However, the application of automatic netw-ork office can make people satisfied.Office automation system can simplify the busines-s operation process fundamentally,and improve the efficiency and quality of enterprise.At the same time,it can save cost and improve the benefit of the enterprises.

This system mainly uses B/S (Browser/server) mode,and using the technique of Ja-va Web.It was designed and implemented can log in and complete the online office n-etwork platform.The main function of the system are employee registration,issued a p-ublic notice,attendance management,leave management,personal information management, and so on. Administrator has some functions,such as posting the announcement,viewin-g employee¡¯s personal information,sign-in information in staff management and carryin-g on processing to the staff leave application. The employee can register,modify perso-nal information,sign in,and applying for a leave operation.

Keywords:B/S mode;office automation OA;Java Web

II

1 ǰÑÔ

1.1 ϵͳ¿ª·¢±³¾°ºÍÒâÒå

µ±½ñÉç»á£¬¹«Ë¾µÄ¹æÄ£ÔÚ²»¶ÏµØÀ©´ó£¬¹«Ë¾µÄÒµÎñ¶îÔÚ²»¶ÏµØÔö¼Ó¡£µ«ÔÚÆóÒµ²»¶Ï·¢Õ¹µÄͬʱ£¬´«Í³µÄÈ˹¤°ì¹«¡¢Ö½Öʰ칫µÄ·½Ê½²»¶ÏµØ±©Â¶³öһЩÎÊÌâ¡£±ÈÈ磺¹«Ë¾µÄÔ±¹¤ÐèÒªÇë¼Ù£¬¾Í±ØÐëÌîдÉêÇë±í²¢½»¸øÁìµ¼£¬¶øÁìµ¼¿ÉÄÜÒòΪÓÐʲ»Ôڰ칫ÊÒ£¬»òÕßÒòΪÆäËûÊÂÎñ²»Äܼ°Ê±½øÐÐÉóÅú£¬ÕâÑù¾Í»áµ¢ÎóÔ±¹¤µÄʱ¼äºÍÆäËû¹¤×÷¡£ÎªÁ˱ÜÃâÖîÈç´ËÀàÊÂÇéµÄ·¢Éú£¬¹«Ë¾ÐèÒª¸ü¼ÓÈËÐÔ»¯¡¢¸ü¼Ó·½±ã¿ì½ÝµÄ°ì¹«×Ô¶¯»¯ÏµÍ³£¬È¥´úÌæ¹ýÈ¥½Ï¸´ÔÓµÍЧµÄÈ˹¤°ì¹«Ä£Ê½¡£

°ì¹«×Ô¶¯»¯ÏµÍ³¾ÍÊÇÒ»¸ö½«ÏÖ´ú°ì¹«Ë¼ÏëºÍ¼ÆËã»ú¡¢ÍøÂ硢ͨѶ¡¢¶àýÌåµÈÏÖ´ú»¯¹¤¾ß¼¯³ÉÔÚÒ»ÆðµÄ°ì¹«Ó¦ÓÃϵͳ¡£Í¨¹ý¼ÆËã»úµÄ´¦Àí£¬Äܹ»½øÒ»²½Ìá¸ß°ì¹«µÄЧÂʺÍÖÊÁ¿£¬Í¬Ê±ÓÖÄܹ»Ëõ¶Ì°ì¹«Ê±¼ä£¬¼õÇáÔ±¹¤°ì¹«Ñ¹Á¦£¬¸ÄÉÆ°ì¹«µÄ»·¾³ºÍÌõ¼þ£¬Ò²Äܹ»Èþö²ßÕßÔÚµÚһʱ¼äµÃµ½×îȨÍþ¡¢×îÓÐЧµÄÐÅÏ¢£¬ÒÔ²úÉúÃ÷ÖǵIJßÂÔ£¬ÎªÆóÒµºÍ¹«Ë¾´øÀ´×î´óµÄÐ§Òæ¡£¶ø×÷ΪһÃû¼ÆËã»úרҵµÄѧÉú£¬Ñо¿Õâһϵͳ²»½öÄܹ®¹ÌºÍÌá¸ßÔÚУËùѧ֪ʶ£¬´ïµ½Ñ§ÒÔÖÂÓ㬸üÄÜΪ½«À´×ßÈëÉç»á´òÏÂÁ¼ºÃµÄ»ù´¡¡£

1.2 ¹úÄÚÍâÑо¿ÏÖ×´

Ŀǰ¹úÍâ°ì¹«×Ô¶¯»¯¼¼ÊõµÄ·¢Õ¹±È½Ï³ÉÊì£¬ÌØ±ðÊÇȺ¼þ²úÆ·£¬ÈçIBM Lotus Notes/Domino ºÍ Microsoft ExchangeµÄ³öÏÖʹ°ì¹«×Ô¶¯»¯Èí¼þµÃµ½Á˹㷺µÄÓ¦Óá£ËüÌṩµÄ¹¤×÷Á÷ƽ̨¼°·Ç½á¹¹»¯Êý¾Ý¿âµÄ¹¦ÄÜʹÎÒÃÇ¿ÉÒԺܷ½±ãµÄʵÏַǽṹ»¯ÎĵµµÄ´¦Àí¡¢È«ÎļìË÷¡¢¹¤×÷Á÷µÈÖØÒªµÄ¹¦ÄÜ¡£Í¬Ê±Lotus Notes»¹ÌṩÁËÓëÆóÒµÒµÎñϵͳµÄÁ¬½Ó·½Ê½£¬Îª¹ÜÀíÈËÔ±ÌṩÁËÒ»¸öͳһµÄ²Ù×÷ƽ̨[1]¡£

½øÈë20ÊÀ¼Í90Äê´úÖÐÆÚÒÔºó£¬ÓÉÓÚ¹úÄÚ¾­¼ÃµÄ·ÉËÙ·¢Õ¹Òý·¢Êг¡¾ºÕùµÄÖð½¥¼¤ÁÒ£¬ÒÔ¼°Õþ¸®¹ÜÀíÖ°ÄܵÄÀ©´óºÍÓÅ»¯£¬ÕâÒ»Çе¼ÖÂÕþ¸®ºÍÆóÒµ¶Ô°ì¹«×Ô¶¯»¯²úÆ·µÄÐèÇó¿ìËÙÔö³¤¡£Õâʱ£¬°ì¹«×Ô¶¯»¯¿ªÊ¼½øÈëÒ»¸ö¿ìËÙ·¢Õ¹µÄ½×¶Î¡£¹úÄÚרÃÅ´ÓÊÂÈí¼þ¿ª·¢µÄ¹«Ë¾Ò²Ö𽥳ɳ¤ÆðÀ´£¬²¢×¨ÃÅΪÕþ¸®ºÍÆóÒµ¶©×ö°ì¹«×Ô¶¯»¯ÏµÍ³¡£ÓÉÓÚÕâЩϵͳÊǸù¾ÝÓû§µÄ¾ßÌåÐèÇ󿪷¢µÄ£¬ËùÒÔÐèÒª¹¦ÄܱȽÏÍêÉÆ£¬²¢ÄܽϺõØÂú×ãÓû§µÄʵ¼ÊÐèÒª¡£µ«ÕâÊÇÒ»¸ö¾Þ´ó¶øµÍЧµÄÊг¡£¬¾ßÌå±íÏÖÔÚͶ×Ê´ó¡¢Ð§¹û²»Ã÷ÏÔ£»Ë®Æ½µÍ¡¢Öظ´½¨Éè¶à£»Ó²¼þͶÈë¶à¡¢Èí¼þͶÈëÉÙ£»Ä£ÄâÊÖ¹¤×÷ÒµÔö¼Ó¹ÜÀí¸ºµ£µÈ¡£ÕâÊÇÒòΪ¿ª·¢ÉÌˮƽ²Î²î²»Æë£¬¿ª·¢¶ÓÎé×é¶Óģʽ²»ºÏÀí¡¢È±·¦¿ª·¢°ì¹«×Ô¶¯»¯²úÆ·µÄ¾­Ñé¡¢Óû§È±·¦¶Ô°ì¹«×Ô¶¯»¯²úÆ·µÄÈÏʶµÈ£»²¿·ÖÈí¼þ²úÆ·ÖÊÁ¿²»¸ß£¬²»¹ËÖйúÆóÒµµÄÔË×÷ÌØµãÕÕ°á¹úÍâ¼¼Êõ£¬Ê¹µÃʵʩÀ§ÄÑ£»¶ÔOAµÄÀí½âÆðµã²»¸ß£¬µ¼ÖÂOAϵͳÓëÆäËûϵͳ¼¯³É¶È²î£»Óû§Ê¹ÓÃˮƽµÍ£¬ÓÖ²»Ô¸»¨Ì«¶àµÄ¾«Á¦Í¶ÈëÅàѵ£»ÊÛºó·þÎñ²»µ½Î»£»¶¨×ö¿ª·¢ÓÖ»áÒòÓû§ÐèÇó±ä»¯Òª¶ÔÈí¼þ½øÐв»¶ÏµÄÐÞ¸Äά»¤¡£µ½×îºó£¬Õû¸öÈí¼þµÄÐÔÄܺͿÉʹÓÃÐÔ¶¼´ó´ó½µµÍ£¬Ã»ÓÐÄÍÐÔµÄÆóÒµË÷ÐÔ·ÏÆúµô´Ó¶øµ¼ÖÂÏîĿʧ°Ü¡£´Ó¼¼ÊõÀ´¿´£¬ÆÕ±é´æÔÚÈçÏÂȱµã£ºÎªÓû§¿¼ÂǵÄÉÙ£¬

1

Èí¼þµÄÈáÐÔ¹¹Ô칦Äܲµ±Ç°ºÜ¶àOAÈí¼þ¹ý·ÖÇ¿µ÷ÁËÈí¼þÖ®¼ä¹¦ÄܵĺáÏò¶Ô±È£¬ÎªÓû§¿¼ÂǵÄʵ¼Ê¹¦ÄܱȽÏÉÙ£¬½á¹ûµ¼ÖÂÈí¼þ´ó¶øÈ«£¬¶øÕæÕýΪÓû§½ÓÊܵŦÄÜÄ£¿éºÜÉÙ¡£ÁíÒ»·½Ã棬Èí¼þµÄÄ£¿é¸´ÓÃÐԺܲֱ½ÓÓ°ÏìÁËÈí¼þµÄÈáÐÔ¹¹Ô칦ÄÜ£¬¶øµ±Óû§µÄÐèÇó¸Ä±äʱ£¬ÄÄÅÂÊÇÇá΢µÄ¸Ä±ä£¬¶¼ÐèÒª¿ª·¢ÉÌÀ´½â¾ö£¬´Ó¶øÓ°ÏìÁËÓû§µÄʹÓÃЧÂÊ£¬¶Ô¿ª·¢ÉÌÒ²ÊÇÒ»¸ö¼«´óµÄ¸ºµ£¡£

1.3 ϵͳ¿ª·¢µÄÈÎÎñ

¶ÔÏîÄ¿¿ª·¢ÈËÔ±À´Ëµ£¬ÔÚÏîÄ¿¿ª·¢¹ý³ÌÖÐÕë¶Ô²»Í¬ÏîĿѡÔñÇ¡µ±µÄÈí¼þÌåϵ½á¹¹·Ç³£ÖØÒª¡£Êʵ±µÄÈí¼þÌåϵ½á¹¹ºÍÈí¼þµÄ°²È«ÐÔ¡¢¿Éά»¤ÐÔµÈÃÜÇÐÏà¹Ø¡£Ä¿Ç°Ö÷ÒªÁ÷ÐеÄÁ½ÖÖÈí¼þÌåϵ½á¹¹ÊÇC/SÌåϵ½á¹¹ºÍB/SÌåϵ½á¹¹£¬ÕâÁ½¸öÊǵ±½ñÊÀ½ç¿ª·¢Ä£Ê½¼¼Êõ¹¹¼ÜµÄÁ½´óÖ÷Á÷¼¼Êõ[2]¡£±¾ÏµÍ³Ö÷Òª²ÉÓÃB/SÌåϵ½á¹¹£¬¸ÃϵͳµÄ¹¦ÄÜÓÐÔ±¹¤×¢²á£¬·¢²¼¹«¸æ£¬Ç©µ½¹ÜÀí£¬Çë¼Ù¹ÜÀí£¬¸öÈËÐÅÏ¢¹ÜÀíµÈ¡£¹ÜÀíÔ±¿ÉÒÔ·¢²¼¹«¸æ£¬²é¿´Ô±¹¤¸öÈËÐÅÏ¢£¬¹ÜÀíÔ±¹¤Ç©µ½ÐÅÏ¢£¬¶ÔÔ±¹¤µÄÇë¼ÙÉêÇë½øÐд¦Àí£»Ô±¹¤¿ÉÒÔ½øÐÐ×¢²á¡¢Ð޸ĸöÈËÐÅÏ¢£¬Ç©µ½ºÍÍËÇ©¡¢ÉêÇëÇë¼ÙµÈ²Ù×÷£»´Ó¶øºÏÀíÓÐЧµØÍê³É¹¤×÷£¬Ìá¸ß¹¤×÷µÄЧÂʺÍÖÊÁ¿¡£

2

2 ϵͳ·ÖÎö

ϵͳ·ÖÎöÊÇÔÚϵͳÉè¼ÆÖ®Ç°£¬Õë¶ÔÕû¸öϵͳ´ÓÐèÇ󡢿ÉÐÐÐÔ¡¢ÏµÍ³²ã´ÎµÈ½Ç¶È£¬ÕÆÎÕÕû¸öϵͳµÄ´óÖ¹¹Ô죬ΪϵͳµÄÉè¼ÆÌṩÓÐÁ¦µÄÀíÂÛÒÀ¾Ý¡£

2.1 ¿ÉÐÐÐÔ·ÖÎö 2.1.1 Êг¡¿ÉÐÐÐÔ

Ëæ×Å»¥ÁªÍø¼°µçÄÔµÄÆÕ¼°£¬ÐÅÏ¢»¯°ì¹«ÒÑÉîÈëÆóÒµÎÄ»¯£¬²ÉÓÃOAϵͳ¿ÉÒÔʵÏÖÎÞÖ½»¯°ì¹«£¬²»½öÄܽÚÔ¼×ÊÔ´£¬¸üÄÜ·½±ã¹ÜÀí£¬Ìá¸ß¹¤×÷ЧÂÊ¡£ÔÚĿǰµÄ¹úÄÚÊг¡»¹Óйã´óǰ¾°¡£

2.1.2 ¾­¼Ã¿ÉÐÐÐÔ

ÆóÒµºÍÕþ¸®²¿ÃÅʹÓð칫ϵͳ×Ô¶¯»¯¶Ô´óÁ¿µÄÊý¾Ý½øÐйÜÀíºÍͳ¼ÆÊ±£¬¿ÉÒÔ´ó´ó¼õÉÙÔÚÈËΪ´¦Àí¸÷ÀàÊý¾Ýʱ²úÉúµÄ´íÎó£¬Ìá¸ßÁËÆóÒµµÄÐ§Òæ¡£Ê¹ÆóÒµµÄ¾ö²ßÕßÓµÓиü¼Ó׼ȷµÄÐÅϢȥ×öÕýÈ·µÄ¾ö²ß£¬Ê¹ÆóÒµ¸ü¼Ó¹æ·¶»¯£¬ÐÅÏ¢»¯ºÍϵͳ»¯¡£

2.1.3 ¼¼Êõ¿ÉÐÐÐÔ

±¾ÏµÍ³Ò³Ãæ·½ÃæJsp±àд£¬·þÎñÆ÷²ÉÓÃservlet±àд£¬²ÉÓÃEclipse×÷Ϊ¿ª·¢¹¤¾ß¡£Í¨¹ýJDBCÁ¬½ÓMySQLÊý¾Ý¿â£¬ÔÚTomcat·þÎñÆ÷ÉÏÔËÐУ¬ÕâЩ¶¼ÊÇÃâ·Ñ¿ªÔ´µÄ¹¤¾ß£¬¶ÔÊý¾ÝµÄ°²È«½¡×³ÓÐÒ»¶¨µÄ±£»¤×÷Óã¬ÇҾ߱¸Ò»¶¨µÄ¿ª·¢ÄÜÁ¦£¬ÊµÏÖ¼òµ¥µÄOA»¹¿É½ÚÔ¼¿ª·¢³É±¾¡£¹Ø¼ü¼¼ÊõÓÐÒÔÏÂËÄÌõ£º

Servlet£ºÊÇÔËÐÐÔÚ·þÎñÆ÷¶Ë£¬ÓÉWeb·þÎñÆ÷¼ÓÔØ£¬ÊǶÀÁ¢ÓÚÆ½Ì¨ºÍЭÒéµÄJavaÓ¦ÓóÌÐò¡£ÔÚÄÚ²¿µÄ»úÖÆÉÏ£¬Ã¿Ò»¸öJsp¶¼ÊDZ»´¦Àí³ÉÒ»¸öServletµÄ¡£Servlet²»ÏÞÖÆÊ¹ÓõÄЭÒ飬Ëüͨ³£Ê¹ÓõÄЭÒéÊÇHTTPЭÒé¡£Servlet¾ßÓÐ¿çÆ½Ì¨ºÍ¿ÉÒÆÖ²ÐÔÇ¿µÈÌØµã£¬Ö÷ÒªÊÇÓÃÓÚ±àд³ÌÐòµÄ´¦ÀíÂß¼­¡£

Jsp£ºJsp(Java Server Pages)ÊÇÓÉSun¹«Ë¾·¢²¼µÄÓÃÓÚ¿ª·¢¶¯Ì¬WebÓ¦ÓõÄÒ»Ïî¼¼Êõ¡£ËüÊÇ»ùÓÚJava ServletµÄWeb¿ª·¢¼¼Êõ£¬ÓÉÓÚ¾ßÓмòµ¥Ò×ѧºÍ¿çƽ̨µÈÌØµã£¬Ê¹Ö®³ÉΪWeb¿ª·¢ÖеÄÊ×Ñ¡[3]¡£

Tomcat£ºTomcatÊÇÒ»¸ö»ùÓÚJavaµÄ¿ª·ÅÔ´ÂëWebÓ¦ÓÃÈÝÆ÷£¬ÊÇApache JakartaÏîÄ¿ÖеÄÒ»¸ö×ÓÏîÄ¿£¬ÓÐApache¡¢Sun¹«Ë¾ºÍÆäËûÈËÔ±¹²Í¬¿ª·¢¡£ËüÓÉÓÚ¼¼ÊõÏȽø£¬Õ¼ÓÃ×ÊÔ´ÉÙ£¬Îȶ¨ÐԺã¬ÇÒÒ×ÓÚÀ©Õ¹µÈµÄÌØµã£¬Í¬Ê±ÓÖÊÇ¿ªÔ´µÄ£¬ËùÒÔʹµÃËü±¸ÊܳÌÐòÔ±µÄϲ°®¡£TomcatÊÇÍêȫʹÓÃJavaÓïÑÔ¿ª·¢ÊµÏֵģ¬Òò´ËËüÓëÔÚÄĸöƽ̨Î޹أ¬¼´¿ÉÒÔͨ¹ýÔÚ²»Í¬µÄ²Ù×÷ϵͳÉϰ²×°JVMʵÏÖ¿çÆ½Ì¨[4]¡£

MySQL£ºMySQLÊÇÒ»¸öСÐ͹ØÏµÊý¾Ý¿â¹ÜÀíϵͳ£¬Ò²ÊÇ×îÖøÃûµÄ¿ª·ÅÔ´ÂëÊý¾Ý¿â¹ÜÀíϵͳ£¬ËüʹÓýṹ»¯²éѯÓïÑÔ½øÐÐÊý¾Ý¿âµÄ¹ÜÀíºÍ²Ù×÷¡£MySQLÊÇÓÉMySQLABÑз¢¡¢·¢²¼ºÍÖ§³Ö£¬ºó±»SUN¹«Ë¾ÊÕ¹º£¬ËüʹÓÃCºÍC++Á½ÖÖÓïÑÔ±àд£¬¶¼¿ÉÒÔ¹¤×÷ÓÚ²»Í¬µÄƽ̨֮ÉÏ¡£MySQLºÍÆäËûµÄ´óÐ͵ĹØÏµÊý¾Ý¿â(ÈçOracle£¬SQL ServerµÈ)Ïà±È£¬

3

ËÑË÷¸ü¶à¹ØÓÚ£º ±ÏÒµÉè¼ÆOA°ì¹«ÏµÍ³ µÄÎĵµ
±ÏÒµÉè¼ÆOA°ì¹«ÏµÍ³.doc ½«±¾ÎĵÄWordÎĵµÏÂÔØµ½µçÄÔ£¬·½±ã¸´ÖÆ¡¢±à¼­¡¢ÊղغʹòÓ¡
±¾ÎÄÁ´½Ó£ºhttps://www.diyifanwen.net/c4hkiq0uibu8wrp7237ux_2.html£¨×ªÔØÇë×¢Ã÷ÎÄÕÂÀ´Ô´£©
ÈÈÃÅÍÆ¼ö
Copyright © 2012-2023 µÚÒ»·¶ÎÄÍø °æÈ¨ËùÓÐ ÃâÔðÉùÃ÷ | ÁªÏµÎÒÃÇ
ÉùÃ÷ :±¾ÍøÕ¾×ðÖØ²¢±£»¤ÖªÊ¶²úȨ£¬¸ù¾Ý¡¶ÐÅÏ¢ÍøÂç´«²¥È¨±£»¤ÌõÀý¡·£¬Èç¹ûÎÒÃÇ×ªÔØµÄ×÷Æ·ÇÖ·¸ÁËÄúµÄȨÀû,ÇëÔÚÒ»¸öÔÂÄÚ֪ͨÎÒÃÇ£¬ÎÒÃǻἰʱɾ³ý¡£
¿Í·þQQ£ºxxxxxx ÓÊÏ䣺xxxxxx@qq.com
ÓåICP±¸2023013149ºÅ
Top