【正文】 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。而對于后者則要求應(yīng)用程序功能完備 ， 易使用等特點。 1 目 錄 第 1 章 緒 論 ......................................................... 4 課題研究背景 ........................................................... 4 近代的設(shè)備維修模式 ................................................. 4 現(xiàn)代主要的設(shè)備管理模式 ............................................. 5 課題研究現(xiàn)狀和前景展望 ................................................. 7 維修管理的現(xiàn)狀 ..................................................... 7 設(shè)備維修管理的未來發(fā)展趨勢 ......................................... 7 課題研究目的與意義 ..................................................... 8 設(shè)備維修管理系統(tǒng)的目的 ............................................. 8 設(shè)備維修管理系統(tǒng)的意義 ............................................. 8 開發(fā)工具 ............................................................... 9 ASP 構(gòu)建技術(shù) ........................................................ 9 IDEFIX 簡介 ....................................................... 10 BEA WebLogic Server 簡介． ....................................... 11 J2EE 簡介 .......................................................... 11 第二章 系統(tǒng)分析 ...................................................... 13 設(shè)備維修管理簡介 ...................................................... 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è)計 ............................................... 17 第 3 章 概要設(shè)計 ................................................... 19 2 3． 1 體系結(jié)構(gòu) ............................................................. 19 系統(tǒng)模塊劃分 .......................................................... 21 系統(tǒng)功能模塊劃分示意圖 ............................................. 21 系統(tǒng)模塊劃分詳細描述 ............................................... 22 系統(tǒng)流程圖 ............................................................ 23 3． 4 系統(tǒng)數(shù)據(jù)庫與數(shù)據(jù)結(jié)構(gòu)關(guān)系的設(shè)計 ....................................... 25 3． 5 維修模式的模型設(shè)計 ................................................... 26 數(shù)據(jù)庫設(shè)計 ............................................................ 26 第 4 章 詳細設(shè)計 ...................................................... 28 數(shù)據(jù)庫表設(shè)計 .......................................................... 28 Admin_info 表 ..................................................... 28 Employee_info 表 ................................................... 28 Kh_info 表 ........................................................ 28 Gz_info 表 ......................................................... 29 Pos_info 表 ........................................................ 29 Sb_glinfo 表 ....................................................... 29 Wxd_info 表 ........................................................ 30 程序設(shè)計 .............................................................. 31 登陸 ............................................................... 32 管理員頁面 ......................................................... 33 用戶頁面 ........................................................... 36 系統(tǒng)界面及輸入輸出設(shè)計 ................................................ 37 第 5 章 測試系統(tǒng)設(shè)計實施與系統(tǒng)調(diào)試分析 ................................. 39 系統(tǒng)測試 .............................................................. 39 調(diào)試過程 .......................................................... 39 調(diào)試方法 .......................................................... 40 系統(tǒng)的實現(xiàn)程序 ........................................................ 40 系統(tǒng)實現(xiàn)的基本思想 ................................................ 40 系統(tǒng)實現(xiàn)的核心的程序 流程圖 ........................................ 41 3 系統(tǒng)的典型運行界面 .................................................... 41 系統(tǒng)應(yīng)用案例與應(yīng)用效果 ................................................ 42 系統(tǒng)測試的設(shè)計 ........................................................ 42 軟件測試方法 ....................................................... 42 系統(tǒng)測試案例 ...................................................... 42 小 結(jié) ............................................................... 44 參考文獻 ............................................................. 46 附 錄 .............................................................. 48 1 設(shè)備 維修管理系統(tǒng)的設(shè)計與實現(xiàn) 摘要： 近年來，計算機網(wǎng)絡(luò)通信技術(shù)正經(jīng)歷著持續(xù)不斷的發(fā)展，軟硬件性能日新月異，促使金融業(yè)、商品流通業(yè)、交通運輸業(yè)、旅游業(yè)等許多領(lǐng)域發(fā)生了極大的變革，人們的生活方式、消費方式也隨之產(chǎn)生了巨大的變化 。對于前者要求建立起數(shù)據(jù)一致性和完整性強、數(shù)據(jù)安全性好的庫。 關(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