ÕªÒª£º±¾¿Í»§¹ØϵϵͳÊÇʹÓÃJSP±à³ÌÓïÑÔºÍql2005Êý¾Ý¿â¹²Í¬À´Íê³ÉµÄ£¬²ÉÓÃÃæÏò¶ÔÏó·½·¨£¬¶Ô¿Í»§¹Øϵϵͳ½øÐÐÉè¼ÆÓëʵÏÖ¡£·ÖÎöÉè¼ÆÁË¿Í»§¹ØϵϵͳµÄ¾²Ì¬Ä£ÐͺͶ¯Ì¬Ä£ÐÍ£¬Íê³ÉÁËϵͳ¿ª·¢µÄ·ÖÎö¡¢Éè¼ÆºÍʵÏֵŤ×÷¡£±¾¿Í»§¹Øϵϵͳͨ¹ýWeb·½Ê½Íê³ÉÓû§ÓëϵͳµÄ½»»¥£¬ÏµÍ³µÄ¹¦ÄÜÄ£¿é¾ßÌåÓпͻ§¹ÜÀíÄ£¿é¡¢ÒµÎñÐÅÏ¢¹ÜÀíÄ£¿é¡¢ÈÎÎñÐÅÏ¢¹ÜÀíÄ£¿é¡£±¾ÏµÍ³µÄ¿ª·¢²ÉÓÃÏÖÓгÉÊì¼¼ÊõΪ²ÎÕÕ£¬¹²ÏíÔ´ÂëΪģ°å£¬½áºÏ±¾¿Î³ÌÍøÕ¾µÄʵ¼ÊÐèÇó½øÐзÖÎöºÍ¹¦Äܵ÷Õû£¬Ì½ÌÖÁËÀûÓÃJSP¿ª·¢¿Í»§¹ØϵϵͳµÄ¹ý³Ì¡£
¹Ø¼ü´Ê£º¿Í»§¹Øϵ£¬¹ÜÀí£¬ÏµÍ³
Abstract: The customer relationship system is the use of JSP and Mysql2000 database programming language common to complete, object-oriented approach, on the banks customer relationship systems design and implementation. Analysis and design of the bank customer relationship system static and dynamic models, the completion of system development analysis, design and implementation work. The bank customer relationship system is accomplished through the Web user and system interaction, the system function modules have specific customer management module, business information management module, statistical information management module. The development of this system using existing proven technology as a reference, sharing source code as a template, combined with the actual needs on this course site analysis and functional adjustment of the use of JSP Development Bank, the process of customer relationship system.
Keywords: Customer Relationship, management, system
Ŀ ¼
1¡¢ÒýÑÔ 4
2¡¢ÏµÍ³·ÖÎö 5
2.1 ϵͳÐèÇó·ÖÎö 5
2.2 ±¾ÏµÍ³²ÉÓõĹؼü¼¼Êõ 6
2.2.1 JSP¼¼Êõ 6
2.2.2 JavaBean¼¼Êõ 8
2.2.3 JDBC¼¼Êõ 9
2.2.4 ÓÃJDBC·ÃÎÊÊý¾Ý¿â 10
2.3 ¿ÉÐÐÐÔ·ÖÎö 13
3¡¢ÏµÍ³¸ÅÒªÉè¼Æ 13
4¡¢ÏµÍ³ÏêϸÉè¼Æ 15
4.1 ºǫ́Êý¾Ý¿âÉè¼Æ 15
4.4.1 Mysql½éÉÜ 15
4.4.2 Êý¾Ý¿â±í½á¹¹ 16
4.2 ϵͳE-Rͼ 18
4.3 ´¦ÀíÁ÷³ÌÉè¼Æ 18
4.3.1 ϵͳ²Ù×÷Á÷³Ì 18
4.3.2 Êý¾ÝÔö¼ÓÁ÷³Ì 19
4.3.3 Êý¾ÝÐÞ¸ÄÁ÷³Ì 20
4.4.4 Êý¾Ýɾ³ýÁ÷³Ì 21
4.4 ϵͳģ¿éÉè¼Æ 22
4.4.1 ¹ÜÀíÔ±µÇ½ 22
4.4.2 ÒµÎñÐÅÏ¢¹ÜÀí 22
4.4.3 ¿Í»§ÐÅÏ¢¹ÜÀí 22
4.4.4 ÁªÏµÈËÐÅÏ¢ÈÎÎñ 23
5¡¢ÏµÍ³µ÷ÊÔÓë²âÊÔ 23
5.1 ³ÌÐòµ÷ÊÔ 23
5.2 ³ÌÐòµÄ²âÊÔ 23
5.2.1 ²âÊÔµÄÖØÒªÐÔ¼°Ä¿µÄ 23
5.2.2 ²âÊԵIJ½Öè 25
5.2.3 ²âÊÔµÄÖ÷ÒªÄÚÈÝ 25
6¡¢½áÂÛ 27
6.1 ϵͳÆÀ¼Û 27
6.2 °²È«ÐÔÎÊÌâ 27
ÖÂл 29
²Î¿¼ÎÄÏ× 30
1¡¢ÒýÑÔ
Ëæ׿ÆËã»ú¼¼ÊõµÄ·ÉËÙ·¢Õ¹£¬¼ÆËã»úÓ¦ÓõÄÆÕ¼°£¬ÀûÓüÆËã»úʵÏÖ¿Í»§¹ØϵµÄ¹ÜÀíÊÆÔÚ±ØÐС£µ±½ñÉç»áÕý¿ìËÙÏòÐÅÏ¢»¯Éç»áÇ°½ø£¬ÐÅÏ¢×Ô¶¯»¯µÄ×÷ÓÃÒ²Ô½À´Ô½´ó¡£´Ó¶øʹÎÒÃÇ´Ó·±ÔÓµÄÊÂÎñÖнâ·Å³öÀ´£¬Ìá¸ßÁËÎÒÃǵŤ×÷ЧÂÊ¡£Ä¿Ç°ºÜ¶à¿Í»§¹Øϵ¹ÜÀí»¹´¦ÓÚÈ˹¤¹ÜÀíµÄ½×¶Î£¬Ð§ÂʵÍÏ£¬ÒѾԶԶÂäºóÓÚµ±½ñ¼¼ÊõµÄ·¢Õ¹¡£²¢ÇÒÈ˹¤¹ÜÀíµÄ±×¶ËÒ²ÓúÀ´ÓúÑÏÖØ£¬ÓÉÓÚ²»¿É±ÜÃâµÄÈËΪÒòËØ£¬Ôì³ÉÊý¾ÝµÄÒÅ©¡¢Î󱨣¬¶øÔì³É¿Í»§¹Øϵ¹ÜÀíÖØ´óËðʧµÄÊÂÀý²ã³ö²»Çî¡£¼ÆËã»úÐÅÏ¢»¯¹ÜÀíÓÐ×Å´¢´æÐÅÏ¢Á¿´ó£¬ËٶȿìµÈÐí¶àÓŵ㣬Ìṩ¸øÎÒÃǵĴ¦ÀíÐÅÏ¢¼°Ê±¿ì½Ý£¬Í¬Ê±Ò²Ìá¸ßÁËÎÒÃǹ¤×÷ÈËÔ±µÄ×ÔÉíËØÖÊ¡£Òò´ËÎÒÃÇÀûÓüÆËã»úÌṩ¸øÎÒÃÇÐÅÏ¢£¬×ö³öÁËÕâ¸ö¿Í»§¹Øϵϵͳ¡£¿Í»§¹ØϵϵͳÊÇÏÖÔÚ¿Í»§¹Øϵ¹ÜÀí¹¤×÷²»¿ÉȱÉÙµÄÒ»²¿·ÖÊÇÊÊÓ¦ÏÖÔÚ¹ÜÀíÖƶȵÄÒªÇó¡£Íƶ¯¿Í»§¹Øϵ¹ÜÀí×ßÏò¿Æѧ»¯