數(shù)據(jù)庫畢業(yè)設(shè)計

目錄
摘要 1
Abstract 2
1 引言 3
1.1 項目開發(fā)背景及意義 3
1.2 耐火材料簡介 3
2 系統(tǒng)分析 5
2.1 需求分析 5
2.1.1 對功能的規(guī)定 5
2.1.2 對性能的規(guī)定 5
2.2 可行性分析 5
2.2.1 技術(shù)可行性分析 6
2.2.2 經(jīng)濟(jì)可行性分析 6
2.3 系統(tǒng)開發(fā)目標(biāo) 6
3 系統(tǒng)實施 8
3.1 系統(tǒng)開發(fā)環(huán)境 8
3.2 軟、硬件配置環(huán)境要求 8
3.3 系統(tǒng)開發(fā)工具選擇及簡介 9
3.3.1 系統(tǒng)開發(fā)工具選擇 9
3.3.2 系統(tǒng)開發(fā)工具簡介 9
4 系統(tǒng)設(shè)計說明 15
4.1 開發(fā)方法的選擇 15
4.2 系統(tǒng)功能分析 16
4.3 系統(tǒng)功能模塊設(shè)計 16
4.4 生產(chǎn)流程分析 17
4.5 數(shù)據(jù)庫需求分析 18
4.6 數(shù)據(jù)庫設(shè)計 18
4.7 數(shù)據(jù)庫結(jié)構(gòu)設(shè)計 19
4.7.1 數(shù)據(jù)庫概念結(jié)構(gòu)設(shè)計 19
4.7.2 數(shù)據(jù)庫邏輯結(jié)構(gòu)設(shè)計 21
5 系統(tǒng)的開發(fā)與實現(xiàn) 24
5.1 概述 24
5.2 系統(tǒng)開發(fā)環(huán)境Eclipse3.2 24
5.3 系統(tǒng)程序設(shè)計 24
5.3.1 主界面設(shè)計 24
5.3.2 系統(tǒng)登錄界面設(shè)計 25
5.3.3 產(chǎn)品領(lǐng)料信息模塊 28
5.4 涉及的主要技術(shù) 35
5.4.1 數(shù)據(jù)庫訪問技術(shù)JDBC 35
5.4.2 JAVABEAN封裝代碼 37
5.5 系統(tǒng)測試概述 39
5.6 測試過程 40
5.6.1 功能測試 40
5.6.2 性能測試 40
5.6.3 客戶端兼容性測試 41
5.6.4 安全性測試 41
6 總結(jié) 42
謝辭 43
參考文獻(xiàn) 44
 
摘要
本文介紹了唐山時創(chuàng)耐火材料有限公司信息管理系統(tǒng)----從設(shè)計到實現(xiàn)的整個過程。首先在“引言”中簡單介紹了混料車間子系統(tǒng)設(shè)計目的背景及耐火材料知識，及本系統(tǒng)開發(fā)過程中所使用的開發(fā)語言JSP、集成環(huán)境Eclipse、數(shù)據(jù)環(huán)境SQLServer 2000
系統(tǒng)采用兩層結(jié)構(gòu)設(shè)計，前臺表現(xiàn)采用JSP后臺數(shù)據(jù)邏輯封裝采用JAVABEAN。
最后便是系統(tǒng)的詳細(xì)設(shè)計，逐步介紹了一個系統(tǒng)從前臺到后臺各部分模塊的設(shè)計過程及其功能的實現(xiàn)并附圖形講解。該設(shè)計共分三個模塊：訂單管理模塊、領(lǐng)料混料管理模塊和不良品管理模塊。訂單管理模塊主要負(fù)責(zé)訂單的管理及以下配料模塊的訂單驅(qū)動。而泥料管理模塊則是接受上級下達(dá)的訂單及和下一個車間進(jìn)行交互，同時它也要管理一些基礎(chǔ)信息。
關(guān)鍵詞： 數(shù)據(jù)庫；訂單；管理

 
Abstract
This article introduces the information management system of TangShan refractory material limited company ---- include the entire process from design to achievement. First of all, in the introduction, it gives an outline on the background of compounding workshop subsystem design purpose and refractory material information. What’s more, it also contains the JSP language which is used in the process of the system development, IDE Eclipse and data environment SOL-Server 2000.
This system adopts two layers of structural design. The foreground display adopts JSP while the background logical data encapsulation adopts JAVABEAN .
In the end, it gives the specific design of this system. It introduces the design process of each pattern from foreground to background of the system step by step. Besides, the graphic explanation .The design is divided into three patterns: order management pattern management pattern. Order management pattern is mainly in charge of management of the order and order form drive of confect material module. while the pug management pattern is responsible for receiving superior order and exchanging something with the next workshop. Meanwhile, it also manages some basic information of this system.
Keyword:database;order;management