進(jìn)銷存系統(tǒng)的設(shè)計(jì)與實(shí)現(xiàn)

論文字?jǐn)?shù):9456,頁(yè)數(shù):31，附設(shè)計(jì)

摘 要
  商品進(jìn)銷存管理系統(tǒng)是典型的信息管理系統(tǒng)(MIS),其開(kāi)發(fā)主要包括后臺(tái)數(shù)據(jù)庫(kù)的建立和維護(hù)以及前端應(yīng)用程序的開(kāi)發(fā)兩個(gè)方面。對(duì)于前者要求建立起數(shù)據(jù)一致性和完整性強(qiáng)、數(shù)據(jù)安全性好的庫(kù)。而對(duì)于后者則要求應(yīng)用程序功能完備,易使用等特點(diǎn)。  經(jīng)過(guò)分析,我們使用Sun Microsystems公司的 Jsp開(kāi)發(fā)工具, 建立的一種動(dòng)態(tài)網(wǎng)頁(yè)技術(shù)標(biāo)準(zhǔn),尤其是數(shù)據(jù)窗口這一能方便而簡(jiǎn)潔操縱數(shù)據(jù)庫(kù)的智能化對(duì)象,首先在短時(shí)間內(nèi)建立系統(tǒng)應(yīng)用原型,然后,對(duì)初始原型系統(tǒng)進(jìn)行需求迭代,不斷修正和改進(jìn),直到形成用戶滿意的可行系統(tǒng)。本系統(tǒng)主要完成對(duì)企業(yè)或商場(chǎng)的管理，包括進(jìn)貨管理，銷售管理，庫(kù)存管理和員工管理四個(gè)方面。系統(tǒng)可以完成對(duì)各類信息的瀏覽、查詢、添加、刪除、修改等功能。  系統(tǒng)的核心是銷售、庫(kù)存查詢和進(jìn)貨管理三者之間的聯(lián)系，每一個(gè)表的修改都將聯(lián)動(dòng)的影響其它的表，當(dāng)完成銷售或進(jìn)貨操作時(shí)系統(tǒng)會(huì)自動(dòng)地完成相對(duì)應(yīng)信息的修改。查詢功能也是系統(tǒng)的核心之一，在系統(tǒng)中主要根據(jù)商品編號(hào)和商品名稱等進(jìn)行查詢，其目的都是為了方便用戶使用，以求更快的查找到各個(gè)物料和產(chǎn)品品質(zhì)的基本信息。系統(tǒng)有完整的用戶添加、刪除和密碼修改功能，系統(tǒng)采用SQL2000來(lái)設(shè)計(jì)數(shù)據(jù)庫(kù),它有著最為靈活的數(shù)據(jù)庫(kù)結(jié)構(gòu)，對(duì)數(shù)據(jù)庫(kù)應(yīng)用有著良好的支持。  論文主要介紹了本課題的開(kāi)發(fā)背景，所要完成的功能和開(kāi)發(fā)的過(guò)程。重點(diǎn)的說(shuō)明了系統(tǒng)設(shè)計(jì)的重點(diǎn)、設(shè)計(jì)思想、難點(diǎn)技術(shù)和解決方案。
【關(guān)鍵詞】 進(jìn)銷存系統(tǒng)； 數(shù)據(jù)庫(kù)； 系統(tǒng)設(shè)計(jì)
 
  
 
 
 Abstract
 
   This system chiefly accomplishes the stock management to the storehouse, includes being put in storage, goes out the warehouse and stocks, and staff’s information, six aspects such as supplier's information as well as cryptogram management etc. What the system can accomplish to various kind the information glances over and the function such as inquires about, adds, deletes andmodification etc. The systematic nucleus is is put in storage, stocks and goes out the contact between the warehouse, and when accomplishes being put in storage or going out a warehouse, the system can accomplish voluntarily the modification of stock to other table of influence that the modification of every table all will be linkageed when operating. Inquiring about the function also is one of systematic nucleus, namely having the wallscroll spare to inquire about and inquires about with many conditions in the system, also having accurately the query to inquire about with bluring, not only there is the condition query of static state in the system, also having the condition query of trends formations, his purpose all is using for convenient user. The system has completeuser to add, deletes and the cipher modification function, and has the reportform and prints the function. The SQL 2000 that the system comes the design data warehouse, and use before one Sun Microsystems development tool JSP, it has the most nimble data base structure, and the application has the good support to the data warehouses. The development background of this the subject, course of function and the development that will be accomplished were chiefly introduced to thesis. The emphatic explanation focal point of systems design, design thought and difficult point technology and settlement scheme. The keyword: the data base, SQL's language. 
【Key words】The purchase,sell and storage management system   ; data-base  ;  system design
 

 
 
 
目 錄

第 1 章  緒論 1
1.1 研究課題的背景 1
1.2 系統(tǒng)簡(jiǎn)介 1
1.3 開(kāi)發(fā)環(huán)境介紹 2
第 2章 系統(tǒng)分析與設(shè)計(jì) 3
2.1 需求分析 3
2.2 功能模塊描述 4
2.4 數(shù)據(jù)庫(kù)設(shè)計(jì) 6
2.4.1數(shù)據(jù)庫(kù)介紹 6
2.4.2 數(shù)據(jù)字典分析 6
第3章 主要模塊詳細(xì)設(shè)計(jì) 9
3.1 登錄界面詳細(xì)設(shè)計(jì) 9
3.2 基本信息管理的設(shè)計(jì) 9
3.2.1客戶信息管理的設(shè)計(jì) 9
3.2.2 商品信息管理的設(shè)計(jì) 12
3.2.3供應(yīng)商信息管理設(shè)計(jì) 14
3.3 庫(kù)存管理模塊的設(shè)計(jì) 16
3.4 商品銷售模塊的設(shè)計(jì) 17
3.5 查詢統(tǒng)計(jì)模塊的設(shè)計(jì) 18
3.6 主程序設(shè)計(jì) 20
第4章 系統(tǒng)連編與測(cè)試 21
4.1 系統(tǒng)連編 21
4.2 系統(tǒng)測(cè)試 21
第5章 結(jié)束語(yǔ) 23
參考文獻(xiàn) 25
致      謝 27