【正文】 ；Oracle ；數(shù)據(jù)庫(kù)The Enterprise Purchasesellstock Management System Based on JavaAbstract:Sailing is an important part of enterprise management in market economy. In order to promote sale,many of them set up subpany or agent promote product to customers through those subpanies or of them lie in different frequent munication of information beyond space and time is the major this case,the traditional management conveying information and data by management personnels can’t satisfy the need of increasing business.The system is a basic in sailing and accounting introduces advanced management by utilizing information offers practical access to the reform of enterprise’s system manage business activities,such as buying,storing and sailing,and the basic information of suppliers and use visual basic which is very popular currently to database makes use of Oracle 10g,having strong function and convenient operation.This thesis with modity purchasesellstock management system analysis and design is introduced, the system of exploitation of each step: system analysis, system design, system achieve, system system mainly introduces the basic information of the module, to make up for the other systems which is difficult to modification and deletion customer information, supplier information and modity the realization of the system, the realization form are appropriate functions of control and source code examples, and the method to realize the menu. This paper lists the main functions of the system operation interface system uses currently popular Java Swing development, backed database using more powerful convenient operation of the Oracle database。Java Swing。database目 錄引 言 ............................................................1第 1 章 概述 ......................................................2 研究課題的背景 ...............................................................................................................2 研究課題的目的和意義 ...................................................................................................2 本課題的主要內(nèi)容及組織結(jié)構(gòu) .......................................................................................3 主要內(nèi)容 ..............................................................................................................3 組織結(jié)構(gòu) ..............................................................................................................3第 2 章 系統(tǒng)開(kāi)發(fā)環(huán)境的選擇與配置 ..................................4 硬件環(huán)境 ...........................................................................................................................4 系統(tǒng)開(kāi)發(fā)工具的選擇 .......................................................................................................4 使用 Java + Oracle 10g 進(jìn)行程序設(shè)計(jì)和數(shù)據(jù)庫(kù)設(shè)計(jì) ..................................4 Java 環(huán)境的配置 .................................................................................................5第 3 章 需求分析與系統(tǒng)設(shè)計(jì) ........................................6 需求分析 ...........................................................................................................................6 概要設(shè)計(jì) ...........................................................................................................................6 詳細(xì)設(shè)計(jì) ...........................................................................................................................7 本章小結(jié) ...........................................................................................................................9第 4 章 數(shù)據(jù)庫(kù)的設(shè)計(jì) .............................................10 數(shù)據(jù)庫(kù)介紹 .....................................................................................................................10 ER 圖 ..............................................................................................................................10 數(shù)據(jù)表概要說(shuō)明 .............................................................................................................12 主要數(shù)據(jù)表的結(jié)構(gòu) .........................................................................................................13第 5 章 主要模塊設(shè)計(jì)與實(shí)現(xiàn) .......................................17 系統(tǒng)登錄模塊設(shè)計(jì)與實(shí)現(xiàn) .............................................................................................17 基礎(chǔ)信息模塊設(shè)計(jì)與實(shí)現(xiàn) .............................................................................................23 銷(xiāo)售單功能設(shè)計(jì)與實(shí)現(xiàn) .................................................................................................25 銷(xiāo)售退貨管理模塊設(shè)計(jì)與實(shí)現(xiàn) .....................................................................................28 查詢統(tǒng)計(jì)模塊設(shè)計(jì)與實(shí)現(xiàn) .............................................................................................29 庫(kù)存管理模塊的設(shè)計(jì)與實(shí)現(xiàn) .........................................................................................30 本章小結(jié) .........................................................................................................................32第 6 章 系統(tǒng)測(cè)試 .................................................33 系統(tǒng)軟件測(cè)試 .................................................................................................................33 測(cè)試的原則 ........................................................................................................33 單元測(cè)試 ............................................................................................................33 集成測(cè)試 ............................................................................................................33 測(cè)試總結(jié) .........................................................................................................................34 系統(tǒng)實(shí)施與維護(hù) .............................................................................................................34結(jié) 論 ...........................................................35致 謝 ...........................................................36參考文獻(xiàn) ........................................................37