Õª Òª
ÎïÒµÊշѹÜÀíÊÇÎïÒµ¹ÜÀíÖбز»¿ÉÉÙµÄÒ»²¿·Ö£¬´«Í³ÎïÒµ¹ÜÀí´ó¶à²ÉÓÃÊÖ¹¤²Ù×÷£¬Ê¹µÃÎïÒµ¹ÜÀíÈËÔ±¹¤×÷Á¿´ó¡¢¹¤×÷ЧÂʵ͡£Õë¶ÔÕâÒ»ÏÖ×´£¬ÔÚ³ä·Ö·ÖÎöÎïÒµ¹ÜÀíµÄʵ¼ÊÐèÇó»ù´¡ÉÏ£¬ÀûÓÃJava£«SQL 2000Éè¼ÆÁËÒ»¸ö»ùÓÚC/S½á¹¹µÄСÐÍÎïÒµÊշѹÜÀíϵͳ¡£ÏµÍ³Éè¼Æ²¢ÊµÏÖÁ˵Ǽ¹ÜÀí¡¢×ÊÁϼÈë¹ÜÀí¡¢ÎïÒµ¹ÜÀí¡¢±¨±í¹ÜÀí¡¢ÏµÍ³¹ÜÀí¡¢°ïÖúϵͳµÈÄ£¿é¡£
ϵͳ×ñÑÁËÈí¼þ¹¤³Ì·½·¨ÂÛ½øÐÐϵͳ·ÖÎö¡¢×ÜÌåÉè¼Æ¡¢ÏêϸÉè¼ÆºÍϵͳ²âÊÔ¡£Ê×ÏȶÔϵͳµÄÑ¡Ìâ±³¾°ºÍϵͳ¿ª·¢Ëù²ÉÓõļ¼Êõ½øÐÐÏàÓ¦µÄ¼òµ¥½éÉÜ¡£È»ºó·ÖÎöÁ˱¾ÏµÍ³µÄÏêϸÐèÇ󣬲¢È·¶¨ÏµÍ³Ó¦¾ßÓеŦÄÜ¡£¶Ôϵͳ½øÐÐ×ÜÌåÉè¼Æ, Ïêϸ·ÖÎöÁËÎïÒµÊÕ·Ñ»·½ÚÖи÷¸ö¹¦ÄÜÄ£¿éÖ®¼äµÄ¹Øϵ,²¢ÇÒ½éÉÜÎïÒµÊշѹÜÀíϵͳµÄÕû¸öÉè¼Æ¹ý³Ì¡£½Ó×ŶÔϵͳÖеÄÊý¾Ý¿â½øÐÐÄ£ÐÍÉè¼Æ£¬°üÀ¨ÊµÌåÁªÏµÍ¼ºÍÊý¾Ý±í½á¹¹¡£È·¶¨×îºÃµÄ½â¾ö·½°¸,×îºó¶Ôϵͳ½øÐбàÂë¼°¹¦ÄÜʵÏÖ£¬¶ÔϵͳÖйؼü¼¼ÊõJavaºÍ¸÷Ä£¿éÉæ¼°µ½µÄ¹Ø¼ü´úÂë½øÐÐÁËÏêϸµÄ·ÖÎö¡£
¹Ø¼ü´Ê£ºÎïÒµÊշѹÜÀíϵͳ£¬C/S£¬SQL SERVER 2000£¬Java
ABSTRACT
Management of property charges is an essential part of Property Management, the traditional property management used mostly by hand, makes property management personnel workload and low efficiency. Community property is not conducive to the management fees standardized, systematic and raise the property management efficiency. In response to this situation, a full analysis of the property management on the basis of actual demand. Using Java + ACCESS2000 for a design based on the C / S structure of the small property management fees system. System functions practical, easy operation, management and maintenance, expandability, and the design and implementation of login management, Input data management, property management, report management, systems management, help system modules.
System followed the software engineering methodology for systems analysis, design, detailed design and system testing. Firstly, this paper briefly introduces of the background of topics and the applied technology of system development. Then it analyzes the detailed requirements of the system and identifies the function the system should have. This paper makes the overall design of the system, and it detailed analyzes the relationship between each functional module in the process of and it introduces the whole design process of bidding management system. Then this paper makes the model design of database of the system, including entities linked graph and the data table structure and ensure the best solution. Finally, it makes code and the implementation of the function to the system, and it detailed analyzes the key technologies Java and the key code related to each module.
Keywords: Property Management System; C/S; SQL SERVER 2000; Java
Ŀ ¼
Õª Òª I
ABSTRACT II
µÚÒ»Õ Ð÷ ÂÛ 1
1.1Ñо¿±³¾° 1
1.2Ñо¿ÏÖ×´ 2
1.3Ñо¿ÄÚÈݺÍÄ¿±ê 4
µÚ2Õ ¿ª·¢¹¤¾ß½éÉÜ 5
µÚ3Õ ϵͳ·ÖÎöÓëÉè¼Æ 8
3.1ϵͳ¸ÅÊö 8
3.2ϵͳÐèÇó 8
3.3ϵͳÁ÷³Ìͼ 9
3.4Êý¾ÝÁ÷³Ìͼ 10
3.5ϵͳ¹¦ÄÜÄ£¿é»®·Ö 12
3.5.1 ×ÊÁϼÈë¹ÜÀíÄ£¿é 13
3.5.2ÎïÒµ¹ÜÀíÄ£¿é 13
3.5.3±¨±í¹ÜÀíÄ£¿é 14
3.5.4ϵͳ¹ÜÀíÄ£¿é 15
µÚ4Õ Êý¾Ý¿âÉè¼Æ 16
4.1 E-R¹Øϵͼ 16
4.2 Êý¾Ý×ÖµäÉè¼Æ 17
4.3Êý¾Ý¿âÁ¬½ÓÉè¼Æ 20
µÚ5Õ ϵͳʵÏÖ 21
5.1 ϵͳÔËÐл·¾³ 21
5.1.1×îСӲ¼þÉ豸 21
5.1.2Èí¼þ»·¾³ 21
5.2ϵͳ¹¦ÄÜʵÏÖ 21
5.2.1µÇ¼¹ÜÀí 21
5.2.2Ö÷½çÃæÉè¼Æ 22
5.2.3×ÊÁϼÈë¹ÜÀí 23
5.2.4 Êշѵ¥¼ÛÐÞ¸Ä 24
5.2.5 ÏÔʾÊշѵ¥¼Û 25
5.2.6 СÇøÎïÒµÊý¾Ý¼Èë 25
5.2.7 Â¥ÓîÐÅϢά»¤ 26
5.2.8ÎïÒµ¹ÜÀí 26
5.2.9±¨±í¹ÜÀí 28
5.3Á¬½ÓÊý¾Ý¿â 30
µÚ6Õ ½áÊøÓï 32
Ö л 33
²Î¿¼ÎÄÏ× 34
µÚÒ»Õ Ð÷ ÂÛ
еÄÊÀ¼ÍÒѾµ½À´£¬ÔÚ¼ÆËã»ú¼¼Êõ·¢Õ¹ÈÕÐÂÔÂÒìµÄ½ñÌ죬¼ÆËã»úÈí¼þµÄÓ¦ÓÃÔçÒÑÉîÈëµ½Á˸÷Ðи÷Òµ£¬²¢·¢»Ó×ÅËüÃǾ޴óµÄDZÁ¦¡£µ±Ç°ÊÇÒ»¸öÐÅÏ¢»¯µÄʱ´ú£¬¸÷Ðи÷Òµ¶¼¾ÊÜ×ÅÒÔ»¥ÁªÍøΪ´ú±íµÄÈ«ÇòÐÅÏ¢»¯À˳±µÄ³å»÷[1]¡£Í¬ÑùÎïÒµ¹ÜÀíÐÐÒµÒ²±»´òÉÏÁËÐÅϢʱ´úµÄÀÓÓ¡£¬ÐÅÏ¢¼¼ÊõÔÚÖйúÎïÒµ¹ÜÀíÖеÄÔËÓÃÒÑÀ¿ªÐòÄ»¡£Ëæ×ÅÎïÒµ¹ÜÀí¹«Ë¾ÔÚÎïÒµ¹ÜÀíµÈ·½ÃæµÄһϵÁеĸĸһÇж¼ÔÚ³¯ÏòÉç»á»¯·¢Õ¹£¬¹ÜÀíÌåÖÆÒ²ÓɹýÈ¥µÄ¡°È«³Ð°ü¡±ÏòÏÖÔڵġ°Ò»Ì廯£¬×¨ÃÅ»¯¡±·¢Õ¹¡£±¾Ð¡ÇøÎïÒµ¹ÜÀíϵͳÌṩ¶ÔÒµÖ÷ÐÅÏ¢ºÍÊÕ·ÑÐÅÏ¢µÈµÄ¹ÜÀí¡£ÎªÁ˶ÔСÇøÎïÒµÊշѵĹ淶¹ÜÀíºÍ·½±ãСÇøÎïÒµ¹ÜÀí¹«Ë¾µÄ¹ÜÀí£¬ÏµÍ³Îª¹ÜÀíÔ±Óû§ºÍÒµÖ÷Óû§ÌṩÁ˲»Í¬µÄ¹¦ÄÜ¡£±¾ÏµÍ³¾ßÓÐÒ»¶¨µÄʵÓÃÐÔ¡£
±¾Ð¡ÇøÎïÒµÊշѹÜÀíϵͳÊÇÔÚ·þÎñÆ÷ÉÏÏÈ°²×°Windows NT²Ù×÷ϵͳ£¬²¢ÔÚNTϵͳÏ°²×°Êý¾Ý¿âϵͳACCESS2000ºÍ½¨Á¢Êý¾Ý¿â¡£È»ºóÔÚXP²Ù×÷ϵͳÏÂÓÃJava±àд²»Í¬µÄϵͳÓû§½çÃ棬ºóÓÃJDBC/ODBCÇÅʵÏÖ·þÎñÆ÷ÉÏÊý¾Ý¿âºÍÇ°¶Ë½çÃæµÄÁ¬½Ó¡£Á¬½Ó³É¹¦ºó£¬½«Java±àдµÄÓû§½çÃæÒÆÖ²µ½¿Í»§¶ËµÄWindows XP²Ù×÷ϵͳÏ£¬²¢ÓÃÕâ¸ö½çÃæʵÏÖÓë·þÎñÆ÷ÉÏNTϵͳϵÄÊý¾Ý¿âACCESSÁ¬½Ó¡£ÒÔ´ïµ½ÔÚ²»Í¬µÄ²Ù×÷ϵͳÏ¿ÉÒÔ»¥Ïàµ÷ÓõÄÄ¿µÄ£¬ÊµÏÖJavaµÄÖØÒªÌØÐÔ£º¿ÉÒÆÖ²ÐÔ¡£
±¾ÕÂÖ÷Òª½éÉÜÔÚÐÅÏ¢»¯±³¾°Ï£¬Ð¡ÇøÎïÒµÊշѹÜÀíÐÅÏ¢»¯µÄÏÖ×´ÒÔ¼°±¾ÎÄËùÒªÑо¿µÄÄÚÈݺÍÄ¿±ê¡£