±¾Éè¼Æ¼´ÎªÒ»¸ö»ù±¾µÄ½øÏú´æ¹ÜÀíϵͳ£¬¾ÍÊÇÀûÓÃÐÅÏ¢»¯ÊֶΰÑÏȽøµÄÆóÒµ¹ÜÀí·½·¨ÒýÈëÆóÒµµÄʵ¼ù£¬ÎªÆóÒµµÄ¹ÜÀí¸Ä¸ïÌṩÇÐʵÒ×ÐеÄ;¾¶¡£ÏµÍ³¶ÔÆóÒµÖг£¼ûµÄ²É¹º¡¢¿â´æ¡¢ÏúÊÛµÈÉÌÒµ»î¶¯ÒÔ¼°Ïà¹ØµÄ¹©Ó¦É̺Ϳͻ§µÈ»ù±¾ÐÅÏ¢½øÐйÜÀí¡£
±¾Éè¼ÆÏêϸ½²ÊöÁËÐÅÏ¢¹ÜÀíϵͳµÄ¿ª·¢¹ý³Ì£¬¶ÔÄ¿±êÉè¼Æ¡¢ÏµÍ³¿ª·¢±³¾°¡¢ÏµÍ³¹¦ÄÜ·ÖÎö¡¢ÏµÍ³¹¦ÄÜÄ£¿éÉè¼Æ¡¢Êý¾Ý¿âÐèÇó·ÖÎöÓëÉè¼Æ¡¢¸÷¹¦ÄÜÄ£¿é±àÂëʵÏÖ¡¢ÏµÍ³µÄ·¢²¼µÈ¸÷¸ö¹ý³Ì½øÐÐÁËÏêϸµÄÃèÊö¡£±¾Éè¼ÆΪһ¸ö»ù±¾µÄ½øÏú´æ¹ÜÀíϵͳ£¬³ÌÐò¹¦ÄÜÌù½üʵ¼Ê£¬ÄÚÈݾ«Á¶£¬ÏµÍ³¶ÔÉÌÒµ»î¶¯Öг£¼ûµÄ²É¹º¡¢¿â´æ¡¢ÏúÊÛµÈÉÌÒµ»î¶¯ÒÔ¼°Ïà¹ØµÄ¹©Ó¦É̺Ϳͻ§µÈ»ù±¾ÐÅÏ¢½øÐйÜÀí¡£ÏµÍ³ÖеÄÊý¾Ý¸ñʽºÍ×Ö¶ÎÉèÖò»¾ßÌåÕë¶Ôijһ¸öÐÐÒµ»òÆóÒµ£¬Òò¶ø¾ßÓÐÆÕ±éµÄÊÊÓÃÐÔ£¬Äܹ»Âú×ãÒ»°ãµ¥Î»µÄ½øÏú´æ¹ÜÀíµÄÐèÒª¡£±¾ÏµÍ³²ÉÓÃÄ¿Ç°Á÷ÐеÄJAVA½øÐпª·¢£¬ºǫ́Êý¾Ý¿âʹÓù¦ÄܸüÇ¿´ó²Ù×÷±ã½ÝµÄSQL Server¡£
¹Ø¼ü´Ê ½øÏú´æ£»JAVA £»SQL Server£»½øÏú´æ¹ÜÀíϵͳ
Abstract
Saling is an important part of enterprise management in market economy.In order to promote sale,many of them set up sub-company or agent system.They promote produce to customers through those sub-companies or agents.Most of them lie in different places.The frequent communication of information beyond space and time is the major feature.In this case,the traditional management conveying information and data by management personnels can¡¯t satisfy the need of increasing business.
The system is basic in saling and accounting management.It introduces advanced management by utilizing information method.It offers practical access to the reform of enterprise¡¯s management.This system manage business activities,such as buying,storing and saling,and the basic information of suppliers and customers.
This system detailedly relating information managing system,design to the target,system development background,system function analysis,system function mold piece design,database need analysis and design,each function mold piece code realize,the system announces each of etc.over with proceed the detailed describing.This case example is a basic saving to manage the system into the PurchaseandSale,the procedure function comes close actual,contents refinement, system to business enterprise familiar purchase,stock,sell etc.business activity and related suppliers to proceed the management with basic information in etc.in customer.The data in the system format establishes with the word segment not aim at a certain profession or business enterprises in a specific way,as a result have the widespread applicability,can satisfy the general unit of save the demand of the management into the PurchaseandSale.It use java which is very popular currently to develop.Backgroud database makes use of SQL Server,having strong function and converient operation.
Key words Saling and accounting JAVA SQL Server PurchaseandSale
Ŀ ¼
Õª Òª I
Abstract II
µÚ1Õ Ð÷ÂÛ 1
1.1 ¿ÎÌâ±³¾° 1
1.2 Ä¿µÄºÍÒâÒå 1
1.3 ϵͳÉè¼Æ˼Ïë 1
1.4 ϵͳ¿ª·¢»·¾³ 2
1.4.1 B/S½á¹¹µÄÊý¾Ý¿â·ÃÎÊģʽ 2
1.4.2 JSP¼¼Êõ¼ò½é 3
1.4.3 Ïà¹ØÊý¾Ý¿â¼ò½é 4
1.5 ±¾ÕÂС½á 5
µÚ2ÕÂ ¿ÉÐÐÐÔ·ÖÎö 6
2.1 ¼¼Êõ¿ÉÐÐÐÔ 6
2.2 ¾¼Ã¿ÉÐÐÐÔ 6
2.3 ·¨ÂÉ¿ÉÐÐÐÔ 8
2.4 ÔËÐпÉÐÐÐÔ 8
2.5 ÒµÎñÁ÷³Ìͼ 8
2.6 ±¾ÕÂС½á 11
µÚ3Õ ÐèÇó·ÖÎö 12
3.1 ÉÌÒµ½øÏú´æ¹ÜÀíϵͳµÄϵͳ¸ÅÊö 12
3.2 ÉÌÒµ½øÏú´æ¹ÜÀíϵͳµÄÐèÇó·ÖÎö 12
3.2.1 Êý¾ÝÁ÷ͼ 13
3.3 Êý¾Ý×Öµä 15
3.3.1 Êý¾ÝÔªËØ 16
3.3.2 Êý¾Ý´æ´¢ 17
3.3.3 Êý¾ÝÁ÷ 18
3.3.4 Êý¾Ý´¦Àí 19
3.4 ±¾ÕÂС½á 20
µÚ4Õ ×ÜÌåÉè¼Æ 21
4.1 ϵͳģ¿é×ÜÌåÉè¼Æ 21
4.2 Êý¾Ý¿âÉè¼Æ 23
4.2.1 Êý¾Ý¿âÉè¼Æ¸ÅÊö 23
4.2.2 Êý¾Ý·ÖÎö 24
4.3 Êý¾Ý¿âµÄÏêϸÉè¼Æ 24
4.3.1 E-RͼµÄÉè¼Æ 24
4.3.2 Êý¾Ý±íµÄÉè¼Æ 25
4.4 ±¾ÕÂС½á 28
µÚ5Õ ÏêϸÉè¼Æ 29
5.1 ϵͳÔËÐÐƽ̨ÉèÖà 29
5.2 ϵͳÖ÷½çÃæÉè¼Æ 29
5.3 »ù±¾ÐÅÏ¢ÉèÖù¦ÄÜÉè¼Æ 30
5.3.1 »ù±¾ÐÅÏ¢¹ÜÀíÄ£¿é 30
5.3.2 ½ø»õ¹ÜÀíÄ£¿é 31
5.3.3 ¿â´æ¹ÜÀíÄ£¿é 32
5.3.4 ÏúÊÛ¹ÜÀíÄ£¿é 32
5.4 ÊäÈëÉè¼Æ 33
5.5 Êä³öÉè¼Æ 36
5.6 ³ÌÐòÁ÷³Ìͼ 37
5.7 ±¾ÕÂС½á 39
µÚ6Õ ϵͳ²âÊÔÓëÐÔÄÜ·ÖÎö 40
6.1 ²âÊÔµÄÈÎÎñºÍÄ¿±ê 40
6.1.1 ²âÊÔµÄÈÎÎñ 40
6.1.2 ²âÊÔµÄÄ¿±ê 40
6.2²âÊÔ·½°¸ 40
6.3 Éè¼Æ±¾ÏµÍ³²âÊÔ·½°¸ 41
6.4 ±¾ÕÂС½á 42
µÚ7Õ Óû§Ê¹ÓÃÊÖ²á 43
7.1 ϵͳÔËÐл·¾³ 43
7.2 ϵͳʹÓÃ˵Ã÷ 43
7.3 Õ¹Íû 44
7.4 ×ܽá 44
½áÂÛ 45
ÖÂл 46
²Î¿¼ÎÄÏ× 47
¸½Â¼1 48
¸½Â¼2 55