摘 要
進(jìn)銷存管理系統(tǒng)旨在解決商業(yè)企業(yè)商品的采購(gòu)、倉(cāng)儲(chǔ)、運(yùn)輸、配送、流通加工等一系列操作流程中的數(shù)據(jù)信息的處理問(wèn)題，提供一系列的數(shù)據(jù)分析，幫助經(jīng)營(yíng)者合理的調(diào)整各個(gè)經(jīng)營(yíng)運(yùn)作環(huán)節(jié)的運(yùn)作節(jié)奏，并對(duì)商品流轉(zhuǎn)過(guò)程進(jìn)行了全程跟蹤管理、相應(yīng)款項(xiàng)流通的全程記錄管理和票據(jù)信息統(tǒng)計(jì)的管理。因此進(jìn)銷存管理系統(tǒng)的全面應(yīng)用，規(guī)范業(yè)務(wù)流程、提高了企業(yè)的管理水平，提高資金流動(dòng)的透明度，加快商品資金周轉(zhuǎn)速度，進(jìn)而全面提高了企業(yè)的經(jīng)營(yíng)水平、進(jìn)而全面提升了企業(yè)的經(jīng)濟(jì)效益。
本進(jìn)銷存管理系統(tǒng)采用JAVA技術(shù)和大型數(shù)據(jù)庫(kù)SQL Server 2000基于eclipse平臺(tái)開(kāi)發(fā)的，主要是處理商業(yè)企業(yè)商品的采購(gòu)、庫(kù)存和銷售各個(gè)環(huán)節(jié)的活動(dòng)，具有良好的人機(jī)界面；考慮到系統(tǒng)的使用對(duì)象可能較多，權(quán)限管理良好；數(shù)據(jù)查詢方便，支持多條件查詢；系統(tǒng)支持良好的數(shù)據(jù)備份和還原操作，有效保護(hù)數(shù)據(jù)，減少意外損失；在相應(yīng)的權(quán)限下，可方便地刪除數(shù)據(jù)；數(shù)據(jù)計(jì)算自動(dòng)完成，盡量減少人工干預(yù)；報(bào)表分析商品進(jìn)貨、商品銷售情況；強(qiáng)大的報(bào)表打印功能；報(bào)表基本信息查詢時(shí)，可根據(jù)查詢條件動(dòng)態(tài)顯示查詢結(jié)果。

關(guān)鍵詞：進(jìn)銷存管理系統(tǒng)； JAVA開(kāi)發(fā)環(huán)境； SQL Server 2000； eclipse;報(bào)表


Abstract
The abstract enters sells saves the management system management system to be for the purpose of solving the commercial department commodity purchase, the warehousing, the transportation, the allocation, the circulation processing and so on in a series of operation flow data message processing question, provides a series of data analysis, helps the operator reasonable adjustment each management operation link the operation rhythm, and has carried on the all-the-way tracking management, the corresponding fund circulation entire journey recording management and the bill information statistics management to the commodity turnover process. Therefore enters sells saves the management system management system the comprehensive application, the standard service flow, raised enterprise's management level, enhances the resource flow the transparency, speeds up the commodity capital handling speed, then raised enterprise's management level comprehensively, then has promoted enterprise's economic efficiency comprehensively.
This enters sells saves the management system management system to use the JAVA technology and large-scale database SQL Server 2000 based on the eclipse platform development, mainly is processes the commercial department commodity the purchase, keeps in stock and sells each link the activity, has the good man-machine contact surface; Considered the system the user are possibly many, the jurisdiction management is good; The data inquiry is convenient, supports the multi-condition inquiry; The system support good data backup and the return to original state operation, protects the data effectively, reduces the accident to lose; Under corresponding jurisdiction, but deletes the data conveniently; The data computation completes automatically, reduces the manual intervention as far as possible; Statement analysis commodity inventory, commodity sale situation; Formidable report form printing function; When report form basic information inquiry, may act according to the inquiry condition dynamic demonstration inquiry result.

Key words: Enters sells saves the management system management system; JAVA development environment; SQL Server 2000; eclipse; Report form






目 錄
摘 要 I
Abstract II
第1章 概述 1
1.1 課題的來(lái)源、現(xiàn)狀以及研究意義 1
1.2 國(guó)內(nèi)外文獻(xiàn)綜述 2
第2章 系統(tǒng)分析 4
2.1 方案論證 4
2.1.1 技術(shù)分析與方案確定 4
2.2 可行性研究 7
2.2.1 技術(shù)可行性 7
2.2.2 經(jīng)濟(jì)可行性 7
2.2.3 操作上及社會(huì)因素的可行性 7
2.3 需求分析 8
2.3.1 目標(biāo) 8
2.3.2 系統(tǒng)的基本功能綜述 8
2.3.3 系統(tǒng)的數(shù)據(jù)流圖 8
2.3.4 數(shù)據(jù)字典 10
2.3.5 進(jìn)銷存管理系統(tǒng)的E-R圖 12
第3章 系統(tǒng)設(shè)計(jì) 17
3.1 設(shè)計(jì)目標(biāo) 17
3.2 系統(tǒng)功能結(jié)構(gòu) 17
3.3 系統(tǒng)流程圖 19
3.4 構(gòu)建開(kāi)發(fā)環(huán)境 19
3.5 文件夾結(jié)構(gòu)組織 19
3.6 數(shù)據(jù)庫(kù)設(shè)計(jì) 20
3.6.1 數(shù)據(jù)庫(kù)分析 20
3.6.2 數(shù)據(jù)庫(kù)表模型設(shè)計(jì) 20
3.7 詳細(xì)設(shè)計(jì) 21
3.7.1 主窗體設(shè)計(jì) 21
3.7.2 基礎(chǔ)信息模塊設(shè)計(jì) 25
3.7.3 查詢統(tǒng)計(jì)模塊設(shè)計(jì) 33
第4章 系統(tǒng)測(cè)試 38
4.1 單元測(cè)試 38
4.2 功能測(cè)試 41
4.3 集成測(cè)試與系統(tǒng)測(cè)試 42
4.4 程序的異常處理 43
4.5 調(diào)試 43
結(jié)論 44
致謝 45
參考文獻(xiàn) 46
附錄 47



參考文獻(xiàn)
[1] 曹哲等. 軟件工程[M]. 中國(guó)水利水電出版社,2004年.196—210.
[2] 牟莉. 小型企業(yè)生產(chǎn)信息管理系統(tǒng)研究與實(shí)現(xiàn)[J]. 科學(xué)技術(shù)與工程, 2007,(02).
[3] 張海藩. 軟件工程導(dǎo)論（第四版）[M]. 清華大學(xué)出版社, 2003年11月.56—92
[4] 柳青，張敏. 物資管理系統(tǒng)的設(shè)計(jì)與實(shí)現(xiàn)[J]. 交通與計(jì)算機(jī), 1994,(05).
[5] 李春媚. 企業(yè)綜合管理信息系統(tǒng)——進(jìn)銷存子系統(tǒng)開(kāi)發(fā)[J]. 華南金融電腦,2007,(03).
[6] 陳紅,王珊. 數(shù)據(jù)庫(kù)系統(tǒng)原理教程[M]. 清華大學(xué)出版社,1998年.29—75.
[7] 虞益誠(chéng). SQL2000數(shù)據(jù)應(yīng)用技術(shù)[M]. 中國(guó)鐵道出版社出版式,2003年. 20—86.
[8] 孫一林，彭波. Java網(wǎng)絡(luò)編程實(shí)例[M]. 清華大學(xué)出版社,2004年.45—63.
[9]（美）HARVEY, M.DEITEL PAUL J.DEITEL[M]. How to Progroam Fourth Edition, 電子工業(yè)出版社,2002年6月.
[10]（英）THOMAS CONNOLLY, CAROLYN BEGG[J]. Database Systems A Pr..