Õª Òª
±¾ÎIJÉÓÃ×Ô¶¥ÏòϵĽṹ»¯µÄϵͳ·ÖÎö·½·¨£¬²ûÊöÁËÒ»¸ö¹¦ÄÜÈ«ÃæµÄVFPÊý¾Ý¿â½ÌѧÍøÕ¾µÄ¿ª·¢¹ý³Ì¡¢²Ù×÷Á÷³Ì¼°ÆäһЩºËÐĵļ¼Êõ¡£±¾ÎÄÊ×ÏȽøÐÐÁËÏîÄ¿¸ÅÊö£¬¼òµ¥½éÉÜÁËÏîÄ¿¿ª·¢µÄ±³¾°¡¢ÏîÄ¿¿ª·¢µÄÄ¿µÄºÍÏîÄ¿¿ª·¢µÄÒâÒ壻½ÓÏÂÀ´ÊÇϵͳ¹æ»®½×¶Î£¬Í¨¹ýʵ¼ÊµÄÒµÎñÁ÷³Ìµ÷ÑУ¬·ÖÎöÁËϵͳµÄ×éÖ¯½á¹¹£¬¾ßÌåÍê³ÉÁËVFPÊý¾Ý¿â½ÌѧÍøÕ¾µÄÐèÇó·ÖÎö¡¢¿ÉÐÐÐÔ·ÖÎö¡¢ÏÖÐÐÒµÎñÁ÷³Ì·ÖÎö£¬²¢Í¨¹ý¶ÔÏÖÐÐÒµÎñÁ÷³ÌµÄÓÅ»¯£¬µÃ³öÁËϵͳµÄÒµÎñÁ÷³Ì£»Ö®ºóÊÇϵͳ·ÖÎö£¬¾ßÌåÍê³ÉÁËÊý¾ÝÁ÷·ÖÎöºÍÊý¾Ý×ֵ䣻ϵͳÉè¼Æ½×¶ÎÖ÷ÒªÍê³ÉÁ˹¦ÄÜÄ£¿éµÄ»®·Ö¡¢Êý¾Ý¿âµÄÉè¼ÆºÍϵͳ½çÃæÉè¼Æ¡£¸Ã½×¶Î¶Ô¸÷¸öÄ£¿éµÄ¹¦ÄܽøÐÐÁËÏêϸÉè¼Æ£¬ÐγÉÁ˱¾ÏµÍ³µÄ¹¦ÄÜÄ£¿éͼ£¬ÔÚ´Ë»ù´¡ÉÏÑ¡ÔñÁ˺ÏÊʵĿª·¢Ä£Ê½£»Êý¾Ý¿âµÄÉè¼ÆÏȽøÐÐÁ˸ÅÄî½á¹¹Éè¼Æ£¬Ö®ºó½øÐÐÁËÂß¼½á¹¹Éè¼Æ£¬×îºóÍê³ÉÁËÊý¾Ý¿â±íµÄÉè¼Æ¡£
¸ù¾ÝÇ°¼¸¸ö½×¶ÎµÄ·ÖÎöºÍÉè¼Æ£¬±¾ÏµÍ³ÔÚÉè¼Æ·½Ãæ²ÉÓÃB/Sģʽ£¬Í¬Ê±Ê¹ÓÃJSP¼¼Êõ½øÐлù±¾Ò³ÃæµÄÉè¼ÆÓ빦ÄÜʵÏÖ£¬ºǫ́Êý¾Ý¿âÑ¡ÓÃSql2005Êý¾Ý¿â¡£±¾ÏµÍ³µÄÉè¼ÆʵʩΪVFPÊý¾Ý¿â½ÌѧÍøÕ¾µÄÔËÐÐ×ö»ù´¡£¬ÎªVFPÊý¾Ý¿â½ÌѧÍøÕ¾ÌṩÁ¼ºÃµÄÌõ¼þ
¹Ø¼ü´Ê£ºÊý¾Ý¿â½Ìѧ£»½á¹¹»¯·ÖÎö£»¹ÜÀíϵͳ
Abstract
In this paper£¬ top-down structured systems analysis£¬ describes a full-featured management system for the housing development agency£¬ operating procedures and some of its core technology. This paper carried out the project overview£¬ a brief background of project development£¬ project development and project development objective of the meaning; followed by the system planning stage£¬ the actual business processes through research and analysis of the system's organizational structure£¬ specifically the completion of the Housing agency management system requirements analysis£¬ feasibility analysis£¬ the existing business process analysis£¬ and optimization of existing business processes£¬ business processes of the system obtained; followed by systematic analysis of the specific completion of the data flow analysis and data dictionary; system design primarily the completion of the division of function modules£¬ database design and system interface design. This phase of the function of each module in detail the design£¬ forming a functional block diagram of the system£¬ on this basis£¬ have chosen the right development model; database design first tested the concept design£¬ followed by a logic design£¬ and finally completed the design of the database table.
According to the first few stages of the analysis and design£¬ the system used in the design of B / S mode£¬ JSP technology£¬ the basic page design and implementation of function£¬ use MySql database backend database. This website is designed to implement management systems for the housing agency to run a foundation for the housing agency management system provides good conditions.
Key Word£ºDatabase teaching; structural analysis; Management System
Ŀ ¼
Õª Òª I
µÚ1Õ ¸ÅÊö 1
1.1 ÏîÄ¿¿ª·¢µÄ±³¾° 1
1.2 ÏîÄ¿¿ª·¢µÄÄ¿µÄ 1
µÚ2Õ ¿ÉÐÐÐÔ·ÖÎö¼°×ÜÌåÉè¼ÆÔÔò 3
2.1 ¿ÉÐÐÐÔ·ÖÎö 3
2.1.1 ¼¼Êõ¿ÉÐÐÐÔ 3
2.1.2 ¾¼Ã¿ÉÐÐÐÔ 3
2.1.3 Éç»á¿ÉÐÐÐÔ 3
2.2 ×ÜÌåÉè¼ÆÔÔò 4
µÚ3Õ ϵͳ·ÖÎö 5
3.1 ÒµÎñÁ÷³Ì·ÖÎö 5
3.2 Êý¾Ý×Öµä 6
µÚ4Õ ϵͳÉè¼Æ 10
4.1 ϵͳ¹¦ÄÜÉè¼Æ 10
4.2 ϵͳÊý¾Ý¿âÉè¼Æ 11
4.2.1 ¸ÅÄî½á¹¹Éè¼Æ 11
4.2.2 Êý¾Ý¿â±íÉè¼Æ 15
4.3 ϵͳ¿ª·¢¹¤¾ßÓ뿪·¢Ä£Ê½µÄÑ¡Ôñ 18
4.3.1 ¿ª·¢¹¤¾ß 18
4.3.2 ¿ª·¢Ä£Ê½ 18
µÚ5Õ ϵͳʵÏÖ 20
5.1 ¹ÜÀíԱģ¿é 20
5.1.1 µÇ¼½çÃæÉè¼Æ 20
5.1.2 Ð޸ĸöÈËÃÜÂë 21
5.1.3 ÀÏʦÐÅÏ¢¹ÜÀí 21
5.1.4 ѧÉúÐÅÏ¢¹ÜÀí 22
5.1.5 ÁôÑÔ°å¹ÜÀí 22
5.1.6 ×Ô²âÌâÄ¿¹ÜÀí 22
5.1.7 °²È«Í˳öϵͳ 23
5.2 ÀÏʦģ¿é 23
5.2.1 Ð޸ĸöÈËÐÅÏ¢ 23
5.2.2 ¿Î¼þ·¢²¼¹ÜÀí 24
5.2.3 ÉÏ´«½ÌѧÊÓƵ 24
5.2.4 ÊÔÌâ¹ÜÀí¹ÜÀí 24
5.3 Íøվǰ̨ģ¿é 25
5.3.1 ϵͳÊ×Ò³ 25
5.3.2 ½Ìѧ¿Î¼þÏÂÔØ 25
5.3.3 ½ÌѧÊÓƵä¯ÀÀ 26
5.3.4 ÔÚÏß×Ô²â 26
µÚ6Õ Èí¼þ²âÊÔÓë·ÖÎö 27
6.1 ϵͳ²âÊԵĶ¨Òå 27
6.2 ϵͳ²âÊÔµÄÄ¿µÄ¼°ÒâÒå 27
6.3 ϵͳ²âÊÔµÄÖØÒªÐÔ 28
6.4 ϵͳ²âÊԵij£Ó÷½·¨ 28
6.5 ²âÊÔ»·¾³Óë²âÊÔÌõ¼þ 29
6.6 ϵͳÔËÐÐÇé¿ö 29
6.7 ²âÊÔ×ܽá 30
µÚ7Õ ×ܽáÓëÕ¹Íû 31
²Î¿¼ÎÄÏ× 32
ÖÂл 33
µÚ1Õ ¸ÅÊö
1.1 ÏîÄ¿¿ª·¢µÄ±³¾°
Ëæ׿ÆËã»ú²úÒµµÄѸËÙ·¢Õ¹£¬µç×Ó¼ÆËã»úÒѹ㷺µÄÓ¦ÓÃÓÚÐÅÏ¢¹ÜÀí¡¢ÎÄ×Ö´¦Àí¡¢¸¨ÖúÉè¼Æ¡¢¸¨Öú½Ìѧ¼°ÈËÃǵÄÈÕ³£Éú»îÖС£VFPÊý¾Ý¿â½ÌѧÍøÕ¾Ö÷ÒªÊÇÕë¶ÔÍøÂç½ÌѧÖÐÉæ¼°½ÌѧµÄһϵÁÐÏà¹Ø¹¤×÷µÄ¹ÜÀí£¬±¾ÏµÍ³µÄ½¨Á¢Ê¹ÍøÂç½ÌѧµÄ¹ÜÀí¸ü¼Ó¹æ·¶»¯¡¢ÏµÍ³»¯£¬²éѯÊֶθü¼Ó±ã½Ý»¯¡£Í¬Ê±£¬VFPÊý¾Ý¿â½ÌѧÍøÕ¾Ò²ÊÇʵÏÖÍøÂç½Ìѧ¹ÜÀíÏÖ´ú»¯ºÍÐÅÏ¢»¯µÄÖØÒªÄÚÈÝ¡£
½üÄêÀ´£¬Ëæ×ÅÍøÂçѧУ¹æÄ£µÄÖð½¥Ôö´ó£¬È˹¤ÊéдÊý¾ÝÒѾ²»Äܹ»´¦ÀíÈç´ËÅÓ´óµÄÊý¾Ý¡£ÎªÁ˸üºÃµÄÊÊÓ¦ÐÅϢʱ´úµÄ¸ßЧÐÔ£¬Ò»¸öÀûÓüÆËã»úÀ´ÊµÏÖÍøÂç½Ìѧ¹ÜÀí¹¤×÷µÄϵͳ½«±ØÈ»µ®Éú¡£»ùÓÚÕâÒ»µã£¬Éè¼ÆÁËÒ»¸öVFPÊý¾Ý¿â½ÌѧÍøÕ¾£¬ÓÃÀ´¾ÍÍøÂç½Ìѧ½øÐйÜÀí£¬ÒÔ±ãÔÚ×î¶ÌµÄʱ¼äÄÚ£¬¸ßЧ׼ȷµÄÍê³ÉÕû¸öÍøÂç½Ìѧ¹ý³Ì¡£