ÕªÒª
ÔÚ¼ÆËã»úʱ´úÈÕÒæ·¢Õ¹µÄ½ñÌ죬¼ÆËã»úÍøÂçÕý¿ìËÙÈÚÈëÕâ¸öÉç»áµÄÿһ¸öÁìÓò¡£ÉçÇø¾ÓÃñÐÅÏ¢¹ÜÀíÒ²´ÓÏÖʵÉú»îÖÐ×ßÉÏÁËÍøÂç¿Õ¼ä¡£¿ª·¢ºÍÉè¼ÆµÄÁúɽ¾ÓÃñÐÅÏ¢¹ÜÀíϵͳ£¬°üÀ¨ÏµÍ³Óû§¹ÜÀí¡¢¾ÓÃñÐÅÏ¢¹ÜÀí¡¢Â¥·¿ÐÅÏ¢¹ÜÀí¡¢ÌØÊâȺÌå¹ÜÀíµÈ¹¦ÄÜ£¬ÆäÄ¿µÄÊÇʹס»§ÓëÕþ¸®²¿ÃÅÖ®¼ä¹Øϵ¸üÃÜÇУ¬¶ÔÉçÇø×ÊÔ´ÀûÓøü±ãÀûÓÐЧ£¬Ìá¸ßÕþ¸®¹ÜÀíЧÂÊ£¬Ê¹¾ÓÃñÉú»î¸ü±ãÀû¡£
±¾ÏµÍ³ÊÇ»ùÓÚB/Sģʽ£¬²ÉÓõÄÊÇJSP+ SQL Server 2000ģʽµÄ¿ª·¢¼¯³É»·¾³¡£´ËϵͳµÄÉè¼Æ´Ó¹¦ÄÜÉÏÀ´Ëµ£¬ÊDZȽÏÍ걸µÄ£¬ÏµÍ³ÒÔWeb½çÃæÓë¹ÜÀíÔ±½»»¥£¬Îª¹ÜÀíÔ±ÌṩÐÅÏ¢²¢½ÓÊÜÆä²Ù×÷£¬Í¬Ê±Í¨¹ýÊý¾Ý¿â¹ÜÀíϵͳÀ´´æ´¢ÐÅÏ¢Êý¾Ý¡£±¾ÏµÍ³µÄ»ù±¾¹¦ÄÜ£ºÊý¾Ý½øÐмÈë¡¢Ð޸ġ¢É¾³ý¡¢²éѯ¡¢Í³¼ÆµÄ»ù±¾¹¦ÄÜ¡£
¹Ø¼ü´Ê£ºSQL £»ÉçÇø¾ÓÃñÐÅÏ¢£»JSP
Abstract
In the computer age growing today, the computer network is rapidly into every field of the society. Residents of the community information management from the real life on the network space. Longshan resident information management system development and design, including user management system, information management, residents of building information management, special group management function, its purpose is to make the relationship between the residents and the government more closely, more convenient and effective use of community resources, improving the government management efficiency, so that residents living more convenient.
The system is based on B/S mode, is used in the integrated development environment JSP+ SQL Server 2000 model. The design of this system from the function, is more complete, the system to the Web interface and administrator interaction, and provide information for administrators and accept its operation, at the same time to store information and data through database management system. The basic functions of the system: the basic function of data entry, modify, delete, query, statistics.
Keywords: SQL; residents of the community information; JSP
Ŀ ¼
1.Ð÷ÂÛ 1
1.1Ñ¡Ìâ±³¾° 1
1.2Ñо¿ÒâÒå 1
1.3ÐÅÏ¢¹ÜÀíϵͳ 1
2.ϵͳ·ÖÎö 2
2.1¿ÉÐÐÐÔ·ÖÎö 2
2.1.1¾¼ÃÉϵĿÉÐÐÐÔ 2
2.1.2¼¼ÊõÉϵĿÉÐÐÐÔ 3
2.1.3²Ù×÷ÉϵĿÉÐÐÐÔ 3
2.2ϵͳ¹¦ÄÜÐèÇó·ÖÎö 3
2.2.1¹¦ÄÜÐèÇó 3
2.2.2ÐÔÄÜÐèÇó 4
2.3ÒµÎñÁ÷³Ì·ÖÎö 5
2.4Êý¾ÝÁ÷³Ì·ÖÎö 6
2.5Êý¾Ý¿âÉè¼Æ 7
2.5.1Êý¾Ý¿â¸ÅÄî½á¹¹Éè¼Æ 7
2.5.2Êý¾Ý¿âÂß¼½á¹¹Éè¼Æ 9
3.ϵͳÉè¼Æ 13
3.1ϵͳÌåϵ½á¹¹ 13
3.2 ¿ª·¢Èí¼þ 14
3.2.1 JSP¼¼Êõ 14
3.2.2 Tomcat¹ÜÀíÆ÷ 15
3.2.3 SQLÊý¾Ý¿â 16
3.3ϵͳµÄÈíÓ²¼þƽ̨ 18
4.ϵͳ²Ù×÷˵Ã÷ 19
4.1¹ÜÀíÔ±µÇ½ҳÃæ 19
4.2ϵͳÓû§Ìí¼ÓÒ³Ãæ 22
4.3¾ÓÃñÐÅÏ¢Ìí¼ÓÒ³Ãæ 22
4.4¾ÓÃñÐÅÏ¢²éѯҳÃæ 25
4.5ǨÒƼǼÌí¼ÓÒ³Ãæ 28
4.6ǨÒƼǼ²éѯҳÃæ 31
4.7»§¼®±ä¸üÌí¼ÓÒ³Ãæ 33
4.8¼Æ»®ÉúÓýÌí¼ÓÒ³Ãæ 36
5.Èí¼þ²âÊÔÓë·ÖÎö 39
5.1ϵͳ²âÊԵĶ¨Òå 39
5.2ϵͳ²âÊÔµÄÄ¿µÄ¼°ÒâÒå 39
5.3ϵͳ²âÊÔµÄÖØÒªÐÔ 39
5.4ϵͳ²âÊԵij£Ó÷½·¨ 40
5.5²âÊÔ»·¾³Óë²âÊÔÌõ¼þ 41
5.6ϵͳÔËÐÐÇé¿ö 41
5.7²âÊÔ×ܽá 42
6.½áÂÛ 42
6.1ϵͳµÄÌصã 42
6.2ϵͳµÄ²»×ãºÍ¸Ä½ø 42
6.3Éè¼ÆÊÕ»ñÓëÐĵà 42
Ö л 44
²Î ¿¼ ÎÄ Ï× 45