Õª Òª
Ëæ×ÅÍøÂçÓ¦Óü¼ÊõµÄ·ÉËÙ·¢Õ¹£¬»ùÓÚÍøÂçµÄÓ¦ÓÃϵͳ¸øÈËÃÇ´øÀ´ÁËÖî¶à±ãÀû¡£¹ÜÀíÐÅϢϵͳÔÚÏÖ´úÉç»áÒÑÉîÈëµ½¸÷Ðи÷Òµ£¬ÓÉÓÚ¼ÆËã»ú¼¼ÊõµÄѸËÙ·¢Õ¹ºÍÆÕ¼°£¬ÐÅÏ¢¹ÜÀíϵͳMISÊÂʵÉÏÒѳÉΪ¼ÆËã»ú¹ÜÀíÐÅϢϵͳ£¬ËæןßУѧÉúÊýÁ¿Ôö¼Ó¶Ô¸ßУѧÉúËÞÉá¹ÜÀíÒ²ÊÇÔ½À´Ô½ÖØÒª£¬´óѧÉúËÞÉá¹ÜÀíϵͳ¾ÍÊÇÒ»¸öµäÐ͵ĹÜÀíÐÅϢϵͳ£¬Ëü¿ÉÒÔÈÃËÞÉá¹ÜÀí¹¤×÷±äµÄ¸üÇáËÉ¡£±¾±ÏÒµÉè¼ÆµÄÈÎÎñ¾ÍÊÇÉè¼ÆÒ»¸ö´óѧÉúËÞÉá¹ÜÀíϵͳ¡£Æ俪·¢¹ý³ÌÖ÷Òª°üÀ¨Ç°¶ËÓ¦ÓóÌÐòµÄ¿ª·¢ºÍºǫ́Êý¾Ý¿âµÄ½¨Á¢ºÍά»¤Á½¸ö·½Ãæ¡£Ö÷ÒªÈÎÎñ¾ÍÊǽ¨Á¢»ù±¾Êý¾Ý£¬ºǫ́³ÌÐòÖ÷Òª¸ºÔðµÄ¶¼ÊǹÜÀíÉϵŦÄÜ¡£
¾¹ý·ÖÎö£¬±¾ÏµÍ³ÔËÓÃÁËMicrosoft SQL Server2000Ϊºǫ́Êý¾Ý¿â£¬ÒÔVisual studio.NET 2005Ϊǰ¶Ë¿ª·¢¹¤¾ß£¬ÏµÍ³ÊµÏÖÁËϵͳά»¤¡¢ËÞÉá¹ÜÀí¡¢Ñ§Éú¹ÜÀí¡¢ËÞÉá·ÖÅä¡¢ÐÅÏ¢²éѯµÈ±ØÐèµÄ¹¦ÄÜ£¬Æä²Ù×÷¼òµ¥£¬½çÃæÓѺã¬ÔËÐбȽÏÎȶ¨£¬ÊÊÓÃÓÚ´óѧԺУ´óѧÉúËÞÉá¹ÜÀí¡£
¹Ø¼ü´Ê£ºËÞÉá¹ÜÀí£»ÐÅÏ¢£»vs2005 £»SQL2000
Abstract
With the rapid development of network technology, web-based application systems to bring people a lot With the rapid development of network technology, web-based application systems to bring people a lot of convenience. Management information system in modern society has been deep into all walks of life, due to the rapid development of computer technology and universal, management information system MIS in fact has become a computer information management system, with the increase in the number of college students on the university student's dormitory management is becoming more and more important, dormitory management system is a typical management information system, it can let dormitory management become more relaxed. The task of this graduation design is to design a management system for college student's dormitory. The process of its development mainly includes the development of front application program and database background to the establishment and maintenance of two aspects. The main task is to set up the basic data, daemons are mainly responsible for the management of function.
After the analysis, the system used Microsoft SQL Server2000 as background database, using Visual studio.NET 2005 as the developing tool, system of system maintenance, dormitory management, student management, dormitory distribution, information and other necessary functions, simple operation, friendly interface, operation is more stable, applicable to university students dormitory management.
Key words: dormitory management; information; VS2005; SQL2000
Ŀ ¼
Õª Òª III
Abstract IV
µÚÒ»Õ Ð÷ ÂÛ 1
1£®1 Ñ¡Ìâ±³¾°¼°ÏÖ×´ 1
1£®2 Ñо¿Ä¿µÄºÍÒâÒå 1
1£®3¿ª·¢ËùÓü¼Êõ¼°Ìصã 2
1.3.1 B/S¿ª·¢Ä£Ê½ 2
1.3.2 ASP.NET¼°Visual Studio½éÉÜ 3
1.3.3 ADO.NET½éÉÜ 5
µÚ¶þÕ ϵͳ·ÖÎöÓë×ÜÌåÉè¼Æ 7
2£®1 ϵͳÐèÇó·ÖÎö 7
2£®2 ϵͳ¹¦ÄÜ·ÖÎö 7
2.2.1µ÷²éÓû§ÐèÇó 7
2.2.2ϵͳ¹¦ÄܵÄÉè¼ÆºÍ»®·Ö 9
2.3ϵͳ¼Ü¹¹·ÖÎö 9
2.4ϵͳ¿ÉÐÐÐÔ·ÖÎö 11
2.5ϵͳ×ÜÌåÉè¼Æ 11
2.5.1ϵͳÉè¼ÆÄ¿±ê 11
2.5.2ϵͳ×ÜÌ幦ÄÜÉè¼Æ 12
2.5.2¹¦ÄÜÄ£¿é 12
2.6ϵͳÊý¾ÝÁ÷ͼ 15
µÚÈýÕ»ù±¾µÄÀíÂÛ 16
3.1Êý¾Ý¿â½éÉÜ 16
3.2Êý¾Ý¿â¸ÅÄî½á¹¹Éè¼ÆE-Rͼ 17
3.2.1¸ÅÄî½á¹¹Éè¼Æ 17
3.2.2Êý¾Ý¿âÂß¼½á¹¹Éè¼Æ 21
µÚËÄÕ ¹¦ÄÜÄ£¿éÏêϸÉè¼Æ 26
4. 1µÇ¼ģ¿éÉè¼Æ 26
4. 2ºǫ́¹ÜÀíÖ÷½çÃæÉè¼Æ 26
4. 2ÇÞÊÒ³¤ÓëÊÒԱģ¿éÉè¼Æ 28
µÚÎåÕ ϵͳ²âÊÔ 33
5.1 ²âÊÔµÄÈÎÎñ¼°Ä¿±ê 33
5.1.1²âÊÔµÄÈÎÎñ 33
5.1.2²âÊÔµÄÄ¿±ê 33
5.2²âÊÔ·½°¸ 33
5.2.1Ä£¿é²âÊÔ 33
5.2.2¼¯³É²âÊÔ 34
5.2.3ÑéÊÕ²âÊÔ 34
5.2.4ƽÐÐÔËÐÐ 34
µÚÁùÕ ϵͳʹÓÃά»¤ 35
6.1ϵͳʹÓÃ˵Ã÷ 35
6.2ϵͳµÄά»¤ 35
½á¡¡ÂÛ 37
Ö л 38
²Î¿¼ÎÄÏ× 39
¸½¼þ³ÌÐòÇåµ¥ 40
µÚÒ»Õ Ð÷ ÂÛ
1£®1 Ñ¡Ìâ±³¾°¼°ÏÖ×´
Ëæ×Åʱ´úµÄ·¢Õ¹£¬¼ÆËã»ú¼¼ÊõÔ½À´Ô½ÉîÈë¸÷Ðи÷Òµ£¬Îª¹ã´óµÄÓû§ÌṩÁ˸üΪÖܵ½ºÍ±ã½ÝµÄ·þÎñ¡£Ä¿Ç°¸÷Ðи÷Òµ¹ã·ºÊ¹ÓÃרÓÃϵͳ£¬ÆäÄÚÈÝ·¶Î§¿çÔ½Á˽ÌÓý¿ÆÑС¢ÎÄ»¯ÊÂÒµ¡¢½ðÈÚ¡¢ÉÌÒµ¡¢ÐÂÎųö°æ¡¢ÓéÀÖ¡¢ÌåÓýµÈ¸÷¸öÁìÓò£¬ÆäÓû§ÈºÊ®·ÖÅÓ´ó£¬Òò´Ë£¬Éè¼Æ¿ª·¢ºÃÒ»¸öרÓÃϵͳ¶ÔÒ»¸ö»ú¹¹(»ò²¿ÃÅ)µÄ·¢Õ¹Ê®·ÖÖØÒª¡£½üÄêÀ´£¬Ëæ×ÅÓû§ÒªÇóµÄ²»¶ÏÌá¸ß¼°¼ÆËã»ú¿ÆѧµÄѸËÙ·¢Õ¹£¬ÌرðÊÇÊý¾Ý¿â¼¼ÊõµÄ¹ã·ºÓ¦Óã¬ÏòÓû§ÌṩµÄ·þÎñ½«Ô½À´Ô½·á¸»£¬Ô½À´Ô½ÈËÐÔ»¯¡£
¶ÔÓÚѧУ¶øÑÔ£¬Ñ§ÉúËÞÉá¹ÜÀíÊDZز»¿ÉÉÙµÄ×é³É²¿·Ö¡£Ä¿Ç°ÈÔÈ»´æÔÚÓÐѧУͣÁôÔÚËÞÉá¹ÜÀí²¿ÃÅÈËÔ±ÊÖ¹¤¼Ç¼Êý¾ÝµÄ½×¶Î£¬ÊÖ¹¤¼Ç¼¶ÔÓÚ¹æģСµÄѧУÀ´ËµÃãÇ¿¿ÉÒÔ½ÓÊÜ£»µ«¶ÔÓÚѧÉúÐÅÏ¢Á¿±È½ÏÅÓ´ó£¬ÐèÒª¼Ç¼´æµµµÄÊý¾Ý±È½Ï¶àµÄ¸ßУÀ´Ëµ£¬È˹¤¼Ç¼ÊÇÏ൱Âé·³µÄ,¶øÇÒµ±²éÕÒijÌõ¼Ç¼ʱ£¬ÓÉÓÚÊý¾ÝÁ¿ÅÓ´ó£¬Ö»ÄÜÒÀ¿¿È˹¤È¥Ò»ÌõÒ»ÌõµØ²éÕÒ£¬ÕâÑù²»µ«Âé·³¶øÇÒÀË·ÑÐí¶àʱ¼ä£¬¹¤×÷ЧÂʱȽϵ͡£²ÉÓüÆËã»úÀ´¹ÜÀíËÞÉáºÍѧÉúµÄÐÅÏ¢£¬´ó´óÌá¸ßÁ˲éѯµÄËٶȣ¬½ÚÔ¼ÁËÈËÁ¦ºÍÎïÁ¦×ÊÔ´£¬´ïµ½ÁËÔ¤ÆÚµÄÒªÇó¡£½ñÌ죬¼ÆËã»úµÄ¼Û¸ñÒѾʮ·ÖµÍÁ®£¬ÐÔÄÜÈ´ÓÐÁ˳¤×ãµÄ½ø²½¡£ËüÒѾ±»Ó¦ÓÃÓÚÐí¶àÁìÓò£¬¼ÆËã»úÖ®ËùÒÔÈç´ËÁ÷ÐеÄÔÒòÖ÷ÒªÓÐÒÔϼ¸¸ö·½Ã棺
Ê×ÏÈ£¬¼ÆËã»ú¿ÉÒÔ´úÌæÈ˹¤½øÐÐÐí¶à·±ÔÓµÄÀͶ¯£»
Æä´Î£¬¼ÆËã»ú¿ÉÒÔ½ÚÊ¡Ðí¶à×ÊÔ´£»
µÚÈý£¬¼ÆËã»ú¿ÉÒÔ´ó´óµÄÌá¸ßÈËÃǵŤ×÷ЧÂÊ£»
µÚËÄ£¬¼ÆËã»ú¿ÉÒÔʹÃô¸ÐÎĵµ¸ü¼Ó°²È«£¬µÈµÈ.