ÕªÒª
¸ßУ¿ÆÑÐÐÅÏ¢¹ÜÀíϵͳÊǵäÐ͵ÄÐÅÏ¢¹ÜÀíϵͳ(MIS),Æ俪·¢Ö÷Òª°üÀ¨ºǫ́Êý¾Ý¿âµÄ½¨Á¢ºÍά»¤ÒÔ¼°Ç°¶ËÓ¦ÓóÌÐòµÄ¿ª·¢Á½¸ö·½Ãæ¡£¶ÔÓÚÇ°ÕßÒªÇó½¨Á¢ÆðÊý¾ÝÒ»ÖÂÐÔºÍÍêÕûÐÔÇ¿¡¢Êý¾Ý°²È«ÐԺõĿ⣬¶ø¶ÔÓÚºóÕßÔòÒªÇóÓ¦ÓóÌÐò¹¦ÄÜÍ걸,Ò×ʹÓõÈÌص㡣
ÔÚ±¾ÂÛÎÄÖУ¬Ê×ÏȽéÉÜÁËϵͳ¿ª·¢¹¤¾ßµÄ¹¦ÄܺÍÌص㡣ϵͳʹÓÃMyeclipse5×÷Ϊǰ̨¿ª·¢¹¤¾ß£¬ÀûÓÃÆäÊý¾Ý¿âSQL Server×÷ΪϵͳÊý¾Ý¿â¡£½Ó×ÅÂÛÊöÁËϵͳµÄÐèÇó·ÖÎö£¬¶ÔϵͳµÄ¹¦ÄܽøÐÐÁ˲ûÊö£¬Æ书ÄÜÖ÷ÒªÓÐʵÏÖÓû§µÇ¼¡¢Óû§²éѯÓëÊÚȨÒÔ¼°ÐÞ¸ÄÓû§ÐÅÏ¢£»ÊµÏÖÐÅÏ¢²éѯ£¬ÆäÖаüÀ¨ÂÛÎÄÐÅÏ¢¡¢³É¹ûÐÅÏ¢¡¢Öø×÷ÐÅÏ¢µÈµÄ²éѯ£»ÊµÏÖ¶Ôϵͳ¿âµÄά»¤¡£È»ºó£¬½éÉÜÁËϵͳÕûÌå½á¹¹ºÍÊý¾Ý¿âÉè¼Æ£¬²¢¸ø³öÁËÖ÷ÒªÊý¾Ý¿â±íµÄÏêϸ¶¨Òå¡£×îºó£¬ËµÃ÷ÁËϵͳµÄÄ£¿é×é³É£¬¸÷Ä£¿éµÄ¹¦ÄÜ£¬ÒÔ¼°ÕâЩģ¿éµÄ¾ßÌåʵÏÖ·½·¨ºÍ³ÌÐòºËÐÄ´úÂë £¬²¢¸½´øÁËһЩÖ÷ÒªµÄ´°¿Ú¡£
¹Ø¼ü´Ê ¸ßУ¿ÆÑÐÐÅÏ¢¹ÜÀíϵͳ£»JSP£» Microsoft SQL Server
Abstract
The system of managing Science Research Information file is a typical application of managing information system£¨MIS£©, which mainly includes building up data-base of back-end and developing the application interface of front-end . The former required consistency and integrality and security of data , the later should make the application powerful and easily used .
In this paper , it introduces the function and characteristic of the systematic developing instrument at first . The system uses Myeclipse5 as the front desk developing instrument , utilizes its database SQL Server as the systematic database . Then it expounds the systematic demand analyse , plains the function of the system . Its function mainly have : Realize user login , user inquiry and adapt user information ; Realize information inquiry , Including paper information inquiry , accomplishment information inquiry; literature information inquiry and so on ; Realize the maintenance of the system database . Then it introduces system total structure and the design of database and gives a detail table design . Finally , proves the systematic module making up , the function of every module , and the concrete implementation method of the module and key code of procedure , at the same time have some main windows .
KeyWords The system of managing Science Research Information ; JSP ; Microsoft SQL Server
Ŀ ¼
ÕªÒª 2
Abstract 3
ÒýÑÔ 4
µÚÒ»Õ ¿ÆÑйÜÀíÐÅϢϵͳÖ÷ÒªÄÚÈÝ 4
1.1¿ÆÑйÜÀíÐÅϢϵͳÖ÷ÒªÄÚÈÝ 4
1.2 ¹ÜÀíϵͳÐèÇóµ÷²é 5
1.3 ÏÖÐÐϵͳҵÎñÁ÷³Ì·ÖÎö 5
1.4 µ±Ç°ÏµÍ³ÖдæÔÚµÄÎÊÌâ 6
µÚ¶þÕ ÔõÑù¿ª·¢Ò»¸ö¿ÆÑйÜÀíÐÅϢϵͳ 6
µÚÈýÕ ϵͳ·ÖÎö 7
3.1 Êý¾ÝÁ÷³Ìͼ·ÖÎö 7
3.2 Êý¾Ý×Öµä 8
3.2.1 Êý¾ÝÏîÌõÄ¿ 8
3.2.2 Êý¾ÝÁ÷ÌõÄ¿ 9
3.2.3 ´¦ÀíÂß¼ÌõÄ¿ 9
3.2.4 Êý¾Ý´æ´¢ÌõÄ¿ 10
3.3 ϵͳÉè¼Æ 11
µÚËÄÕ WindowsϵÄJSP ±à³Ì»·¾³¼ò½é 11
4.1 JSP 11
4.2 Êý¾Ý¿âÂß¼½á¹¹Éè¼Æ 12
µÚÎåÕÂ SQL Server 2000 13
5.1 SQL Server ¹ØϵÊý¾Ý¿â¼ò½é 13
5.2 SQL Server Ìصã 13
5.4 JDBC 14
5.5 B/Sģʽ·ÖÎö 15
µÚÁùÕ ϵͳÅäÖÃÉè¼Æ 16
Èí¼þÅäÖÃ 17
Ó²¼þÅäÖÃ 18
ÐÅÏ¢´úÂëÉè¼Æ 18
µÚÆßÕ Êý¾Ý¿âÉè¼Æ 18
7.1 ¸ÅÄîÉè¼Æ 19
7.2 E-R ͼ·ÖÎö 19
7.2.1 ½ÌʦÓë¿ÆÑгɹûE-Rͼ 19
7.2.2 ¿ÆÑгɹûÓëѧ¿ÆµÄE-Rͼ 20
7.2.3 Âß¼Éè¼Æ 20
7.2.4 ÎïÀíÉè¼Æ 20
7.2.5 ¼ÈëÄ£¿éÉè¼Æ 22
7.2.6 ȨÏÞÉèÖÃÄ£¿éÉè¼Æ 23
µÚ°ËÕ ½áÊøÓï 28
ÖÂл 29
²Î¿¼×ÊÁÏ 30
¸½ ¼ 31
ÒýÑÔ
Ëæ׿ÆËã»ú¼¼ÊõµÄ¹ã·ºÓ¦ÓÃÒÔ¼°ÏÖ´úÉç»áÐÅÏ¢Á¿µÄ¼±¾çÔö¼Ó,´«Í³µÄÈ˹¤ÐÅÏ¢¹ÜÀíÌåϵÒѾԶԶ²»ÄÜÂú×ã¿ì½Ú×à¡¢¸ßЧÂʵÄÏÖ´úÉú»îµÄÐèÒª,ÂäºóµÄ¹ÜÀí¼¼ÊõÑÏÖØ×è°ÁËÐÅÏ¢µÄ½»Á÷Óë¹²Ïí¡£Í¬Ê±£¬ÍøÂç¼¼ÊõµÄÆÕ¼°£¬ÈçºÎͨ¹ýÍøÂçÀ´ÊµÏÖ¶Ô¸ßУ¿Æ¼¼ÐÅÏ¢µÄÔ¶³Ì·ÃÎʺÍÓëÔ¶³Ì¹ÜÀí£¬´Ó¶øʵÏÖ¶ÔÐÅÏ¢µÄ¹²ÏíºÍ½»Á÷³ÉΪµ±ÎñÖ®¼±¡£
¸ßУ¿ÆÑгɹûÊýÁ¿Ôö¼Ó½Ï¿ì£¬½ÌʦµÄ¿ÆÑÐÄÚÈݽÏΪ¸´ÔÓ£¬Éæ¼°·¶Î§¼«Æä¹ã·º£¬¶øÇÒΪÁ˹«Æ½ºÏÀíµÄÍƶ¯½Ìʦ¶ÓÎéµÄ¿ÆÑÐѧ½¨É裬Ϊ½ñºó¿ÆÑÐÐÅÏ¢µÄ²éÕÒÌṩ·½±ã¡¢¿ì½ÝµÄ·þÎñ£¬¼øÓÚ´ËÄ¿µÄ»ùÓÚJSP¼¼ÊõµÄ¿ÆÑÐÐÅÏ¢¹ÜÀíϵͳΪÎÒÃÇÌṩÁËÇ¿ÓÐÁ¦µÄÓ¦Óù¤¾ß¡£¸Ãϵͳ¿ÉÒÔ´ïµ½Óû§¼ìË÷ѸËÙ£¬²éÕÒ·½±ã£¬Â¼Èë¼òµ¥£¬¿É¿¿ÐԸߣ¬´æ´¢Á¿´ó£¬±£ÃÜÐԺõÄÒªÇó¡£
¸ßУ¿ÆÑгɹû¹ÜÀíÐÅϢϵͳÊǸߵȽÌÓýÖеÄÒ»¸öÖØÒª»·½Ú£¬ÊÇÕû¸öԺУ¹ÜÀíµÄÖØÒªµÄÒ»²¿·Ö¡£Ëæ×ÅѧУʦ×ÊÁ¦Á¿Öð½¥¼ÓÇ¿£¬Ãæ¶ÔÖÖÀà·±¶àµÄÊý¾ÝºÍ±¨±í£¬ÊÖ¹¤´¦Àí·½Ê½ÒѾºÜÄѸúÉÏÏÖ´ú»¯¹ÜÀíµÄ²½·¥£¬Ëæ׿ÆËã»ú¼°Í¨Ñ¶¼¼ÊõµÄ·ÉËÙ·¢Õ¹£¬¸ßµÈ½ÌÓý¶Ô¿ÆÑгɹû¹ÜÀí¹¤×÷Ìá³öÁ˸ü¸ßµÄÒªÇó¡£´«Í³µÄ¹ÜÀí·½·¨¡¢ÊÖ¶ÎÒÔ¼°¹¤×÷ЧÂÊÒѲ»ÄÜÊÊӦеķ¢Õ¹ÐèÇó£¬ÎÞ·¨¼°Ê±×¼È·µØ´òÓ¡³öËùÐèµÄ±¨±í£¬¾¡¿ì¸Ä±ä´«Í³µÄ¹ÜÀíģʽ£¬ÔËÓÃÏÖ´ú»¯ÊֶνøÐпÆѧ¹ÜÀí£¬ÒѾ³ÉΪÕû¸ö½ÌÓýϵͳؽ´ý½â¾öµÄ¿ÎÌâÖ®Ò»¡£