【正文】 西京學(xué)院 畢業(yè)設(shè)計(jì)報(bào)告 題目： 超市信息管理系統(tǒng) 系別： 工程技術(shù)系 班級(jí)： 計(jì)算機(jī)科學(xué)與技術(shù) 0601 姓名： 導(dǎo)師： 日期： 2021 年 4 月 28 日 摘 要 隨著經(jīng)濟(jì)的發(fā)展，社會(huì)的進(jìn)步，計(jì)算機(jī)越來(lái)越深入到我們?nèi)粘５墓ぷ鲗W(xué)習(xí)及生活中，成為我們?nèi)粘Ｉ钪胁豢扇鄙俚妮o助工具。 隨著科學(xué)技術(shù)的不斷提高 ,計(jì)算機(jī)科學(xué)日漸成熟 ,其強(qiáng)大的功能已為人們深刻認(rèn)識(shí) ,它已進(jìn)入人 類社會(huì)的各個(gè)領(lǐng)域并發(fā)揮著越來(lái)越重要的作用。它已經(jīng)深入到日常工作和生活的方方面面，比如文字處理、信息管理、輔助設(shè)計(jì)、圖形圖像處理、教育培訓(xùn)以及游戲娛樂等。然而，雖然現(xiàn)在世界上已經(jīng)充滿了多如牛毛的各種軟件，但它們依然不能滿足用戶的各種特殊需要，人們還不得不開發(fā)適合自己特殊需求的軟件。以前開發(fā) Windows 應(yīng)用軟件是專業(yè)人員的工作，需要掌握許多專業(yè)知識(shí)和經(jīng)過(guò)特殊的培訓(xùn)才能勝任?，F(xiàn)在不同了，即使你沒有接受過(guò)嚴(yán)格的程序設(shè)計(jì)訓(xùn)練，使用 JAVA 也一樣能夠開發(fā)出功能強(qiáng)大、適合自己特殊需求的應(yīng)用程序了 . 超市管理系統(tǒng)用計(jì)算機(jī) 管理超市庫(kù)存進(jìn)出管理的一種計(jì)算機(jī)應(yīng)用技術(shù)的創(chuàng)新 ,在計(jì)算機(jī)還未普及之前庫(kù)存管理都是由工作人員手工書寫的方式來(lái)操作的 .現(xiàn)在一般的超市都采用計(jì)算機(jī)智能化管理 ,采用計(jì)算機(jī)作為工具的實(shí)用的計(jì)算機(jī)超市庫(kù)存管理程序來(lái)幫助管理員進(jìn)行更有效的超市庫(kù)存管理工作。超市管理系統(tǒng)是典型的信息管理系統(tǒng) (MIS),其開發(fā)主要包括后臺(tái)數(shù)據(jù)庫(kù)的建立和維護(hù)以及前臺(tái)收銀系統(tǒng)程序的開發(fā)兩個(gè)方面。對(duì)于前者要求建立起數(shù)據(jù)一致性和完整性強(qiáng)、數(shù)據(jù)安全性好的庫(kù)。而對(duì)于后者則要求應(yīng)用程序功能完備 ,易使用等特點(diǎn)。 數(shù)據(jù)庫(kù)采用 SQL Server2021，由于我 們的系統(tǒng)要求，采用它完全可以適合我們的工作需求，并且它所支持的數(shù)據(jù)類型十分豐富，維護(hù)簡(jiǎn)便，費(fèi)用比較低。 關(guān)鍵字 :超市管理 ,JAVA,數(shù)據(jù)庫(kù) ,SQL Server2021. ABSTRACT With economic development, social progress, 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. Professional Windows application software development before the work is needed in many professional knowledge and petence through special training. Different now, even if you have not received strict procedures designed training, the use of JAVA also like to develop a powerful, and suited to their special needs applications. supermarket 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. Supermarket Jinxiaocun 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. 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. Database adoption SQL Server 2021, request because of our system, adopt it to can suit our work need pletely, and it a data for supporting type is abundant very, support simple, the expenses is lower. keyword : supermarket management,JAVA, database, Microsoft SQL Server 2021 目 錄 第一章 超市 管理系統(tǒng)問題定義 ............................................... 1 課題背景 .............................................................. 1 研究意義 .............................................................. 1 國(guó)內(nèi)外發(fā)展概況 ........................................................ 2 第二章 可行性分析 ........................................................ 3 經(jīng)濟(jì)可行性 ............................................................ 3 技術(shù)可行性 ............................................................ 3 操作可行性 ............................................................ 3 第三章 需求分析 .......................................................... 4 背景分析 .............................................................. 4 功能分析 .............................................................. 5 性能分析 .............................................................. 5 運(yùn)行環(huán)境 .............................................................. 5 第四章 總體設(shè)計(jì) .......................................................... 6 系統(tǒng)設(shè)計(jì)原理 .......................................................... 6 功能模塊設(shè)計(jì) .......................................................... 6 第五章 數(shù)據(jù)庫(kù)設(shè)計(jì) ........................................................ 9 數(shù)據(jù)庫(kù)設(shè)計(jì)規(guī)則 ........................................................ 9 數(shù)據(jù)庫(kù)概念結(jié)構(gòu)設(shè)計(jì) .................................................... 9 數(shù)據(jù)庫(kù)關(guān)系模型設(shè)計(jì) ................................................... 12 數(shù) 據(jù)庫(kù)邏輯結(jié)構(gòu)設(shè)計(jì) ................................................... 12 第六章 詳細(xì)設(shè)計(jì) ......................................................... 15 系統(tǒng) 登錄模塊的設(shè)計(jì) ................................................... 15 添加 用戶模塊