約一萬(wàn)九千字

摘要

配件管理是用于調(diào)節(jié)生產(chǎn)所做的必需儲(chǔ)備，對(duì)配件的管理具有十分重要的意義。配件太過(guò)少，會(huì)造成不能滿(mǎn)足生產(chǎn)的需要，從而影響正常的生產(chǎn)或者銷(xiāo)售；而配件過(guò)多，則一方面增加了倉(cāng)儲(chǔ)面積和管理保養(yǎng)費(fèi)用，另一方面，也造成了大量資金的占用。使用傳統(tǒng)的手工記錄配件帳的方法往往不能實(shí)時(shí)反映配件情況，而對(duì)于配件物品的查詢(xún)也相當(dāng)困難。從而導(dǎo)致配件中有大量的物品積存，而同時(shí)又有某些物品缺貨，影響正常生產(chǎn)。
企業(yè)配件管理系統(tǒng)是典型的信息管理系統(tǒng),其開(kāi)發(fā)主要包括后臺(tái)數(shù)據(jù)庫(kù)的建立和維護(hù)以及前端應(yīng)用程序的開(kāi)發(fā)兩個(gè)方面。對(duì)于前者要求建立起數(shù)據(jù)一致性和完整性強(qiáng)、數(shù)據(jù)安全性好的數(shù)據(jù)庫(kù)。而對(duì)于后者則要求應(yīng)用程序功能完備,易使用等特點(diǎn)。本系統(tǒng)采用Microsoft ACCESS 建立數(shù)據(jù)庫(kù)后臺(tái),使用Sun公司的jsp開(kāi)發(fā)工具建立前端應(yīng)用程序，采用基于網(wǎng)絡(luò)的B/S模式，可以實(shí)現(xiàn)配件信息管理的系統(tǒng)化、規(guī)范化、自動(dòng)化、和網(wǎng)絡(luò)化，并可以達(dá)到以下目的：
(1) 科學(xué)管理配件檔案，優(yōu)化分類(lèi)，全面反映物品情況，有利于進(jìn)行標(biāo)準(zhǔn)化工作。
(2) 管理配件變動(dòng)信息，實(shí)時(shí)反映配件現(xiàn)狀。
(3) 為制定生產(chǎn)計(jì)劃提供配件支持，在編制生產(chǎn)計(jì)劃時(shí)，可結(jié)合當(dāng)前配件情況對(duì)生產(chǎn)計(jì)劃作適當(dāng)調(diào)整。
(4) 為保證合理配件量提供實(shí)時(shí)信息，系統(tǒng)對(duì)于超量存儲(chǔ)的配件及存儲(chǔ)低于最低配件量的配件會(huì)實(shí)時(shí)發(fā)出提示信息。
(5) 為合理計(jì)算生產(chǎn)成本提供依據(jù)
關(guān)鍵詞：企業(yè)配件管理系統(tǒng)，ACCESS，JSP，B/S模式

Abstract

The Accessory management is essential for regulating production, which has the extremely vital significance to the accessory’s management. too few accessory will cause production can not meet the needs, thus affects the normal production or the sale, but the accessory excessively are many, on the one hand, increased storage space and maintenance management,on the other hand, it has caused a massive diversion of funds. Using traditional manual methods are often not recorded accessories account immediately reflected accessories, and spare parts for items enquiries are also quite difficult. Resulting in a large number of items in stock spare parts, while certain items are in short supply, affecting the normal production.
The enterprise ccessory management system is a typical information management system, which mainly include development background to the establishment and maintenance of the database and front-end application development.For the former,it request for the establishment of strong data consistency and integrity, data security good database. For the latter request applications functions, such as easy to use features. the system use Microsoft access biuld database background, use the JSP of Sun company build front-end application. Use Web-based B/S modle can achieve accessories information management’s systematic, standardization, and automation, and networking, and can achieve the following objectives :
(1) Scientific management accessories files, and optimize classification fully reflect items, conducive to standardization
(2) Changes in information management accessory, reflect accessories’s real-time status
(3) Supply accessory support for the development of production plans, make appropriate adjustments to production plans to the current combination of accessories
(4) To ensure a reasonable supply of accessory in real time information, for the excessive storage of accessories and storage volume below the minimum accessories information will be immediately sent reminders
(5) Provide the basis for a reasonable calculation of the cost of production
Keyword: Enterprise accessories management system，ACCESS，JSP，B/S modle

目錄

企業(yè)配件管理系統(tǒng) I
摘要 I
Abstract II
第一章 緒論 1
1.1 背景 1
1.2 管理信息系統(tǒng)概述 1
1.3 配件信息系統(tǒng)開(kāi)發(fā)的意義 1
第二章 需求分析 2
2.1 配件管理信息系統(tǒng)開(kāi)發(fā)的必要性 2
2.2 可行性分析 2
第三章 系統(tǒng)分析 3
3.1 系統(tǒng)基本情況描述 3
3.2 系統(tǒng)分析 4
3.2.1 系統(tǒng)的功能分析 4
3.2.2 系統(tǒng)數(shù)據(jù)分析與描述 5
3.3.3 實(shí)現(xiàn)本系統(tǒng)功能的方法 5
第四章 系統(tǒng)設(shè)計(jì) 5
4.1 數(shù)據(jù)庫(kù)設(shè)計(jì) 6
4.2 系統(tǒng)功能的模塊設(shè)計(jì) 10
4.3 數(shù)據(jù)流程圖 10
4.3.1 系統(tǒng)管理 11
4.3.2 數(shù)據(jù)管理 13
4.3.3 用戶(hù)登錄 16
4.3.4 出入庫(kù)操作 17
4.3.5 數(shù)據(jù)查詢(xún)及報(bào)表生成 20
4.4 系統(tǒng)界面設(shè)計(jì) 21
致謝 25
參考文獻(xiàn)（references） 25
附錄： 27


參考文獻(xiàn)（references）
[1] 啟明工作室.MIS系統(tǒng)開(kāi)發(fā)與應(yīng)用.人民郵電出版社.2005.9
[2] 施伯樂(lè)等.數(shù)據(jù)庫(kù)系統(tǒng)教程.高等教育出版社.2003.6
[3] 史濟(jì)民等.軟件工程-原理、方法與應(yīng)用.高等教育出版社.2002.12
[4] 張海藩編著.軟件工程導(dǎo)論（第四版）.清華大學(xué)出版社.2004.11
[5] 飛思科技.JSP應(yīng)用開(kāi)發(fā)詳解（第二版）.電子工業(yè)出版社.2005.9
[6] 石志國(guó).JSP應(yīng)用教程.清華大學(xué)出版社.2006.3
[7] 耿祥義.JAVA 2 使用教程.清華大學(xué)出版社.2005.8
[8] 林赤海組.固定資產(chǎn)管理系統(tǒng).The 8s’ studio.2006.3
[9] www.baidu.com
[10] www.cnbruce.com
[11] www.dvbbs.net