【正文】 1 超市進(jìn)銷(xiāo)存銷(xiāo)售管理系統(tǒng)設(shè)計(jì)與實(shí)現(xiàn) 摘 要 隨著社會(huì)的 發(fā)展 ，計(jì)算機(jī)越來(lái)越深入到我 們?nèi)粘５墓ぷ鲗W(xué)習(xí)及生活中，成為我們?nèi)粘Ｉ钪胁豢扇鄙俚妮o助工具。 隨著科學(xué)技術(shù)的不斷提高 ,計(jì)算機(jī)科學(xué)日漸成熟 ,其強(qiáng)大的功能已為人們深刻認(rèn)識(shí) ,它已進(jìn)入人類(lèi)社會(huì)的各個(gè)領(lǐng)域并發(fā)揮著越來(lái)越重要的作用。 它已經(jīng)深入到日常工作和生活的方方面面，比如文字處理、信息管理、輔助設(shè)計(jì)、圖形圖像處理、教育培訓(xùn)以及游戲娛樂(lè)等。各行各業(yè)的人們無(wú)須經(jīng)過(guò)特別的訓(xùn)練就能夠使用電腦完成許許多多復(fù)雜的工作。然而，雖然現(xiàn)在世界上已經(jīng)充滿(mǎn)了多如牛毛的各種軟件，但它們 依然不能滿(mǎn)足用戶(hù)的各種特殊需要，人們還不得不開(kāi)發(fā)適合自己特殊需求的軟件。 超市進(jìn)銷(xiāo)存管理系統(tǒng)用計(jì)算機(jī)管理超市庫(kù)存進(jìn)出管理的一種計(jì)算機(jī)應(yīng)用技術(shù)的創(chuàng)新，在計(jì)算機(jī)還未普及之前庫(kù)存管理都是由工作人員手工書(shū)寫(xiě)的方式來(lái)操作的?，F(xiàn)在一般的超市都采用計(jì)算機(jī)智能化管理，采用計(jì)算機(jī)作為工具的實(shí)用的計(jì)算機(jī)超市庫(kù)存管理程序來(lái)幫助管理員進(jìn)行更有效的超市庫(kù)存管理工作。超市進(jìn)銷(xiāo)存管理系統(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ò)分析 ， 我們利用其提供的各種面向?qū)ο蟮拈_(kāi)發(fā)工具 ， 尤其是數(shù)據(jù)窗口這一能方便而簡(jiǎn)潔操縱數(shù)據(jù)庫(kù)的智能化對(duì)象 ， 首先在短時(shí)間內(nèi)建立系統(tǒng)應(yīng)用原型 ,然后 ， 對(duì)初始原型系統(tǒng)進(jìn)行需求迭代 ， 不斷修正和改進(jìn) ， 直到形成用戶(hù)滿(mǎn)意的可行系統(tǒng)。 因?yàn)楸救四芰τ邢?，加上時(shí)間緊迫，所以設(shè)計(jì)出來(lái)的本系統(tǒng)可能功能比較簡(jiǎn)單，另外本系統(tǒng)是單機(jī)版，不能實(shí)現(xiàn)網(wǎng)絡(luò)互聯(lián)操作，這些都有待于我在以后的工作學(xué)習(xí)中進(jìn)一步改進(jìn)。 關(guān)鍵 詞 ： 超市進(jìn)銷(xiāo)存管理 系統(tǒng) ； 信息管理系統(tǒng) (MIS)；數(shù)據(jù)庫(kù) 2 Design and Implementation of Supermarket purchasesellstock Management System Abstract With the development of society, the puter and went to work learning and our daily lives, we bee an indispensable tool in everyday life. As science and technology continue to improve, puter science increasingly mature, and its powerful functions for the people to deeply understand that it has entered human society in various fields and is playing an increasingly important role. It has to go down to the daily work and life, such as word processing, information management, aided design, graphics and video processing, as well as education and training game entertainment. All people without special training will be able to use puters to plete numerous plex. However, although now the world has been filled with an overabundance of software, but they still can not meet the special needs of the various users, it also had to develop software suited to their particular needs. Supermarket purchasesellstock management system using puter management Supermarket stocks a puter application and management of technology innovation in the puter before the inventory management are not yet universal manual written by the staff to operate. Supermarkets are now generally used puter intelligent management, using the puter as a tool for puter supermarket inventory management procedures to help managers more effectively supermarket inventory management. Surpermarket purchasesellstock management system is a typical management information system (MIS), including its main development background to the establishment and maintenance of the database and frontend application development. The request for the establishment of strong data consistency and integrity, good for the security of the data. For the latter request applications functions, such as easy to use features. After analysis, we use various objectoriented development tools, especially data that can be easily accessible and concise window manipulation database intelligent objects, the first prototype application system in a short time and then, putation of the initial prototype system needs to constantly revise and improve until the formation of a viable system of user satisfaction. Because I limited capacity, coupled with time constraints, it designed the system may function relatively simple, and the system is single edition, not Inter operations work, which I have yet to learn that in future work to further improve. Keywords: Supermarket purchasesellstock management system。 management information system (MIS)。 database 3 目 錄 引 言 .................................................................... 1 第一章 需求分析 ............................................................. 3 超市進(jìn)銷(xiāo)存銷(xiāo)售管理系統(tǒng)的研究?jī)?nèi)容及所 達(dá)到的目標(biāo) ........................ 3 研究?jī)?nèi)容 ........................................................... 3 所達(dá)到的目標(biāo) ....................................................... 3 超市進(jìn)銷(xiāo)存銷(xiāo)售管理系統(tǒng)設(shè)計(jì)方案 ........................................ 3 設(shè)計(jì)原則 ........................................................... 3 運(yùn)行架構(gòu) ........................................................... 3 第二章 系統(tǒng)設(shè)計(jì) ............................................................. 5 超市進(jìn)銷(xiāo)存銷(xiāo)售管理系統(tǒng)設(shè)計(jì) ............................................ 5 系統(tǒng)目標(biāo) ........................................................... 5 銷(xiāo)售管理系統(tǒng)的需求分析 ............................................. 5 超市進(jìn)銷(xiāo)存銷(xiāo)售管理系統(tǒng)總體設(shè)計(jì) ..................................... 6 超市進(jìn)銷(xiāo)存銷(xiāo)售管理系統(tǒng)的可行性研究 .................................... 6 超市進(jìn)銷(xiāo)存銷(xiāo)售管理系統(tǒng)可行性研究前提要求 ........................... 6 可行性研究方法 ..................................................... 6 決定可行性的主要因素 ............................................... 7 超市進(jìn)銷(xiāo)存銷(xiāo)售管 理系統(tǒng)功能設(shè)計(jì) ........................................ 7 超市進(jìn)銷(xiāo)存銷(xiāo)售管理系統(tǒng)概述 ......................................... 7 超市進(jìn)銷(xiāo)存銷(xiāo)售管理系統(tǒng)功能 ......................................... 8 超市進(jìn)銷(xiāo)存銷(xiāo)售管理系統(tǒng)內(nèi)容和功能設(shè)計(jì) ............................... 8 系統(tǒng)窗體可視化設(shè)計(jì) ................................................ 9 超市進(jìn)銷(xiāo)存銷(xiāo)售管理系統(tǒng)功能模塊圖 ................................... 9 數(shù)據(jù)庫(kù)設(shè)計(jì)與實(shí)現(xiàn) ..................................................... 10 數(shù)據(jù)庫(kù)的需求分析 .................................................. 10 數(shù)據(jù)庫(kù)的概念設(shè)計(jì) .................................................. 10 數(shù)據(jù)庫(kù)的邏輯設(shè)計(jì) .................................................. 12 超市進(jìn)銷(xiāo)存銷(xiāo)售管理系統(tǒng)的功能實(shí)現(xiàn) ..................................... 15 用戶(hù)登錄模塊實(shí)現(xiàn) .................................................. 15 主窗體的功能設(shè)計(jì) .................................................. 17 第三章 系統(tǒng)測(cè)試 ............................................................ 20 超市進(jìn)銷(xiāo)存銷(xiāo)售管理系統(tǒng)的三個(gè)測(cè)試階段 ................................. 20 測(cè)試系統(tǒng) ............................................................. 21 結(jié) 論 ................................................................... 26