Õª Òª
ÔÚ¶þʮһÊÀ¼Í£¬µØÇòÒòΪ»¥ÁªÍøµÄ´æÔÚ£¬ÔçÒѱä³ÉÒ»¸ö´åÂä¡£ÈËÃÇÔÚ»¥ÁªÍøÊÀ½çÀﾡÇéµÄåÛÓΣ¬ÏíÊÜ×ÅInternet´øÀ´µÄÎÞÏÞÀÖȤ¡£ÎÒÃÇÏ°¹ßÁËÉÏÍø¿´ÐÂÎÅ¡¢È¥ÂÛ̳¿´Ìû¡¢ÍøÉϹºÎ׫д×Ô¼ºµÄÍøÂçÈÕÖ¾µÈµÈ¡£µ±È»£¬×îÀë²»¿ªµÄ£¬»¹ÊǸ÷ÖÖËÑË÷ÒýÇ棬°ïÎÒÃÇÕÒµ½ÏëÒªµÄÐÅÏ¢¡£×ÜÖ®£¬»¥ÁªÍøÒѾ­³ÉΪÎÒÃǵÄÒ»ÖÖÉú»î·½Ê½£¬Ò»¸ö¾Þ´óµÄ֪ʶ¿â¡£
Ëæ׿ÆËã»ú¼¼ÊõµÄ·ÉËÙ·¢Õ¹ºÍ¼ÆËã»úÔÚÆóÒµ¹ÜÀíÓ¦ÓÃÖеÄÆÕ¼°£¬ÀûÓüÆËã»úʵÏÖÆóÒµÈËÁ¦×ÊÔ´¹ÜÀíÊÆÔÚ±ØÐС£¶ÔÆóÒµÈËÁ¦×ÊÔ´¹ÜÀíϵͳµÄ»ý¼«Ê¹ÓÃÊÇʹÏÖ´ú»¯ÆóÒµÔÚ¾ºÕùÖÐÁ¢ÓÚ²»°ÜÖ®µØµÄ±ØÒªÌõ¼þ¡£ÈËÁ¦×ÊÔ´¹ÜÀíϵͳ¶ÔÓÚÆóÒµµ¥Î»µÄ¹ÜÀíÕßÀ´Ëµ£¬¾ßÓÐʹÓ÷½±ã¡¢²éѯ¿ì½Ý¡¢¹ÜÀí׼ȷµÈÌص㣬³ÉΪÆóÒµµ¥Î»²»¿ÉȱÉٵIJ¿·Ö¡£±¾ÎÄÂÛÊöÁË»ùÓÚJSPģʽµÄÈËÁ¦×ÊÔ´¹ÜÀíϵͳµÄÉè¼ÆÓëʵÏÖµÄÈ«²¿¹ý³Ì¡£ÔÚÏÖ´ú»¯µÄ½ÌÓý¼¼ÊõģʽÏ£¬¼ÆËã»úÒѾ­¹ã·ºÓ¦ÓÃÓÚÆóÒµµÄÈËÁ¦×ÊÔ´¹ÜÀí£¬¸ø´«Í³µÄÈËÁ¦×ÊÔ´¹ÜÀí·½Ê½´øÀ´ÁËÖØ´óµÄ¸ïÃü¡£ÈçºÎÓÐЧ½øÐÐÈËÁ¦×ÊÔ´¹ÜÀíÊÇ°ÚÔÚÎÒÃÇÃæÇ°µÄÒ»¸öеĿÎÌâ¡£±¾ÎÄÔÚÑо¿Ä¿Ç°¸÷¸öÆóÒµÈËÁ¦×ÊÔ´¹ÜÀíÇé¿öµÄ»ù´¡ÉÏ£¬´ÓÆóÒµµÄʵ¼ÊÐèÇó³ö·¢£¬²ÉÓõ±Ç°½ÏΪÁ÷ÐеÄB/S£¨ä¯ÀÀÆ÷/·þÎñÆ÷£©½á¹¹ºÍJSP¶¯Ì¬ÍøÒ³¿ª·¢¼¼Êõ£¬»ùÓÚWindowsX²Ù×÷ϵͳºÍSQLÊý¾Ý¿â£¬Éè¼Æ²¢ÊµÏÖÁËÒ»¸ö¹¦ÄܽÏΪÍêÉƵÄСÐÍÆóÒµ¹ÜÀíϵͳ¡£Í¨¹ý¶Ôϵͳ½øÐÐһϵÁеÄÐèÇó·ÖÎö¡¢Éè¼Æ¡¢±àÂë¡¢²âÊԵȹ¤×÷£¬Ê¹ÏµÍ³ÊµÏÖÁ˶ÔÆóÒµÔ±¹¤ÐÅÏ¢µÄ²é¿´£¬Ìí¼Ó£¬Ð޸ģ¬É¾³ý£¬ÒÔ¼°ËÑË÷µÄ¹¦ÄÜ¡£Öصã¶ÔϵͳÉè¼Æ¹ý³Ì×÷ÁËÏàÓ¦ÃèÊö£¬Í¬Ê±Ò²¶ÔϵͳÐèÒª¸Ä½øµÄµØ·½×öÁË×ܽᡣ±¾ÏµÍ³¾­¹ý²âÊÔ£¬ÔËÐÐЧ¹ûÎȶ¨£¬²Ù×÷·½±ã£¬¿ì½Ý£¬ÊÊÓÃÓÚÒ»°ãÆóÒµµÄÈËÁ¦×ÊÔ´¹ÜÀíÒªÇó¡£
 
¹Ø¼ü´Ê£ºJSP£¬ÈËÁ¦×ÊÔ´¹ÜÀí£¬SQLÊý¾Ý¿â

Abstract
In the 21th, because the presence of the Internet. People traveling around in Internet world, and enjoy themselves in it. We used to watch news, browse topics in web forum, write our blog and so on. In a word, Internet turns to a type of our life style, a huge repository.
As computer technology developing and computer employed in management has widespread to the extent that using computer for human resource management is imperative under the situation. It is vital for a modern corporation to be successful in nowadays competition.This assignment has discussed project and achieve human resource management system based on JSP mode. Human resource management system has taken advantage in convenience, fast search and exact management as a result of vital for corporations.In the modern educational technology mode, the computer has been widely used in the personnel management of enterprises, to the traditional personnel management methods brought about a major revolution. How effective personnel management is in front of us a new topic. Based on the study the current management of all enterprise personnel on the basis of the actual demand from enterprises starting with the more popular B / S (browser / server) JSP structure and dynamic web development technology, based on Windows2000 Server operating system and database SQL, designed and implemented a small function better enterprise management system. Through a series of system requirements analysis, design, coding, testing, the system has information on the employees view, add, modify, delete, and search functions. Focus on the system design process accordingly described, but also the need to improve the system of localities to sum up. After testing the system, operating results stability, and easy to operate, fast. Apply to general corporate personnel management requirements.

Key Words£ºJSP,Personnel Management,SQLdatabase
Ŀ ¼
1 Ð÷ÂÛ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­1
1.1Òý ÑÔ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­1
1.2¸Å Êö¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­1
1.3 JSP¸ÅÊö¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­2
2 ϵͳÔËÐбØÒªµÄ»·¾³¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­4
2.1 JSPÔËÐл·¾³¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­4
2.1.1Ó²¼þ»·¾³¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­4
2.1.2Èí¼þ»·¾³¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­4
2.2°²×°ºÍÅäÖÃJDK¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­4
2.3°²×°Tomcat¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­5
3 ϵͳ·ÖÎöÓëÉè¼Æ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­6
3.1ÐèÇó·ÖÎö¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­6
3.2¿ÉÐÐÐÔ·ÖÎö¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­6
3.2.1¾­¼ÃÐÔ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­6
3.2.2¼¼ÊõÐÔ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­6
3.2.3²Ù×÷¿ÉÐС­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­7
3.2.4ϵͳ½á¹¹¿ÉÐÐÐÔ·Ö¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­7
3.3×ÜÌåÉè¼Æ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­7
3.3.1ÏîÄ¿¹æ»®¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­7
3.3.2Éè¼ÆÄ¿±ê¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­8
3.3.3ϵͳ¹¦Äܽṹͼ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­8
4 ϵͳ¹¦ÄܵÄʵÏÖ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­9
4.1Ä£¿é¹¦ÄܽéÉÜ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­9
4.2Êý¾Ý¿âµÄÉè¼ÆʵÏÖ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­9
4.2.1Êý¾Ý¿âµÄÐèÇó·ÖÎö¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­9
4.2.2Êý¾Ý¿â±íµÄÉè¼Æ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­10
4.2.3Êý¾Ý¿âµÄÁª½áÓë·ÃÎÊ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­12
4.3Ä£¿é¹¦ÄܵÄʵÏÖ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­14
4.3.1µÇ¼ģ¿é¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­14
4.3.2ÈËÔ±µµ°¸Ä£¿é¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­14
4.3.3½±³Í¹ÜÀíÄ£¿é¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­16
4.3.4ÈËÔ±µ÷ÓÃÄ£¿é¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­18
5 ϵͳÑÝʾ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­20
5.1ϵͳ¹¦ÄܵÄʵÏÖЧ¹û¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­20
6 ¼¼ÊõÄѵãºÍϵͳ²âÊÔ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­24
6.1¼¼ÊõÄѵ㡭¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­24
6.1.1ÖÐÎÄÂÒÂëÎÊÌâ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­24
6.1.2°²È«ÐÔÎÊÌâ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­24
6.1.3 JavaScriptµÄʵÏÖ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­25
6.2ϵͳ²âÊÔ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­25
6.2.1½çÃæ²âÊÔ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­25
6.2.2ÐèÇó²âÊÔ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­25
7 ×ܽᡭ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­26
ÖÂл¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­27
[²Î¿¼ÎÄÏ×]¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­28
 
1 Ð÷ÂÛ
1.1 ÒýÑÔ
ÏÖÔÚÍøÂçµÄ·¢Õ¹ÒѳÊÏÖÉÌÒµ»¯¡¢È«Ãñ»¯¡¢È«Çò»¯µÄÇ÷ÊÆ¡£Î´À´ÆóÒµ³É¹¦µÄ¹Ø¼üµÄÒÀ¿¿ÆóÒµÈËÁ¦×ÊÔ´£¬È˲ÅÖ®ÕùÒѾ­³ÉΪÊг¡¾ºÕùÖеĺËÐÄÄÚÈÝÖ®Ò»£¬ÒÔÈËΪ±¾³ÉΪÆóÒµÁ¢×ãºÍ·¢Õ¹µÄ¸ù±¾¡£ÓÐЧÁ¦¹ÜÀíÆóÒµµÄÈËÁ¦×ÊÔ´£¬ÎªÆóÒµÌṩǿÓÐÁ¦µÄ´¢±¸Á¦Á¿£¬Ê¹Ö®³ÉΪÆóÒµ·¢Õ¹µÄÖ÷¶¯Á¦¡£Í¨¹ýÈËÁ¦×ÊÔ´µÄÓÐЧ¹ÜÀí£¬ÕÆÎÕ×îеġ¢×¼È·µÄÆóÒµÈËÁ¦×ÊÔ´ÐÅÏ¢£¬²¢¶ÔÆä½øÐи´ÔÓµÄͳ¼ÆÓë·ÖÎö£¬´Ó¶ø³ä·Ö·¢»Óÿ¸öÔ±¹¤µÄDZÄÜ£¬ÎªÆóÒµ´´Ôì¸ü´óµÄ¼ÛÖµ¡£
1.2 ¸ÅÊö
±¾ÏµÍ³Ê¹ÓÃMS SQL Server ¡¢TomcatΪ·þÎñÆ÷¡£TomcatÊÇ¿ªÔ´Èí¼þ£¬¿ÉÒÔ´ÓÍøÉÏÃâ·ÑµÃµ½ÆäÕýʽµÄ·¢Ðа汾£¬¶øMS SQL Server Êǵ±Ç°Ê¹ÓõÃ×î¹ã·ºµÄÊý¾Ý¿â£¬ÆäÐÔÄÜ¡¢°²È«ÐԵȷ½Ã涼Óкܺõı£Ö¤¡£TomcatËäÈ»ÊÇ¿ªÔ´Èí¼þ£¬µ«Ðí¶à´óÐÍÍøÕ¾Ò²ÒòÆäÎȶ¨µÄÐÔÄܺͳöÉ«µÄÐÔÄܶøÑ¡ÔñËü×÷ΪרҵµÄJSPÈÝÆ÷[1]¡£ÓÉ´Ë×é³ÉµÄÕû¸öϵͳµÄµ×²ã¿ò¼Ü£¬¼ÈÄܽÚÊ¡¿ªÖ§£¬ÅäÖùý³ÌÒ²Ïà¶Ô¼òµ¥¡£
ʹÓÃÃæÏò¶ÔÏó¼¼Êõ£¬½«¸÷¸ö½ÇÉ«£¨Ò»°ãÓû§£¬ÏµÍ³¹ÜÀíÔ±£©·â×°³ÉÀ࣬ÕâÑùÄÜ°ïÖú³ÌÐòÔ±¸üÖ±¹ÛµØÈ¥Àí½âÕû¸öÒµÎñÁ÷³Ì£¬½«Öصã·ÅÔÚÒµÎñÂß¼­µÄ´¦ÀíÉÏ£¬½µµÍÁË¿ª·¢ÄѶȣ¬ÕâÑùÒ²±ãÓÚ½«À´µÄÀ©Õ¹[2]¡£
±¾ÏµÍ³µÄһЩÁÁµã£º
£¨1£©Âß¼­²ãʵÏÖʱʹÓÃÊÂÎñ£¨Transaction£©±£Ö¤Êý¾ÝµÄÍêÕûÐÔ¡£
£¨2£©·þÎñÆ÷¶Ë²ÉÓÃÊý¾Ý¿â£¬ÊÂÎñÂß¼­£¬Óû§½çÃæÏ໥¶ÀÁ¢µÄ½á¹¹£¬¸÷¸öÄ£¿é×ÔÉíÀ©³ä·½±ã£¬ÇÒ»¥ÏàÖ®¼äñîºÏ¶È·Ç³£µÍ£¬¶ÔÂß¼­²ãÉÔ×öÀ©³ä¾Í¿ÉÒÔʵÏÖÒ»¸ö¹¦ÄܸüÍêÉƵÄϵͳ¡£
×ÜÌåÀ´Ëµ£¬±¾ÏµÍ³ÊÇ»ùÓÚJSPµÄÉè¼Æ·½°¸£¬Ê¹Óñíʾ²ã£¬Âß¼­²ãºÍÊý¾Ý²ãÈý²ãģʽ[3]¡£Ê¹ÓÃB/Sģʽ£¬Ê¹ÓÃMS SQL Server×÷ΪÊý¾Ý¿â£¬ Tomcat×÷ΪJSPÈÝÆ÷¡£Êý¾Ý¿â²ãʹÓÃJDBCÓëµ×²ãÊý¾Ý¿â½øÐн»»¥£¬Âß¼­²ã·â×°ÔÚJavabeanÀàÖУ¬±íʾ²ãÓÉJSPʵÏÖ¡£