Õª¡¡¡¡Òª
Ëæ×ŵçÄÔµÄÆÕ¼°ÓëʹÓã¬ÏÖÔڵĹÜÀíÒ²ÌáÉýÁËÒ»¸öµµ´Î£¬½¥½¥ÊµÏÖÁËÎÞÖ½»¯°ì¹«£¬¼´´ÓÔÀ´µÄÈ˹¤¼Ç¼¹ÜÀíģʽת±äΪµçÄÔÒ»Ì廯¹ÜÀí¡£¸ßУÊÇ¿ÆÑеÄÕóµØ£¬ºóÇÚµÄËÞÉá¹ÜÀíÒ²Ó¦¸ÃÒ»¸Ä´«Í³µÄÈ˹¤¹ÜÀí£¬¸ü¼ÓÐÅÏ¢»¯£¬Ê±´ú»¯£¬½ÚÊ¡ÈËÁ¦ÎïÁ¦£¬Ìá¸ßЧÂÊ¡£Ñ§ÉúËÞÉáÊÇÿһλÔÚУѧÉúÉú»î¡¢Ñ§Ï°¡¢Ï໥½»Á÷µÄÖ÷Òª³¡Ëù£¬ÈçºÎÌṩһ¸öÁ¼ºÃµÄѧÉúËÞÉáµÄ¹ÜÀíÌåϵ£¬¶ÔѧУºÍͬѧ¶øÑÔÖÁ¹ØÖØÒª¡£ÒÔÍùµÄѧÉúËÞÉá¹ÜÀí»ù±¾ÉÏ»¹´¦ÓÚÈ˹¤²Ù×÷µÄ½×¶Î£¬Ëæ׿ÆËã»ú¼¼ÊõºÍÍøÂç¼¼ÊõµÄÈÕÒæ¹ã·ºÓ¦Ó㬲ÉÓüÆËã»úÒÔ¼°ÍøÂçÀ´¹ÜÀíѧÉúËÞÉᣬÓÐןܺõÄÇ°¾°¡£»ùÓÚÕâÒ»µã£¬¿ª·¢´ËѧÉúËÞÉá¹ÜÀíÈí¼þ¡£
ÂÛÎĽ«Éè¼ÆÒ»¸öѧÉúËÞÉá¹ÜÀíϵͳµÄWebÓ¦Óýâ¾ö·½°¸²¢ÓèÒÔʵÏÖ¡£Ñ§ÉúËÞÉá¹ÜÀíϵͳÊÇÒ»¸ö°²È«ºÍ¸ßЧµÄרÓÃϵͳ,¡£Õâ¸öϵͳʹÓÃÁ˺ܶ༼Êõ£¬±ÈÈçJSP,JDBCµÈ¡£×¨ÓÃϵͳʹÓõÄÊý¾Ý¿âÊÇSQL Server 2005 Êý¾Ý¿â¡£»ùÓÚJSPѧÉúËÞÉá¹ÜÀíϵͳµÄÖ÷Òª¹¦ÄÜ°üÀ¨£º¿ÉÒÔʵÏÖ¶ÔѧÉúËÞÉáÐÅÏ¢µÄ¼È빦ÄÜ,Ð޸ŦÄÜ,ɾ³ý¹¦ÄÜ¡£Í¨¹ýϵͳÉÏÊö¹¦ÄÜʵÏÖËÞÉá¹ÜÀí²¿ÃŶÔÓÚѧÉúËÞÉáÐÅÏ¢µÄÈÕ³£¹ÜÀí£¬¼´·½±ãËÞÉá¹ÜÀíÈËÔ±¼°Ê±È«ÃæµØÕÆÎÕѧÉúסËÞÇé¿ö¼°ËÞÉá·ÖÅäÇé¿ö£»ÎªÓû§£¨¹ÜÀíÓû§ºÍÒ»°ãÓû§£¬ÈçѧÉú£©ÌṩÁËһЩ¼òµ¥µÄÊý¾Ý²éѯ²¢Êä³ö¸÷ÖÖÐÅÏ¢µÈ£»ÔÚʵÏÖ¼ìË÷ѸËٺͲéÕÒ·½±ãµÄͬʱ,¶ÔÐÂÈëУѧÉúºÜ¿ìµØ½øÐÐËÞÉá°²ÅŵÈÈÕ³£¹ÜÀí¡£
¹Ø¼ü×Ö£ºËÞÉá¹ÜÀí£¬Ñ§ÉúËÞÉáÐÅÏ¢£¬B/Sģʽ£»SQL Server 2005
Abstract
With the popularity of computers and use, current management has improved a notch, and gradually achieve a paperless office, from the original manual records management into the integrated management of the computer. Colleges and universities are research positions, dormitory management of logistics should also be changed the traditional manual management, more information, times of, saving manpower and resources and improve efficiency. Each dormitory is the student life in school, learning, the main place to communicate with each other, how to provide a good student hostel management system is critical for schools and students. Dormitory Management is basically the previous manual operation is still in the stage, with the computer technology and network technology becomes more widely used, the use of computers and networks to manage the student hostel, with good prospects. Based on this, developing the student dormitory management software.
Thesis, a student hostel management system solutions and Web applications to be realized. Student hostel management system is a safe and efficient dedicated system. The system uses a number of technologies such as JSP, JDBC and so on. Dedicated system using the database is SQL Server 2005 database. Dormitory Management System based on JSP main features include: can the student dormitories information input function, modify the function, delete function. Through the system to achieve the above functions for the student hostel dormitory management information, daily management, the management staff to facilitate timely accommodation of students fully grasp the allocation of accommodation and hostels; for the user (management of users and general users, such as students) to provide some simple data query and export all kinds of information; in achieving rapid and find easy to retrieve the same time, new students quickly into the arrangements for the daily management of the hostel.
Keywords: dormitory management, information on student hostels, B / S mode; SQL Server 2005
Ä¿¡¡¡¡Â¼
Õª¡¡¡¡Òª 1
Abstract 2
1ÒýÑÔ 1
1.1Ñ¡Ìâ±³¾° 1
1.2Ñо¿ÒâÒå 1
1.3Ñо¿Ë¼Â·ºÍ·½·¨ 2
1.4Ô¤ÆÚ½á¹û 2
2¿ª·¢Æ½Ì¨¼°ÓïÑÔ½éÉÜ 3
2.1»ùÓÚB/S½á¹¹¿ª·¢ 3
2.2 JAVAÓïÑÔ¼ò½é 3
2.3 JSP¼¼Êõ 3
2.4 Tomcat 5
2.5 SQL Server 2005 6
2.6 Eclipse 7
3ÐèÇó·ÖÎö 9
3.1»ù±¾ÒªÇó·ÖÎö 9
3.2Éè¼ÆÌõ¼þ·ÖÎö 9
3.3ϵͳ¼¼Êõ·ÖÎö 9
3.4¿ÉÐÐÐÔ·ÖÎö 10
3.4.1¹ÜÀíÉϵĿÉÐÐÐÔ 10
3.4.2¼¼ÊõÉϵĿÉÐÐÐÔ 10
3.4.3¾¼ÃÉϵĿÉÐÐÐÔ 10
3.4.4·ÖÎö½áÂÛ 10
3.5ϵͳ¹¦ÄÜ·ÖÎö 11
4×ÜÌåÉè¼Æ 12
4.1ϵͳ¹¦ÄÜÄ£¿éµÄÉè¼Æ 12
4.2Êý¾Ý¿âÉè¼Æ 12
4.3ÎïÀí½á¹¹Éè¼Æ 14
4.4³ö´íÉè¼Æ 14
5ÏêϸÉè¼Æ 15
5.1µÇÈë½çÃæ 15
5.2¹ÜÀíµÇ¼Ö÷½çÃæ 15
5.2.1¼ÈëѧÉúÐÅÏ¢ 16
5.2.2 ϨµÆʱ¼äÉèÖà 17
5.2.3 ËÞÉáÌí¼Ó 17
5.2.4À´·ÃÕßÌí¼Ó 17
5.2.5 ÎÀÉú¼ì²éÐÅϢ¼Èë 18
5.2.6 ±£ÐÞÐÅÏ¢ÉóÅú 18
5.3 ѧÉúµÇ¼Ö÷½çÃæ 19
5.3.1Ìí¼Ó±¨ÐÞ 19
5.3.2 ÎÀÉúÅÅÃûÐÅÏ¢²éѯ 19
6 ϵͳµ÷ÊÔÓë²âÊÔ 20
6.1 ³ÌÐòµ÷ÊÔ 20
6.2 ³ÌÐòµÄ²âÊÔ 20
6.2.1 ²âÊÔµÄÖØÒªÐÔ¼°Ä¿µÄ 20
6.2.2 ²âÊԵIJ½Öè 21
6.2.3 ²âÊÔµÄÖ÷ÒªÄÚÈÝ 22
6.3×ܽá 23
½á ÂÛ 24
ÖÂл 25
²Î¿¼ÎÄÏ× 26
1ÒýÑÔ
Ëæ×ÅÖйú¸ßµÈ½ÌÓý¹æÄ£µÄ²»¶ÏÀ©´ó£¬¸÷¸ßУ¶¼ÃæÁÙן÷ÖÖ¸÷ÑùµÄÎÊÌ⣬¶ø¹²ÓеÄÒ»¸öÎÊÌâ¾ÍÊÇѧÉúËÞÉáÈÕÒæ½ôÕÅ¡£ÈçºÎºÏÀí°²ÅÅѧÉúסËÞÊǸßУºóÇڸĸïÖбØÐ뿼ÂǵÄÒ»¸öÖØÒªÎÊÌâ¡£Éè¼ÆÒ»¸öËÞÉá¹ÜÀíϵͳ¿ÉÒÔʹÕâ¸öÎÊÌâ±äµÃ¼òµ¥Ò×ÐУ¬²¢ÓÐÒ»¶¨µÄͨÓÃÐÔ£¬¿ÉÒÔÍƹ㵽²»Í¬µÄ¸ßУ¡£
ËÞÉá¹ÜÀíϵͳµÄÐÅÏ¢Á¿±È½Ï´ó£¬Êý¾Ý°²È«ÐԺͱ£ÃÜÐÔÒªÇó½Ï¸ß¡£±¾ÏµÍ³¿ÉʵÏÖ¶ÔËÞÉáÐÅÏ¢¡¢Ñ§ÉúÐÅÏ¢¡¢¹ÜÀíÈËÔ±ÐÅÏ¢µÄ²éѯ¡¢Êä³öºÍά»¤¡£¹¤×÷ÈËÔ±¿Éä¯ÀÀ¡¢²éѯ¡¢Ìí¼Ó¡¢É¾³ý¡¢Ð޸ġ¢Í³¼Æ¸÷ÖÖ»ù±¾ÐÅÏ¢¡£
ʹÓüÆËã»ú¶ÔËÞÉáÐÅÏ¢½øÐйÜÀí£¬¾ßÓÐÊÖ¹¤¹ÜÀíËùÎÞ·¨±ÈÄâµÄÓŵ㣬ÀýÈ磺²éÕÒ±ã½Ý¡¢¿É¿¿ÐԸߡ¢´æ´¢Á¿´ó¡¢±£ÃÜÐԺᢳɱ¾µÍµÈ¡£ÕâЩÓŵãÄܹ»¼«´óµÄÌá¸ß¹ÜÀíÈÕÒæÔö¶àµÄËÞÉáµÄЧÂÊ¡£
ÂÛÎÄͨ¹ýËÞÉá¹ÜÀíÐèÇó·ÖÎö£¬½éÉÜÁ˱¾¿ÎÌâËùÒªÍê³ÉµÄ¹¦ÄܺͿª·¢µÄ¹ý³Ì¡£Í¨¹ýÕâ´ÎÂÛÎĵÄÉè¼ÆʹµÄ×Ô¼º¸üÉîÈëµÄÁ˽âJAVA¼°ÆäÇ¿´óµÄ¹¦ÄÜ£¬Í¬Ê±Ò²Ìá¸ßÁË×Ô¼ºµÄÈí¼þ¿ª·¢ÄÜÁ¦ºÍ±à³ÌÄÜÁ¦¡£ÓÉÓÚʱ¼ä²Ö´ÙºÍ±¾ÈËˮƽÓÐÏÞ£¬²»µ±Ö®´¦ÔÚËùÄÑÃ⣬Çë¸÷λÀÏʦÅúÆÀÖ¸Õý¡£