【正文】 目錄 目 錄 設(shè)計(jì)總說明 ................................................................. I Introduction .............................................................. II 1引言 ...................................................................... 1 ...................................................... 1 ...................................................... 1 ...................................................... 3 ...................................................... 3 2 可行性分析 ............................................................... 4 .......................................................... 4 .......................................................... 4 ...................................................... 4 ................................................................ 4 3 需求分析 ................................................................. 5 ............................................................ 5 ............................................................ 6 ............................................................ 6 ............................................................ 7 ........................................................ 7 業(yè)務(wù)流程圖 .................................................... 7 數(shù)據(jù)流程圖 .................................................... 9 4 概要設(shè)計(jì) ................................................................ 12 ....................................................... 12 HIPO圖 ...................................................... 12 IPO 圖 ....................................................... 13 ......................................................... 15 數(shù)據(jù)庫(kù)設(shè)計(jì)原則 ............................................... 15 數(shù)據(jù)庫(kù)表的設(shè)計(jì) ............................................... 16 接口設(shè)計(jì) .......................................................... 19 用戶接口 ..................................................... 19 外部接口 ..................................................... 19 內(nèi)部接口 ..................................................... 19 ....................................................... 19 出錯(cuò)輸出信息 ................................................. 19 出錯(cuò)處理對(duì)策 ................................................. 19 ....................................................... 19 5 詳細(xì)設(shè)計(jì) ................................................................ 21 系統(tǒng)模塊的實(shí)現(xiàn) ..................................................... 21 6 系統(tǒng)測(cè)試 ................................................................ 25 ....................................................... 25 什么是單元測(cè)試 ..................................................... 25 系統(tǒng)的部分測(cè)試 ..................................................... 26 員工登錄功能的測(cè)試 .......................................... 26 目錄 信息添加模塊 —— 商品信息添加的測(cè)試 .......................... 26 商品信息查詢模塊 —— 查詢商品信息的測(cè)試 ...................... 26 商品信息修改模塊 —— 修改商品信息的測(cè)試 ...................... 27 商品信息刪除模塊 —— 刪除商品信息的測(cè)試 ...................... 27 總 結(jié) .................................................................. 28 鳴 謝 .................................................................. 29 參考文獻(xiàn) .................................................................. 30 設(shè)計(jì)說明 I 設(shè) 計(jì)總說明 超市具有貨物種類數(shù)量繁多、客流量大等特點(diǎn)。如何有效管理這些數(shù)量龐大的貨物是每個(gè)超市經(jīng)營(yíng)者需要迫切解決的問題。傳統(tǒng)的人工管理具有效率低、保密性差、容易丟失數(shù)據(jù)、成本高等問題，已經(jīng)遠(yuǎn)遠(yuǎn)不適用于發(fā)展規(guī)模越來越大的超市了。于是，隨著計(jì)算機(jī)技術(shù)的進(jìn)步，超市進(jìn)銷存管理系統(tǒng)應(yīng)運(yùn)而生。超市進(jìn)銷存管理系統(tǒng)具有檢索迅速、查找方便、可靠性高、存儲(chǔ)量大、保密性好、壽命長(zhǎng)、成本低等優(yōu)點(diǎn)。這些優(yōu)點(diǎn)能夠有效提高超市管理的效率，節(jié)約超市經(jīng)營(yíng)的成本，是企業(yè)科學(xué)化、系統(tǒng)化管理，與世界接軌的重要條件。 超市進(jìn)銷存管理系統(tǒng)是一個(gè)典型的信 息管理系統(tǒng) (MIS)，其開發(fā)主要包括后臺(tái)數(shù)據(jù)庫(kù)的建立和維護(hù)以及前端界面程序的開發(fā)兩個(gè)方面。超市進(jìn)銷存管理系統(tǒng)在設(shè)計(jì)上體現(xiàn)了人性化和“以人為本”的精神。界面設(shè)計(jì)上親切友好，簡(jiǎn)單直觀，便于操作。 本系統(tǒng)采用 SQLserver 數(shù)據(jù)庫(kù)，開發(fā)語(yǔ)言采用 C語(yǔ)言，實(shí)現(xiàn)系統(tǒng)的查詢、錄入、添加、刪除等功能。 關(guān)鍵字：超市進(jìn)銷存管理系統(tǒng)； SQL； C 設(shè)計(jì)說明 II Introduction The supermarket has many characteristics, such as kinds of goods quantity is various, traffic. How to effectively manage the large number of goods is every supermarket operators need to urgently solve the problem. Traditional artificial management has low efficiency, poor confidentiality, easy loss of data, the cost is high, far does not apply to development scale is being more and more big supermarket. Then, with the progress of puter technology, the supermarket enters sells saves the management system came into being. The supermarket enters sells saves the management system has retrieves, the search rapidly convenient, the reliability high, thereserves big, the secrecy good, the long life and low cost etc. These merits can effectively improve the efficiency of the supermarket management, saving the cost of supermarket management, is the enterprise scientific, systematic management, and the important condition of the world. The supermarket enters sells saves the management system is a typical management information system (MIS), its development mainly includes the backstage database the establishment and maintenance of and the front interface program development two aspects. The supermarket enters sells saves the management system in the design embodi