超市信息管理系統(tǒng)(SQL)(dephi)SQL

1、 - PAGE 7 -畢業(yè)論文題 目：超市信息管理系統(tǒng) 學(xué) 生：指導(dǎo)老師：專 業(yè)： 計(jì)算機(jī)與信息科學(xué)系 班 級(jí)：學(xué) 號(hào)：摘要隨著計(jì)算機(jī)科學(xué)技術(shù)的高速發(fā)展，計(jì)算機(jī)與網(wǎng)絡(luò)已經(jīng)成為人們工作、生活中必不可少的工具，如今生活日益多姿多彩，交流日益快捷方面。人們?cè)谏詈凸ぷ髦薪柚诟鞣N計(jì)算機(jī)軟件技術(shù)，更有效地為人們服務(wù)。我國的經(jīng)濟(jì)不斷的向前發(fā)展，人們消費(fèi)水平的提高，大量的國內(nèi)的超市被國外的超市沖沒市場(chǎng)，大多紛紛退出了市場(chǎng)，這很大一部分是國內(nèi)超市資金不夠而買不起先進(jìn)好的信息管理系統(tǒng)。這就體現(xiàn)了一個(gè)好的管理系統(tǒng)的經(jīng)濟(jì)價(jià)值。第一章對(duì)數(shù)據(jù)庫應(yīng)用系統(tǒng)開發(fā)和超市信息管理系統(tǒng)進(jìn)行了簡明的介紹，并分析超市信息管理系統(tǒng)方案

2、論證，說明開發(fā)超市信息管理系統(tǒng)所要進(jìn)行的工作。第二章對(duì)數(shù)據(jù)庫的設(shè)計(jì)和SQL語言的使用進(jìn)行了系統(tǒng)分析，為深入理解數(shù)據(jù)庫應(yīng)用打下了基礎(chǔ)。第三章學(xué)習(xí)了具體的開發(fā)工具Delphi6.0，對(duì)其數(shù)據(jù)庫組件，SQL語言在Delphi中的應(yīng)用等數(shù)據(jù)庫編程關(guān)鍵技術(shù)進(jìn)行了系統(tǒng)的介紹。設(shè)計(jì)充分利用Delphi6、MSSQLServer2000數(shù)據(jù)庫技術(shù)的強(qiáng)大力量，提高了編程效率和可靠性。關(guān)鍵字：數(shù)據(jù)庫，SQL語言，MSSQLServer，Delphi6，數(shù)據(jù)庫組件，超市信息管理，窗體，組件。AbstractAlong with the computer science technology high speed d

3、evelopment, the computer and the network already became the people to work, in the life the essential tool, now lives day by day colorful, exchange day by day quick aspect. The people in the life and the work with the aid of in each kind of computer software technology, effectively serve for the peo

4、ple. Our countrys economy is unceasing moves forward, the people consumption level enhancement, the massive homes supermarket is flushed by the overseas supermarket does not have the market, withdrew from the market mostly in abundance, this very major part is the domestic supermarket fund insuffici

5、ently but cannot buy the advanced good information management system. This has manifested a good management system management system economic value.First chapter has carried on the concise introduction to the database application system development and the supermarket information management system,

6、and the analysis supermarket information management system plan proof, explained the development supermarket information management system must carry on work.Second chapter has carried on the system analysis to the database design and the SQL language use, has built the foundation for the thorough u

7、nderstanding database application.Third chapter has studied concrete development kit Delphi 6.0, to its database module, the SQL language in the Delphi database programming essential technology and so on application has carried on the system introduction. Designs fully uses Delphi 6, MS SQL the Serv

8、er2000 data bank technology formidable strength, enhanced the programming efficiency and the reliability.Key words: Database, SQL language, MS SQL Server, Delphi6, database module, supermarket information management, window, module.目錄TOC o 1-2 h z u HYPERLINK l _Toc128496337 摘要 PAGEREF _Toc128496337

9、 h 2 HYPERLINK l _Toc128496338 Abstract PAGEREF _Toc128496338 h 3 HYPERLINK l _Toc128496339 前言 PAGEREF _Toc128496339 h 5 HYPERLINK l _Toc128496340 第一章概述 PAGEREF _Toc128496340 h 6 HYPERLINK l _Toc128496341 1.1選題背景 PAGEREF _Toc128496341 h 6 HYPERLINK l _Toc128496342 1.2 主要技術(shù)要求和內(nèi)容(需求與任務(wù)描述) PAGEREF _Toc

10、128496342 h 7 HYPERLINK l _Toc128496343 第二章超市信息管理的方案論證 PAGEREF _Toc128496343 h 9 HYPERLINK l _Toc128496344 21 本課題所采用的設(shè)計(jì)方案 PAGEREF _Toc128496344 h 9 HYPERLINK l _Toc128496345 2.2 采用此套方案的原因: PAGEREF _Toc128496345 h 9 HYPERLINK l _Toc128496346 2.3 系統(tǒng)的特點(diǎn) PAGEREF _Toc128496346 h 13 HYPERLINK l _Toc128496

11、347 第三章系統(tǒng)的詳細(xì)設(shè)計(jì) PAGEREF _Toc128496347 h 14 HYPERLINK l _Toc128496348 3.1進(jìn)貨管理 PAGEREF _Toc128496348 h 14 HYPERLINK l _Toc128496349 3.15退貨管理 PAGEREF _Toc128496349 h 17 HYPERLINK l _Toc128496350 3.16補(bǔ)貨管理 PAGEREF _Toc128496350 h 18 HYPERLINK l _Toc128496351 3.2 庫存管理 PAGEREF _Toc128496351 h 18 HYPERLINK l _Toc128496352 3.3幫助 PAGEREF _Toc128496352 h 20 HYP