【正文】 management information systems. The invention includes two sides: the establishment and maintenance of background database and development of frontend applications. Database requires the establishment of data consistency and integrity of strong data security for the first, as for the latter demanding the functional application maturity, and easy to use. I have a deep study and application in both MS SQL Server 2021 database management system and ASP applications design according to requirements of information management systems, the main job is to plete the analysis of the management system requirement, functional modules and database modeling, then design the structure of the database and application procedures. As constructed by ASP, this system can run not only in single puter but work as well with the high flexibility. Keywords: The Equipment system。而對(duì)于后者則要求應(yīng)用程序功能完備 ， 易使用等特點(diǎn)。 1 目 錄 第 1 章 緒 論 ......................................................... 4 課題研究背景 ........................................................... 4 近代的設(shè)備維修模式 ................................................. 4 現(xiàn)代主要的設(shè)備管理模式 ............................................. 5 課題研究現(xiàn)狀和前景展望 ................................................. 7 維修管理的現(xiàn)狀 ..................................................... 7 設(shè)備維修管理的未來發(fā)展趨勢(shì) ......................................... 7 課題研究目的與意義 ..................................................... 8 設(shè)備維修管理系統(tǒng)的目的 ............................................. 8 設(shè)備維修管理系統(tǒng)的意義 ............................................. 8 開發(fā)工具 ............................................................... 9 ASP 構(gòu)建技術(shù) ........................................................ 9 IDEFIX 簡(jiǎn)介 ....................................................... 10 BEA WebLogic Server 簡(jiǎn)介． ....................................... 11 J2EE 簡(jiǎn)介 .......................................................... 11 第二章 系統(tǒng)分析 ...................................................... 13 設(shè)備維修管理簡(jiǎn)介 ...................................................... 13 管理信息系統(tǒng)概述 .................................................. 13 本論文的主要工作內(nèi)容 .............................................. 13 系統(tǒng)初步調(diào)查 ....................................................... 14 可行性研究 ......................................................... 15 2． 2 系統(tǒng)需求分析 ........................................................ 15 需求分析介紹 ...................................................... 15 系統(tǒng)功能需求分析 .................................................. 16 應(yīng)用需求分析 ..................................................... 16 2． 3 設(shè)備維修模型的建立 ................................................... 16 2． 4 系統(tǒng)功能及工作流程設(shè)計(jì) ............................................... 17 第 3 章 概要設(shè)計(jì) ................................................... 19 2 3． 1 體系結(jié)構(gòu) ............................................................. 19 系統(tǒng)模塊劃分 .......................................................... 21 系統(tǒng)功能模塊劃分示意圖 ............................................. 21 系統(tǒng)模塊劃分詳細(xì)描述 ............................................... 22 系統(tǒng)流程圖 ............................................................ 23 3． 4 系統(tǒng)數(shù)據(jù)庫(kù)與數(shù)據(jù)結(jié)構(gòu)關(guān)系的設(shè)計(jì) ....................................... 25 3． 5 維修模式的模型設(shè)計(jì) ................................................... 26 數(shù)據(jù)庫(kù)設(shè)計(jì) ............................................................ 26 第 4 章 詳細(xì)設(shè)計(jì) ...................................................... 28 數(shù)據(jù)庫(kù)表設(shè)計(jì) .......................................................... 28 Admin_info 表 ..................................................... 28 Employee_info 表 ................................................... 28 Kh_info 表 ........................................................ 28 Gz_info 表 ......................................................... 29 Pos_info 表 ........................................................ 29 Sb_glinfo 表 ....................................................... 29 Wxd_info 表 ........................................................ 30 程序設(shè)計(jì) .............................................................. 31 登陸 ............................................................... 32 管理員頁(yè)面 ......................................................... 33 用戶頁(yè)面 ........................................................... 36 系統(tǒng)界面及輸入輸出設(shè)計(jì) ................................................ 37 第 5 章 測(cè)試系統(tǒng)設(shè)計(jì)實(shí)施與系統(tǒng)調(diào)試分析 ................................. 39 系統(tǒng)測(cè)試 .............................................................. 39 調(diào)試過程 .......................................................... 39 調(diào)試方法 .......................................................... 40 系統(tǒng)的實(shí)現(xiàn)程序 ........................................................ 40 系統(tǒng)實(shí)現(xiàn)的基本思想 ................................................ 40 系統(tǒng)實(shí)現(xiàn)的核心的程序 流程圖 ........................................ 41 3 系統(tǒng)的典型運(yùn)行界面 .................................................... 41 系統(tǒng)應(yīng)用案例與應(yīng)用效果 ................................................ 42 系統(tǒng)測(cè)試的設(shè)計(jì) ........................................................ 42 軟件測(cè)試方法 ....................................................... 42 系統(tǒng)測(cè)試案例 ...................................................... 42 小 結(jié) ............................................................... 44 參考文獻(xiàn) ............................................................. 46 附 錄 .............................................................. 48 1 設(shè)備 維修管理系統(tǒng)的設(shè)計(jì)與實(shí)現(xiàn) 摘要： 近年來，計(jì)算機(jī)網(wǎng)絡(luò)通信技術(shù)正經(jīng)歷著持續(xù)不斷的發(fā)展，軟硬件性能日新月異，促使金融業(yè)、商品流通業(yè)、交通運(yùn)輸業(yè)、旅游業(yè)等許多領(lǐng)域發(fā)生了極大的變革，人們的生活方式、消費(fèi)方式也隨之產(chǎn)生了巨大的變化 。對(duì)于前者要求建立起數(shù)據(jù)一致性和完整性強(qiáng)、數(shù)據(jù)安全性好的庫(kù)。 關(guān)鍵詞： 設(shè)備系統(tǒng)；查詢； SQL Server 2021； ASP 2 The Design And Implementation Of Equipment Maintenance Management System Abstract： In recent years, as the continual development of web munication technology and capacity o