【正文】 I 本科畢業(yè)設(shè)計(jì) (論文 ) 題目名稱(chēng)： 基于 c/s 的 倉(cāng)庫(kù) 智能 管理系統(tǒng) II 摘 要 本文主要闡述 了 采用面向?qū)ο笏枷腴_(kāi)發(fā) 基于 C/S 的倉(cāng)庫(kù) 智能 管理系統(tǒng)的方法和過(guò)程， 包括從可行性研究到系統(tǒng)投入使用的主要相關(guān)文檔。 本系統(tǒng)主要完成對(duì)倉(cāng)庫(kù)的庫(kù)存管理，包括入庫(kù)、出庫(kù)、庫(kù)存、員工信息、供應(yīng)商信息以及密碼管理等 6 個(gè)方面。 系統(tǒng) 可以完成對(duì)各類(lèi)信息的瀏覽、查詢(xún)、添加、刪修改、報(bào)表等功能。 系統(tǒng)的開(kāi)發(fā)環(huán)境為 mysql+Myeclipse。使用 Myeclipse 時(shí)限邏輯 代碼。 系統(tǒng)實(shí)現(xiàn)了 系統(tǒng)設(shè)置，單據(jù)填開(kāi)，庫(kù)存查詢(xún)，報(bào)表導(dǎo)出 等功能 。其中系統(tǒng)設(shè)置包括：管理員的增加，修改，刪除，以及權(quán)限管理； 倉(cāng) 庫(kù)內(nèi)貨物的基本資料的增加，修改，刪除；商家的基本資料的增加，修改，刪除。單據(jù)填開(kāi)模塊包括：出庫(kù)單，入庫(kù)單，等單據(jù)的填開(kāi)級(jí)作廢操作。庫(kù)存查詢(xún)系統(tǒng)包括：庫(kù)存情況的查詢(xún)，各項(xiàng)明細(xì)的查詢(xún) 。 該系統(tǒng)是對(duì)倉(cāng)庫(kù)的智能管理，并進(jìn)行相應(yīng)的采購(gòu)管理、入庫(kù)管理、出庫(kù)管理、報(bào)表管理等一些倉(cāng)庫(kù)方面的管理。 該系統(tǒng)可以方便地實(shí)現(xiàn)商品的入庫(kù)操作和出庫(kù)操作、以及報(bào)表輸出等功能，這些功能的實(shí)現(xiàn)對(duì)該公司的倉(cāng)庫(kù)管理從以往的手 工管理過(guò)渡到計(jì)算機(jī)的信息化管理，從而大大提高了工作效率。 關(guān)鍵詞 ： 數(shù)據(jù)庫(kù) ； sql語(yǔ)言 ； Myeclipse； 數(shù)據(jù)庫(kù)組建 ； 倉(cāng)庫(kù)管理 III Abstract The system mainly refers to warehousing management,which includes the folllowing fields:stock in and out,inventory,staff data,suppliers data and password also offers the funcions as data browse, adding,deleting,modification and report,etc. The System development environment is mysql and contains 3 modules,system management,receipts management and inventory management module is used to conduct operater and authoirties assignmentmin addition,inventory,staff andcustomer data adding,modification and deleting。the second part refers to stock in and out,receipts fillin cancellation。 thelast maodule contends to warehousing query,staff salary query,monthly,quarterly,yearly report query.. As stated previously,the sysrem is an intelligent warehousing management includes:purchasing management,stock in and our management,report management,etc. The system can expediently carry out the merchandise to store in warehouse the operation and a database operation, and the statement print etc. function, the realization of these functions manages to the stock of that pany to manage to transfer the informationbased management of the calculator from the former handicraft, raising the work efficiency thus and consumedly. Key words： database。 SQL。Myeclipse 。Database module。 Database management 目 錄 摘 要 .............................................................................................................................. II Abstract ..............................................................................................................................III 第 1 章 緒論 ....................................................................................................................... 1 選題背景 .................................................................................................................. 1 國(guó)內(nèi)外發(fā)展概況及存在的問(wèn)題 .............................................................................. 2 選題目的、意義 ...................................................................................................... 2 課題應(yīng)解決主要問(wèn)題 .............................................................................................. 3 指導(dǎo)思想 .................................................................................................................. 3 第 2 章 系統(tǒng)分析 ............................................................................................................... 6 可行性研究 ................................................................................................................. 6 技術(shù)可行性研究 ............................................................................................... 6 經(jīng)濟(jì)可行性研究 ............................................................................................... 7 需求分析 .................................................................................................................. 8 理解需求 ........................................................................................................... 8 分析需求 ......................................................................................................... 10 數(shù)據(jù)處理需求 ................................................................................................. 10 第 3 章 概要設(shè)計(jì) ............................................................................................................. 12 總體構(gòu)想 ................................................................................................................ 12 據(jù)庫(kù)設(shè)計(jì)模塊 ........................................................................................................ 12 數(shù)據(jù)庫(kù)結(jié)構(gòu)設(shè)計(jì) ............................................................................................. 12 連接數(shù)據(jù)庫(kù) ..................................................................................................... 13 功能模塊設(shè)計(jì) ........................................................................................................ 14 客戶(hù)端的基本功能 ........................................................................................... 15 服務(wù) 器的基本功能 ........................................................................................... 15 第 4 章 詳細(xì)設(shè)計(jì)及實(shí)現(xiàn) ................................................................................................. 16 程序主體框架設(shè)計(jì) ................................................................................................ 16 程序流圖 ................................................................................................................ 16 客戶(hù)端窗口及相關(guān)功能 ........................................................................................ 18 服務(wù)器功能實(shí)現(xiàn) ...................................................................................................... 24 多線(xiàn)程監(jiān)聽(tīng)功能的實(shí)現(xiàn) ................................................................................. 24 數(shù)據(jù)傳輸功能的實(shí)現(xiàn) ..................................................................................... 25 數(shù)據(jù)庫(kù)持久層功能的實(shí)現(xiàn) ............................................................................. 27 數(shù)據(jù)統(tǒng)計(jì)的實(shí)現(xiàn) ............................................................................................. 32 第 5 章